Click here to Skip to main content
11,492,279 members (63,705 online)
   

Database

 
AnswerRe: Database design for E commerce web site Pin
gvprabu8-Mar-13 21:04
membergvprabu8-Mar-13 21:04 
GeneralRe: Database design for E commerce web site Pin
subbaraogaddam8-Mar-13 21:21
membersubbaraogaddam8-Mar-13 21:21 
GeneralRe: Database design for E commerce web site Pin
gvprabu8-Mar-13 21:31
membergvprabu8-Mar-13 21:31 
GeneralRe: Database design for E commerce web site Pin
subbaraogaddam8-Mar-13 21:40
membersubbaraogaddam8-Mar-13 21:40 
GeneralRe: Database design for E commerce web site Pin
Shameel11-Mar-13 5:51
memberShameel11-Mar-13 5:51 
AnswerRe: Database design for E commerce web site Pin
Richard MacCutchan8-Mar-13 23:08
mvpRichard MacCutchan8-Mar-13 23:08 
AnswerRe: Database design for E commerce web site Pin
jschell10-Mar-13 7:30
memberjschell10-Mar-13 7:30 
Questiondb_accessadmin? Pin
ThePotty18-Mar-13 0:57
memberThePotty18-Mar-13 0:57 
OK, so as I understand it the db_accessadmin role got merged into db_securityadmin in recent versions of SQL server? This is fine, it's better this way.

My question is, when did it happen? I try to cater for all reasonable flavours of SQL server in my system, I recently took great joy in removing support for SQL 7 (The last client using it paid me to migrate their data to 2008r2 via 2005).

Now I'm trying to set up a login with both db_accessadmin & db_securityadmin rights. Or just db_securityadmin, if appropriate. So I need to know which release they merge in. Google is useless on this, so is MSDN.

I could just try to grant the right and suppress the error if it fails, On Error resume next anyone Poke tongue | ;-P
One day we'll look back on this and plow into a parked car.

AnswerRe: db_accessadmin? Pin
JammoD878-Mar-13 2:21
memberJammoD878-Mar-13 2:21 
GeneralRe: db_accessadmin? Pin
ThePotty18-Mar-13 2:53
memberThePotty18-Mar-13 2:53 
QuestionI keep running into xml format issues in various editors ... please advise Pin
RedDK7-Mar-13 12:13
memberRedDK7-Mar-13 12:13 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
RedDK7-Mar-13 13:13
memberRedDK7-Mar-13 13:13 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
Davidduraisamy7-Mar-13 20:45
memberDavidduraisamy7-Mar-13 20:45 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
Davidduraisamy8-Mar-13 1:54
memberDavidduraisamy8-Mar-13 1:54 
GeneralRe: I keep running into xml format issues in various editors ... please advise Pin
RedDK8-Mar-13 9:31
memberRedDK8-Mar-13 9:31 
Questionhow to unloch table in sql Pin
mehdi.sabet7-Mar-13 8:38
groupmehdi.sabet7-Mar-13 8:38 
AnswerRe: how to unloch table in sql Pin
Eddy Vluggen7-Mar-13 9:01
mvpEddy Vluggen7-Mar-13 9:01 
GeneralRe: how to unloch table in sql Pin
mehdi.sabet7-Mar-13 22:15
groupmehdi.sabet7-Mar-13 22:15 
AnswerRe: how to unloch table in sql Pin
Eddy Vluggen7-Mar-13 23:31
mvpEddy Vluggen7-Mar-13 23:31 
GeneralRe: how to unloch table in sql Pin
mehdi.sabet7-Mar-13 23:51
groupmehdi.sabet7-Mar-13 23:51 
Questiona query by less performnace Pin
mehdi.sabet7-Mar-13 5:00
groupmehdi.sabet7-Mar-13 5:00 
AnswerRe: a query by less performnace Pin
Eddy Vluggen7-Mar-13 9:02
mvpEddy Vluggen7-Mar-13 9:02 
GeneralRe: a query by less performnace Pin
mehdi.sabet7-Mar-13 23:46
groupmehdi.sabet7-Mar-13 23:46 
GeneralRe: a query by less performnace Pin
Eddy Vluggen7-Mar-13 23:49
mvpEddy Vluggen7-Mar-13 23:49 
GeneralRe: a query by less performnace Pin
mehdi.sabet8-Mar-13 0:08
groupmehdi.sabet8-Mar-13 0:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 28 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid