Viewing 15 posts - 9,376 through 9,390 (of 13,469 total)
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...
May 25, 2010 at 11:37 am
bigclick (5/25/2010)
oh yeah I've suffered through that same situation before, I feel for...
May 25, 2010 at 11:24 am
_ms65g_ (5/25/2010)
SELECT TOP 100 CLACCT, DATE
FROM
(
SELECT CLACCT, CAST(MONTH AS VARCHAR(2)) + CAST(YEAR AS VARCHAR(4)) AS DATE
FROM cu102 (nolock)
) D
WHERE DATE > 062007
this should be a lesson to never store...
May 25, 2010 at 10:04 am
proof of concept for Steve's idea;i thought that was kind of neat:
--results:
Status cnv ...
May 25, 2010 at 9:33 am
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...
May 25, 2010 at 8:37 am
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...
May 25, 2010 at 8:24 am
Vishal Singh (5/25/2010)
This is how the sample data looks like:
INSERT INTO [tbl1] ([PrimaryID],[RelatedID],[RelationID],[PosID])VALUES(1,78628,4,1)
INSERT INTO [tbl1] ([PrimaryID],[RelatedID],[RelationID],[PosID])VALUES(1,89059,4,1)
INSERT INTO [tbl1] ([PrimaryID],[RelatedID],[RelationID],[PosID])VALUES(1,89230,4,1)
INSERT INTO [tbl1] ([PrimaryID],[RelatedID],[RelationID],[PosID])VALUES(1,89235,4,1)
looks very easy to re-format; all four values appear...
May 25, 2010 at 7:24 am
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...
May 25, 2010 at 7:01 am
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...
May 25, 2010 at 6:50 am
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...
May 24, 2010 at 8:29 pm
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...
May 24, 2010 at 8:16 pm
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...
May 24, 2010 at 5:40 pm
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...
May 24, 2010 at 4:20 pm
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...
May 24, 2010 at 9:44 am
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...
May 24, 2010 at 9:40 am
Viewing 15 posts - 9,376 through 9,390 (of 13,469 total)