dwilliscp (7/26/2013)

---

The where looks at the two columns that make up the PK... You code is more compact though.

But I am looking for a better way to not run the...

As An FYI for datetime, Luis mentioned you can't add a single millisecond; the minimum is 3 milliseconds, and that's imposed due to the way the data is stored by...

Patti yes, that is correct; we...

my first thought, is that this trigger is checking things that don't make sense in that WHERE statement, and can be updating rows that it should not.

of course the [Document]...

dwilliscp (7/26/2013)

---

Is there any way to limit the trigger, so that it only runs when the app is a .Net SqlClient Data Provider? Or ...not to run if the app...

Patti I hope this helps:

this is a copy of the definition for scripting my linked server to Oracle; this is working for me, without using a DSN.

note that if your...

ok, after modifying the SoapAction to the correct name, i get the xml back of the data table, but the xml doesn't contain the schema,just the data i think,...

||edit||: the code below, as long as you have a web server and a valid conneciton to a sql server from that web server works 100%

I found this interesting when...

note that the PATH variable is null?

I'm sure that means because someone is actively using SQL Profiler to run the trace live; Profiler will instantly recreate the trace if it...

Cadavre I love your new signature with the nolock pointers! just noticed it today.

at least in SQL2008 and above, for cross database or cross server references, references are at least tracked in the current database, but not enforced of course

this query has...

another possibility is to create the user with the "right" limited permissions, with the same password as 'sa' currently;

that should be easy to do , since everyone is logging in...

i believe that's because , according to SQL rules, you cannot create a parameter from appended objects. you can assign it, or build it before hand, but noty inline

declare @param...

Eugene Elutin (7/25/2013)

---

Lowell (7/25/2013)

---

doh!, if it ends in [0-9] might be even easier?

SELECT *,

CASE

WHEN x LIKE '%[0-9]'

THEN 1

...

doh!, if it ends in [0-9] might be even easier?

SELECT *,

CASE

WHEN x LIKE '%[0-9]'

THEN 1

ELSE...