Viewing 2 posts - 1 through 2 (of 2 total)
The more correct way would be sp_helpserver.
If that isn't the correct alias that you want (perhaps being on a Veritas Cluster) you can change it with sp_dropserver(oldname)
GO
sp_addserver(correctalias)
January 15, 2009 at 8:43 am
#927413
Hi RPSql,
there isn't any way to change the place for the system databases during the installation.
You can change the location afterward for SQL Server 2005 according to http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx
However,...
January 15, 2009 at 8:42 am
#927408