- Did you use "NO RECOVERY" when restoring database on the MIRROR server?

Also, go thru this link:

http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx

Manu

Try this. Hope it works.

Create PROCEDURE dbo.s_test

AS

SET NOCOUNT ON

-- declare all variables

DECLARE @sdbname SYSNAME

DECLARE @Account SYSNAME

DECLARE @VHOName SYSNAME

DECLARE @sSQL VARCHAR(150)

DECLARE @sSQL1 VARCHAR(150)

DECLARE @iRowCount INT

DECLARE...

Thanks Greg. Is there any similar option avaialble in SQL Server 2000?

Have you checked the access permisions for sql service account on this new mdf and ldf files location? Usually this message comes due to this only. Also, have master and...

If you want you can try this script:

/*==================================================================================

NAME: Move a table between filegroups

DESCRIPTION: This script moves a user-given table from one file group to

another, where both file...

James,

--For files consolidation

You need to use EMPTYFILE option under DBCC SHRINKFILE command so as to move the data present in the file(of same filegroup) to one file(of same filegroup).

Please...

Go thru this MS doc. once:-

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&displaylang=en

SQL Server 2005 Upgrade Technical Reference Guide

Manu

Go thru this too if you are intrested in resolving deadloacks issue:

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

I want to view the SQL Server instances that are installed on the machine.

Have you gone thru this link:

http://sqldev.net/sqlagent/SQLAgentRecuringJobsInSecs.htm

Manu

Thanks Jim. But I need to generate script using query analyzer.

Manu

Red arrow means that login is disabled. You can enable it using right click login-->properties-->status option.

Manu

It can be done if you create three different jobs with their schedules and call them with the folowing workflow. For example:

Job1 Step 1 execution--On successful completion --> Go to...

Thank you friends..

Replication is working between SQL 2000 to SQL 2005.. It's rocking..

Please post incase of any new articles like this..

Regards,

Mallik.