My first thought was to use PowerShell. Here is a script that looks promising

http://gallery.technet.microsoft.com/scriptcenter/79644be9-b5e1-4d9e-9cb5-eab1ad866eaf

J M-314995 (2/6/2013)

---

If there is a way to import files using a wildcard character without having to rename the files (using a static file name), I'd sure like to know....

Nice workaround. Thanks for posting back.

I am not sure I understand the qualifier you mentioned. How is "done using" different from "don't need the document to be in an open state"?

Once we moved beyond the terminology of "sysadmin" the way I am reading the requirement "But I need to ensure this local admin has sysadmin rights to only one DB."...

VIEW SERVER STATE might work if only view is required. It offers nothing in the way of managing and allows the user to see things related to other databases, not...

I am thinking you meant 'membership in db_owner' and not 'dbo.'

You gave them dbo?[/url]

With regards to activity monitor, this should be...

I have run into that too. Are there restrictions on compiling permanent or temporary stored procs into tempdb?

If permanent procs are disallowed you could change the CREATE portion of the...

Why use sysprocesses here, a deprecated feature of SQL Server? One other side note, if you're not in master then you have to fully-qualify it as sys.sysprocesses in SQL 2008.

sp_whoisactive...

What is the goal? A set of rows with no duplicates? If so, would you want the row with the max ID? the min ID?

Most importantly, what have you tried...

Anywhere in your code once you're done using the document.

I tend to agree that for a few thousand rows you'll find that the effort to split the tables will not be worth the gains you might receive, not to...

Er, no.

VBScript can do popups or download Visual Studio C# Express Edition and create a Windows Forms app.

In that case I would recommend you move towards a C# Windows Forms app. Anything done in Batch would be a workaround and I cannot bring myself to recommend new...