Ok, and what statement is failing where?

Does the user executing that have permissions to create explicit tables in TempDB? Why permanent tables and not temp tables?

Without seeing the script, no idea.

What report are you asking about the script for?

Honestly, there's no way to answer that question. Depends on too many factors.

Write the code, test...

Sure, if you want a nice little SQL Injection...

So why don't you post your thoughts and we can comment on them? As it is, it looks like homework and rather vague to boot.

Define 'not working'?

If you have a full database backup, there's nothing special that needs doing, at most all the files need the WITH MOVE clause, but nothing different between mdf...

ALTER DATABASE (db_name) SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

Otherwise it waits for existing connections to disconnect and it's willing to wait forever.

And unless the DB was suspect, you don't need or...

Ditch DTA. If you read the articles, I show how to identify the worst performance problems of what's in the trace, how to dig into the procedures and what you...

Please don't tell...

ChrisM@Work (2/21/2014)

---

GilaMonster (2/20/2014)

---

PSA: Yes, my blogs (and email, etc) is down, I have noticed (no email for almost a week is a good hint). Yes, it is being looked into....

Post the exact output of your attempt to repair

Errr.... a copy-paste of an entire thread? Is there a problem/question here?

Step 1, parameterise that query

Step 2, read up on the .NET parameters collection and use it.

Step 3, read up on all the horrors of SQL injection attacks that you've now...

Please post new questions in a new thread. Thank you.