Thanks Gianluca.

One *major* inconvenience, at least for me, is that the "URL" tags in posts are not automatically underlined. Who knows how many links I have not seen because the URLs...

I agree, the search is pretty useless. I would appreciate that getting an overhaul as I also currently use Google.

And just in case Grant didn't mention it, test again.

But seriously, for this kind of change you *REALLY* want to be sure everything works. And in your testing be sure...

I'd be very surprised if there isn't a tool from RedGate (an SQLServerCentral.com sponsor - click their ad at the top right of the page) that can do this for...

Sony would love that! Are you ready...

Did I post this in the wrong section or do people not have experience to share in this regard?

Thanks Jeffrey. The point in shrinking the log file was that I didn't want to waste space with a large backup for a database that was just to test something....

Thanks for the reply Howard. Is the default log...

+1 on coming to South Africa! 🙂

Thanks guys.

Thanks guys. Yes, @@SPID is what I was looking for.

When adding columns to a table via our admin app, I need to show the admin user that the users X,...

Very useful article concept/theme - especially for the newbies, illustrative and effective example, great username (although I trust that you're not a construct :-))

Yeah, and I filed away some useful keywords that I found while spelunking through MSDN/BOL.

That works for me. Thank you very much Paul, I appreciate your help.

For those of you who are interested in the SELECT statement to view connections and some connection information...