Posted by John Bell on 12/29/06 09:11
Hi
Regarding your other thread "prompting users", as you are using SQL 2005
then you can make your script execute particular actions by setting
variables and passing them to SQLCMD. These variables can then set by
prompting the user in a batch script or WMI script and then within your SQL
script they can be tested. There is more on this in Books Online.
John
"fireball" <fireball@onet.kropka.eu> wrote in message
news:en0qnc$gf2$1@atlantis.news.tpi.pl...
> Uytkownik "John Bell" <jbellnewsposts@hotmail.com> napisa w wiadomoci
> news:4593b698$0> > IF CAST(LEFT(CAST(SERVERPROPERTY('productversion') AS
> varchar(30)),1) AS
> [...]
> I love newsgroups :-)
>
>
>
>
[Back to original message]
|