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 |
|
HarryAgain
Starting Member
4 Posts |
 Posted - 2010-07-23 : 13:04:57
|
| In SQL Server management studio, when attaching a database you have the option of choosing an 'attach name' that is different from the default.Once attached you can change the database name. This is separate from the physical file name (database.mdf).What is the difference between the database name and the attach name?Does the 'Initial Catalog' in connection strings relate to the database name or the attach name? |
|
|
kfluffie
Posting Yak Master
103 Posts |
Posted - 2010-07-23 : 20:49:08
|
| Hi,The "Attach As" option names the database that you are going to attach. The box "Database Name" is not editable and it is the current name of the database.When it comes to the "Initial Catalog" I am not really sure what you mean but you have some information here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107741Best regards,KFluffie |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-24 : 02:59:48
|
| initial catalog is the name of the database you are connecting to |
|
|
|
|
|
|
Attaching and naming a database