Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

I No Longer Have Access to My DB and I'm a DBCreator! Expand / Collapse
Author
Message
Posted Wednesday, January 22, 2014 11:24 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Today @ 11:48 AM
Points: 6,783, Visits: 1,879
Comments posted to this topic are about the item I No Longer Have Access to My DB and I'm a DBCreator!

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #1533910
Posted Wednesday, January 22, 2014 11:24 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 11, 2014 12:00 AM
Points: 1,691, Visits: 757
Interesting QotD thanks.

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1533911
Posted Thursday, January 23, 2014 2:13 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:41 AM
Points: 2,500, Visits: 2,382
Andy Warren (1/22/2014)
Comments posted to this topic are about the item <A HREF="/questions/Security/105935/">I No Longer Have Access to My DB and I'm a DBCreator!</A>

Easy one! Thanks!
Post #1533938
Posted Thursday, January 23, 2014 3:02 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:58 PM
Points: 3,915, Visits: 5,093
Really interesting question, thanks - had to read up on this, as I don't use sqlcmd very often.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1533958
Posted Thursday, January 23, 2014 3:49 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:24 AM
Points: 1,739, Visits: 6,351
Interesting question, but the title meant it was easy to get the right answer.
Though it looks like almost half the people who answered didn't read the title
Post #1533983
Posted Thursday, January 23, 2014 5:59 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 6:41 AM
Points: 519, Visits: 252
I'm one of the ones who did not read the title. I hate missing a question like that!

Live and learn... and learn .... and learn

Todd



Thanks,

ToddR
Post #1534030
Posted Thursday, January 23, 2014 6:26 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, August 21, 2014 3:52 PM
Points: 5,988, Visits: 12,923
Toreador (1/23/2014)
Interesting question, but the title meant it was easy to get the right answer.
Though it looks like almost half the people who answered didn't read the title


count me in that half! Obvious if you do.

Also, the question should specify this is SQL2012 specific (alter server role).

you would also need to be logged onto the server when running SSMS to use localhost


---------------------------------------------------------------------

Post #1534044
Posted Thursday, January 23, 2014 7:16 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:55 AM
Points: 3,234, Visits: 1,262
Also, the question should specify this is SQL2012 specific (alter server role).

I wonder how many people gave an "incorrect" answer, based on the fact that they were not using SQL2012, but an older version. Then the correct options would have 1, 4 and 6.
Post #1534063
Posted Thursday, January 23, 2014 7:20 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 8:26 AM
Points: 1,803, Visits: 2,168
Got it wrong, but also got this when I ran the script in SQLCMD mode:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'ROLE'.


Running on 2008. Is it just a 2008/2012 issue? (If so, should have been posted with question.) Or am I missing something else?


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1534066
Posted Thursday, January 23, 2014 7:35 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:58 PM
Points: 3,915, Visits: 5,093
Thomas Abraham (1/23/2014)
Got it wrong, but also got this when I ran the script in SQLCMD mode:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'ROLE'.


Running on 2008. Is it just a 2008/2012 issue? (If so, should have been posted with question.) Or am I missing something else?


ALTER SERVER ROLE is new functionality added with SQL2012


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1534079
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse