I came across a blog post by Chrissy LeMaire[/url] that looked interesting, I'm not in a environment to try it though.

If your SQL Server installation is with service pack 3 (meaning it will install at service pack 3 level of SQL server) then I'm pretty sure Windows XP must be...

Active Directory itself includes a attribute that can be queried that has the last logon timestamp.

Now this timestamp does not mean that SQL Server was the last thing they logged...

Understanding SQL Server Backups

Good article from July 2009 issue of Technet on backups.

Duration column within profiler indicates how long the process took in milliseconds.

Have you query sys.objects to check if the table was created after the backup you are trying to restore from?

As far as using a domain account or local account it depends on the security policies and guidelines for your company. I would check with your Security Officer (or...

The way I read it it seems there is a system process running against the database. Do you have any backup software that is taking a backup of the...

End date is 01/12/2010 as per the link you provided.

Yes your assumption is correct through, after that date when you call MS for support they will state the lifecycle for...

From this link

TCP/IP Sockets

TCP/IP Sockets is a non-authenticated protocol. This means that connections are not authenticated, and...

When you create the ODBC connection what authentication type are you using? What authentication mode is the SQL Server you are connecting to in?

Is 'remote access' enabled for your SQL instance?

exec sp_configure 'show advanced options', 1

reconfigure

exec sp_configure

Executing the above will display the configuration. Look for 'remote access' and see what the configured...

What method did you use to "copy" the database?

on the SQL Server can you either logon as that domain account and access the share?

Or you logon and try to map the network drive, using the domain account in...

SQL is not ment to run in that manner. Each edition you installed is fighting for memory on your system and process. There is not real point in...