Hi,

I did the following steps in SQL Server 2005:

Step 1.

Use Mydb

Go

/* CREATE A NEW ROLE...

Yes..Its a share point content database

Could you explain me how to create a custom database role to achive the following:

thanks

The whole application is using this login. If I entere a password, then application will fail to connect to sql server.

My Question is, if I enter the password & enable...

-T1222 is on our server and I'm getting dead lock graph in error log whenever a dead lock occurs. But how to deal with Blocking?

Check the following information before you install SP3 on a failover cluster instance:

?Do not stop the cluster service before you run the SP3 Setup program, or while the installation program...

I'm running the UpdateStatistics job weekly and its taking 40 mins. Does this weekly update statistics enough?

JOB RUN:DBMaintenancePlan.UpdateStatistics' was run on 8/9/2009 at 1:00:00 AM

DURATION:0 hours, 40 minutes, 5 seconds

STATUS:...

Hi Lynn,

I went through this link http://www.dbforums.com/microsoft-sql-server/1627384-moss-collation-question.html in which one of the forum members telling the below

Hey guys,

I am working on the database side of an upgrade for...

Often enough that your stats don't get out of date to the point that it's affecting queries. No way to give you a hard and fast fixed number, it varies...

Could you plz explain me the below

thank you very much,

I'm also thinking to rebuild or reindex based on the fragmentation level instead Rebuild all the indexes.

Could you please clarify me that how often the Update statistics...

Hi,

Could you please give me some info on above questions..

thanks

Just to confirm that we can not open system tables in SSMS..

I able to query and see the data using t-sql commands though

Thank you

I'm the Administrator of that sql server, but I'm not able to open the system tables in MSDB. The open table option is greyed out!!!

Were you saying we can failover to the secondary location2 sql server and point the applications from location 1 to location2 servers?

In our scenario, if the location1 is completly in...