Viewing 15 posts - 9,886 through 9,900 (of 13,469 total)
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...
March 7, 2010 at 4:42 am
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...
March 5, 2010 at 12:22 pm
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...
March 5, 2010 at 10:14 am
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...
March 5, 2010 at 8:58 am
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...
March 5, 2010 at 6:42 am
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...
March 5, 2010 at 6:27 am
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...
March 4, 2010 at 11:28 am
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 ...
March 3, 2010 at 12:13 pm
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...
March 3, 2010 at 11:25 am
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...
March 3, 2010 at 9:58 am
here's a second table with an instead of trigger:
CREATE TABLE EXAMPLE2(KEYID BIGINT REFERENCES MASTERKEYS(KEYID),
...
March 3, 2010 at 9:04 am
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...
March 3, 2010 at 8:48 am
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,...
March 3, 2010 at 8:11 am
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...
March 3, 2010 at 8:03 am
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...
March 3, 2010 at 5:22 am
Viewing 15 posts - 9,886 through 9,900 (of 13,469 total)