Copy Stored Procedures (2005)!

Hi,
I am trying to import stored procedures from one db on one server to
another db on another server.
I have been able to get the tables & data accross using the import wizard,
but don't appear to be given any options to copy stored procedures accross.
Using SQL Server 2005
Cheers,
Adam
http://communities.microsoft.com/new...=sqlserver2005
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Adam Knight" wrote:

> Hi,
> I am trying to import stored procedures from one db on one server to
> another db on another server.
> I have been able to get the tables & data accross using the import wizard,
> but don't appear to be given any options to copy stored procedures accross.
> Using SQL Server 2005
> Cheers,
> Adam
>
>