You can also use osql
EXEC xp_cmdshell 'osql -Q "exec msdb.dbo.getdbsizeweeklyreport" -o "D:\DBA\bcptest.txt" -S "YourServerName"-E'
Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs
No comments:
Post a Comment