Viewing 15 posts - 1,231 through 1,245 (of 2,387 total)
quote:
Is the sid in sysprocesses useful? I'm not quite sure what that is, whether it's the NT user SID or the...
August 29, 2003 at 7:25 am
From BOL.
"If you set fill factor to 100, SQL Server creates both clustered and nonclustered indexes with each page 100 percent full. Setting fill factor to 100 is suitable only...
August 28, 2003 at 12:07 pm
I guess your supervisor just want to prevent database curruption by shrinking database 'in case' even thoght I haven't seen that too.
You may have to find out why database is...
August 28, 2003 at 9:28 am
Do you use four part qualified name, ie instancename.dbname.dbowner.tablename in your trigger?
You have to setup linked server to the other instance.
August 28, 2003 at 8:28 am
Don't think you can do it. You may monitor the sysprocesses regularly (Sechdule a job) and kill the processes generated by QA/EM if you know those users who shouldn't use...
August 28, 2003 at 7:26 am
These two server have remote server setup to other SQL Server with 'sa' login mapping. Go to Security --> Remote Server --> properties to verify that.
August 28, 2003 at 7:09 am
The answer is still 'No', unfortunaly.
August 27, 2003 at 6:49 pm
Replace the failure drive and start SQL Server, TempDB will be recreated.
If you want to move TempDB to another location, See http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
August 27, 2003 at 1:30 pm
Don't store databases (MDF/LDF) on single disk drive as single drive don't afford any fault tolerance. Instead, always choose a RAID array made up of two or more physical drives...
August 27, 2003 at 12:50 pm
August 27, 2003 at 12:42 pm
Putting database in single user mode will restrict database access from application/users. You could find out how long dbcc takes from your job history and schedule downtime to perform the...
August 27, 2003 at 11:54 am
Each database has pair of database files, ie MDF and LDF. In your case, where is the LDF, Is it in drive 3? Or the drive 3 is used to...
August 27, 2003 at 11:50 am
From BOL.
"How to configure log shipping (Enterprise Manager)
New Information - SQL Server 2000 SP3.
To configure log shipping with the Database Maintenance Plan Wizard
Note Before you configure...
August 27, 2003 at 11:07 am
backup database tempdb with truncate_only
August 27, 2003 at 10:58 am
Put database in single user mode and run dbcc checkdb to see whether you still have the problem.
Quoted from BOL.
"Error 2501
Severity Level 16
Message Text
Could not find table named '%.*ls'. Check...
August 27, 2003 at 10:56 am
Viewing 15 posts - 1,231 through 1,245 (of 2,387 total)