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 |
|
eric_ht
Starting Member
37 Posts |
 Posted - 2008-10-24 : 07:03:24
|
| Just moved to Sql 2005. I connect to two servers, one on my local machine and another remotely. On the remote server I can expand a particular database, then expand security and I have several options one of those being Schemas. On My local machine I only see Users and Roles under Security. Does that mean I have some type of express edition? Or is there a setting somewhere?thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-24 : 07:05:55
|
| Are you using SQL Server 2005 management studio on both places to connect to server? |
 |
|
|
eric_ht
Starting Member
37 Posts |
Posted - 2008-10-24 : 07:09:15
|
| Yes, I am sorry I forgot to mention that. I am using MS SQL Server Management Studio. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-24 : 08:29:40
|
| This happens when you are trying to see SQL 2000 from SQL 2005 management studio. |
|
|
|
eric_ht
Starting Member
37 Posts |
Posted - 2008-10-24 : 08:48:38
|
| Ok that makes sense. I have both 2000 and 2005 installed on my local machine. When 2005 first started it asked me about my local database called <machine_name>. Is there a way to convert this db to 2005? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-24 : 08:59:43
|
| From your local machine, connect to the server that has SQL Server 2005 installed in it. |
|
|
|
|
|
|
Schemas don't show?