Viewing 8 posts - 1 through 8 (of 8 total)
The expression SCHEMA_NAME(SCHEMA_ID) throws an error, you would need parens after SCHEMA_ID, i.e., SCHEMA_NAME(SCHEMA_ID()), though that would be redundant, just SCHEMA_NAME() returns the same thing. Both return the...
[font="Comic Sans MS"]The Black Knight ALWAYS triumphs. Have at you![/font]
January 6, 2012 at 2:14 am
In all fairness, is it really the responsibility of the DBA and/or net admin to review all of the web app and client app source code developed by their company?...
[font="Comic Sans MS"]The Black Knight ALWAYS triumphs. Have at you![/font]
September 6, 2011 at 7:24 am
Perry Whittle (7/11/2011)
mmcgintyare builtin admins definitely in the sysadmin role, please execute the following against your instance and advise the results
EXEC sp_helpsrvrolemember 'sysadmin'
Yes definitely:
ServerRoleMemberNameMemberSID
sysadminBUILTIN\Administrators0x01020000000000052000000020020000
I noticed the SID for this account...
[font="Comic Sans MS"]The Black Knight ALWAYS triumphs. Have at you![/font]
July 11, 2011 at 11:40 am
No, not at all. It's a standard group and behaves the same way all others do.
I just tested it on my Windows 7 workstation, and NT group membership does work...
[font="Comic Sans MS"]The Black Knight ALWAYS triumphs. Have at you![/font]
July 11, 2011 at 6:17 am
Welsh Corgi (7/9/2011)
By default, the local Windows Group BUILTIN\Administrator is no longer included in the SQL Server sysadmin fixed server role on new SQL Server 2008 installations.Regards,
WC
In that case the...
[font="Comic Sans MS"]The Black Knight ALWAYS triumphs. Have at you![/font]
July 11, 2011 at 2:46 am
"G0 x" means run the above batch x times.
Wouldn't that be, "GO x" means return the value x, as the only [and unnamed] column, in the only row of the...
[font="Comic Sans MS"]The Black Knight ALWAYS triumphs. Have at you![/font]
August 24, 2008 at 10:25 pm
Interesting article, but I'm afraid your comments about C++ are not technically accurate:
In C++ when a variable is created the variable has an address of 0xddddddd (in debug but it...
[font="Comic Sans MS"]The Black Knight ALWAYS triumphs. Have at you![/font]
February 22, 2008 at 3:09 am
You'll need to use sp_attach_db rather than sp_attach_single_file_db, the latter only works when all files other than the .mdf are in the same location they were when the db was...
[font="Comic Sans MS"]The Black Knight ALWAYS triumphs. Have at you![/font]
February 12, 2008 at 3:16 am
Viewing 8 posts - 1 through 8 (of 8 total)