Viewing 15 posts - 1,261 through 1,275 (of 2,387 total)
You can also have detailed Maintenance Plan information written to a file. To have detailed Maintenance Plan information written to a file, use these steps: In SQL Server Enterprise Manager,...
August 22, 2003 at 1:32 pm
SQLBill,
His SQL Server version is 6.5. There is no such MDF/LDF database files and detach/attach commands in this version.
Dimpal,
Go to your SQL Server installation folder \MSSQL\LOG to open those errorlog...
August 22, 2003 at 12:32 pm
I would go to server Task Manager to see any SQL Server Maintenance processes (sqlmaint.exe) that could be hung. Kill them and try your jobs.
Which version of SQL Server and...
August 22, 2003 at 12:22 pm
For example.
use master
go
alter database northwind set offline with rollback immediate
go
drop database northwind
go
August 22, 2003 at 12:16 pm
Of course you have to purchase your license. Paper work is one thing and how to change it is another thing.
Call Microsoft if you like to confirm whether it...
August 22, 2003 at 10:01 am
Ok. It looks you want to disconnect all user's connections before droping the database.
You may try to replace your step1 with 'alter database' command with 'termination' option. See BOL...
August 22, 2003 at 9:57 am
quote:
I run detach user, drop DB and then restore DB, 3 steps in the job
August 22, 2003 at 9:40 am
USE pubs
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'reminder' AND type = 'TR')
DROP TRIGGER reminder
GO
CREATE TRIGGER reminder
ON titles
FOR INSERT, UPDATE,...
August 22, 2003 at 9:30 am
Which stored procedure did you try to run? sp_adduser?
August 22, 2003 at 9:23 am
quote:
Couple of days back we had a situation that the jobs were hung with a status "performing completion actions". We had...
August 22, 2003 at 8:56 am
A trigger is a special type of stored procedure that is not called directly by a user. When the trigger is created, it is defined to execute when a specific...
August 22, 2003 at 8:52 am
Sorry, I was wrong. Once the license mode is set, you can't change the modes but you can add seat or processor licenses from control panel --> SQL Server 2000...
August 22, 2003 at 8:29 am
Build number 818 indicates you have installed MS03-031: Cumulative Security Patch for SQL Server that was released recently and Win2k SP4 shouldn't include it. SP4 was published for download around...
August 22, 2003 at 8:20 am
The old history recods will be deleted. SQL Server Agent uses 'sysjobhistory' to log history information but the maintenance plan keeps the history in 'sysdbmaintplan_history' table for that plan. The...
August 22, 2003 at 8:11 am
Execute permissions default to the public role for a user changing the password for his or her own login. Members of the securityadmin and sysadmin fixed server roles can change...
August 22, 2003 at 7:07 am
Viewing 15 posts - 1,261 through 1,275 (of 2,387 total)