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 |
|
sharonmtowler
Starting Member
12 Posts |
 Posted - 2010-04-30 : 13:06:42
|
| IN 2005 MANAGEMENT STUDIO MY STORED PROCEDURES PLACED THIS ON THE TOP LINE USE [PBSA](DATBASE)IF I CHANGE THAT AND EXECUTE THE PROCEDURE ON A DIFFERENT DATABASE IT IT GETS CREATED ON THE DATABASE USE IS POINTING TO. I GATHER THIS DOESNT WORK IN THE 2005 VERSION FROM SERVER.DB.OWNER.TABLEHOW CAN I STORE MY PROCEDURE ON ONE DATABASE AND PULL THE DATA FROM ANOTHER? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
STORED PROCEDURES ONE DB PULL DATA FROM ANOTHER