Compare Stored Procedures

Is there a way to compare Stored procedure definitions
in different databases?
Eg. I have database A with Stored procedure Sp1
and database B with Stored procedure Sp1
how can I compare the definitions of Sp1 in two databases?
Thank you in advance-
-Asokcheck out www.dbghost.com
>--Original Message--
>Is there a way to compare Stored procedure definitions
>in different databases?
>Eg. I have database A with Stored procedure Sp1
>and database B with Stored procedure Sp1
>how can I compare the definitions of Sp1 in two
databases?
>Thank you in advance-
>-Asok
>.
>|||Check out SQL Compare by Red-Gate at www.red-gate.com
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Asok" <anonymous@.discussions.microsoft.com> wrote in message
news:fca701c43e95$7d34d480$a101280a@.phx.gbl...
> Is there a way to compare Stored procedure definitions
> in different databases?
> Eg. I have database A with Stored procedure Sp1
> and database B with Stored procedure Sp1
> how can I compare the definitions of Sp1 in two databases?
> Thank you in advance-
> -Asok|||Several tools listed here:
http://www.aspfaq.com/2209
In addition, you could script your stored procedures to a file and use
WinDiff (which ships with Visual Studio).
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Asok" <anonymous@.discussions.microsoft.com> wrote in message
news:fca701c43e95$7d34d480$a101280a@.phx.gbl...
> Is there a way to compare Stored procedure definitions
> in different databases?
> Eg. I have database A with Stored procedure Sp1
> and database B with Stored procedure Sp1
> how can I compare the definitions of Sp1 in two databases?
> Thank you in advance-
> -Asok|||Hi
Try dbMaestro. It's a product that allows comparison, migration and archiving of database schema and data
You can find it here
http://www.extreme.co.i

Command line action still not supported after installing sp1

Why is the command line action still not supported after installing SP1 in the SQL Server Business Intelligence Development Studio?

What command line functionality you are looking for from BI Dev Studio?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

sorry my mistake, I mean the command line actions in the BI Dev Studio!

I know there is a workaround, but I expect a command line action in the action listbox in the BI Dev Studio.

|||

hello Peter,

This is actually as expected: this action type is not listed in the UI intentionally. Actions of this type are unsafe, so they are explicetly 'demoted' in the UI. However, if you already have a command line action (like in the migrated cube), you should still be able to see them with the proper type.

hope this clarifies