I've been looking at the SqlPubWiz.exe command to write a batch file so that I can keep my script up to date in my source control. But what I need is for the command line tool to allow me to pick specific tables to include (and that I can exclude others). I think SqlPubWiz.exe won't do that for me (let me know if I'm wrong) but if someon...
We currently use the SQL Publishing Wizard to back up our database schemas and data, however we have some database tables with hashed passwords that contain the null character (chr(0)). When SQL Publishing Wizard generates the insert data scripts, the null character causes errors when we try and run the resulting SQL - it appears to ign...
Currently I'm trying to automatically generate a create script for all my SQL jobs of a MS SQL2005 Server. One method I found was done manually http://msdn.microsoft.com/en-us/library/ms191450.aspx A second method I found could be done automatically but I don't have direct access to the SQL server. http://relatedterms.com/thread/19166...