USAGE: SQLCMD DOS Commands from T-SQL Script

by John 20. September 2007 03:00

USAGE: SQLCMD DOS Commands from T-SQL Script

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
Tags:
Categories: DOS | SQLCMD
E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed

USAGE: xp_dirtree

by John 18. September 2007 06:05
EXEC master.sys.xp_dirtree N'E:\MSSQL\MSSQL.1\'

Subdirectory depth
MSSQL 1
Backup 2
Data 2
JOBS 2
LOG 2
repldata 2
Tags:
Categories:
E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed