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...
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?...
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...
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...
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...
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...
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...
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...
February 12, 2008 at 3:16 am
Viewing 8 posts - 1 through 8 (of 8 total)