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

Remember we are not sitting behind you, looking over your shoulder.

i have no idea what is working or not working.

If you want help with...

interview questions?

your table needs to use nvarchar and not varchar fields to hold unicode data.

in addition, any parameters you are using also need to be nvarchar...so in .NET language, for example...

Ive never seen that in the options no.

You can do a find and replace very easy though

[INSERT INTO ] --> [INSERT INTO MYDB.]

i missed the part about restoring on the remote server.

if you have a linked server, i know you can do EXECUTE AT;

here's an example of creating a table on the...