Assuming that this was not a trick question, I believe that the correct answer is 'it depends'. You can set the status bar for the query window to display...

The explanation contradicts answer number 3 being true.

I learned something. I thought that the backup would be OK, but the there would be no history for the backup in msdb.

Good question.

If you need to have your items inserted into the temp table persist outside of the transaction, you should consider using a table variable instead of a temp table. ...

You might check your permissions in Server B. Keep in mind that the the insert on that server will be acting in the context of the login set in...

If you use this method, make sure that users are not entering or modifying data because you will have issues with transactions made to the old database after the backup...

Good question! I learned something today.

If you are using version 7.x you need to go to tools/report template builder. There you will find all kinds of options to create whatever type of report you...

Shouldn't the where clause of the 3rd statement be "where id = 2"?

dmc (1/9/2009)

---

This database is movable in 2005. Is it not in 2K8? I know its movable because the person before me at this job moved it and when...

I don't believe that you can move the mssqlsystemresource (resource) database. See the portion of the following article regarding moving the resource database: http://msdn.microsoft.com/en-us/library/ms345408.aspx

Festeron (10/15/2008)

---

I agree...

This appears to more of an advertisement than an article. There are some down sides to oursourcing the DBA function and those are not mentioned.

What's wrong with that? This forum should be open to SQL Server DBA's at every level. ...

This does not work on SQL Server 2005. You get the following error message:

"Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the varchar value 'B' to...