Be sure you have the original query in your SSMS, and then issue a "drop table test" before you run it.

I've tested on 2 2005 instances, both show the error,...

http://www.sqlservercentral.com/scripts/Miscellaneous/30931/

Read in here about cross tabs.

You do need a crosstab, though if there are potentially lots of entries you are going to have an ugly query and potentially a report...

We can't really teach you enough for an interview, nor are we interested in having you try to show more knowledge than you have.

Be honest that you don't know answers....

I'd use a DDL trigger, capture the drop user from production and build a script to run on the warm server.

Sorry, these aren't published yet. I don't have a good way to get the poll set prior to publishing other than put it out there.

Patience.

I still think tape is cheaper for any type of off-site, archival mechanism. Perhaps HDDs can fit, but most places I know can't get all their backups off to disk,...

Nope, no more contests. They're a pain, and honestly we found a few people are excited and work hard to win, so the same people show up over and...

I've tested this in build 9.00.3077. That's my test instance.

I return an error in SSWK5, AdventureWorks, compat mode 90. No rows inserted.

I can't necessarily verify on every version. If you...

Tape allows for a disconnected medium that isn't active. Moving to disk, often means that you have a process there. you could make this offsite, and offline, but then you...

Here, here. Let some of these...

You'd think there was a way, but there isn't. Gail's suggestion of SSIS is the best way to move to a lower version.

Logins do not transfer to a user database. They exist only in master. The task will work to the mirror server as the logins move to the master database.

Users are...

I'm confused.

If you set up connections to SQL from a client with ODBC, you don't have failover. You need SNAC (native client).

From the server, for mirroring, the failover depends on...

George,

I think most people handle it like other DR stuff. They reinstall SQL (have to know the version + SP + hotfix) on the new server and then point things...

You should read about how logs work in SQL Server so that you understand what is wrong.

A full or diff backup does not clear space from the log. Only a...