thanks Gail,

Here is the output after running the DBCC commands

PAGE HEADER:

------------

Page @0x1CE04000

----------------

m_pageId = (1:221153) m_headerVersion = 1 m_type = 1

m_typeFlagBits...

hi,

Iam planning to do the following steps to change the collation settings of user databases.Corect me if Iam wrong?

1. Script out all user databases .In management studio, Database->tasks->Generate Scripts->In...

thanks Jeff,

This script is giving the mdf and ndf file. But I would like to get the actual space allocated for datafile and the available space inorder to monitor .Based...

could you plz provide me a script to monitor the datafile size and log file size

Thanks

Madhu

I guess it would be fine if the autogrow set to 5% instaed of 10% as the error log saying that use alter database to set to a smaller filegrowth....

thanks Gail,

so right now the available space(unallocated space) 311.97 MB. So it is decreased further, I need to manually increase the datafile right?

for that Do I need to follow this...

I tried with sp_spaceused in the database causing the issue. Below are the results

databasename database_size unallocated space

ABC ...

thanks,

I have lot of disk space left where the datafile exist, so how this auto grow option effects to cause issues. and how to monitor the database growth. could you...

thanks Gail,

The automatically grow file option is enabled and the file growth by percent 10 is enabled for all production databases.

I never get this timeout problem. So whatwill be the...

Thanks steve,

I installed the new sql server and it is in a different domain. After scripting the jobs from old server,what are the items do I need to change in...

thanks Manu....

In My Case I would like to change only the user databases collation settings from Latin1_General_CI_AS_KS_WS to SQL_Latin1_General_CP1_CI_AS.

System databases: collation: SQL_Latin1_General_CP1_CI_AS

User databases:collation: Latin1_General_CI_AS_KS_WS

We have 3 nodes in the...

could you plz take me to the link in BOL

How to rebuild system databases in SQL Server 2005

thank you

thank you,

Our environment is Active\Active\passive clustered SQL Server 2005.

The link http://msdn.microsoft.com/en-us/library/dd207003.aspx#Mtps_DropDownFilterText explains for SQL Server 2008. I tried to find out for SQL Server 2005 but I did...

thanks,

I would like to know how to disable TCP chimny and there upto 9 cumulative updates, so Iam thinking to apply the recent one.plz advice me

Thanks Gail,

is that must and should to enable page level locking for all the indexes?

what the purpose of enabling and disabling page level locking on indexes?