wow that looks a little scary to me, where maybe the logic isn't quite clear.

it looks like you want to delete any existing records that might end up having...

aaron.reese (4/24/2013)

---

Which is sort of annoying!

It means that home developers and/or people trying to 'break in' to SQL development have a huge barrier to entry. I understand why Microsoft...

well, note the comments in the thread;

if you need to protect 400 tables, it's probably better to look at the security aspect of it, adn not tackle this via a...

Andy did you copy the trigger verbatim or modify it a bit?

it worked fine for me when i posted to the thread originally;

can we see your version of...

ok by looking at a different registry key and looking for Service names, i think this finds them all on my sample machine:

/*

ResultsId ResultsText

233 ...

Geoff A code example worked fairly well on my machine.

My dev machine has four instances installed:

2008 standard (default).

2005 Express.

2008R2 Developer.

2012 Developer.

The above query seems to have missed my...

according to microsoft This Link for Error 8952 says it's a hardware error, and suggests a default restore from backup, i think.

Table error: Database 'DBNAME', index 'OBJNAME.INDNAME' (ID O_ID) (index...

your key types, being huge varbinarys, are preventing you from indexing; that's going to require a table scan.

is that a default varbinary size that someone/some application imposed? can you get...

this interview question is testing to see if you know about collation.

there are UPPER and LOWER functions for converting things;

the problem is unless you explicitly state the collation, a default...

niladri.primalink (4/22/2013)

---

Hi Lowell,

Thanks for your reply I have craeted role under CAS database..then grant select option and after that when I add rolemember then it shows me error

User or role...

create a specific role with only the limited permissions you want.

once the role is created, then add the users to that role.

remember roles are cumulative, so if you add the...

ok, maybe i'm wrong here, but I believe there is no need to use sp_msForEachDB:

that dmv creates ALL the missing indexes in for All databases that meet the missing index...

not an SSRS expert, but i certainly know html and css.

if you can set the class of each option in the select list, you can do it:

a css example:

http://stackoverflow.com/questions/2720532/html-select-dropdown-list-with-multiple-colours

and here...

could it be someone was cleaning up data and used a REPLACE without a WHERE statement?

the rowversion gets incrmeneted even thought here was no "real" change:

CREATE TABLE WHATEVER(

WHATEVERID INT...

no.

the role db_owners, being a built in role, cannot be modified.

instead, create your own role , ie '[AlmostOwners]', and assign the privileges you want.

then remove db_owner from the users, and...