here's an article that does explains what we were talking about: total lockout due to a trigger:

http://www.pythian.com/news/1310/sql-server-troubleshooting-logon-triggers/

seems if you use the dedicated admin connection(DAC), you are also in without the...

forget about the reinstall...just look at your rule: no ssms.....that's not preventing ALL connections, so you could change your application, which IS allowed to connect , but i'd do it...

howard i just tested this with a few different logons, and it seems to work; while i did not get the error message from the raiseerror stuff, it did prevent...

I agree with Lutz;

changing it to say, an inner join doesn't make that much of a differenc:

SELECT [MODE],[NUMBER],[DESCRIPTION],[UNITSIZE]

FROM [database1].[DBO].[table1]

EXCEPT

SELECT [_ZONE],[MODE],[NUMBER],[DESCRIPTION]

FROM [database2].[DBO].[table2] t1

INNER JOIN( SELECT MAX (ENTRYDATE) AS ENTRYDATE FROM...

Kris there is a difference between a string which happens to have Carriage Returns, and splitting a string into rows;

search the script contributions for "Split", for a huge collection of...

Fig your new laptop is probably running Windows 7 or Vista, right?

thos operating systems changed, compared to XP; they no longer make your login an sql administrator when you...

ahh so true; the dba title is one you can apparently take at will; we see way to many "dba" titles around the neck of posters asking questions from Chapter...

I don't think anyone can post anything that would be more understandable that what exists in Books online;...

how about selecting all the non-5.10.15 values so they can be eliminated?

WHERE vehicle_types IN (05,10,15)

AND vehicle_types NOT IN (SELECT vehicle_types FROM SOMETABLE WHERE vehicle_types NOT IN (05,10,15))?

WHERE vehicle_types IN (05,10,15)

AND vehicle_types NOT IN (20)?

excellent job on giving us all the stuff we need to help with!

in this case, i thinkyou want to use the BETWEEN command in your where statement, that lets you...

there are two ways;

you can not refer to the column at all, or you need to use the NULL keyword explicitly:

--define the columns being inserted, skip #4

INSERT INTO TableName ...

i think i understood you correctly...say there is a file Archive.zip on your ftp site, you wanted to know the names of the files / contents INSIDE Archive.zip before having...

nope, there is no way to read the contents of a zip file unless it exists locally; so if the file exists on the FTP site, you have to download...

this is normal; the execution plan is cached;

when you create a proc/function/view, and it features SELECT * FROM, behind the scenes the actual query is stored as SELECT Col1,Col2,Col3.... for...