san - what exactly are you hoping to accomplish ?!

sp_defaultdb is used along with sp_grantdbaccess to grant users access/permissions to a default database - this default database can only be...

you would pass an @userID variable and your query would change to:

SELECT PT.description AS roleDescription, CASE

WHEN A.hasRole IS NULL THEN 'False' ELSE 'True' END hasRole

FROM

pos_user_type PT

LEFT OUTER JOIN

(SELECT user_type_id...

bryan - you would really have to read up on linked servers and distributed queries and transactions - there are some simple "how to"s in BOL on creating a linked...

you could go to 'Active Topics' - but again, just because a question is answered doesn't necessarily mean that the answer was the right one...also, when a question goes...

derek - i haven't had much time to work on this...but here's something to get you started off in the right direction...I have the query you're looking for (I think!)...

saad - it appears that you are trying to insert rows into a system table - sysdepends ?!?!

if that's the case:

1) you need to have 'allow updates' set to 1.

2)...

Once the kids go, it's off................

haven't you heard - The kids NEVER leave....

If you're all telling me that it's normal practice to move from dev to production with the pk gaps included then fine, I'll learn to live with it - no...

derek - i'll try and get back to this later on tonight but meanwhile a couple more confirmations required......

1) is your pos_user_type_link.user_id = users.id ?!

2) is the pos_user_type.id = pos_user_type_link.user_type_id...

overall point that the article makes is well taken - oftentimes, the unfortunate reality, however, is that the vision that comes with careful planning and laying the right foundation is...

What I understood was that you need some sort of a "catch all" table that will list all the applications, their users, userid etc..

however, I'm not clear about why (for...

derek - what are you trying to insert into your temp table ?! is it data from another table or something else ?!

also, if you could pl. explain why you...

does a "select distinct...." reduce the # of rows at all ?!

also - what are some of the other requirements - eg: if a person has more than one applicationID,...

not having done any research on this - but my immediate guess is that since "page deallocations are recorded in the transaction log"... that they would be reallocated as soon...

so this has to be a left outer join...you want to get person info regardless of whether they have an applicationID or not ?!?!

also - how are you using your...