Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
csphard
Posting Yak Master
113 Posts |
 Posted - 2004-08-12 : 11:21:50
|
| (I FIGURED IT OUT THANKS)I just imported a database from sql2000 on one server to another and it did not bring across the store procedures. Did i miss something.Howard |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-12 : 12:08:41
|
| How did you import it?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-12 : 12:11:09
|
| And for your knowledge, it is much easier to just import a database by backing up the source, copying that file over to the destination, then restoring that file. Alternatively, you could detach/attach but that takes the source down temporarily.Tara |
|
|
|
|
|
|
importing db does not import store procedures