Viewing 15 posts - 3,556 through 3,570 (of 6,105 total)
Unless you've moved your repository for Analysis Services to SQL Server, look for an Access database in the bin directory called msmdrep.mdb. This is probably where the metadata you're looking...
April 15, 2004 at 12:05 pm
In SQL Server there are two large categories of roles: database and server. The sysadmin role is a server role. While we can create user-defined database roles, server roles are...
April 15, 2004 at 9:38 am
The reason the sysadmin role is needed is for AUTO_FIX. This option will associate to a login of the same name if found, but if there isn't a login that...
April 15, 2004 at 6:47 am
They can set a policy that supercedes the default group policy they may have set on all servers... so all is not lost. They'll need to do this on any...
April 13, 2004 at 9:43 am
Hrm. It was on sale at Amazon still as late as last week if I remember right. I see even Bookpool.com is out of stock. However, it is on-line at...
April 13, 2004 at 7:07 am
I can't help you on the book side as I'm not very Oracle savvy, but copies can be downloaded from Oracle's web site. You can find Oracle 9i towards the...
April 8, 2004 at 9:39 pm
As stacenic points out, so long as BUILTIN\Administrators has rights, you're not going to keep them out. You can remove BUILTIN\Administrators but there are some gotchas. The pros and cons...
April 8, 2004 at 9:34 pm
Also, the backup password merely stops someone from restoring the backup to SQL Server. Open up a backup file with a text editor and you'll be amazed at the information...
April 7, 2004 at 9:00 pm
If the antivirus grabs the file first when SQL Server attempts to start up, things like that. Also remember than many antivirus agents are going to scan changing files frequently....
April 7, 2004 at 2:49 pm
There's this, though I'm not sure how applicable it will be to your setup:
BUG: The SQL Server 2000 Service Manager Utility Does Not List Instances That Have Not Enabled Network...
April 6, 2004 at 9:10 pm
There is an undocumented role within msdb, TargetServersRole, which I believe has permission to do this. It would require granting individual users access to msdb and then making them members...
April 6, 2004 at 9:04 pm
Our DBAs happen to be local administrators because it makes their job easier overall. However, this isn't absolutely necessary in order for a DBA to perform typical day-to-day functions.
I...
April 6, 2004 at 8:55 pm
Just to piggy-back, what Alamir suggests as far as extensions are concerned is what we practice. However, we do scan important folders such as %systemroot% and %systemroot%\win32. The reason being...
April 6, 2004 at 6:35 am
Is there a sqlsp.log on the other node? If so, does it show an error in the last few lines?
April 3, 2004 at 11:01 am
See if they have explicitly defined:
- Log on as a service
- Act as part of the operating system
- Replace a process level token
If they have defined those values in their...
April 2, 2004 at 8:34 am
Viewing 15 posts - 3,556 through 3,570 (of 6,105 total)