Service packs are not listed anywhere. You go off the build version and compare it to http://vyaskn.tripod.com/sqlsps.htm

Interesting solutions and thanks. I said 1 myself, but both are interesting solutions.

I also think that the requirements, asking to read the table once, are misleading. I don't think that...

Jan,

There is no easy way to do this. Something needs to connect to both servers and compare the data. You could send your master db to the customers and run...

Also you will need to configure outlook using the account that runs SQL Server.

Really you'd need to track your database size on a daily or weekly period and then use that. Error logs work as well, but if you are having regular growths,...

Post moved.

Prakesh, what are you trying to do? You can "close" the database with autoclose and resources will be released, but if someone accesses the database, it will reopen. This...

I agree with the above. I started in 91 with the old syntax and never had issues. Outer joins were tricky, but they're still tricky.

However I swithed to ANSI syntax...

You might scan the scripts on this site for some VB Script items. The ones I've most often used are the FileSystemObject and basic server connections (recordset, connection objects).

Here are...

Normal is relative to your server. What might hang your server works great on mine.

You need to look at a bigger picture and not worry about that counter. Find out...

SQL Server is ODBC/OLEDB compliant. Your web server would communicate with SQL Server using one of these types of drivers. There are not specific ones for each applicaiton.

You cannot delete the log. It is an open file that is essential for the database to function.

A database cannot run without a log file.

Dan,

Are you accepting cookies? I use IE and Firefox and remain logged in with cookies setup. It's likely a security thing on your side and I wish I had a...

http://www.sqlservercentral.com/columnists/sjones/20010422115754_1.asp

Part 1 deals with users.

You can use a third party (Log PI, APEXSQL Log, or something like that). Or you can run Profiler and see what happens during that hour.

IIS allows an account to be specified for anonymous users. Be sure this is a basic domain account with only the permissions needed to access only the data needed.