Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 364 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, 296 reads

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

Naming Keys & Constraints

 G'day,

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, 171 reads

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