Mirroring is database specific it has nothing to do with rest of the B,C,D databases for which its not being configured. Also, the source database in mirroring is available for...

Try to find out the object occupying space there by querying sysindexes table:

select * from sysindexes

where groupid='Blob object filegroup ID(from sysfilegroups)'

MJ

Execute permissions default to the public role for these stored procedures.

MJ

CREATE INDEX idx_1 ON table1(col1) ONLINE

MJ

Do make use of ONLINE option while creating the index.

MJ

If you really need to do this then make use of replication as it also allows for ddl changes to be replicated along with data in sql server 2005.

MJ

You shouldn't shrink your database as it creates frgamentation and consumes costly server resources like cpu etc.

http://www.karaszi.com/SQLServer/info_dont_shrink.asp

Read about the three options on books online and you will understand it.

MJ

Ananda,

Is there any column defined as a "uniqueidentifier" for this table and check is there any other table where this trigger tries to insert data when fired?

http://www.eggheadcafe.com/software/aspnet/31942317/operand-type-clash-uniqu.aspx

MJ

I meant the media should be for SQL Server 2005 standard or enterprise edition not for RTM one.

MJ

Have you checked the confilict schema script? There must be some messages about articles for which its not able to initialize subscription.

MJ

Are you using correct installation CD or media file as I see the version as

2005.90.1399.0 in the error messages.

The above file version is for RTM version.

http://sqlserverbuilds.blogspot.com/

As per upgrade...

Are you able to ping the remote server? How you have registered that server by name or IP?

MJ

Where exactly you are checking for space usage:

Taskpad, thru Command or ?

MJ

Are you logged in on the system with your credentials? If yes, is that credential having rights to that server instance? Which account is used for starting sql server service?

MJ

Run the below mentioned code(on under database) to kill all connections to this database and then drop the database:

DECLARE @DatabaseName nvarchar(50)

SET @DatabaseName = N'Enter DB Name here'

DECLARE @sql varchar(50)

SET @sql...