ir depends on if you are looking for a string, a reference to an object(table/view/etc), or a reference to a column.

-- a string

select * from sys.all_sql_modules where definition like '%COMM%'

--...

on my dev machine, where i have the last 4 versions of SQL, i was able to create a linked server from 2008R2 to 2012, and successfully query a known...

if you've ruled out the last 3, the only way I know of (and it's probably this, i guess) is it's getting stopped because the server stops and starts.

instead of...

Offhand, these are the reasons I remember for a trace stop being stopped

1.the SQL server is stopped and started. If that is the case, you might need to...

Ok Alan, help me out here: what makes a Broadcast Calendar? are we talking about TV programming, and just a regular calendar, but the first day the first Monday of...

my google of "Error: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded." says that Access can raise that error if too many records are being returned, or the database tries to...

I've played with lots of calendar generations, and googled a bit to see what a "Broadcast Calendar" is; all i found was a bunch of (what i think) are fake/.virus...

Not sure, we can't tell from this side;

you said you got it working for pipe delimited, and the only difference between...

you create multiple roles which contain the permissions you want to be able to assign;

adding a user and granting permissions are a three part process.

first you really needed to already...

aliases are always needed when you add the same table twice; here'a i'm using an aribtrary T1 and T2;

it especially helps the query as well, as with your example, it...

also, take a look at this, where you should change the WarningsReturnAsErrors flag in php.ini:

http://msdn.microsoft.com/en-us/library/cc793139(v=sql.90).aspx

gotcha, so it works correctly most of the time, but not correctly when accessing via PHP.

When using the PHP application and DBBUser the trigger fails to even run and the...

fixed the link for the screenshot, so you can see an example of how other errors occur in the trigger, but only the generic error gets sent to the user

again, no matter what the REAL ERROR is inside the trigger (ie Invalid object name 'DatabaseLogonAudit.dbo.AuditDatabase '. or user does not have access,

the generic error message is all they get.

pretty...

this error:

The check for encryption trigger fails with the infamous ‘login fails due to trigger execution’ error when using any .Net app (SSIS, SSRS, VB program, etc.).

is normal for a...