Search results for query: *

Check out the following article about the above worm. It attacks servers which have a blank 'sa' password by using the extended sp xp_cmdshell 'SQLsnake' Worm Blamed For Spike In Port 1433 Scans --------------------------------------------------- By Brian McWilliams, Newsbytes SAN MATEO...

Hi There Can anybody give me any advice. Is it possible to have a Main server "ServerA" on a Windows2000 domain with a linked server set up "ServerB" on a WindowsNT domain. Can I run Distributed Transactions on this server ? When I try I constantly get this message...

Hi There Does anybody know 1. If I can enlist a target server that is on a different domain to the master server and if so how ? 2. If I can enlist a target server that is on a different workgroup to the master server (which is part of a domain) and if so how ? How do you use MSX and TSX...

Hi There Does anybody know if you can you the SQL Server 6.5 client and SQL Anywhere 5.5 client on the same pc. I am having problems at the moment trying to get them to coexist !!!!! Bernadette

Hi There How often should I run sp_compile and update statistics on a SQL6.5 server ? Also, should I run these jobs on SQL7.0 or are they handled automatically ? What do you guys do ? Any advice would be appreciated. Bernadette

Hi There I am wondering if anyone can help me. I have a set up with 1 master server and 7 target servers. The Master server went down earlier on today and had to be rebuild. After SQL was installed I restored the msdb backup to restore my jobs on the master server, however now none of the...

Hi There I used to run a script to monitor the size of the transaction logs in the database while in SQL 6.5. Does anybody have a script which will tell me my transaction log size and amount of unused space in it for SQL 7.0 ???? If not, how do you monitor your transaction log size on a daily...

Hi There I used to run a script to monitor the size of the transaction logs in the database while in SQL 6.5. Does anybody have a script which will tell me my transaction log size and amount of unused space in it for SQL 7.0 ???? If not, how do you monitor your transaction log size on a daily...

XP_Cmdshell runs with the full permissions of the account it is running under so if your SQL Server is running under a domain administrator's account - then the 'sa' account will have control over the NT network using xp_cmdshell. The 'sa' account can run any OS Command including "format...

Hi There Can anyone tell me which are the important SQLServer Counters in Performance Monitorto monitor my servers with. I have to issue weekly statistics and have looked BOL and the Knowledge Base but I am finding the Performance Monitor a bit confusing. Any help would be appereciated. Thanks...

Can anybody tell me the main differences between a Remote Server and a Linked Server ? Thank You In Advance Bernadette B-)

I was wondering if anyone could help me and give me any advice about Transfering Database Diagrams from one server to another ?? Thank You in Advance Bernadette

I have a server called "Invest_LM_DEV" running SQL Server 6.5 and it is constantly sending "SQLCtr60 Errors" to the event log. I have checked the knowledge base and checked everything on article "Q227662", however it is still giving SQLCtr60 Errors. These are the...