SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: September 2011

SQL Table Columns Disappear in Access

A couple weeks ago a user complained that on one of our development databases, one of the views he was linking to via Access was missing some of the columns.  There were no permissions issues and the columns all showed up properly if they looked at the view via SSMS;… Read more

0 comments, 1,516 reads

Posted in Never Say Never on 28 September 2011

Replication DDL Triggers

Because this was a problem that Google was zero help on and I did find a couple other people afflicted with it, I figured I’d write a post about it. 

The issue was this.  I add a table to replication (SQL Server 2005).  The option to replicate DDL changes is… Read more

2 comments, 1,893 reads

Posted in Never Say Never on 21 September 2011

Normalize your Linked Server Names

This is a technique I’m sure many people are already using in their environments.  Instead of using the actual name of your SQL Server as the name of the linked server that you call, use a generic name.  For instance.  If you have a couple of servers named SQLSales02 and… Read more

10 comments, 3,390 reads

Posted in Never Say Never on 14 September 2011