hello, i need to reference a table in a sqlserver instance from a
stored procedure in a different sqlserverinsctance... it's possible
reference the table from the stored procedure?
Did you try using full naming:
servername.database.owner.Tablename
MC
"hongo32" <hongo32es@.yahoo.com> wrote in message
news:1133304999.836436.40130@.g49g2000cwa.googlegro ups.com...
> hello, i need to reference a table in a sqlserver instance from a
> stored procedure in a different sqlserverinsctance... it's possible
> reference the table from the stored procedure?
>
Tuesday, March 20, 2012
referencing linked server in stored procedures
Labels:
astored,
database,
instance,
linked,
microsoft,
mysql,
oracle,
possiblereference,
procedure,
procedures,
reference,
referencing,
server,
sql,
sqlserver,
sqlserverinsctance,
stored,
table
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment