Apologies! The answer has been corrected and the points awarded back. The question was submitted by a user and I was in a rush and didn't double check it.

At this point I think you want to uninstall, reinstall SQL. Then you can move the master and other databases to where you need them.

As far as moving:

http://www.sqlservercentral.com/columnists/sjones/moveyourmaster.asp

http://www.sqlservercentral.com/columnists/sjones/movingmsdb.asp

I assume you have, but did you CAST both the variables to something?

The code entitles you to some extras from us, but doesn't change the price of the conference. The PASS folks changed the discount from $500 to $400 on July 1...

Apologies. The SET FMTONLY on part was a typo from the previous day.

I don't like to do this in code, but if you must, query the information_Schema.columns view for the table and column.

Can you query sysdatabases? select * from master.dbo.sysdatabases?

I bet id3 = tempdb, which means you can't find those mdf/ldf files. Get them and put them in the proper place to...

Wow, that's quite a long time. The site's been here since March 2001, so not much before that.

Thanks for sticking around!!!!

There is no deadline from us, well maybe Sept 22nd or so. However the PASS prices go up soon.

http://www.sqlpass.org/summit

Are you replicating system tables? You should not be doing that.

Interesting responses, but keep in mind this is an interview, not a real life situation and Andy is assessing how the person "thinks". I'd personally lean towards print statements to...

Key management is hard and I question the wisdom of this exercise.

http://www.sqlservercentral.com/columnists/sjones/wp_encryption.asp

If you feel you must: http://www.protegrity.com/

For Yukon, I'm not sure. Have you tried uninstalling and then deleting the registry keys for SQL Server?

The other solution is for you to reinstall in a new folder and...

I knew I wasn't the first to use it. Some interesting ideas, especially the statis cell.

There are some post SP3 patches, mostly security related, but possibly something else.

http://www.microsoft.com/technet/security/current.aspx?productid=30&servicepackid=0&chkcritical=on&chkimportant=on&chkmoderate=on&chklow=on&seldaterange=0&txtdatestart=&txtdateend=&submit1=go