What about something like a Restore with Replace and just restore to a new file location?

You mean you created 30 filegroups and then created all your data files under primary? Or did you not actually create the filegroups?

Adding filegroups and then creating files...

Sticking just with TSQL, here are a couple of other options...

Assuming your target tables have the same schema you could fudge together other alternatives like creating a...

Your syntax error is because you're using a variable for the database name, you'd need some dynamic SQL to make it work.
If you still want to stick with a...

You could also create a job with a powershell step to access the files. I used this the other day for importing a bunch of create object scripts

$folder = "c:\scriptfolder\";$scripts...

OK that explains a lot then 🙂 Spaces tacked on at the start or end of a result can be a pain to troubleshoot when you're not expecting them, glad...

I'm also a bit confused about what the actual data looks like.

"WHERE EST_UOM <> '%'" assumes that the actual value in the column is "%". It will still return rows...

engrshafiq4 (2/1/2012)

---

Hi all,

i have alot of store procedures ...i have written discription etc for each while creating sp.

now i want to create a document for that.

i need a script which...

Dbloc (1/31/2012)

---

I must mention that there are some other columns in the table that are specific to each row. I should have mentioned this right away but forgot. sorry 🙁

So...

We had similar issues in our environment when two instances shared a node. Currently, on sql startup (like after failover), we have a procedure that runs and checks how many...

The sysadmin role is a very powerful role in that it can perform any activity in sql server including deleting databases, logins, changing objects, shutting the server down, etc. NT...

Good to hear!

This page has all the grant information needed http://msdn.microsoft.com/en-us/library/ms188371.aspx

for the procedures

GRANT EXECUTE ON [procedure] TO user

and this is probably easier for the tables than doing grants though it will be...

I agree it's not phrased very well, but if I understand correctly then there's a good answer to a similar question over at the msdn forums : http://social.msdn.microsoft.com/Forums/en-CA/transactsql/thread/c097ff31-aa01-4d7f-a1c4-63d3738ed147.

Yep. Anything in the Application event logs related to mail or the mail queue?