Click here to Skip to main content
14,826,029 members
Home / Discussions / Database
   

Database

 
GeneralRe: Single row for multiple results Pin
vanikanc25-Jul-11 5:22
Membervanikanc25-Jul-11 5:22 
GeneralRe: Single row for multiple results Pin
_Zorro_25-Jul-11 6:20
professional_Zorro_25-Jul-11 6:20 
GeneralRe: Single row for multiple results Pin
smcnulty200025-Jul-11 13:04
Membersmcnulty200025-Jul-11 13:04 
AnswerRe: Single row for multiple results Pin
S Douglas11-Aug-11 9:33
professionalS Douglas11-Aug-11 9:33 
QuestionData on one server, structure on another [modified] Pin
_Zorro_22-Jul-11 0:42
professional_Zorro_22-Jul-11 0:42 
AnswerRe: Data on one server, structure on another Pin
Corporal Agarn22-Jul-11 3:02
professionalCorporal Agarn22-Jul-11 3:02 
GeneralRe: Data on one server, structure on another Pin
_Zorro_22-Jul-11 4:14
professional_Zorro_22-Jul-11 4:14 
GeneralRe: Data on one server, structure on another Pin
Corporal Agarn22-Jul-11 4:27
professionalCorporal Agarn22-Jul-11 4:27 
_Zorro_ wrote:
Not so sure about that, I may be wrong though.

If you try running a stored procedure that stores to the c:\ drive, see where the file ends up. Now there is most likely a way to change behavior of where a process runs but I use the defaults. See sp_who also will show you what is running on a given server.

You can run a stored procedure from one linked server on another by using the server/database name. Within a stored procedure I like to have the database with the table so if it is ran from another database it still runs. I think this is called fully qualified but I do not remember. But database.schema.table is what I suggest and with the new schema importance in 2005/2008 referencing the schema should be the minimum. (We still currently use dbo for our tables though).
GeneralRe: Data on one server, structure on another Pin
_Zorro_22-Jul-11 4:50
professional_Zorro_22-Jul-11 4:50 
GeneralRe: Data on one server, structure on another Pin
Corporal Agarn22-Jul-11 5:03
professionalCorporal Agarn22-Jul-11 5:03 
GeneralRe: Data on one server, structure on another Pin
_Zorro_22-Jul-11 5:17
professional_Zorro_22-Jul-11 5:17 
AnswerRe: Data on one server, structure on another Pin
smcnulty200022-Jul-11 20:58
Membersmcnulty200022-Jul-11 20:58 
GeneralRe: Data on one server, structure on another Pin
_Zorro_25-Jul-11 2:37
professional_Zorro_25-Jul-11 2:37 
GeneralRe: Data on one server, structure on another Pin
smcnulty200025-Jul-11 7:33
Membersmcnulty200025-Jul-11 7:33 
GeneralRe: Data on one server, structure on another Pin
_Zorro_25-Jul-11 22:22
professional_Zorro_25-Jul-11 22:22 
GeneralRe: Data on one server, structure on another Pin
smcnulty200025-Jul-11 8:16
Membersmcnulty200025-Jul-11 8:16 
GeneralRe: Data on one server, structure on another Pin
_Zorro_25-Jul-11 22:24
professional_Zorro_25-Jul-11 22:24 
AnswerRe: Data on one server, structure on another Pin
Mycroft Holmes22-Jul-11 21:24
professionalMycroft Holmes22-Jul-11 21:24 
GeneralRe: Data on one server, structure on another Pin
smcnulty200022-Jul-11 21:32
Membersmcnulty200022-Jul-11 21:32 
GeneralRe: Data on one server, structure on another Pin
Mycroft Holmes23-Jul-11 0:03
professionalMycroft Holmes23-Jul-11 0:03 
GeneralRe: Data on one server, structure on another Pin
David Skelly24-Jul-11 22:36
MemberDavid Skelly24-Jul-11 22:36 
GeneralRe: Data on one server, structure on another Pin
_Zorro_25-Jul-11 2:45
professional_Zorro_25-Jul-11 2:45 
GeneralRe: Data on one server, structure on another Pin
Mycroft Holmes25-Jul-11 12:13
professionalMycroft Holmes25-Jul-11 12:13 
GeneralRe: Data on one server, structure on another Pin
_Zorro_25-Jul-11 22:15
professional_Zorro_25-Jul-11 22:15 
GeneralRe: Data on one server, structure on another Pin
Mycroft Holmes25-Jul-11 22:43
professionalMycroft Holmes25-Jul-11 22:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.