Excellent rj.  Glad I could help.  The simple things are often the hardest to see.

jg

It would appear as if you are connecting to the gendb database (Initial Catalog=gendb)  when you attempt to restore the gendb database.  So that means that you expect the database...

Hi sol,

There a couple quadzillion (10^40)  ways to interpret what you are asking for.  If you can be specific as to what you are trying to accomplish, someone hwere might...

Arthur,

You can probably rest easy.  I've done the same thing in the past without negative repurcussions.

The code that updates the CHECK constraints for publisher-side identity ranges will only delete 1 check...

Hi sol,

You've changed your requirements a little now.  At first you wanted to know when people accessed a row in a table.  Now you indicate that you'd like to programmatically...

Vidas,

I should mention that putting that kind of trigger in a production environment could be dangerous, so use it with caution.

For example, if the table gets updated by a procedure...

Hi silly,

If you don't want us to laugh, then quit putting the smileys in your posts..   heh 

I think that you could use a tool called SQL profiler, which will...

I'm with Colin.  Roll back the change and confirm that it speeds up.

You can capture the SQL that caused a trigger to fire.  I forget exactly the layout for the logging table, but if you play in your sandbox, you should be...

Yes.  It was me.  Sorry.

But seriously, someone from the youtele.com domain (most likely), probably from the IP address 203.109.72.227, made connection attempts to your SQL server.

If you allow connections directly from...

Understood.  That's not what you said originally, however...

"I want to search to see if the above values already exist. " and ID is up there.

Now, how are you going to come up...

Interesting, except why would you need to get the ID from an existing row in the table, since you have specified that it is one of the search arguments?    I think...

Hi Mindy,

Sometimes ninjas forget that us normal people want to know what is really going on.  They are too busy being ninjas. (heh)

The usage of sp_updatestats probably won't fix the non-problem.  Besides,...

Hi Mindy,

Although I don't have a direct answer to your question, I do have a suggestion.  I often wonder just what the heck the Enterprise Manager is doing behind the scenes to arrive...

Hmmm.  Looks like the good old FM87 format file.

Try using an ExecuteSQL task prior to running the data pump task.  In that ExecuteSQL task, put the appropriate SET statement, and...