How do I know if I have Enterprise or Standard on my machine?

I go to help>About and it just says SQL Server 2005

Microsoft SQL Server Management Studio Version 9.00.1399.00

You can use osql at the command prompt like this:

osql -S yourServerName -E -q "select CAST(SERVERPROPERTY('edition') AS VARCHAR)

|||

The problem I'm having is that I'm unable to establish and instance of a server so I don't know or have a server name.

This is one of the reasons why I want to know the edition I have. As I understand it, Enterprise edition does not support XP Pro OS, which is what I'm running. If I have enterprise then I figure I might as well give up on trying to get this solved. If I have standard, then I won't give up so easily.

|||If you can get to the SQL Server Configuration Manager, select SQL Server 2005 Services in the left pane, then right click on the SQL Server process and select properties, go to Advanced tab and look at the entry "Stock Keeping Unit Name".|||

I can get to the SQL Configuration Manager, however when I right click on SQL Server 2005 Services "SQL Server process" is not shown.

Also, seems like I don't have SQL Server Browser Service installed. The file sqlbrowser.exe is not in my 90\Shared folder.

Any ideas?

Thanks

|||

An easy way is to go to the registry and look for this key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\Edition

Note: You'll have this key for each component installed, so you'll find them here as well:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\NS\Setup\Edition
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup\Edition
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Setup\Edition

Thanks,
Sam Lester (MSFT)

|||

Ok got it..

I have standard edition...So that rules out OS incompatibility theory I was under the assumption that I working under.

So back to my main problem.

I'm unable to establish a local server instance on my machine.

I have established remote server instances, but not local..

Any ideas?

Thanks

How do I install SQL Server Management Studio

From everything I read SQL Server Management Studio is only installed when you install SQL 2005 server.

I am using SQL Server 2000 sp3 so I have the Enterprise Manager.

Is there a way to install it or some other tool I can use to manage/view my sql everywhere database?

You could install the SQL Express management Tools and try them.

|||I figured it out and forgot to post the solution. On the SQL Server 2005 install cd you can install the tools.sql

How do I hide databases that I don't need to see?

Hello,
How do I hide databases that I don't need to see on a server? I am using
SQL Server Management Studio 2005.
Thanks!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-I don't think you can hide them in management studio, but you can
restrict access to them
by using
deny connect to guest.
So that only authorised user to particular database can access it.
Regards
Amish Shah|||"amish" <shahamishm@.gmail.com> wrote in news:1138703226.471823.58290
@.g43g2000cwa.googlegroups.com:

> I don't think you can hide them in management studio, but you can
> restrict access to them
> by using
> deny connect to guest.
> So that only authorised user to particular database can access it.
> Regards
> Amish Shah
>
Thank you Amish.
P.S. Cool name!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-|||Thanks
Amish is indian name, meaning is honesty and love.
Regards
Amish Shah

How do I hide databases that I don't need to see?

Hello,
How do I hide databases that I don't need to see on a server? I am using
SQL Server Management Studio 2005.
Thanks!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
I don't think you can hide them in management studio, but you can
restrict access to them
by using
deny connect to guest.
So that only authorised user to particular database can access it.
Regards
Amish Shah
|||"amish" <shahamishm@.gmail.com> wrote in news:1138703226.471823.58290
@.g43g2000cwa.googlegroups.com:

> I don't think you can hide them in management studio, but you can
> restrict access to them
> by using
> deny connect to guest.
> So that only authorised user to particular database can access it.
> Regards
> Amish Shah
>
Thank you Amish.
P.S. Cool name!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
|||Thanks
Amish is indian name, meaning is honesty and love.
Regards
Amish Shah

How do I hide databases that I don't need to see?

Hello,
How do I hide databases that I don't need to see on a server? I am using
SQL Server Management Studio 2005.
Thanks!
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-I don't think you can hide them in management studio, but you can
restrict access to them
by using
deny connect to guest.
So that only authorised user to particular database can access it.
Regards
Amish Shah|||"amish" <shahamishm@.gmail.com> wrote in news:1138703226.471823.58290
@.g43g2000cwa.googlegroups.com:
> I don't think you can hide them in management studio, but you can
> restrict access to them
> by using
> deny connect to guest.
> So that only authorised user to particular database can access it.
> Regards
> Amish Shah
>
Thank you Amish.
P.S. Cool name!
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Best free software
http://www.vbmark.com
Freeware-dedicated search engine
http://www.eurekster.com/parties/Freeware1.htm
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-|||Thanks
Amish is indian name, meaning is honesty and love.
Regards
Amish Shah

How do i get the database that i am using in visual studio into my SQL server management s

How do i get the database that i am using in visual studio into my SQL server management studio?

i need to create some scripts to create stored procedures on a live server.

Take your .mdf file for the database that you are using in Visual Studio.NET and attach it to a database in MS SQL Server.

Good luck.

How do I get Management Studio to not reset the selected database to Master when I open a new qu

Hi there,

I often have to run multiple SQL scripts against a single database. SQL Server Management Studio always reverts the selected database to Master whenever I open a different SQL file. This requires me to re-select the correct database, and if I forget, I end up running the script against the Master database. SQL 2000's query analyzer "remembered" your selected database and did not force you to re-connect each time.

Is there any way to make SQL Server Management Studio act this way?

Thanks!

Kiron

Kiron,

You could set the default database for the sql login. so that the default DB will be selected automatically.

To set default databasefor a sql login, In Object Explorer, expand Security -> Logins

right click on login , properties, set the default database

After setting default DB for the SQL login, if you open up new query with the above mentioned login, you would see the default database selected

If you feel that the above solution does not meet your requirements, Please log a feature request in connect web site

https://connect.microsoft.com/SQLServer/Feedback

Thanks
Sethu Srinivasan, Software Design Engineer, SQL Server Manageability
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

|||

Hi Sethu -

thanks for the response. Unfortunately, this will reset the default database, as opposed to having the new query session just "remember" the database that was selected for other open query sessions. Ideally, I would want the same behavior as in Query Analyzer from 2000 - you connect once to the database and from then on, all query windows are assumed to be related to the same database.

As part of my work, I often have to open multiple SQL scripts and execute them against the same database - the database is never the same, hence, the default database approach will merely shift the issue from "master" to some other database. What I would need is an option to tell Management Studio to pick the database that is used by all open query windows as the default when a new query window is opened vs. picking the user's default database.

I'll log a feature request as suggested!

Thanks again!

Kiron

How do I get Management Studio to not reset the selected database to Master when I open a ne

Hi there,

I often have to run multiple SQL scripts against a single database. SQL Server Management Studio always reverts the selected database to Master whenever I open a different SQL file. This requires me to re-select the correct database, and if I forget, I end up running the script against the Master database. SQL 2000's query analyzer "remembered" your selected database and did not force you to re-connect each time.

Is there any way to make SQL Server Management Studio act this way?

Thanks!

Kiron

Kiron,

You could set the default database for the sql login. so that the default DB will be selected automatically.

To set default databasefor a sql login, In Object Explorer, expand Security -> Logins

right click on login , properties, set the default database

After setting default DB for the SQL login, if you open up new query with the above mentioned login, you would see the default database selected

If you feel that the above solution does not meet your requirements, Please log a feature request in connect web site

https://connect.microsoft.com/SQLServer/Feedback

Thanks
Sethu Srinivasan, Software Design Engineer, SQL Server Manageability
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

|||

Hi Sethu -

thanks for the response. Unfortunately, this will reset the default database, as opposed to having the new query session just "remember" the database that was selected for other open query sessions. Ideally, I would want the same behavior as in Query Analyzer from 2000 - you connect once to the database and from then on, all query windows are assumed to be related to the same database.

As part of my work, I often have to open multiple SQL scripts and execute them against the same database - the database is never the same, hence, the default database approach will merely shift the issue from "master" to some other database. What I would need is an option to tell Management Studio to pick the database that is used by all open query windows as the default when a new query window is opened vs. picking the user's default database.

I'll log a feature request as suggested!

Thanks again!

Kiron

How do I find Database Designer in 2005 Managment Studio?

I cannot find how to open the Visual Database Designer (or Visual Table Designer) in the Management Studio loaded with SQL Server 2005 Professional.

I right-click on the Database Diagrams icon but all it gives me is "Working with SQL Server 2000 diagrams" and "Refresh". Similarly no Visual Table Designer option.

Regards,

Nick Samuel

I believe that functionality was moved to BIDS or VSTS and is NOT in SSMS.|||Arnie, thank you for the suggestion but I cannot fand it in BIDS/VSTS either.|||

Go to server | database | Tables. Right click on tables node -> New Table. This will launch table designer for you.

-Sravanthi

|||

Sravanthi, thank you for your help but I cannot find the options you list on either tool. I can choose to display the Database Design toolbar but it is, of course, grayed out. What am I missing?

Regards,

Nick

|||Are you using SQL Server Management studio only? Make sure you open Object Explorer ( View Menu -> Object Explorer) or press F8. Then in the tree view that comes up in Object Explorer navigate using the steps i mentioned above. If you have already done this, then please post a screen shot or something so that we can see what the issue you are facing exactly.|||

Hi Sravanthi,

I have have used Object Explorer. I cannot see how to post a screen shot on this forum.

Regards,

Nick Samuel

|||

Database Designer is in Visual Studio, and the 'premium' version is in 'Visual Studio for Database Professionals'.

There is NOT a 'database designer' in SSMS.

How do I export my database from SQL Server Management Studio Express

Hi

I am using SQL Server Management Studio Express to make my databases but I noticed if I make my database in Visual studios and go new Item and make a new database I see it in app_data folder and server express tab and if I make it in SQL Server Management Studio Express I only see it in the server explorer.

So if I have to move my files to another computer how do I move my database easly with SQL Server Management Studio Express? Since when you make it with the visual studio the file gets stored with all the other files of your project so if you move it all to another computer you prob won't run into a problem.

So how do I make it that so I can do everything in SQL Server Management Studio Express(since I like working in it) then export it into a file that I can then go into my app_data folder and add it is an exist item?

Thanks

Hi chobo2,

Generally speaking, when you create a new database through Management Studio, the database file will be stored at: %yoursqlinstallationpath%MSSQL.1\MSSQL\Data. If you want to access it through your Visual Studio you must first connect to it(server exploer--> new connection).

And if you create a new database through Visual Studio, the database file will be stored in you application App_Data folder.You can access to it directly through both Visual Studio and Management Studio.

As to export a database file to new location(or migrate databae), as far as i know, you have 2 options:

1: Detach and Attach:

Detach the database from original database Server and copy the physical database files(*.mdf and *.ldf) to the new location.At the new server side, you put the physical database files to a certain place(generally speaking it's the default sql server database folder), and attach to the database again;

2:Use Backup and Restore:

In your original database server you can make a backup of your database file and store it to a certain place(*.bak).Take the *.bak file to the new server and in the new database server, restore that database.

You can implement the above 2 methods in sql2000, sql express, or sql 2005. However, detailed operations could be different if you use different verstions of sql server.

Hope my suggestion helps

How do I export data in certain table through management studio

Hi there,
In SQL Server 2005 How do I export data in certain table through management studio?
Thanks,
AnuRight Click on a database select all tasks and then export data, select just the table you want from the list in the grid.|||This is only possible if you have SQL Server 2005 and not with the SQL Server Management Studio.....
I have the same problem and would like to export my tables to the ASPNETDB after installing the latest version of ASP.NET 2.0 with VWD.

After upgrade, I cannot login anymore to my site... This is due to SQL Express Stored Procedures that have been changed... and even when changing manually the Stored Procedure, it doesn't work...

So... I think I will need to create my table again... Rrrrrrrrrrr.....

Anyone a suggestion or a hint how I can export my table and import to SQL Express again?

Thanks folks,
B.

How do I export data in certain table through management studio

Hi there,
In SQL Server 2005 How do I export data in certain table through management studio?
Thanks,
AnuRight Click on a database select all tasks and then export data, select just the table you want from the list in the grid.|||This is only possible if you have SQL Server 2005 and not with the SQL Server Management Studio.....
I have the same problem and would like to export my tables to the ASPNETDB after installing the latest version of ASP.NET 2.0 with VWD.

After upgrade, I cannot login anymore to my site... This is due to SQL Express Stored Procedures that have been changed... and even when changing manually the Stored Procedure, it doesn't work...

So... I think I will need to create my table again... Rrrrrrrrrrr.....

Anyone a suggestion or a hint how I can export my table and import to SQL Express again?

Thanks folks,
B.

How do I develop a plug-in for Management Studio?

Recently saw a red-gate product that added an entire menu header to the management studio interface. How does one go about developing that? My company has several SQL related home grown mini utilities written in C# that I've placed in Management Studio for convienience via the external tools functionality. Feedback from our development and database groups indicate that this solution does not go far enough in cleanly simplifying how we leverage our custom utilities. That being the case it would be a great boon to learn how to add an entire menu to the environment as to customize it to our needs. Any information would be a help. Thanks in advance.

My team owns SQL Server Management Studio. In SQL Server 2005, we do not have any publicly documented or supported ways of plugging into Management Studio. We will be rectifying this in future versions of SQL Server. I was at PASS in Seattle, WA this past week and saw Red-Gate's SQL Refactor utility. What they have done is pretty impressive considering we have not made that information public.

In future releases, we will try to follow Visual Studio's plug-in architecture. Once we are confident that our interfaces will not change significantly, we will release that information to the public.

You could file this as a suggestion on Microsoft Connect. We will keep you in the loop as we make decisions throughout the product development lifecycle. http://connect.microsoft.com/SQLServer/.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/