Check the installation log file and se what it says.

MJ

I think database trigger prevented the deletion/creation of hidden system database named mssqlsystemresource.

MJ

I see few errors one of those is:

Disk space required for the installation exceeds available disk space. Property(S): DiskSpace_DlgDesc1 = The available disk space and the space required for installation...

I think restoring back the system databases will do.

Experts please comment.

MJ

Make use of this sample code:

Deleting records from 600 to 100 days old:-

USE MSDB

DECLARE @backup_date DATETIME

DECLARE @countback int

set @countback = 600

while @countback >= 100

BEGIN

print @countback

set @backup_date=(select dateadd (dd,...

Its not working for me.

set @cServerName = '[ABC-1C98DDDFF87\SQL2000]'

set @cDBName = 'master'

What else do I need to set as I am logged in to this instance and still getting sql server...

Run select @@version in ssms.

Manu

Read http://sqlblog.com/blogs/aaron_bertrand/archive/2009/01/18/my-latest-sp3-experiences-two-thumbs-acting-like-divining-rods.aspx

Manu

SELECT a.* FROM OPENROWSET('SQLOLEDB',

'DRIVER={SQL Server};SERVER=ServerName;Trusted_Connection=yes;',

'SET NOCOUNT ON;SET FMTONLY OFF; exec (''dbcc sqlperf(logspace)'')') AS a

MJ

What is slow? Select statament queries with Where clause Or Inserts/Updates/Deletes? What is the index structure? Are there too many non-clustered indexes on this table(out of which some not getting...

Why are you reindexing it daily? Are you seeing framentation in this table? You should reindex it only if fragmentation is high(>30-40) otherwise do it weekly or at a...

I don't remember the options screen, have you checked under Advanced Options?

MJ

Check under sys.databases output whether anyone of the following holds true:

is_published

is_subscribed

is_merge_published

is_distributor

Also, I liked the below mentioned solution given by noonone at

http://www.sqlservercentral.com/Forums/Topic115333-7-1.aspx

You can restore another database backup, that don`t have...

Have you chked http://social.technet.microsoft.com/Forums/en-US/sqlce/thread/bf8efab4-fb22-4015-ac38-f894f49bbe6d/

Mj

select * from sys.system_objects

where type_desc like '%func%'

MJ