Have you thought about log shipping, replication or database mirroring? Here is a link you might want to look at that describes all three options.

http://www.logicworks.net/page.php/prmID/313

Thanks. 🙂 It did not seem to be causing any problems, but I have not come accross it before. Couldn't find any documentation on it either.

I selected the answer "run GUI from original CD...." Because from the following KB (http://msdn2.microsoft.com/en-us/library/ms144259.aspx#rebuilddatabase) it says:

To rebuild system databases for a default instance of...

The following link also shows that the two can be run concurrently

http://msdn2.microsoft.com/en-us/library/ms187900.aspx

I answered that you have to uninsatll then reinstall because of the following KB http://support.microsoft.com/kb/914158#top.

It states: To work around the problem (of not being able to...

For April Folls day I thought the answer would be True. Or at least get points for both answers.

I ran a test with SQL Server 2005 compatability mode 80 and the query worked. When I made the compatability mode 90 it gave me the "ambiguous column name"...

What type of authentication are you using, windows only, or sql server and windows? Try logging on with windows authentication instead of the SA id.

.NET 2.0 was reinstalled. The problem was that a patch to .NET 2.0 was uninstalled and it caused problems with SQL Server. We had to reinstall .NET 2.0...

Do not use the "Attempt to repair any minor problems" option. This will put your database in single user mode and can cause unforseen problems.

I agree with EdVasse. We have the same situation here where everyone logs in with the SA id and password. I am now in the process of putting...

I can sympathize. When I started my new job there was no DBA before me. No one knew that you needed to back up the system databases so...

Thanks for all of your responses. I will try Adam's view and see if it gives me the results I need.

Thank you for your information about profiler. I will try that. But I was also curious to know why BOL says eventinfo is nvchar(4000) and it will only...

I worked from home for 7 years, now I am back in an office environment. When working from home, I found IM really helpful in keeping me in touch...