Greg,

The duration reported for the Audit Logout event is the elapsed time for the associated connection, from login to logout, reported in milliseconds.

So, it's not the cause of the problem. If you...

You can find support life cycle information on the Microsoft Support web site at this address: http://support.microsoft.com/?pr=lifecycle

For SQL Server 7, mainstream support ends 2005-12-31, and extended support ends 2010-12-31....

By default, the newer MSDE packages (SP3 and higher, I think.) disable network access to the instance. If I had to guess, it would be that MSDE isn't listening on...

You generally need to have the SQL Server running under a domain user account for it to be able to access network resources, such as file shares. So, although you...

Check in Books Online, if you have it, under "XML and Internet Support",

there is a section on "Accessing SQL Server using HTTP"

A link to the online version:

http://msdn.microsoft.com/library/en-us/xmlsql/ac_xml1_022c.asp?frame=true

Hope this helps you...

You can review life cycle information for Microsoft Server family products at the following web site:

http://support.microsoft.com/gp/lifesrvr

Mainstream support for SQL Server 7.0 ends December 31, 2005.

Hope this helps!

The sp_configure above won't work for what you need to do.

It's used for remote stored procedure calls.

If the the default instance on ServerA was installed with the default options, then network access to...

Nari,

You should use the /3GB switch in the primary node's boot.ini file. (Only the primary node, as the other hasn't been upgraded.)

This will change the standard mapping of 2GB kernel/2GB...

Here's what I would do:

First, make backups.

Read the sp_attach_db topic in Books Online.

I would detach the database using sp_detach_db, copy (not move) the log file to its new location, then attach the...

I would check to see if the MSDE you're attempting to upgrade is a named instance (Look in Services for something like MSSQL$InstanceName.) If it is a named instance, you...

Microsoft does indeed appear to have licensed at least some portion of the Diskkeeper engine for the Defrag utility. If you look at Help->About Disk Defragmenter... it mentions Executive Software Int'l....

Fred,

You might try using the DROP TRIGGER statement in Query Analyzer. It's a little more efficient than using Enterprise Manager and much less prone to hanging on a busy server.

More...

You'll also want to script out all of your SQL Agent jobs and delete them before you rename the server.

Run the scripts to restore the jobs after the rename...

Nita,

I would guess that the SQL Server Agent is attempting to log in to the SQL Server as sa.

To verify, right-click on the SQL Server Agent in Enterprise Manager and...

I had one of these the other day, and this MS KB article saved me.

http://support.microsoft.com/default.aspx?scid=kb;en-us;888634

I used the RecoverCorruptDB VBA routine to recover the tables and imported them into...