yeah, whatever you create, you have the right to destroy..that's what can be scary about granting db_owner...they can drop the database with that right/role.

so with ddl_admin, if you create...

Jason Tontz (5/4/2011)

---

Hello all.

I need to create a role that allows members to create tables in the database. I want to nest db_datareader, db_datawriter as well. This will allow db...

yes, absolutely correct. roles are cumulative, so if i belong to two roles, i get access to whatever was granted to each role.

grants are cumulative, and deny's/revokes top dog: if...

did you find out what it was? was it a job or a script or application that was running?

SKYBVI (5/4/2011)

---

Yesterday, i had to change the sa password on a dev server.

From since then, I am getting errors in sql logs that

Login failed for user 'sa' ; client local...

per login = possible.

per database = not possible.

you can restrict the number of connections for a login, but not which databases they touch AFTER they complete the LOGON process; the...

you have to use the AND for subsequent AND join criteria:

SELECT *

FROM EMPLOYEE

INNER JOIN GEOGRAPHY

ON EMPLOYEE.CITYTBLKEY = GEOGRAPHY.CITYTBLKEY

AND EMPLOYEE.COUNTYTBLKEY= GEOGRAPHY.COUNTYTBLKEY

AND EMPLOYEE.STATETBLKEY= GEOGRAPHY.STATETBLKEY

kinda brief on the details, aren't you?

I think the real issue is you KNOW there is a relationship between the two tables, but don't know how to join them? does...

i think you could run into problems if the default colaltion ( which is what tempdb would have) is different:

this simple exampel raises this error:

Msg 468, Level 16,...

yes you can do it, but there are a few rules: the sheet has to have column names in the first row, i think.

if your SQL2008 instance is 64 bit,...

i've seen this same requirement in other posts; we could google to find the original thread itself, but I wrote this snippet in response; this generates all the revoke commands...

you probablyt want to describe what you are trying to do to get a better answer, as it's a pretty broad question.

This kind of question sometimes comes up due...

i htink by using a case statement, you can make sure you apend them together correctly; I'm assuming the fields are varchars, so i don't worry about trailing spaces;

see if...

here's an example on how to get all the elements to create the Julian date; to append them you have to cast them to VARCHAR, and you'd also have to...