So your on ORACLE and connectioning to SQL - so as long as you have drivers installed thats how you connect these two together.

Is oracle sql developer come with Oracle...

Try using the sa or equilavent instead of the Network ....i never got Network/Acct to work.

When you do your restore....do you first have to restore the FULL BAK then the LOG TRN after this.

I.e lets say you have FULL BACK Midnight and then 5 TRN...

Why don't you try this for updating the statistics

UPDATE STATISTICS DaveTable(anames)

WITH FULLSCAN, NORECOMPUTE

GO

Be careful the above can take some time to run on a massive Database.

Oh that will teach you to read the manual 😀

Hmm that interesting i believe mine is none i don't change the defaults...

Glad to hear it working.

where do you put sync type ? just for further reference.

Ok i needed to put on lock release and acquired also to see it .

Then i could see what page of data it was on.

Thanks.

Is there a way to see in the sp_lock - which actually event it is on.

I have about 6 different locks.

So i was wondering at what stage is the code...

10 MIN is the default then it stops the databasemail then it should fire again when you request email.

You can change this setting but mine sometimes fires on the hour...

I get the same thing..........over here - i am on with MS but they can't figure out but the call is still open.

Oh - let me look in the profiler for that event selection cheers

sp_depends not heard of this.

Oh but i was trying to get the exact sp the sql is in when it booms out but i get fetch api and that means...

Yes got all of them - just trying to figure out how the @P1 is coming in because it not the right values got to be a unique coding for...

I see if i can get the login and go look myself - cheers.

Its the strangest thing for me sometimes they fire then hours later they don't then they run...