I did something like this before. Just wanted to note how I did it as it can eliminate the use of sed grep and find (since you already are...

all the solutions given use:

xp_cmdshell, sp_OACreate, sp_OAMethod

which you state is not an option.

what about clr procedures? you can access performance counters this way:

PerformanceCounterCategory pcc = new PerformanceCounterCategory("LogicalDisk", SERVER);

PerformanceCounter pcPercentFree...

Using command line options you can specify a server to connect to on startup - but this only opens a query window. The object explorer remains blank and you...

isn't this an interesting one.

Is this contained to one database, or all on the server?

Same on the master db?

Does the same thing happen when you run your query using a...

Look into merge replication. Might provide an acceptable solution for you.

http://msdn.microsoft.com/en-us/library/ms152746(SQL.90).aspx

both scripts (2000 & 2005) run perfectly. This is a GOOD ONE.

Thanks!!

-- and i just realized I didn't answer your question whatsoever. Talking about restores 🙂

check this article

http://www.karaszi.com/SQLServer/info_restore_no_truncate.asp

have you tried deleting and re-registering your server connection?

well ... here's what I know - might get you going.

Tools Menu / Options / Query Execution / "By Default, Open queries in SQLCMD mode" check box.

this will auto turn...

Ya, I don't know. I read it differently. It wasn't very clear.

I assume PID was the tree, and the second level was the branch. And the results...

I was thinking a recursive query, but couldn't think of how to properly make it go back down the tree to find the remaining items... the recursive query misses 40...

what im seeing, is you have 70. You know 10 is top level. So you want the entire tree that 70 is in.

Not just the path in the...

You can use views, join them to temp tables, and put it SP's.

But you can't create or reference a temp table within a view.

You have to do the...

this will generate an alter table statements -- i just whipped this up so its not tested, but should get you started. If I have some time tomorrow I'll...

Agreed - keepass generate&save is the way to go.