I'm desperately looking for the Book that explains complete clustering.

No need to install SQL Server 2000 DTS designer components on your Cluster.

If want to see and edit the DTS package, intall SQL Server 2000 DTS designer component in Development...

Is it clustered SQL Server or Stand alone SQL Server?

If it is Stand alone SQL Server, Installing Service Pack is pretty straight forward:

1.Down load and Read the read me file...

Thank you...

Currently, I'm Installing and configuring multiple clustered sql server 2005. Is there any Good book that explains complete clustering of sql server 2005 and how to maintain a production...

Thank you..

Could you please provide me a script to get the all the tables size in sql server 2000

thanks

Hi,

I'm using below script to get the table size in a database and its working in SQL Server 2005 BUT NOT in sql Server 2000. I'm getting the below error...

Thank You.

I got one orphand user in one database as below:

UserName UserSID

John 0x3922A096AD89EB49B6BA68362BFDA1B6

Could you please tell...

Hi Jagan,

This is an excellent Article for a SQL DBA to start with ORACLE concepts....

well done..

Thank You

Ram

Thanks,

We have all SQL logins...

I have scripted all the logins in primary using sp_help_revlogin and saved the generated output script a file and ran in secondary server(after bringing all databases...

could please advice me on the above..

No matter how many databases you log ship to secondary, when you bring those databases online on secondary, we need to transfer all the Logins to secondary from Primary?? is...

4.) Then transfer the logins, jobs, linked servers etc.. the only reason being is Log shipping is a database level while the jobs, logins etc.. are created at a server...

Can you point me to BOL,...

1.Is it legal to use developer edition of sql server 2005 for monitoring purpose in production environment?

2.Can we use the same Monitor server, for monitoring log shipping of the sql...