sure, something like this will give you all the spids that are coming from a given hostname...

if i have 8 SSMS windows open, i will have 8 spids, so it's...

looks like you already have it there, Welsh Corgi;

you are using the object_schema_name() function, so just add it to your WHERE staetment :

AND OBJECT_SCHEMA_NAME(ep.major_id) = 'CTL'

great...working as expected

disabling a user...

jshahan (4/5/2012)

---

Thanks much, Lowell. We may have not been aware of how easily this can be accomplished and I'm really glad I asked. I'll run it by my...

just my two cents:

if you've created a CLR assemby on one of your servers, it is trivial to script the assembly as a binary string, which can then be executed...

small world, i'm playing with the exact same thing, and it is working beautifully.

YAddress has posted a nice CLR on codeplex for US addresses , and it hits a free...

ok...help us help you;

what would you like to do to the data? for example, if you KNOW the datetime string is always at the front, and always has the GMT...

then just change the join condition to

ON (target.ITEM = source.ITEM)

AND (target.DESCRIPTION= source.DESCRIPTION)

something like this passes the syntax check:

MERGE INTO dbo.tableA AS Target

USING(

SELECT ITEM, DESCRIPTION FROM dbo.tableB

) AS source

ON (target.ITEM...

just a basic logic error;

a trigger uses the virtual INSERTED and DELETED tables, not the whole table itself.

using the INSERTED table will update only the items that were affected, and...

sys.objects is a view which is filtered on the database_principals permissions.

rows of data may exist for an admin which will not be visible to that user; simple enough to prove:

create...

well, as you probably read over at books online about sp_settriggerorder (Transact-SQL), you can set the first trigger, and the last trigger.

there is no way, with four triggers, to know...

databases all by themselves are independant of service packs.

only system databases(master,model,msdb)...

another way to do it:

use xp_cmdshell to get a list of all files in a directory, or all files including subdirectorys;

sticking that data into a table, you can join the...

ok got it.

the files may have been deleted.

You could do it via xp_cmdShell, or with a nice CLR that Elliot Whitlow has posted out there:

http://nclsqlclrfile.codeplex.com/

then you can use a simple...