@ GSquared

Thanks a lot.

Regards,

Sushant

@ gsquared

Thanks.. that worked for all the objects in a database..

How can I know about hte creation dates of all the jobs/maintenance plans on a sql server.

Regards,

Sushant

@ syed

Congrats..

Can i know some preparation material so that I can also prepare for the exam?

I am a DBA.....so will this certification useful to me?

Regards,

SUSHANT

@ steve

When i try to start the sqlcmd, it starts and goes off (within 1 sec)

and show the same error, which i posted ....'only 1 administrator can login'..

Regards,

Sushant

I started Sql server in single user mode and then when I try to enter sql server management studio it says:-

Login faield for user 'sa'. Server is in single user...

@ pradeep.

When I tried to do that, it said that for restoring master database, it should be in single user mode.?

How can I implement that.

Regards,

Sushant

@ greg

In his scenario too, he doesnt have space for more than 1 backup thats why he is deleting the older backups, so overwriting cant be ruled out.

If the file...

@ sagar

If you dont need previous day's backup, you can also choose to over write the last day backup.

In that way, there will not be disk space problem and also...

@ rajesh

Also,

--> When the logs are shipped to the secondary server but they are not applied on to the secondary database. That chain of unapplied logs increases and...

@ rajesh..

As gail said, its important to analyze the error rather than just backup and restore again,

What will you do if you again get this type of error after restoring..??...

when i try to delete the schema, it says cannot delete the schema as it is refrenced by object 'xyz'

Regards,

Sushant

@ chrissy

--Script to automatically reindex all tables in a database

USE DatabaseName --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR

SELECT...

@ chrissy

There are some tools like sql search tool, its free and downloadable(from redgate), it helps you to save a lot of time in searching.

You just have to specify the...

@ chrissy

You can search for that index in the database-->tables--> indexes and then rebuild/reorganize from there.

Regards,

Sushant

I installed the client components from the setup.exe and everything was back into place.

I then logged into SSMS( windows authentication) and then changed the sa password.

Thanks all

Regards,

Sushant