Rajesh this is a common security issue. The problem is that when you access any resource OUTSIDE ofSQL server, like network shares, local hard drives,sp_OA type functions etc, it...

Jeff i think you want to join the archiv table to the SELECt so you can exclude records already transferred;

i don't know the PK of the tables, but this should...

how up to date does the data need to be between servers? does it really need to be up-to-the-second as a linked server?

if it can be a day or so...

in my experience, deleting all rows in all tables is not the right thing to do; i'm sure there are many tables that are "lookup' tables used to populate drop...

jayanth linked servers can be notoriously slow, and there's a couple of reasons.

if you are joining two tables, i.e.

SELECT *

FROM Server1.Db.dbo.Customers X

INNER...

masterpeice the part you are missing is how to test (along witht he DENY statement already identified.

here's a working example: note the EXECUTE AS and then the REVERT when i'm...

if you can't infer the missing item due to the sum(0 of the dollar amounts not matching, is there some other logic to help infer something is missing?

for example, if...

would something like this help?

if i know you are going to take 12/21/2010 off thru 12/25/2010 for the holidays, you want to generate teh 5 days of records?

--results:

myuserID ...

when you resotre, or when you attach, you have the option to change the database name; it would fail of course if there is already a database with that name;

if...

definitely not normal. foreign key relationships are a best practice.

I've encountered this before, and it seems the companies think that their schema would reveal their business processes ro something, so...

here's a second table with an instead of trigger:

CREATE TABLE EXAMPLE2(KEYID BIGINT REFERENCES MASTERKEYS(KEYID),

...

i got curious on this and built a prototype.

man what a pain to have to code a zillion triggers, just to have a master id someplace.

i could

I ended...

to actually implement this, I think each trigger would have to insert into a mastertable with a bigint identity() column, and use an OUTPUT clause for the collection of values,...

just to clarify the whole Oracle thing, Oracle doesn't have a native identity() function like SQL does; instead, you use a SEQUENCE and a TRIGGER to duplicate the functionality, and...

yeah pseudo code is bad. your placeholder proc implied something completely different.

it is absolutely not possible to call a procedure with an update statement.

you can call a function, which returns...