With a small amount of research I found the following:
http://technet.microsoft.com/en-us/library/dd939795(v=ws.10)
In my case i was running Server 2008 R2 so download and install the prereqs.
Server 2008 R2 = http://www.microsoft.com/en-us/download/details.aspx?id=16978
Don't click the download link as that just gives you a worthless txt file. Instead scrol down to "install instructions" and expand. Here you'll see a full list of download sites. Grab the following:
- Microsoft SQL Server 2008 R2 Native Client x64 Package
- Microsoft SQL Server 2008 R2 Command Line Utilities x64 Package
"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\sqlcmd" -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query -i C:\Scripts\WsusDBMaintenance.sql
Ensure you "run as adminitrator" or you'll get an access denied error.
Issue resolved.
Buddy Thanks a lot for your suggestion.. It worked like charm for me. :)
ReplyDeleteGlad that helped!
Deletedoes this work for sbs2011 also?
ReplyDeleteDoes this also apply to sbs2011
ReplyDeleteYes, this applies to sbs 2011 as well
ReplyDelete