Hi EveryBody... I am using SQL server 2000 and i was working on Strore procedure and manupulating tables.Sql Server shows me messages that ur log size is Increased and as a result it does not allow me to do any manupulations.so I de attached the database and rename it and increase its log file...more >>

I'm stumped on this error message. I've looked everywhere and I can't figure out why this is happening. I've set all fields in my sql table to text and all fields in my vb dataset to string, but I still get this problem. Can anybody see why this error message occurs: "SQL Exception Unhandle...more >>

Hi, I use Microsoft outlook as MAPI client. On my own computer, when the outlook is open, both SQL Mail and Agent Mail can use the file of mail profile to send email. But on one of client's computer, when outlook is open, it locks the file of profile and both SQL Mail and Agent Mail fail when...more >>

Using SS2000 SP4. I have an account called "sqlserver" that I use to start the SQL Server service and the SQL Server Agent service. This account is an admin account in sql server. I moved a database from one drive to a new drive. The database came up as read-only. The permissions on both drive...more >>

Hello: It's a long story, as to why we ask this. But, here it goes. About a week ago, we upgraded a Windows Server 2003 box from SQL 2000 to SQL 2005 service pack 2. Is it possible to go back to SQL 2000? Restoring a backup is not an option. We conducted this upgrade by installing a ...more >>

I have a large number of databases on my localhost. Whenever I open up Management Studio, there is one database that is selected by default (under Available Databases). But this is not the database that I use regularly. Everytime I run a query, I have to make sure that the database is changed. ...more >>

Hi, Some facts regarding my problem: - I am running the 64bit version of SQL2005 on a Win2k3 Enterprise 64bit installation with 8GB of RAM. - I have configured the min/max values, but they seem to be ignored. - The sqlserv.exe task never takes more than 200 to 300 MB, even after restor...more >>

In trying to create a new maintenance plan via the wizard, the retention type field for both the DB and the TL is blank. The plan seems to create, but then updating it causes a Sql-DMO (ODBC SqlState:42000) Error 8114: Error converting data type Int to TinyInt. Any ideas? -- Graham (Pe...more >>

SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition Can not run DBCC Checkdb on database because receiving the following error messages: Msg 5030, Level 16, State 12, Line 1 The database could not be exclusively locked to perform the operation. Msg 7926, Level 16, State 1, L...more >>

Hi, I'm not soo familiar with how the indexes work... I'm seeing some slow performance on one of the DBs (netiq appmanager product). The Disk queues & memory on the server seem fine. But the processor maxes periodically with sqlserver.exe and queries time out. I checked the DB size by r...more >>

i have created a new tcp endpoint using the following: CREATE ENDPOINT [CustomConnection1] STATE = STARTED AS TCP (LISTENER_PORT = 1444, LISTENER_IP =ALL) FOR TSQL() ; And I got warning about permissions being revoked for the default tcp endpoint, but I was okay with that since I really w...more >>

I have SQL 2k SP4 on Windows 2003 Can A sqlserver user, with out having SA role, see the DTS packages, Job and their status ? -- RK...more >>

Hi all, I don't understand this. I had SPID 104 blocked by SPID 87. However, SPID 87 was sleeping. How can that be? Please advise. Audrey *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi, I am very confused with the result of 'sp_dbcmptlevel' I have many databases on several servers (all upgraded from 2000 to 2005). the stored sp_dbcmptlevel returs following: exec sp_dbcmplevel @dbname='mydatabase' The current compatibility level is 90. Books on line have this sen...more >>

I recently purchased a new development workstation (dual processor) and installed the developer edition of SQL Server 2005 that comes with Visual Studio. I also installed the Management Studio Express tools. Everything SQL-related that I do on this new machine (application access via ODBC, crea...more >>

Hello , I know that to open Management studio I use "sqlwb" in the run window from the start menu. Is there a run command to open up Enterprise Manager? Thanks -L ...more >>

I have a SQL database = 100gb and a transaction log file = 10gb running on SQL Server 2005. When I perform a backup of each I get a database backup = 10gb and a transaction log backup = 36gb. Why is my transaction log backup larger than the original transaction log? My recovery mode is Full...more >>

I have a strange problem with locking. I have a client server application that uses SQL Server as the back end. For 5 years this application has used SQL 7.0 without EVER one occurance of locking to the point that all the users get frozen/blocked. About one year ago we finally got off SQL 7.0...more >>

Hi, I would like to know new features available in SQL Server 2005, compared to those available in SQL Server 2000....more >>

I have SQL Server 2005 Standard Edition installed and I am trying to become familiar with many of the new features. For now, I would like to schedule a full backup to run daily. I have found the option to back up the database and transaction log to disk, but I can not find where to schedule ...more >>

Hi, I've upgraded from 2000 to 2005, 2005 on a new server too. I have moved a DTS package from the 2000 box to 2005 box & have performed th DTS Migration Wizard. Now I want to fiddle with the design of the package in Business Intelligence Design Studio. Where the heck is it (the migrated pac...more >>

Hi, We've recently noticed a problem on our SQL Server 2005 (SP1) database cluster (2 node fail over with shared RAID'd array HD) and its implementation of the Backup Database Task. Our db cluster raided HD has two mapped drives: G: is the data file location for the databases, and H: is ...more >>