A very good question! It seems to me that people seem very keen to...

There are a couple of things you need to check:

- Recovery model of the database (if full then you need to make sure you're doing regular transaction log backups, otherwise...

In order to change the collation for the master database you need to rebuild the system database using the installation procedure through the command prompt. Copy the SQL Server...

Actually I think you'll find most DBA's say yes to those! 😉

For my part backups are obviously key and...

In which case I would focus on the application and any configurations this may have. See if there are any system DSNs on the server that the app runs...

It might be worth checking that the users can actually access the database on the new server. Try creating a DSN that uses windows authenitcation and see if you...

Here are some instructions for configuring IIS:

Before installing Reporting Services, you must enable ASP.NET and IIS. To enable these features, configure a server role:

Click Start.

Click Server Manager at the top...

I love the idea of having loads of money, having a great big house, not have to worry about whether we can afford to buy stuff every month, and giving...

I would hope that my job and my wife's job are fairly secure as we both work in the public sector, but there are never any guarantees. My main...

Granted your query is the easier way of finding out the answer to the question. I don't have that many fingers and toes to count all of the event...

Here's a reference to all the available event classes:

http://msdn.microsoft.com/en-us/library/ms175481(SQL.90).aspx

This is for SQL 2005

I guess we're all assuming here that SQL is installed on this server (a fair assumption given what we're all here for!) 🙂

But as everyone else has pretty much covered...

I'd disagree. It doesn't sound like rocket science granted, but sometimes the most simple of solutions can...

I've had to do something similar myself on our intranet database. One of the webteam ran a procedure that completely screwed up our forums, but because the database is...

I've had plenty of head-banging moments with linked servers so you have my sympathy. But there's one thing that's worth trying and that's to log on to the server...