Viewing 15 posts - 3,616 through 3,630 (of 6,105 total)
Just keep in mind this is undocumented and subject to change. For instance, permissions this role had were changed with SP3. So if you make use of it, test in...
March 30, 2004 at 6:47 am
If you're using paramerized stored procedures, this probably goes without saying, but just to be safe... ensure the permissions are issued only against the stored procedures and take advantage of...
March 30, 2004 at 6:43 am
There isn't a Sarbanes-Oxley for Idiots book, unfortunately, since a lot of S-Ox is still like HIPAA... open for legal interpretation.
Sarbanes-Oxley, in a nutshell, is designed to ensure non-fraudulent financial...
March 24, 2004 at 2:24 pm
You want to take a look at the system stored procedure sp_helprotect.
February 20, 2004 at 7:18 pm
Does the MSSQLSERVER service start and stay running? What are the contents of the ERRORLOG file indicating? Any errors in the Application or System event log for the system?
February 20, 2004 at 9:27 am
SQL Server has no documented internal mechanism for encrypting/decrypting data in this manner. Microsoft will point you to the use of third parties. Protegrity is one such vendor.
February 20, 2004 at 9:25 am
Can you give a bit more specs about your configured environment?
February 20, 2004 at 9:23 am
Can you access the SQL Server from the console (at the server itself) using Enterprise Manager or Query Analyzer?
February 19, 2004 at 7:05 am
As another said, ApexSQL log can do this for the most part. Might be better to have a sql trace, though, using Profiler or the trace stored procedures if it's...
February 18, 2004 at 11:57 am
You can basically follow Brian Knight's instructions to get the initial SQL Server instance online with two main exceptions:
1) DTC needs its own physical drive, name, and IP address (and...
February 18, 2004 at 12:32 am
User login is handled at the beginning of the connection. From that point forward it basically maintains the session, so the user login won't get passed a second time. You'll...
February 18, 2004 at 12:23 am
For clusters, no, you don't want to use local group. The groups, while named the same to you and me, will have different SIDs on each node of the cluster....
February 16, 2004 at 1:36 pm
They haven't backed off on the OS side... however, from a SQL Server perspective I lean towards global groups when I'm considering a rapid recovery situation... here's why. A Windows...
February 16, 2004 at 10:37 am
The cluster account should be made a member of the sysadmin role.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;263712
February 13, 2004 at 1:33 pm
Run a Profiler trace to see the connection being created and the stored procedure being executed. Add Exceptions & Warnings to see if the stored procedure is throwing an exception when...
February 6, 2004 at 12:04 pm
Viewing 15 posts - 3,616 through 3,630 (of 6,105 total)