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

Archives: September 2010

Aliases in SQL Server 2008

Recently I set up replication and as the target server was not on our domain I initially used an IP address to identify the server.

After coming across an issue with the GUI tools that prevented me from entering an IP address, I initially scripted out the replication and manually… Read more

0 comments, 946 reads

Posted in measure twice, cut once. on 20 September 2010

SQL Server 2008 Surface Area Configuration

Ever wondered what happened to the SQL 2005 Surface Area Configuration Utility in SQL SERVER 2008.

Well you can accomplish pretty much the same thing in SQL SERVER 2008.


and then

you can also use sp_configure if that spins your wheels.

  Read more

1 comments, 854 reads

Posted in measure twice, cut once. on 14 September 2010

Naming Keys & Constraints


This is pretty much my first blog post - at least on sqlservercentral.com -  so to get started I thought that I'd mention something simple that I like to do.

And that's naming my own constraints, rather than letting SQL SERVER apply some cryptic string for me - however… Read more

1 comments, 414 reads

Posted in measure twice, cut once. on 1 September 2010