Viewing 15 posts - 1,621 through 1,635 (of 2,387 total)
I did reproduce the error as described by KB 812915. Thanks to ianscarlett.
I have confirmed it is a SQL Sever bug and Microsoft has a fix for that. If you...
June 13, 2003 at 7:57 pm
Run sp_droprolemember to remove 'B6013' from your 'glreports' role and then try to drop the login.
If you still see errors, use sp_dropalias to remove the alias.
Edited by - Allen_Cui on...
June 13, 2003 at 1:48 pm
Which version of SQL Server and Service Pack are you running?
June 13, 2003 at 1:07 pm
Can you post the result of sp_spaceused @objectname = 'yourtablename', @updateusage = true? Any indexes created for this table?
June 13, 2003 at 12:33 pm
Use sp_dboption to verify your database options whther 'auto close' is enabled.
June 13, 2003 at 12:16 pm
Try run sp_changedbowner 'anyotherloginhere' and then sp_changedbowner 'sa'.
June 13, 2003 at 9:46 am
Read SQL Server 2000 Operation Guide at http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/default.asp
June 13, 2003 at 9:44 am
quote:
maybe you have followed my thread about profiler and privacy?At the moment I can't use profiler until I get an answer on...
June 13, 2003 at 9:40 am
quote:
Hm, all I need to know is, whether WRITETEXT or UPDATETEXT are utilized
Can you...
June 13, 2003 at 9:12 am
This KB seems answer your question.
http://support.microsoft.com/default.aspx?scid=kb;en-us;272093
June 13, 2003 at 7:45 am
Yes, I did but it doesn't apply to my sitution. The SQL Server performance counters show up without any problem if SQL Server running active/passive in service pack 3. It...
June 13, 2003 at 7:03 am
Correction about the additional licence. See http://www.microsoft.com/sql/howtobuy/activepassive.asp
Quoted
"The only permissible exception to the requirements for a Processor or Server license is a purely passive server with SQL Server 2000 Enterprise Edition...
June 12, 2003 at 4:51 pm
Viewing 15 posts - 1,621 through 1,635 (of 2,387 total)