Viewing 15 posts - 5,176 through 5,190 (of 5,590 total)
rambilla4 (6/22/2009)
Hi,We are using xp-cmdshell for deleting old backups. But I heard that xp_cmdshell is a big security threat for SQL Server. Is it true?
That depends. Do you consider this...
June 22, 2009 at 12:33 pm
Jeff Moden (6/22/2009)
Does anyone have some apple-sauce? 😛
Strangely enough, I just picked some up last night...
June 22, 2009 at 12:18 pm
Jeff Moden (6/21/2009)
WayneS (6/20/2009)
Jeff Moden (6/20/2009)
June 21, 2009 at 11:14 pm
Jeff Moden (6/21/2009)
WayneS (6/20/2009)
ROW_NUMBER() OVER(ORDER BY Seq)It is producing the same thing as the Seq column by itself. Is there a reason why you went through the trouble... June 21, 2009 at 11:11 pm
su_kumar11 (6/21/2009)
Hi,Can we install sql server 2005 on linux ? ,If it is possible so please tell me the procees of installation.
Thanks,
Sunil Kumar
Only...
June 21, 2009 at 10:55 pm
Jeff Moden (6/21/2009)
PaulB (6/21/2009)
June 21, 2009 at 10:53 pm
Paul White (6/21/2009)
Jeff Moden (6/20/2009)
Oh yeah... now I remember. One column needed to be split (a portion isolated, really) from the middle.
Fascinating thread. I just spent the last...
June 21, 2009 at 10:41 pm
ktlady (6/20/2009)
By the way, i am using SS2008 Management Studio. Don't know if that would make any difference.
I don't think so... that's what I'm using also.
June 20, 2009 at 11:33 pm
Jeff Moden (6/20/2009)
June 20, 2009 at 10:29 pm
Mark (6/12/2009)
DECLARE @Jobs TABLE(Street VARCHAR(10), Seq INT)
INSERT INTO @Jobs(Street, Seq)
SELECT 'Street A',1 UNION ALL
SELECT 'Street A',2 UNION ALL
SELECT 'Street A',3 UNION ALL
SELECT 'Street A',4 UNION ALL
SELECT 'Street...
June 20, 2009 at 10:27 pm
ps (6/20/2009)
GilaMonster (6/20/2009)
If you type in the local machine name can you connect?
OR type a period (.) in the Server Name and then connect. This will connect you to the...
June 20, 2009 at 10:10 pm
ktlady (6/20/2009)
The first Flo's script, I got the following error:
Invalid object name 'Tally'.
Second Waynes script, I got empty output...
June 20, 2009 at 10:01 pm
Jeff Moden (6/20/2009)
June 20, 2009 at 9:58 pm
Jeff Moden (6/20/2009)
WayneS (6/20/2009)
Jeff Moden (6/17/2009)
Ummmm.... my rule of thumb is to peel one potato at a time on the quirky update...
Hey Jeff, I remember reading a post where...
June 20, 2009 at 9:51 pm
ktlady (6/20/2009)
Column1 Column2
a1 ...
June 20, 2009 at 4:47 pm
Viewing 15 posts - 5,176 through 5,190 (of 5,590 total)