Hi Guys,

Just a question here. I used DTS to copy a database (tables & views) from one local server to remote server. All fine.
But is there some way to automatically copy all user defined Stored procedures, functions and data types over also as part of package or does this need to be scripted...
Only new to this type of Admin.
Any help would be appreciated.