This was very helpful, thank you.

Adding brackets around the name actually doesn't work in my experience, although it changes the error message I get. Without brackets, it picks up the first parts of the server...

Thanks so much for your reply. It is particularly reassuring that I'm not the only one who was worried about this. 🙂 Thanks again.

Hey all,

I realize this is an old thread, but a colleague helped me find the solution, and I wanted to post about it here since it describes a frustrating issue...

Thanks for the replies. Yeah, I'm running a restore query that a colleague wrote, so I may not understand it very well. The .bak db file was on the D...

Wow, that sp_help procedure is great. Thanks for letting me know. I had been copying the column info out of a view before, haha.:-P

I did match up the columns in...

Eric Stimpson (8/29/2011)

---

Update for Windows 7 x64 OS:

Use HKEY_USER instead of HKEY_CURRENT_USER. You'll need to know your current SID (Security ID). This you'll find by looking at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows...

Thanks for the reply. When you fill in the relevant names for tablename and id name, that SQL 2000 statement works.

I also found a way to check this in the...

Yeah, I started that. That's the thing that in SQL 2008 I find a little too optimistic and worry-free.:-)

Wow, so many great responses! Thanks so much folks. I like the rollback idea (I'm not that familiar with it, I'll read up on it), as well as using a...

These scripts seem great--thanks guys!

One thing is that they're returning a lot of results. I think this is because the command in question I specified was from a couple of...

I'm running SQL 2008 R2 now, and this method still works for me. Simply look for the registry path \HKCU\Software\Microsoft\Microsoft SQL Server\10... instead...

Hey all,

A colleague of mine recommended a good solution to this issue, so I thought I'd share it here.

You can use osql with the -o switch. This will output the...

Ahh, that makes sense. I like the joining of the max appdate as a created field. Thanks!

Thanks for the advice. Re: performance issues, no where in particular, but performance is an issue in general. 🙂

I was wondering about this because I was curious about cases where...