Viewing 3 posts - 16 through 18 (of 18 total)
GilaMonster (2/18/2010)
river1 (2/18/2010)
Make a "inner join on x=Y" or make "select ..... where x not in (select y)"Unless I'm missing something, those will not return the same result.
I was...
Karl Lambert
SQL Server Database Administration
Business Intelligence Development
February 18, 2010 at 11:08 am
The short answer is yes, xp_cmdshell is a dangerous object to enable. There are several ways around using xp_cmdshell, and it would be worth your while to research your alternatives.
Karl Lambert
SQL Server Database Administration
Business Intelligence Development
June 22, 2009 at 12:37 pm
I have always done this with WMI in a script task. WMI scripting allows you to assign a namespace, and designate impersonation levels, etc. I suggest using integrated security though,...
Karl Lambert
SQL Server Database Administration
Business Intelligence Development
June 22, 2009 at 12:25 pm
Viewing 3 posts - 16 through 18 (of 18 total)