Click here to Skip to main content
11,706,803 members (46,381 online)
   

Database

 
AnswerRe: database design for a self food ordering system? Pin
Sandeep Mewara11-Mar-13 7:04
mvpSandeep Mewara11-Mar-13 7:04 
Questionwhy i am unable to retrieve holiday name Pin
Member 870181310-Mar-13 22:35
memberMember 870181310-Mar-13 22:35 
AnswerRe: why i am unable to retrieve holiday name Pin
Mycroft Holmes10-Mar-13 23:20
memberMycroft Holmes10-Mar-13 23:20 
GeneralRe: why i am unable to retrieve holiday name Pin
Member 870181311-Mar-13 4:31
memberMember 870181311-Mar-13 4:31 
QuestionBCP - Exported files (docx, xlsx & pptx) are corrupted Pin
ragasai10-Mar-13 16:52
memberragasai10-Mar-13 16:52 
QuestionDatabase design for E commerce web site Pin
subbaraogaddam8-Mar-13 19:44
membersubbaraogaddam8-Mar-13 19:44 
AnswerRe: Database design for E commerce web site Pin
gvprabu8-Mar-13 20:04
membergvprabu8-Mar-13 20:04 
GeneralRe: Database design for E commerce web site Pin
subbaraogaddam8-Mar-13 20:21
membersubbaraogaddam8-Mar-13 20:21 
GeneralRe: Database design for E commerce web site Pin
gvprabu8-Mar-13 20:31
membergvprabu8-Mar-13 20:31 
GeneralRe: Database design for E commerce web site Pin
subbaraogaddam8-Mar-13 20:40
membersubbaraogaddam8-Mar-13 20:40 
GeneralRe: Database design for E commerce web site Pin
Shameel11-Mar-13 4:51
memberShameel11-Mar-13 4:51 
AnswerRe: Database design for E commerce web site Pin
Richard MacCutchan8-Mar-13 22:08
mvpRichard MacCutchan8-Mar-13 22:08 
AnswerRe: Database design for E commerce web site Pin
jschell10-Mar-13 6:30
memberjschell10-Mar-13 6:30 
Questiondb_accessadmin? Pin
ThePotty17-Mar-13 23:57
memberThePotty17-Mar-13 23: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 1:21
memberJammoD878-Mar-13 1:21 
GeneralRe: db_accessadmin? Pin
ThePotty18-Mar-13 1:53
memberThePotty18-Mar-13 1:53 
QuestionI keep running into xml format issues in various editors ... please advise Pin
RedDK7-Mar-13 11:13
memberRedDK7-Mar-13 11:13 
AnswerRe: I 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
Davidduraisamy7-Mar-13 19:45
memberDavidduraisamy7-Mar-13 19:45 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
Davidduraisamy8-Mar-13 0:54
memberDavidduraisamy8-Mar-13 0:54 
GeneralRe: I keep running into xml format issues in various editors ... please advise Pin
RedDK8-Mar-13 8:31
memberRedDK8-Mar-13 8:31 
Questionhow to unloch table in sql Pin
mehdi.sabet7-Mar-13 7:38
groupmehdi.sabet7-Mar-13 7:38 
AnswerRe: how to unloch table in sql Pin
Eddy Vluggen7-Mar-13 8:01
mvpEddy Vluggen7-Mar-13 8:01 
GeneralRe: how to unloch table in sql Pin
mehdi.sabet7-Mar-13 21:15
groupmehdi.sabet7-Mar-13 21:15 
AnswerRe: how to unloch table in sql Pin
Eddy Vluggen7-Mar-13 22:31
mvpEddy Vluggen7-Mar-13 22:31 
GeneralRe: how to unloch table in sql Pin
mehdi.sabet7-Mar-13 22:51
groupmehdi.sabet7-Mar-13 22:51 
Questiona query by less performnace Pin
mehdi.sabet7-Mar-13 4:00
groupmehdi.sabet7-Mar-13 4:00 
AnswerRe: a query by less performnace Pin
Eddy Vluggen7-Mar-13 8:02
mvpEddy Vluggen7-Mar-13 8:02 
GeneralRe: a query by less performnace Pin
mehdi.sabet7-Mar-13 22:46
groupmehdi.sabet7-Mar-13 22:46 
GeneralRe: a query by less performnace Pin
Eddy Vluggen7-Mar-13 22:49
mvpEddy Vluggen7-Mar-13 22:49 
GeneralRe: a query by less performnace Pin
mehdi.sabet7-Mar-13 23:08
groupmehdi.sabet7-Mar-13 23:08 
AnswerRe: a query by less performnace Pin
Mycroft Holmes7-Mar-13 12:04
memberMycroft Holmes7-Mar-13 12:04 
GeneralRe: a query by less performnace Pin
mehdi.sabet7-Mar-13 22:56
groupmehdi.sabet7-Mar-13 22:56 
QuestionHow to use sql server database into oracle Pin
Arun kumar Gautam7-Mar-13 1:05
memberArun kumar Gautam7-Mar-13 1:05 
AnswerRe: How to use sql server database into oracle Pin
Sandeep Mewara7-Mar-13 1:10
mvpSandeep Mewara7-Mar-13 1:10 
GeneralRe: How to use sql server database into oracle Pin
Davidduraisamy7-Mar-13 1:13
memberDavidduraisamy7-Mar-13 1:13 
GeneralRe: How to use sql server database into oracle Pin
mehdi.sabet7-Mar-13 21:06
groupmehdi.sabet7-Mar-13 21:06 
GeneralRe: How to use sql server database into oracle Pin
Davidduraisamy7-Mar-13 21:30
memberDavidduraisamy7-Mar-13 21:30 
GeneralRe: How to use sql server database into oracle Pin
mehdi.sabet7-Mar-13 21:59
groupmehdi.sabet7-Mar-13 21:59 
QuestionCreate a table for prices Pin
MedZi20106-Mar-13 18:10
memberMedZi20106-Mar-13 18:10 
AnswerRe: Create a table for prices Pin
Member 95016167-Mar-13 0:43
memberMember 95016167-Mar-13 0:43 
GeneralRe: Create a table for prices Pin
Davidduraisamy7-Mar-13 1:10
memberDavidduraisamy7-Mar-13 1:10 
AnswerRe: Create a table for prices Pin
Sandeep Mewara7-Mar-13 1:08
mvpSandeep Mewara7-Mar-13 1:08 
AnswerRe: Create a table for prices Pin
MedZi20107-Mar-13 15:29
memberMedZi20107-Mar-13 15:29 
Questionretrieving 3 working days Pin
Member 87018135-Mar-13 7:53
memberMember 87018135-Mar-13 7:53 
AnswerRe: retrieving 3 working days Pin
Mycroft Holmes5-Mar-13 12:01
memberMycroft Holmes5-Mar-13 12:01 
Questionchecking whether today's date is public holiday Pin
Member 87018134-Mar-13 7:08
memberMember 87018134-Mar-13 7:08 
AnswerRe: checking whether today's date is public holiday Pin
David Mujica4-Mar-13 8:20
memberDavid Mujica4-Mar-13 8:20 
AnswerRe: checking whether today's date is public holiday Pin
Mycroft Holmes4-Mar-13 11:43
memberMycroft Holmes4-Mar-13 11:43 
GeneralRe: checking whether today's date is public holiday Pin
Member 87018134-Mar-13 21:28
memberMember 87018134-Mar-13 21:28 

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
Web01 | 2.8.150819.1 | Last Updated 26 Aug 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid