@ derrick

What is the difference between checking this(pinging) and opening the sql server configuration manager and seeing if the sql server, agent, etc are running/???

Regards,

Sushant

@ derrick

Ya, there is a blank screen and looks like nothing happened.

That means it is running fine..

Thanks..

Regards,

Sushant

@ mike

/* users, locked or not, and days until expiration */

use master;

go

set nocount on;

go

declare @loginname varchar(200);

declare @logintbl table (

LoginName varchar(20) ,

IsLocked char(5) ,

DaysUntilExpiration int);

declare c_logins...

@ brainy...

Why have you mentioned checking database integrity twice (at starting and at end)?

Also, my production databases are150GB, 6GB , 3 GB so how frequently should I run these steps...

What should be the order of these maintenance plans when performing on anyy datbaase :-

Update statisitcs, reorganize index, shrinking database, rebuilding index, checking integrity

Regards,

Sushant

How often should reorg and rebuild indexes should be run on a production database?

How is update statistics differ from above two. Its runnning frequency should be diffferent?

Checking integrity checkup does...

@ sai

I guess, you have to update the sql server to sp3 or

you can also check by restarting sql server not just agent.

Regards,

Sushant

@ pradeep and steve

Thanks a lot

Regards,

Sushant

@ nagaraj

Just for 2 databases...

sp_helpdb shows that the owner for those databases is null

@Adiga..

Ya, the owner of those databases is NULL....

Can i change the ownername of those databases...

@ balaji

The drawback which i noticed is that some users wont be able to login into the databases after you restore the database to another server.

That happens due to the...

@ steve

The main purpose is that, I am creating a documentation (excel file) which has name of all the objects like tables, procedures, sys stored procs, triggers in all databases...

@ gila

I wanted to say that

if there are few user dbs and system databases

each having different system stored procs...

then this above query will give all the system stored procs...

@ gila

Ya, the code working fine , but if i run that in any user database or system database ,

it is giving the same output

why?

Regards,

Sushant

@ kevin

oops

I meant to say it doesnt give any output.

Regards,

Sushant

@ kevin

It doesnt give any error.

I see there are many system stored procedures.

Regards,

Sushant