Posts
Sort by recent activity
Can database references be replaced during deployment?
My team currently follows an environment deployment process that places our development, test, and Production databases on separate servers. Within our current loads, we often have scripts that co...
Error in deployment script for table rebuild with computed columns
When attempting to deploy a change that
necessitated a table rebuild, and
included a computed field
My deployment script ran into an error: invalid column name "MyTable.MyColumn".
Invest...
Find Invalid Objects cannot detect nonexistent tables in trigger
When I look in a database for invalid objects, it cannot detect triggers that reference tables that do not exist.
Since I use triggers to maintain referential integrity, this can bite me if I ever...
Apply Casing Options error combining FOR SYSTEM_TIME with HAVING
I've been experiencing a recurring error with SQL Prompt and a specific query. After trying to strip out all the bits and pieces, I've been able to isolate the behavior to a situation that has two...
Bug: System-versioned history tables in wrong schema
I've got a project that's comparing a pair of databases. One database has the relevant data in the 'dbo' schema; the other puts it into the 'X' schema.
I've used the Owner Mapping section of the P...
SQL Doc upgrade crashed SSMS
This morning, SQL Doc prompted me to install the latest version. I did so, and was immediately unable to open SSMS - every time it would come up, throw an "SSMS has stopped working" error, attempt...
OPENQUERY Issue
A coworker of mine came to me with a strange SQL Prompt issue this morning. In a very specific set of circumstances, SQL Prompt will remove columns from a SELECT list.
Here's the scenario as I see...
Alias added to computed column
Today I modified some code and added a computed column to a table variable:DECLARE @TableVar TABLE
(
Col1 INT
,Col2 AS Col1 * 1
)
INSERT INTO @TableVar
(
Col1
)
VALUES (1)
SELECT tv.C...
Extended Properties on Foreign Keys missing
When I make a deployment using SQL Compare to a parent table with foreign keys pointing at it, the foreign keys are often dropped and recreated.
Unfortunately, any extended properties on those fore...
Align Definition Data Types - extend to computed columns
I like the new option to align definition data types and constraints, but it doesn't seem to apply to computed columns.
For example, the following code is formatted with the new feature:
CREATE TAB...