the piece you seem to be missing is the second part of my example...sp_addlinkedsrvlogin , which adding a link between you/yourlogin and what will be used on the...

you are correct; a schemabound vie can only reference objects in the same database; that jump to the parallel table in the database "fac" is preventing the schemabinding...

also this will really get you what you are after:

select * from all_views where LEFT(view_name,5) = 'USER_'

there's a few suites of views of the objects: ALL_TABLES, DBA_TABLES and USER_TABLES;

i try to stick with USER_tables, which are filtered to the schema you belong to (well the oracle...

I'm under the impression that for a linked server on another domain, you must use a SQL username and password, and not a your domain credentials;

to use your domain credentials,...

html query string does not pass comma delimited lists; if the object (like a select list) has more than one value, it repeats like this:

?bob=one&bob=two

so you need to build your...

for servers on a different domain(assuming you can connect), i've always used this format, which makes the alis for the server different from the connection:

EXEC master.dbo.sp_addlinkedserver @server = N'MyLinkedServer',@srvproduct =...

it's scope; the table exists INSIDE the exec statement, but is destroyed when it comes back to the "outer" scope of code that called the EXEC..

you have to create the...

John USER is a keyword in SQL, can you try wrapping the tablename in brackets or double quotes?

select * from LINKEDNAME...

select * from LINKEDNAME..."USER"

does it work that way?

barry.smallman (10/7/2010)

---

Hi,

Yes, I tried amending the SP to query the sys.dm_exec_connections DMV as suggested in the reply by Lowell!!

When the stored procedure failed to run this morning, I started investigating...

parthi-1705 (10/6/2010)

---

Hi Lowell

why did you changed your pic of old(that dog) it was nice when i came long time...

looks like version 4.2 is for "all" versions of SQL 2008; no special version just for SQL 2008 R2:

there are two different downloads for 2005 vs 2008 though, both marked...

I like to think of SSIS as the universal tool, which can connect to all kinds of datasources, and you can write code to do anything you want. lots of...

SQL has created some ready-to-use Oracle Migration Assistants to make this kind of transformation a lot easier.

http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx

you can do it with SSIS, but this handles a lot of the twists...

post the DDL and sample data here; there's lots of volunteers on...