Posts
Sort by recent activity
correct existing stored procedures
I have an existing project which has large number of stored procedures. They were written a while age I would like to run them though Sql Prompt to have a standard format and Analyse them for impro...
Preventing multiple Assembly includes
We have been working with the excellent redgate tools for many years. We uses SQL Source Control (V6.1.8) with TFS to track Database changes and use SQL Compare (v13.7) and SQL Data Compare to prod...
sql compare not working with sql source control
Hi,
I am trying to get a deployment script between two version of a database using TFS. I can select the two versions I need but sql compare is saying I need to install sql source control.
The ver...
Old Migration scripts showing as Uncommitted
After an update to 3.8.4.662 a number of old Migration scripts are showing as uncommitted. I have tried undo changes but the scripts remain as uncommitted. Can anyone help solve this. I am conte...
updating a string colum to xml
Hi,
I am looking at changing a column from a string to a type xml type. Some parsing of the string is required to re-encode the data. I have developed a CLR function to do this. My questions is ...
Menus items not enableing
Hi,
I am runing SQL prompt 5 on SQL Server Management Studio 2008 R2. The mnue items are not enabling what is wrong?