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 |
|
doco
Yak Posting Veteran
77 Posts |
 Posted - 2010-06-10 : 11:48:01
|
| How would one go about discovery of what the server name and or alias is on ones' local SQL Server? Does that make sense?I have SQL SERVER 2005 installed on my local machine and am able to connect to remote servers but am wanting to attach/create db's locally for training, etc. but do not know server name, etc.TIAEducation is what you have after you've forgotten everything you learned in school |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-06-10 : 12:04:11
|
try this :)SELECT @@SERVERNAME Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
doco
Yak Posting Veteran
77 Posts |
Posted - 2010-06-10 : 14:40:43
|
| Ummm...Don't you have to be connected to the [unknown] server in order to do that?Guess I am going to have to uninstall SQL Server and reinstall - ARGH!Education is what you have after you've forgotten everything you learned in school |
|
|
|
|
|
|
Local SQL Server