Hi Paul,

Thanks..

I will try this script.

Rd,

Deepali

--sp_services contains the following code which fetches the state of the services in a machine:

--xp_cmdshell 'sc query state= all'

Their is no such sytem Stored Procedure "sp_services" in SQL2000/2005.

From...

--I am assuming you know the whole server require master rebuild

Yes , I know that to rebuid require when system databases collation has to be changed.

I want script which can...

Hi,

No,don't restore mirror database with recovery .

it seems that mirror_diff.bkp file having some problem.

Hope so this not a production box...Repeat step of taking latest full backup from principle server &...

Some general issues for Query performing slow so the database were No indexes, table scans, missing or out of date statistics, blocking, excess recompilations of stored procedures, procedures and triggers...

Hi,

Can you explain in brif what kind of excutable is that?

Rd,

Deepali

Check for Database Usage(Data and Log Size).

Check for Table space usage (Most used tables)

Check for errors logs for SQL Server

Check for Memory usage and paging for SQL Server

Check the time...

To fetch database list from multiple servers see the below code;

Create linked server connection between servers from server on which script has to be excuted ;

Create PROC dbinfo

@server_nm VARCHAR(15)

AS

BEGIN

...

We can change the server name for only default instance by changing the hostname. But in case of named instance we can not change the Server name.

If any one know...

As DBA ; Automation is always preferred..

I will Suggest schedule it during Non peak hours & have ready report at

the start of Day.

Rd,

Deepali

Hi,

Find script for sql2000;

If exists (Select name from sysobjects where name = 'DBGrowthRate' and Type = 'U')

Drop Table dbo.DBGrowthRate

Create Table dbo.DBGrowthRate (DBGrowthID int identity(1,1), DBName varchar(100), DBID int,

NumPages...

Hello Experts,

Can anyone provide Document which explain about database Cross ownership with examples apart from books online.

It will help a lot .......thanks in advance

Rd,

Deepali

Hi,

Find the DB mirrioring doc...for details refer books online

Rd,

Deepali

Thanks Adi.

Can you pls suggest on above senario how can I protect my table test from deleting records by user ABC who can delete records by executing stored proc.

Pls suggest.

Rd,

Deepali

Hi,

Apply Sql server service pack 2 or 3; Problem will resolved.

In your attached file it is showing Sql server version 9.0.1399 in which Database Mirrioring is not enabled.

Rd,

Deepali