Hi Steve,

How do you get the time to reply so quickly when you're at Tech Ed? Anyway, it would be a very short article so here is an example script....

Thank you Sanjay but I needed to get the port that a user connection is coming in from not the one(s) that SQL is listening on. The system view, sys.dm_exec_connections,...

Thanks Steve - sys.dm_exec_connections did it.

Yep - that's exactly what I did and that makes perfect sense now :hehe:

Thanks

I thought it would be an empty result but wasn't positive decided to "test" and created the table. I got this message on executing the query:

Msg 8121, Level 16, State...

Glad I could I help. It drove me nuts when I ran into it.

This is an obscure bit of information that I always seem to forget with proxys. The SQL Agent account that runs the job will have a Temp folder. The proxy...

Up to now, we have never moved a complete database. For the most part we use linked servers of ad hoc queries to pull data so I just didn't think...

I was just about to roll my own when I came across this looking for an updated version of DumpSec. Thank you, Thank you, Thank You:-D:-D:-D

What really burns me up about the "error messages" is that the people who write the compilers know exactly what the "error" is so why can't they just say so...

Just to add to the knowledge base on this, we recently had the same issue. We normally "pull" data from Oracle into SQL but for this project it was the...

I figured out my problem. I was trying to get the permissions on a Role. Wrong place. It all works well when using the proper objects such as tables, views,...

Hi Gary - dbrname was the database name being passed to the VB.Net sub. In the POSH script, $db is the database and $dbrole is the role in the database.

You can use the GUI. In Object Explorer, click on the Linked Servers node and they should be listed in the Object Explorer Details. Select all the Linked Servers in...

check this link:

http://blogs.msdn.com/petersad/archive/2009/06/17/creating-a-merged-slipstreamed-drop-containing-sql-server-2008-rtm-service-pack-1.aspx