Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
javad.nikoo
Starting Member
17 Posts |
 Posted - 2011-11-09 : 07:57:17
|
| hii have 2 version of sql on my server (2005,2008)i install the 2005 at first and i connect to it with . (dot) and now i have installed 2008 but i can not run with . so i want to change my instance name and i want 2008 to be local (.(start with .(i mean log in with dot not my sql 2008 instance name) )) best regards |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-09 : 08:00:03
|
| always better to use instance name rather than . while specifying serverit should be machinename\instancename------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
javad.nikoo
Starting Member
17 Posts |
Posted - 2011-11-09 : 08:33:44
|
| yes you are right but i dont want to write my instance name what should i do |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-09 : 09:03:56
|
quote:
Originally posted by javad.nikoo
yes you are right but i dont want to write my instance name what should i do
why so?you need to use it especially now that you've more than 1 in your machine------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
change My Instance name