Posts
Sort by recent activity
SQL Compare uses wrong source control
Sql compare throws error:
Error retrieving migration scripts.
I am using Team Foundation Server online.
Since creating the migration script for this particular database, the url and the project nam...
Format SQL adds semicolon to the end of each statement
I am on SQL Prompt 6.5.0.326.
When I choose to format a set of SQL statements I noticed that a semicolon is added to the end of each statement.
How do I turn this off.
I am on Windows 7 Enterprise ...
Change the server that the database is linked too.
My Team Foundation Server has been rebuilt with a new name.
Is there an easy way to edit the server portion of the link with out unlinking and then linking each database?
Formating puts the ON clause in the wrong place
When using the WITH (NOLOCK) in a JOIN of the FROM clause, the ON clause is shifted out to the first parentheses of the WITH as in the following example:
FROM
BillingProcess.dbo.Billing AS b WI...
Format SQL does not format a CREATE TYPE statement
The command to format sql ignores the CREATE TYPE statement.
If I type the following:CREATE TYPE dbo.test AS TABLE (
clm1 VARCHAR(2), clm2 INT, clm3 INT, clm4 INT )
and choose to ...
No candidates in the list for FETCH NEXT ... INTO
The candidate list only has snippets in it when you type the following and press ctrl+space:
FETCH NEXT FROM tmp INTO<space>
When you add the @ so the statement looks like this:
The candidate list ...
Format SQL does not format an ALTER INDEX statement
I have found that an ALTER INDEX sql statement is completely ignored when doing Format SQL (ctrl+k, ctrl+y). The only thing it does is to align the statement to the begining of other sql statements...
SQL Doc 2 does not add new object to the web pages.
I have a project created that I run thru windows task scheduler to update the documentation automatically. The scheduled tasks complete succesfully, but the web pages do not show new objects.
When ...
Team Foundation Server 2010 support
Will SQL Source Control 1 support TFS 2010?
selecting a candidate throws an exception
When I highlight a table, press <ctrl> + <space> and bring up the candidate list, when I double click or tab to choose the candidate that is highlighted I get the following exception:
See the end o...