Archives: September 2010
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
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.
you can also use sp_configure if that spins your wheels.
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