that only happens if you run the statement in tempdb. those are real object names, but they were dynamically created by SQL;lots of object names in temp start like that:

from...

charindex returns the starting position of one item.

to find two items, you need two searches;

CHARINDEX ( ' emergency',CommentColumn) > 0 OR CHARINDEX( 'not secure',CommentColumn) > 0

more likely, you...

another possbility is to bcp the query to disk, then open it up and find/replace the delimiter(tab,comma?) with </td><td> and replace all CrLf with </tr><tr>;

append the leading and trailing table...

personally, i like queries as attachments;

at one point, i know i wanted all the data in the html of the email, so i build a simple CLR that formatted the...

Alvin Ramard (9/12/2010)

---

That OP is now on my...

did your cursor just create the file prior to moving it? it's quite possible that the command to create the file was issued, and the disk sub system is still...

is this happening directly in a SQl statement run in SSMS, or are you using something else?

for example, if you are using a typed dataset in .net, which includes...

it's the compiler rules...you've probably seen it:

Msg 111, Level 15, State 1, Line 57

'CREATE VIEW' must be the first...

i guess i'm feeling generous;

I didn't even bother looking at the request, as the lack of consumable data was as far as i cared to...

syntax...you can fix that....the original trigger i wrote was tested, so it's gotta be a modification.

note i did test on a 2008 server...there may be a difference if this is...

not a server wide trigger No.

triggers for ALL SERVER can only track LOGON...

Tara-1044200 (9/10/2010)

---

I am sorry if i have confused you.

from the above script does it mean that users listed in NOT IN cluse can drop the tables.

Actually my goal is to...

Tara-1044200 (9/10/2010)

---

Looks like this trigger prohibits dropping all tables and all users and it is raising error only for the given users.

I want to prohibit everyone except User1 and User2...

because of the error "A triggermust be the first command in a batch"

you have to use dynamic SQL after the IF EXISTS test.

that goes the same for procedure/ function/ view...

Tara-1044200 (9/10/2010)

---

actually i want to handle this in reverse like say i want to restrict access to eevry one except one win group, how do i filter that group or...