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 |
|
pattikay
Starting Member
36 Posts |
 Posted - 2001-07-23 : 03:36:01
|
| Is it possible to get the object_id for a table on another server ?I have been trying the following and i get NULL as the result:select object_id("servername.database.owner.table")I am executing it in a query in a stored procedure in the following way :select "Database Version"= syp_value, "Total Attendances" = rows FROM servername.database.owner.systemproperties, servername.database.owner.sysindexes where id = OBJECT_ID("servername.database.owner.Attendance_details") AND indid < 2AND syp_type = "Database Version"Thanks in advance. |
|
|
|
|
|
Object_Id