100 SQLServerCentral.com     <===== =====> Answering at least half as many questions as

posts, all questions                       you ask on SQLServerCentral.com

  - 2 points                                  +4 points

How much should I get for this...

Can you give out a ittle more details without breaking any confidentiality agreements?  I can't offer much support with that little information!

That too, we'll see what RG will do with this .

Don't give up so soon, there must be another way of doing this task.  What problem were you trying to solve using this method?

And BTW I assume you know triggers on system tables don't work, and the rare times they do they are not reliable!  I know it probabely doesn't apply to your...

Never tried it and never will.  If you can't make it work then that's your answer.  I can't stress enough that security should be build from the first moment you...

I'm not an expert on that matter but this is supposed to be handled but the databases and server logins / permission.  And at design time (can have a module...

Looks like I need to brush up on my 2005 skill (no s here )

Maybe the floating point [im] precision is different between the 2 Softwares.  I'm just throwing this out there as I have never encountered that problem before.

If you want something like :

If data not exists then insert

else

update

You need to code it just like that.  You have to make 2 statements because the insert/update in a...

Just thaught of another way :

Set the application name in the connection string.

Then fire up the profiler with the trace of active connections only.  Save the results to a...

In the connection string you can set an application name, which you can retrieve from sql server (when doing auditing in a trigger or SP).  But I don't know if...

Lol, maybe what this site really needs is a new moderator.  I might be able to do it for less than 100$/hour if they want me to help

I  got tired of asking why and starting a war everytime I see this.  But you have a good point.

Why in %/? name do the users have to change the...

So what are the final run times?