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...

probably very similar, using reverse and patindex for the first non numeric character: from there, for the 1/-1, a case based on the len() would be what i would use.

with...

procedure a supposed to be called with the full EXEC ProcName @Parameters or EXECUTE ProcName @Parameters.

only when a procedure is the only line item (or the first line item in...

Learner, it kind of sounds like these users are sysadmins? i don't think you can deny a sysadmin anything, so you have to take away their superpowers before you can...

its a binary AND operation.

5 = 00000101

17 = 00010001

the only column in BOTH values binary representation above is the first column, representing 2^0, so the value is 1.

16...

ok i created this complete example by merging some of your stuff into my known, working trigger example.

it's working well for me, but has a couple of duplicate columns from...

pwalter83 (7/24/2013)

---

Thanks Lowell,

However, I was wondering is it not possible to implement this logic within the table structure because as I mentioned earlier, the values in one table would be...

pwalter83 (7/24/2013)

---

Hi,

I am very new to SQL and really dont know how to phrase my question.

There are 2 tables linked through a primary key and if the values in...

can you use the trick of a SUM(CASE...

not sure if you need a count, or the coutn distinct for each item:

SELECT

[DateofScan]

,[DeviceType]

,count([PlugInID])

,SUM(CASE WHEN Critical = 'Y' THEN 1 ELSE 0...

Oh man,so you've been added into the naughty list, then right?

you should be able to fix it without a trace at all; the error is in the report itself.

somewhere in that' reports definition,you've got something like

...WHERE ClientID = (SELECT...