If you add a NEWID() column to your select and then order by it, you'll get some pseudo random results.

DMO/SMO is what you need to examine. You can create a handle to a SQL Server object and then perform various actions.

A few resources:

http://msdn.microsoft.com/en-us/library/ms162169.aspx

http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=259

varchar(max) is recommended as text will go away. It doesn't affect your use of SSMS.

you can change the limits, but not sure if they'll get above 65k. Why do you...

The Forever War is great! My son picked it up in March and when I saw it in the Science Fiction Museum in Seattle, I read it as well.

The information is...

it depends.

Sorry, hate to say it, but the distributor takes a load of writing transactions to a file and then sending them to subscribers. Is that a...

I think Grant Fritchey does some of this with VSTS. I know a few people did this awhile back with Agile development, but not sure how many do it now.

you'll need to build scripting into your process to append the date to the name as well as delete the old ones. I'd make these two separate processes, one calling...

I think you'd have to read this out of the registry.

Buy a tool. Most of them are cheap and they do a good job. this isn't a hard task, but it's easy to make mistakes. For $300 or so, you...

You can check sysdepends, but that's not always accurate. You can also search syscomments, but that may or may not work.

Red Gate (I work for them) has a dependency tracker...

I don't think you need to restart SQL, but I'm not sure how much benefit you get here. Unlike regular database files, you can't really control where tempdb objects are...

There is no way to do this across all fields without explicitly testing them. It's a pain to build, but if it's needed, you write it once and it's used...

I could see a snapshot on msdb for history purposes or even testing since it's got scheduling/history data.

This isn't a place for people to do work for you. Show some effort, try to figure out what you need and then ask questions. We'll try to help, but...

You don't want to encrypt data with a certificate or asymmetric key. Use a symmetric key to encrypt the data and encrypt the symmetric key with an asymmetric key.