i love that line! thanks for...

ohpenot (2/20/2013)

---

IDTheOutput

1nt service\mssql$sqlexpress

2NULL

3NULL

Indeed! That's what i have. I had checked actually when i first red your post (in services, right-click on the instance name..). The point is that for the...

@@spid is the unique Id SQL server assigned to the connection, which in this case, would be executing your stored procedure.

if you run exec sp_who2 on your server, you'll...

here's one idea: modify the trigger to also use CONTEXT_INFO as the update criteria

ALTER TRIGGER [dbo].[tuReferral_UpdateAudit]

ON [dbo].[tReferral]

FOR UPDATE

AS

-- Select the context information

DECLARE @sess VARBINARY(128), @var NVARCHAR(64)

SET @sess = (SELECT context_info...

yes. both triggers will fire. two triggers same table, even if one is an instead of trigger.

That might be a logical error, having two insert triggers on the same...

In general, I think the preference is to avoid triggers when possible.

after that, it's not a preference, but rather which method, a standard insert trigger vs an instead of trigger...

ok not as hard as i thought: here you go:

SELECT StateName,stuff(( SELECT ',' + CONVERT(varchar,RW) + '.' + CityName

...

getting the cities as a list wasn't hard, but i'm having trouble numbering them inline; my row_number verisons not quite there yet, but here's the start of it:

SELECT StateName,stuff(( ...

i guess the question is how are you testing the public permissions then?

did you create a new database user , unconnected form any login like this?

are you using execute as?...

MyDoggieJessie (2/19/2013)

---

I don't believe this is possible unless you already have Change Data Capture running

There is nice app from ApexSQL which can be used as a trial and literally and...

I'm awful sure there is a solution to that; I know i've seen lots of SSRS topics like "don't send if no data is found", kind of threads.

this was just...

not a reporting services guru, but for regular scheduled jobs, i can create a job which does something, like send an email or update or whatever, that runs every...

homebrew i think this is equivilent to your first update query, but should theoretically perform better.

compare the SELECT to teh UPDATE , and tell me if it looks like it...

nikus thank you for the feedback! i really appreciate it!

awesome solution Cadavre!

only thing i would do is clean up the presentation with REPLICATE to get the zeros, and maybe just a simple not like '%[^0-9]%' ; what do you...