I believe its different from ER modelling ? Can one model SQL server systems using ORM ? Sounds like a dumb question.. But can someone give me more info or provide links about ORM and SQL ? Thanks ...more >>

On manually starting SQLSERVERAGENT service, it gives the following error: error 1068: The depending service for group failed to start. Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER services. Thanks, misecprj ...more >>

I have a problem with SQL Server 7. Database: c_base c_base_data.mdf - c_base_log.ldf The file c_base_log.ldf have become of 15 GB. I have tried to reduce the LOGICAL dimensions with one backup of TRANSACTION LOG and until here all ok. After with command DBCC SHRINKDATABASE or DBCC S...more >>

I'm a newbie to the admin side of SqlServer. I created a new login: <code> CREATE LOGIN pmd_app WITH PASSWORD='********' </code> I then used the "Server Management Studio Express" to create a new user in my DB with the same name, then give the logical permissions, at least logical to m...more >>

Hello, I have a SQL server 2000 running on windows 2000 server, SP4 (4 CPU, and 2G RAM) We use this for Maximizer ECRM application, but lately (past 2-3month) we seem to get more SQL locking issues while running application. When I try to kill the proccess that causing the lock, it still show...more >>

Hi, I have a stored procedure which does intense calculations. It does calculations against millions of records and when it is executed the CPU performance goes up to 100%. Is there a way in SQL queries which specifies that CPU performance should not go beyond 50% for that particular stored...more >>

Hi guys, I find out that if you use DMP and change the backup path from default and set the settings to delete old backup , say after 3 days, it doesnt really delete them. IS it a bug? Is there any fix for it? It happens in SQL2000 as well as in SQL2005 TIA...more >>

Hello. We SBS2000(SP4) with SQL2000 installed. When i attempt to run the SQL Enterprise Manager, i get the following error: Snap-in failed to initialize Name: Microsoft SQL Enterprise Manager CLSID:{00100100-1816-11d0-8ef5-00aa0062c58f} Does anybody know how to resolve this ? Any he...more >>

I've gone through about 30+ google results looking for the magic answer to this problem. I have a brand new machine with a brand new install of Sql Server 2005 express. I am trying to connect via SQLCMD in a command window with the following info: SQLCMD -S 192.168.1.103 -U **** -P ******! ...more >>

I program in SQL Server 2000 and need to know the procedure for moving database data files from one drive to another. I have outgrown the original hard drive and have added a second one. I have done somw research and the research has suggested adding another file to the file group on the new d...more >>

Hello everyone, Right now, our SQL 2000 server has both local and domain users. Domain user's login is something like 'olddomain\someuser'. There are quite a few domain users. Now we need to move the SQL server to a new domain. The question is how to change their logins to 'newdomain\so...more >>

HI I have a table that someone else designed like ********************************************* * employeeid * firstname * last name * supervisor_id * ********************************************* * 1 * Paul * Sed * 2 * *******...more >>

We are in the process of migrating from SQL 2000 to SQL 2005 and there are some features of Enterprise manager that I really miss. 1. I have not found a way to generate an sp script in management studio in ANSI format that has the drop statement, the sp screate statment and the security as...more >>

Does anyone know why MOM 2005 won't install on a SQL 2005 instance? I was hopeful that SP1 for MOM would resolve that problem, but it hasn't. I'm waiting in anticipation of the day I can do this....more >>

Hello, I have a phone number field with the format (123)-456-7890 I need to convert this to 1234567890 formats while I am retrieving data from the table. How can I do this? ...more >>

Hi; I know this can be done because I have done it before - but I can't find the setting. I have a job (SQL Server Agent) that does a backup of the database once a day. How do I set it to save just the last 4 backups and delete any that are older? -- thanks - dave david_at_windward...more >>

Any way to turn OFF deferred name resolution? Looking for something like Option Explicit in the old Visual Basic. ...more >>

My post wasn't in the right thread sorry bout this that's why I'm reposting. I also find out it's happening at the end of a big replication initialize (3000000 rows). So the problem is: I'm having trouble with a database constantly becoming suspect. The log is the following: =========...more >>

I have setup my backup job to delete file older than 12 hours. I want to keep atleast 2 backup files saved. The backup runs every night. My backup job fails on alternate days. The day it fails, it completes just 2 steps 'backup database' and 'verify database'. The day is completes su...more >>

Hi all, I have a large dataabase doing reindex weekly and failed every time running index. My question is that the reindex increase the sql log file? for some reason the database doesn't have much activitiies during the weekends but the log file increased a log --- 30 G. .. If yes, is the...more >>

Am I an idiot, or is there no easy way to do this in SMS2005? I click on a table, choose "Import Data" and I can only copy data between tables? What about stored procs, UDFs, etc? I cant even figure out how to get it to drop a table at the destination database because the option is grayed out....more >>

I'm trying to create stored procedures in about 85 databases. I keep running into the problem 'Incorrect syntax near the keyword 'procedure': declare @cmd1 varchar(500) set @cmd1 = 'if ''?'' like ''%_06'' CREATE procedure newproc AS select * from item' exec sp_MSforeachdb @command1=@cm...more >>

A database of a my customer is corrupt. The file *.mdf is lost (perhaps deleted!). I have only the last transaction log file, none backups of logs; moreover I have the last backup of mdf file. I cannot create a backup of the transaction log to retrieve the db. I would like to view into log fil...more >>

Hi, I am getting following error in SQL Server (SQL Server 6.5) Log. "Could not find row in sysindexes for database ID %d, object ID %ld, index ID %d. Run DBCC CHECKTABLE on sysindexes" I have checked on MSDN but no help. The MSDN artical is saying that there could be some SP that is ud...more >>

It is hard to unisntall SqlServer 2005 ctp from control pannel. Have there any tools to uninstall it? ...more >>

Hi, First of all, I am totally new to MSSQL server, both sql server 2000 and sql server 2005, i've never touched any of them before. I just did a standard install of SQL server 2005, to be used in a hosting environment. I've added a couple of databases and logins, and they are working fine....more >>

Hi, I have table with varchar column, it contains values like 450,450.1,450.2,450.3,450.4,450.5, 451.0,451.1,451.2,451.3, 452,452.1,452.2,452.3 ... etc I want to select the 450,450.1,450.2,450.3 values only, How can i select these values using like operator. Please advise me. rgds...more >>

Is there any way to convert a SQL Server 2005 (v9) database to a MSDE (v8) database?...more >>

Hi, I have checked the current SQL Server Log and i could see there were many records of "starting up DB1" within a few seconds of each other what does it means , i would think that these would appear only after you have startup the SQL Server ? whereelse could i go to check further ?...more >>

Hello, In enterprise manager when detaching DB, there is an option to clear open connections without actually detaching a database. I'm looking for the sp with the ability of clearing cconnections. I failed looking it up in books on line. I'm using SQL 2000 I would be grateful for any h...more >>

having a LOT of problems with SQL server linked servers. I have a server running Windows Server 2003. (Server A) I want to run a query from a different server (Server B) using query analyser. E.g SELECT * FROM [SERVER A].DBName.dbo.tablename keep getting the following message Login faile...more >>

Hello I have got problem with my SQL Serv. 2000. It consumes almost 100% CPU. The scenario for that is: 1) database: 1GB 2) IIS + ASP.NET This database is for internet webpage. Till this moment everything was ok. But suddenly SqlServ started using all resources. ? The question is: ...more >>

Hi , Previously i have setup OutLook 2002 wif SQL server 2000 and was able to send email with the OutLook opened. I was logged in as test\user1 which the SQL Server service uses to start as well. So i close OutLook & send an email from SQL. i logged in as test\user2 and i realised that ...more >>

hi all, i want to start full-text search on sql-server 2000. when trying this with enterprise manager i get error message "error 1722 (rpc-server not availaible)" the mssearch server can be started within mmc. but if it is not started within enterprise manager the option to add a table to ...more >>

Executing this command: BACKUP DATABASE master TO TAPE='\\.\\Tape0' WITH FORMAT, MEDIANAME='NEW_2006_02_21' Gets this result: Server: Msg 3229, Level 16, State 2, Line 1 Request for device '\\.\\Tape0' timed out. Server: Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminatin...more >>

During the installation of SQL 2005, I got this error "The file C:\Windows\Microsoft.NET\Framework\...\mscorlib.tlb could not be loaded. An attempt to repair this condition failed because the file could not be found. Please reinstall this program." When I clicked OK, the install procee...more >>

I use PIVOT when I create a view, but it is fall to save. How can I do? ...more >>