Viewing 15 posts - 16 through 30 (of 31 total)
System tables should not be altered (DELETE, UPDATE, or INSERT) by a user nor should a user create user-defined triggers on system tables.
There is no harm referencing documented columns in...
May 10, 2004 at 1:46 pm
Make sure that your Windows NT users and groups (both local and global groups) are incorporated into SQL Server as logins. By themselves, Windows users and groups do...
May 10, 2004 at 12:58 pm
Apparently something went terribly wrong. I will try to work with you step by step. Please do the first step and post the results. I...
May 10, 2004 at 12:22 pm
Deadlocks? Or Locks owned by orphaned sessions?
Some times deadlocking is confused with normal blocking. When one transaction has a lock on a resource that another transaction wants, the second transaction...
May 10, 2004 at 10:37 am
Apparently the issue is related to Service Accounts. SQL Server 2000 services accounts and passwords are linked to Windows user accounts and passwords. If you make...
May 10, 2004 at 7:50 am
You may find some useful information about ERROR 8344 on the following article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
Regards
May 8, 2004 at 9:48 am
Your issue may have a connection with the following:
The MSCS cluster group that holds the database files for a SQL Server instance is associated with a SQL Server virtual server...
May 8, 2004 at 9:19 am
You may be getting this error message when the file you transfer contains a DRI in this case a non clustered index.
May 7, 2004 at 9:10 am
May 7, 2004 at 8:35 am
Normally a sleeping process may be waiting ether for a lock or user input. Cortec is correct the process is not holding locks.
Regards
May 7, 2004 at 7:03 am
Make sure that the startup account assigned to the MSSQLServer Service is a member of the Local Administrators group, and if the BUILTIN\Administrators SQL Server login...
May 7, 2004 at 6:24 am
Setting SET WORKING SET SIZE to 1 forces the OS (Windows NT 4.0, Windows 2000, and Windows Server 2003) not to swap out SQL Server pages...
May 6, 2004 at 3:42 pm
Congratulations! apparently you found the culprit. Definitely, make sure you code efficient transactions in your stored procedure. For information on designing and coding efficient transactions...
May 6, 2004 at 2:35 pm
If you have EXCEL 2003, Import the data into EXCEL and then use the Pivot Table and Report functions. You will save yourself a lot of...
May 6, 2004 at 10:21 am
Try the following:
- stop and then start the SQL Server service
- When you list the SPNs, make sure...
May 6, 2004 at 9:48 am
Viewing 15 posts - 16 through 30 (of 31 total)