Maxthere is not a ton of options,as you've identified;

the parameter @recipients,@copy_recipients and @blind_copy_recipients for sp_send_dbmail is a varchar max, expecting a semicolon seperated list of recipients;

if all the recipients can...

bigclick (5/25/2010)

---

.... Unfortunately this is an old legacy system where the database isn't controlled by the company ....

oh yeah I've suffered through that same situation before, I feel for...

this should be a lesson to never store...

proof of concept for Steve's idea;i thought that was kind of neat:

--results:

Status cnv ...

first, i would suggest not killing any connections, whether you know they are in use or not.

just because they 've connected for a long time, does not mean they are...

without dropping it, the calculated column would need a different name; it depends on what you really need;

since I would prefer not to delete delete data by dropping a column,i...

looks very easy to re-format; all four values appear...

ugg; one-time imports are sometimes the most time consuming...can we see a row or two of sample data? enough to make a format file so you could test a bcp...

Vishal in my experience, a text filefilled with INSERT INTO....commands is much much slower than using BULK INSERT or bcp to bring in a text doucment filled with raw data;

for...

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...