Yes it does.. i didn't think it would overlay the one inside my current transaction though.. looks like SCOPE_IDENTITY did the trick though.. handy to know.. i have @@IDENTITY in...

I found this on google..

http://msdn.microsoft.com/en-us/magazine/cc163473.aspx

hope it helps

seems like it reads from the remote machine just nicely.. im running it from an xp machine and im getting windows server 2003 SP2 as the result.. so yeh.. thats...

If i were to connect to my remote machine then issue the command, would it pull back the machine im working from, or the machine im querying?

hmm.. i didn't know that existed.. let me google it and see what I can find..

thanks

I have a little app which will pull a few key metrics for me for different servers on the network.. some of these servers have applications on them, not good...

yep.. actually did that days ago, and I have roughly 20 or so sites bookmarked, none of which answered the exact question I asked. theres plenty of reference material...

a guy i work with wrote a vb app that was propogated to all the machines in the company with group policy & login scripts which ran wmi queries which...

i cant take credit for the sp_who one.. i read it somewhere.. cant remember where though.. made me chuckle though 😀

knock knock..

whos there?

sp

sp who?

spid1.. spid2.. spid 3..

I think I have a solution, it just requires that OLE Automation be turned on..

SET NOCOUNT ON

DECLARE @hr int

DECLARE @fso int

DECLARE @drive char(1)

DECLARE @odrive int

DECLARE @TotalSize varchar(20)

DECLARE @MB bigint ;...

in a perfect world.. yep.. they'd be 2005/2008 - but.. there are...

I was hoping to avoid manually entering these values in.. lots of sql instances to monitor, and I was hoping to create a standard job I could run (even on...

Thanks a lot Felix, thats exactly what I was looking for..my pivot attempt just wasn't quite right.. but that works perfectly

Thanks again!

Thats a nice solution for a horrible situation.