As the Index and Statistics data moves along with the database backup set, consistency check can be (and must be ) run . I would also suggest to select...

Hi Gail,

Would be grt if you can put some light on the influence of the isolation level on this scenario.

Thanks...Arshad

I did something nearly similar to this for one of my previous employers and managed to for about 4 years especially for sharepoint and some financial apps elbeit support by...

What is the status of the database ? If u are familiar with the explorer window in SSMS , please see if there's anything written to the right of this...

How about using a dll kind a component that can be called from SQL server and getting the datetime from client as a return value.

How about this user's access to other objects? Is this a new user, how was the behavior before?

I would have been a professional sports person or pursued career in movies. Some incident forced me to pursue sports as amateur. While in college, RDBMS concepts then attracted my...

Try SQL idera .I used it long back. Has many features.Try evaluation.

This option is not feasible as you want to setup log shipping meaning required space has to be more than double minimum which can't be obtained by freeing the unused...

See how much free space you have in the database. If it's huge and if it's sure that it won't be used for a longtime, you can consider shrinking and...

True Gail.

Are u able to connect using the local SSMS with other users ? If not then clearly the issue is with the client tools on this machine.