You can also run setup.exe file with /qn or /qb option while installation.

I guess you have missed something.

refer following link for more detail.

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/2d7cc40a-47e8-4419-9b2b-7c69f700e806.htm

I doubt if chaning port is possible with T-SQL.

Yes, it could be possible to edit the registry settings and do the change but I do not recomend.

Not sure about your...

check this out:

http://msdn.microsoft.com/en-us/library/ms190982(SQL.90).aspx

What SQL Server 2005 Edition are you using?

We are using Windows auth only. It is more secure. If you are using windows auth than your application should be more powerful security feature or settings.

You need to create...

Hello Winston,

Is blocking is temporary?

Are you facing any deadlock problem?

check this view:

sys.dm_tran_locks

HTH

Yes, you are heading into right direction. It will work.

As a broad level here is the list of sp which are related to replication; you can use as per your requirement.

http://msdn.microsoft.com/en-us/library/ms174364.aspx

HTH

for SSRS you can think about Mirroring if possible in your scenario.

You can also use standard report "Disk Usage". Which will also give you requried info.

You can also think about the third party database designing / data-modeling tool which will make your task easy.

You can create the various Operators in SQL 2005 and assign the specific job to send mail to related operator when the job fails.

HTH

Check first of all that Replication is working fine. What is the latency of replication of the data?

Also check if db has grown to 59 GB what is the free...

Hello Zombi,

Thank you for more clarification and making your question understand 🙂

As far as I know there should not be any problem unless and untill you are using ENGLISH language...