I have a job that executes a dts package and then depending on whether it success or fails it goes to the next step. The next step is a CmdExec
I get the following in log
reason %1 is not a valid Win32 application
I currently have in their C:\scripts\dts_good.vbs
Which I can run fine locally from the server. However I am running this step from another server on the network since enterprise manager is busted on this sql server.
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb. Luckily, there is a free version SQL Express, but does …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…