einman33 (11/3/2009)

---

Automatic kill can be a death sentence especially when the rollback kicks in. I would personally go a different route to figure out why this spid is...

homework questions, you think? trying to make...

lol no, MS does not issue any default system triggers, that's for sure...also you can kind of tell by the name:'DDLTriggerTest'

definitely some trying out some code.

Feebie (11/2/2009)

---

hi,

when u tried to modify the procedure then it gives me error like this...

Procedure tr_ProcedureEvents, Line 6

Invalid object name 'DDLTriggerTest..EventTableData'.

please let me know what causes this...

the answer is yes and no.

once I have a username and password, I'm good to connect with anything i can get my grubby fingers on...SSMS, a program i write, Access,Excel,...

without more details, all i can offer is an example:

in this case, I've wrapped the counting sql with another query to get me the isnull of the count.

SELECT ISNULL(CNT,0) As...

ahh, that's the difference between a variable and an array of values:

SQL will not auto convert a string(@var) into an array of values...you have to explicitly do it.

select name...

simple i think:

ad a preceeding and ending single quote, and replace every comma with singlequote-comma-singlequote

that will work weather there is one value or lots of values.

SELECT '''' + REPLACE(YourColumn,',',''',''') +...

i've done this all via TSQL; I happen to also get all the scripts in FK hierarchy order as well.

this has a dependancy for the procedure sp_GetDDL, which gets any...

i use this and stick it in master:

usage is simply sp_kill databasename

this is simliar to Sanjay's, but a little more robust on a couple of validation things like your own...

Shabba (10/30/2009)

---

hmmm... can only seem...

the unregisted version of Editplus is free, with only...

i use the cliptext feature of Editplus to save all my snippets and valuable code; i try to organize with a keyword and brief description;

if i double click on the...

ok, if things run under a default account like you said, this is my next guess: does it return the correct results?

Select

'Sept'as mnth,

td.tdes_m,

tran_x,

...

this is just a guess, but i think this would return a result set for all of your numbers, so you can avoid a cursor.

Select

'Sept'as mnth,

...