extra apps on a clustered server

We are moving our Servers to a more physically secured location and alot of
the server management is going with them. The company that will be managing
our servers wants to put a tool called IBM Manger on the Passive side of our
our Active Passive SQL2K Cluster. It sounds like a bad idea to me, but need
something to back it up. I have no Clustering background so it's a bit
difficult to talk about intelligently other than saying "it's not good to
have other apps on SQL". All ammo is greatly appreciated.
--
SQL2K SP3
TIA, ChrisRGoing to reost.
"ChrisR" <bla@.noemail.com> wrote in message
news:eZj7$5f4EHA.3756@.TK2MSFTNGP14.phx.gbl...
> We are moving our Servers to a more physically secured location and alot
of
> the server management is going with them. The company that will be
managing
> our servers wants to put a tool called IBM Manger on the Passive side of
our
> our Active Passive SQL2K Cluster. It sounds like a bad idea to me, but
need
> something to back it up. I have no Clustering background so it's a bit
> difficult to talk about intelligently other than saying "it's not good to
> have other apps on SQL". All ammo is greatly appreciated.
> --
> SQL2K SP3
> TIA, ChrisR
>

Extending SQL Server Management Studio

I am wondering if it is possible to extend the Sql Server Management Studio
user interface by adding plugins. Similar to the way plugins can be
generated for Visual Studio 2005.Not yet--it's something they are talking about adding to a future release.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Andy S" <AndyS@.discussions.microsoft.com> wrote in message
news:1FFA776D-388F-413E-81C4-B2AA996FD572@.microsoft.com...
>I am wondering if it is possible to extend the Sql Server Management Studio
> user interface by adding plugins. Similar to the way plugins can be
> generated for Visual Studio 2005.
>|||That's what I feared, thanks!
"Adam Machanic" wrote:

> Not yet--it's something they are talking about adding to a future release.
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Andy S" <AndyS@.discussions.microsoft.com> wrote in message
> news:1FFA776D-388F-413E-81C4-B2AA996FD572@.microsoft.com...
>
>

Extending SQL Server 2005 Mgmt Studio?

Hi,

I've had requests for a version of my product ViEmu, a VS.NET 2003-VS2005 add-in, which will work within SQL Server 2005 Management Studio. I had a look at the Mgmt Studio, and it seems to be a version of the VS2005 environment customized for the product. There is a registry hive along the line of the one in Visual Studio, but located in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell.

I looked for any hint online, but it seems largely undocumented.

I tried plugging my software by writing the right 'Packages' and 'AutoloadPackages' keys, and running "SqlWb /setup", which seems to do something. Nothing happened afterwards, anyway, the DLL doesn't seem to be loaded into the process. I tried using the '/log' option, but an error message comes up (which doesn't describe the /setup option either).

Is there a way to load a VS package into SQL Server 2005 Mgmt Studio? Is this a problem with the PLK? Is it unsupported? Has anybody been successful in such a feat? Would it be ok if I hack some way, no matter how obscure? Is this deliberately turned off, as in the Express editions?

Best regards and thanks in advance,

- J
-
ViEmu - vi/vim emulation for Visual Studio

Try the SQL Tools forum.

-Jamie

Extending Management Studio

In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management Studio. If ISVs (independent software vendors) could plug their SQL Server tool(s) into Management Studio – creating a single environment for you to work in – which tools do you use that you’d like to see surfaced in Management Studio.

Dan

DBGhost by Innovartis.

It would be extremely nice to be able to compile, check in, and check out changes on the fly from within SQLMS.

Also, IntelliSense would be very nice. Apex SQL Edit has their own, however I like the VS / SQLMS interface better.|||Thanks for the feedback. IntelliSense is soemthing we're looking into. A different group owns this so I don't know the latest for it. Its addition would improve greatly productivity.

Dan|||RedGates SQL Compare and Data Compare tools would be very helpful for those of us that manage seperate Dev, UAT and Production enviroments.

Allison|||Could we get the Query Analyzer from SS 2000?
Please.|||Sessionless analysis of current operations available in Quest's Spotlight. It was explained to me as directly analysing the memory (whitesapaces) being used by SQL Server.|||G'day Dan.

Are you asking which elements of the Management Studio we would like to see exposed to extensibility? If so, I have a list! ;-) I am an ISV start-up with a potentially "killer app" (aren't they all lol) and the lack of extensibility is crippling...
Cheers,

Paul McMahon
Xavier Ltd|||Hi Paul,

That's a slightly different question than what I'm asking, however, it is very relevant. Let's chat as I'd love to get your list - you can reach me at dan.jones@.microsoft.com.

Cheers,
Dan|||I think it would be cool to have PromptSQL integrated into Management Studio to give SQL Intellisense inside Management Studio :-)

But then I would say that.|||With respect to QA 2000, what is lacking in SSMS 2005 that you would want added?

Extending Management Studio

Hi There,
In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
Studio. If ISVs (independent software vendors) could plug their SQL Server
tool(s) into Management Studio creating a single environment for you to
work in which tools do you use that youd like to see surfaced in
Management Studio.
Cheers,
Dan
Lead PM
SQL Server Management Platform Team
Red Gate's SQL Compare or a similar tool would be great
Any 3rd-party backup tool that ships with its own console
Reporting tools / performance tools
... pretty much anything else
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
|||Took the words right out of my mouth :-)
SQLCompare + 3rd party backup would be at the top of my list.
Personally I'd like to be able to offer Reporting Services Scripter
(http://www.sqldbatips.com/showarticle.asp?ID=62) as an add-in to enhance
the RS scripting abilities of SSMS (possibly in the form of a wizard)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:Oc%23b4fJ7FHA.268@.TK2MSFTNGP10.phx.gbl...
> Red Gate's SQL Compare or a similar tool would be great
> Any 3rd-party backup tool that ships with its own console
> Reporting tools / performance tools
> ... pretty much anything else
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
>
|||Any backup compression tool (Idera, Red-gate, SQLLiteSpeed). This includes
using the designated compression tool for log shipping and detecting it for
restores. Using the tool includes transparent/automatic deployment to new
target machines, especially for restores (no license implications)..
Tools for performance tuning/monitoring/alerting.Yes, I saw the Data
Management Warehouse presentation at PASS. I lobbied for an open XML
standard for individual server aggregation in addition to MOM collection
already planned on top of the local warehouse. Support
aggretation/multi-server monitoring/alerting.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
|||Please bring Intellisense into Query editing!
"Dan Jones" wrote:

> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio – creating a single environment for you to
> work in – which tools do you use that you’d like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
>
sql

Extending Management Studio

Hi There,
In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
Studio. If ISVs (independent software vendors) could plug their SQL Server
tool(s) into Management Studio ? creating a single environment for you to
work in ? which tools do you use that you?d like to see surfaced in
Management Studio.
Cheers,
Dan
Lead PM
SQL Server Management Platform TeamRed Gate's SQL Compare or a similar tool would be great
Any 3rd-party backup tool that ships with its own console
Reporting tools / performance tools
... pretty much anything else :)
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Took the words right out of my mouth :-)
SQLCompare + 3rd party backup would be at the top of my list.
Personally I'd like to be able to offer Reporting Services Scripter
(http://www.sqldbatips.com/showarticle.asp?ID=62) as an add-in to enhance
the RS scripting abilities of SSMS (possibly in the form of a wizard)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:Oc%23b4fJ7FHA.268@.TK2MSFTNGP10.phx.gbl...
> Red Gate's SQL Compare or a similar tool would be great
> Any 3rd-party backup tool that ships with its own console
> Reporting tools / performance tools
> ... pretty much anything else :)
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
>> Hi There,
>> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
>> Management
>> Studio. If ISVs (independent software vendors) could plug their SQL
>> Server
>> tool(s) into Management Studio - creating a single environment for you to
>> work in - which tools do you use that you'd like to see surfaced in
>> Management Studio.
>> Cheers,
>> Dan
>> Lead PM
>> SQL Server Management Platform Team
>|||Any backup compression tool (Idera, Red-gate, SQLLiteSpeed). This includes
using the designated compression tool for log shipping and detecting it for
restores. Using the tool includes transparent/automatic deployment to new
target machines, especially for restores (no license implications)..
Tools for performance tuning/monitoring/alerting.Yes, I saw the Data
Management Warehouse presentation at PASS. I lobbied for an open XML
standard for individual server aggregation in addition to MOM collection
already planned on top of the local warehouse. Support
aggretation/multi-server monitoring/alerting.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Please bring Intellisense into Query editing!
"Dan Jones" wrote:
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio â' creating a single environment for you to
> work in â' which tools do you use that youâ'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
>

Extending Management Studio

Hi There,
In SQL Server 2005 Enterprise Manager was rewritten and renamed to Managemen
t
Studio. If ISVs (independent software vendors) could plug their SQL Server
tool(s) into Management Studio creating a single environment for you to
work in which tools do you use that youd like to see surfaced in
Management Studio.
Cheers,
Dan
Lead PM
SQL Server Management Platform TeamRed Gate's SQL Compare or a similar tool would be great
Any 3rd-party backup tool that ships with its own console
Reporting tools / performance tools
... pretty much anything else
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Took the words right out of my mouth :-)
SQLCompare + 3rd party backup would be at the top of my list.
Personally I'd like to be able to offer Reporting Services Scripter
(http://www.sqldbatips.com/showarticle.asp?ID=62) as an add-in to enhance
the RS scripting abilities of SSMS (possibly in the form of a wizard)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:Oc%23b4fJ7FHA.268@.TK2MSFTNGP10.phx.gbl...
> Red Gate's SQL Compare or a similar tool would be great
> Any 3rd-party backup tool that ships with its own console
> Reporting tools / performance tools
> ... pretty much anything else
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
>|||Any backup compression tool (Idera, Red-gate, SQLLiteSpeed). This includes
using the designated compression tool for log shipping and detecting it for
restores. Using the tool includes transparent/automatic deployment to new
target machines, especially for restores (no license implications)..
Tools for performance tuning/monitoring/alerting.Yes, I saw the Data
Management Warehouse presentation at PASS. I lobbied for an open XML
standard for individual server aggregation in addition to MOM collection
already planned on top of the local warehouse. Support
aggretation/multi-server monitoring/alerting.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Dan Jones" <u15880@.uwe> wrote in message news:57901965fb8d4@.uwe...
> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to
> Management
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio - creating a single environment for you to
> work in - which tools do you use that you'd like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team|||Please bring Intellisense into Query editing!
"Dan Jones" wrote:

> Hi There,
> In SQL Server 2005 Enterprise Manager was rewritten and renamed to Managem
ent
> Studio. If ISVs (independent software vendors) could plug their SQL Server
> tool(s) into Management Studio – creating a single environment for you t
o
> work in – which tools do you use that you’d like to see surfaced in
> Management Studio.
> Cheers,
> Dan
> Lead PM
> SQL Server Management Platform Team
>

Extended Properties

When I add an extended property using SMO, it doesn't show up on the Properties of the table in SQL Management Studio. Also, if I add one in Managment Studio, I can't see it using SMO. What am I missing here?

Can you please provide some more information on how you are trying to add and retrieve the Extended Properties using SMO. And also what version of SQL Server are you using.

Your code should look similar to -

Table t = mydb.Tables["tableName"];

foreach(ExtendedProperty exp in t.ExtendedProperties)

{

Console.WriteLine(exp.Name + " " + exp.Value);

}

t.ExtendedProperties.Add(new ExtendedProperty("propertyName", "property value"));

|||My code is pretty much just like that. I am using SQL Server 2005.|||

Here is the code sample which I found working, let me know if you face any issues.

Server server = newServer("localhost");

Table table = server.Databases["mydatabase"].Tables["mytable"];

table.ExtendedProperties.Add(newExtendedProperty(table, "propertyName", "propertyValue"));

table.Alter();

table.Refresh();

foreach (ExtendedProperty e in table.ExtendedProperties)

{

Console.WriteLine(e.Name + " " + e.Value.ToString());

}

Thanks,

Kuntal

Extended Properties

When I add an extended property using SMO, it doesn't show up on the Properties of the table in SQL Management Studio. Also, if I add one in Managment Studio, I can't see it using SMO. What am I missing here?

Can you please provide some more information on how you are trying to add and retrieve the Extended Properties using SMO. And also what version of SQL Server are you using.

Your code should look similar to -

Table t = mydb.Tables["tableName"];

foreach(ExtendedProperty exp in t.ExtendedProperties)

{

Console.WriteLine(exp.Name + " " + exp.Value);

}

t.ExtendedProperties.Add(new ExtendedProperty("propertyName", "property value"));

|||My code is pretty much just like that. I am using SQL Server 2005.|||

Here is the code sample which I found working, let me know if you face any issues.

Server server = new Server("localhost");

Table table = server.Databases["mydatabase"].Tables["mytable"];

table.ExtendedProperties.Add(new ExtendedProperty(table, "propertyName", "propertyValue"));

table.Alter();

table.Refresh();

foreach (ExtendedProperty e in table.ExtendedProperties)

{

Console.WriteLine(e.Name + " " + e.Value.ToString());

}

Thanks,

Kuntal

Extend the sql server management studio

I'm looking for info/documentation about writing plugins for the management studio.
i'd like to extend the interface, for instance, alter the interface to allow scripting of all indexes for a table, by adding that option to the table context menu.

i'm also looking for a way to create macros in the query editor, so i can have pressing tab after writing a short word expand to a pre-selected template.

any help appreciated.

Check the following URL....

add-in to SQL Server Management Studio

http://www.codeproject.com/useritems/enisey.asp?df=100&forumid=315231&exp=0&select=1908869

|||http://blogs.msdn.com/dtjones/archive/2005/11/16/493440.aspx you can as per Dan's blog out there, I believe your best bet would be to contact Microsoft dev.team for more information.

Express Manager / Management Studio Express

When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database.I'm wondering that also. I think I heard something about MS dropping Express Manager.|||We've dropped Express Manager. Instead, you can download and use SQL Server Management Studio Express to manage your Express servers. SSMSE is a subest of the full Management Studio tailored for SQL Server Express functionality. SSMSE can also connect to uplevel SQL Server 2005 servers, SQL Server 2000 servers, and MSDE 2000 servers.

You can download it from MSDN here: http://msdn.microsoft.com/vstudio/express/sql/ Look for the "Free Management Tool" paragraph on the page. It has a link to the Management Studio Express download page.

A few things to be aware of:

First, Management Studio Express is currently a Community Technology Preview, so there are still a few minor defects that remain to be fixed before it formally ships in the first half of 2006. If you use SSMSE, you can use this MSDN Forum to provide feedback. Issues raised on these forums have added weight with the dev team when it comes to prioritizing changes.

Second, Management Studio Express cannot run side-by-side with SQL Server 2005 Management Studio. SSMSE is supposed to have an error message that pops up telling you to use Management Studio if it detects the full product on your machine, but this appears to be broken for many people, for whom nothing happens at all when the try to start Management Studio Express on machines that have a version of the full Management Studio installed.|||Thanks for the info and the link!|||After reading a number of posts and trying out SSMSE, I would have to say that you have done an excellent job on 2005.

Dave
Retired SQL Sever DBA with 35+ years experience|||

Hi there.

I have just installed the Express editions of VB and SQL.However, I can't seem to find an IDE for SQL Server. I have been able to create a database through VB, but not directly in SQL Express as there is no way into a UI. Is this normal?

I would like to create and manage databases independently of VB and VWD and then connect to them in the way it was probably done before 2005. Is this possible? Do I have to install the SQL Server Management Studio Express (SSMSE)?

Many thanks in advance,

Chris

By the way, very impressed with the whole Express Edition initiative and with the tools themselves. It's a brave move. Well done to all involved. I'm sure these editions will help to ensure .NET dominance over other technologies for years to come.

|||You will want to download and install SSMSE. Here's a link to the November CTP of SSMSE. It will allow you to run SQL scripts to create, manage and query databases.|||

That's great. Thanks for your help.

Chris

|||

I downloaded and tried Management Studio Express because I need a substitute for Query Analyzer for users to run adhoc queries and save the results to files. This looks good, but is is a Community Technology Preview November 2005 version and it states that it is an unsupported pre-release version. Is there a RTM version available? If not will there be one? Can I give this to power users as a substitute for the Query Analyzer?

|||

There is no RTM version of Management Studio Express yet. We do plan to release a final version soon.

Management Studio is intended to be a replacement for Query Analyzer 2000 and SQL Enterprise Manager 2000, so it should be appropriate for your power users.

Regards,

Steve

|||Thanks Steve. Is there any target date yet for the RTM version of Management Studio Express? I need something very soon for a production system.

Express 2005 Tools

Aren't there any tools like Management Studio available for SQL Server 2005
Express?
Thanks.
There will be a scaled down version of management studio available for download. No timeframe yet.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jay" <msnews.microsoft.com> wrote in message news:%23WwKU9t4FHA.1276@.TK2MSFTNGP09.phx.gbl...
> Aren't there any tools like Management Studio available for SQL Server 2005
> Express?
> Thanks.
>
|||Jay,
there is a CTP available for download
http://www.microsoft.com/downloads/d...displaylang=en
Jan D'Hondt
<Toto, I've got a feeling we're not in Kansas anymore.>
SQL database and .NET solutions
"Jay" wrote:

> Aren't there any tools like Management Studio available for SQL Server 2005
> Express?
> Thanks.
>
>

Express 2005 Tools

Aren't there any tools like Management Studio available for SQL Server 2005
Express?
Thanks.There will be a scaled down version of management studio available for downl
oad. No timeframe yet.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jay" <msnews.microsoft.com> wrote in message news:%23WwKU9t4FHA.1276@.TK2MSFTNGP09.phx.gbl..
.
> Aren't there any tools like Management Studio available for SQL Server 200
5
> Express?
> Thanks.
>|||Jay,
there is a CTP available for download
http://www.microsoft.com/downloads/...&displaylang=en
Jan D'Hondt
<Toto, I've got a feeling we're not in Kansas anymore.>
SQL database and .NET solutions
"Jay" wrote:

> Aren't there any tools like Management Studio available for SQL Server 200
5
> Express?
> Thanks.
>
>

Express 2005 Tools

Aren't there any tools like Management Studio available for SQL Server 2005
Express?
Thanks.There will be a scaled down version of management studio available for download. No timeframe yet.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jay" <msnews.microsoft.com> wrote in message news:%23WwKU9t4FHA.1276@.TK2MSFTNGP09.phx.gbl...
> Aren't there any tools like Management Studio available for SQL Server 2005
> Express?
> Thanks.
>|||Jay,
there is a CTP available for download
http://www.microsoft.com/downloads/details.aspx?familyid=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en
--
Jan D'Hondt
<Toto, I've got a feeling we're not in Kansas anymore.>
SQL database and .NET solutions
"Jay" wrote:
> Aren't there any tools like Management Studio available for SQL Server 2005
> Express?
> Thanks.
>
>

Exporting Stored Procedures to a file

I have a need to export all of the stored procedures in a database to files on the server dirve. I know that this can be done through the management interface but I need a way to do it programatically. I need to have a script or stored proc that dumps all of the procedures to a defined location on disk. Does anyone know how this can be done?

Thanks!

You can use SQL-DMO (in SQL Server 2000) or SMO (in SQL Server 2005) to do this. Please take a look at the setup CD it contains sample solutions that you can use to familiarize with these APIs. You can also search in Books Online for samples.|||

There is an article with a stored procedure that does this at http://www.databasejournal.com/features/mssql/article.php/2205291

Also a slightly different approach to the same problem at http://www.databasejournal.com/features/mssql/article.php/3401081, though the first way is probably the one you want to use.