Try the attached file in Management Studio. See if it does what you need.

You can use a column name instead of the @XML variable, if you're inserting the data...

If it's a reporting services report, then reporting services is the front end.

If you really need to do the pivot in SQL, then take a look at the article on...

I can't quite tell, but it looks like your first Case checks for the presence of a comma, then runs a charindex on a blank space. If that's what...

CTE or CLR? I think you mean CLR.

http://www.simple-talk.com has an article on dynamic pivots in SQL.

Personally, I always recommend pivoting in the front-end application. Excel, Crystal, SSRS, are all better at dynamic pivots than T-SQL is.

Autoshrink is always a bad idea, so far as I can tell. Even Microsoft recommends against it, and they're the ones who made it available.

Most likely, a change in the domain. Otherwise, something changed in the DNS files or the server.

Can you create an empty copy of the database, then add the filegroups to that?

It can. Whether it will or not is another question that depends on what else is going on with the table at the same time.

You'll want to join the tables using that column, then put the other part in the Where clause.

If you can put the create scripts for the tables into the forum,...

Including it improves performance. The only reason to not include it is if different users access different tables, and you want that managed by the database. Doing so...

There is no perfect solution. Either the data is completely secure, and can easily become unretrievable, or it's just barely secure, and easy to recover, or somewhere in between.

Since...

I don't have enough data to be sure, but the way you currently have it looks correct, or at least standard.

If that index will work for clustering, then sure, go ahead. You'll know more about the table and its uses than I do, so your judgement on the subject...

In that case, I think you're stuck with setting up the dependency and hoping they made it fault-tollerant enough to deal with it.

I guess your best bet would be to...