For the Enthusiasts:

-- Just Updated this post 2:45PM 3/39/2007

My Hypothesis: The first thing that came to my mind, from past experience, is that a derived table in the case of...

The command works, I am able to find what I am seeking. Thank you for the heads up info on the system procedures. Plus, having the server back online also...

Thanks Noel for kind reply. I will try this out when the server is backed online.

Thanks,

Erik,

Ideally, this T/SQL should be fast depending on the size of dbo.tblInstructor, whether or not the appropriate indexes are on the tables. If you shall find that it is slow, please look...

-- ***** Note per our MSN IM conversation, I'm posting a solution here.

-- Note the only thing you may need to change,

-- considering the table names are valid, is

-- [Server1]  ...

Sorry, this post is no longer up to date, I have added some comments to my posting at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=350384#bm351189 . Please check and respond there, thank you and sorry for...

Yes,

Any ideas would be greatly appreciated. The current configuration setting is that the Replicated Database and the Distribution Database are on the same server. The publisher is remote from these...

Hi There Shekhar,

You need to use this syntax in order to insert into dbo.jobs

SET IDENTITY_INSERT [dbo].[jobs] ON

---Your insert sql...

SET IDENTITY_INSERT [dbo].[jobs] OFF

In most cases, [dbo].[jobs] uses [job_id] as the Primary Key and Identity...

Please also give us an estimated number of rows per table. And a more complete table structure, so that we can help you optimize the query, and improve the indexes....