Strange, how are they accessing the databases?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

No effect. The events are still written to the SQL log. If you have configured events to write to the NT log, they will not be written.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

There are two ways.

1. There is copy logins task in DTS. This is the one that looks like a server with a person in front of it.

2. Search sp_help_revlogin on...

This is the only product that I know of. Nothing will read selects as they are not logged.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Haven't tried it and someone whacked my VMWare workstation, but I hope to give it a try soon. MDAC tends to break things around here, so I'm not sure how...

Is this a local account? Should be .\sqlserviceaccount. Or if it is a non-admin domain account, domainname\accountname

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Two questions:

1. Where in Silicon Valley?

2. What is RAID programming experience?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

SQLZip (I believe) uses an algorithm similar to Winzip and eats up quite a bit of CPU. Compression is better than Litespeed set at level 2, but didn't appear to...

I've seen this a few times and never figured it out. Only a reboot has solved it.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Is there a primary key?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

These are used internally by the service. Not sure exactly what each does. I believe that xplog70 handles the SQL Server logging.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Is the server running? You might open the Services applet and be sure the server is started or even manually start it. I've seen places where it doesn't start in...

There are a number of ways. You could make a call to isql and see if it returns data. You could monitor the server, srvinfo.exe will tell you if an...

Posts about pet peeves

Just kidding. These days it's corporate management.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Do you mean the first ten records in the table or matching some pattern? Or do you want the first ten rows of data matching some zip code?

select top 10...