USAGE: SQLCMD DOS Commands from T-SQL Script

by John 20. September 2007 03:00

Log into the local sql server, trusted account and run a DOS command.

DECLARE @vcCmd varchar(8000)
SET @vcCmd = 'sqlcmd -S' + @@SERVERNAME + ' -E -Q":!! DIR C:\"'
EXEC xp_cmdshell @vcCmd

423f41f6-009f-453d-a2ea-5a643d3efaaa|0|.0

Tags:

Categories: DOS | SQLCMD

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

Quickly import EXCEL data to tempdb table and script out field descriptorUSE tempdbGOSELECT *INTO MyEXCELSheetFROM OPENDATASOURCE( 'Microsoft.Jet...Supported SQLCMD SyntaxSupported SQLCMD Syntax Query editor supports the following SQLCMD script keywords:[!!:]GO[count] !!...T-SQL - sp__who2Here's my sp_who2 replacement script. CREATE PROC...

Add comment

Name*
E-mail*
Website
Country Country flag

b i u quote

Notify me when new comments are added

The SQL DBA