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 |
|
anchaljain
Starting Member
8 Posts |
 Posted - 2007-06-06 : 07:43:06
|
| Hi, I am new to SQL Server 2005. I tried connecting to my local machine by using my machine name as Server name and then tried running the following query:SELECT * FROM SYS.Objects. It gives me following error:Invalid object name 'sys.objects'.Whereas, if I connect to my local machine using mahcinename\SQLEXPRESS, then the above mentioned query runs fine.Why is this difference? What is the difference when I login in these 2 different ways. Any help would be appreciated.Thanks in advance.Any help |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-06 : 07:49:05
|
| Probably your machine has SQL server 2000 installed as default instance. So when you connect to SQL Server giving machine name as Server name, you are, in fact, connecting to SQL server 2000. Since SQL 2000 doesn't have sys.objects view, it throws error.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Difference in SQLSERVER/sqlExpress and SQLSERVER