Find the article how to configure mail profile.

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

SQL Server doesn't support sending SMS messages. You would need to use the cell phone's email address and have the SQL Server send a regular email to the cell phone.

Most...

Are you using sql server 2000 or 2005

Hi

Thanks for the reply,

Right now I have statement like this

dbcc dbreindex(tblname,'',0,sorted_data_reorg)

If I modify the above statement as

dbcc dbreindex(tblname,'',0)-- You are saying that the while creating the clustered index...

I do not have any requirement to enable the VIA, Just I was testing the protocals and my server did't start, So just I would like to know what it...

Hi Thanks for the reply, You are right, my problem is solved by executing the script proveded by microsoft.

http://support.microsoft.com/kb/818334

Regards

Rajesh Kasturi

Disable all the replication related jobs on publisher, distributor, subscriber

then enable when you want to it.

Hope it will work.

Hi Wildcat,

Could you please tell me what is meaning of incremental backup weather...

use DBCC INPUTBUFFER(SPID)

Make sure you have 4 GB of RAM if you do not have 4GB of ram no use of migrating to 64 bit, backup the database before migrating, If it...

Regarding Space issue you you run DBCC spaceused and check the unused space and you run DBCC UPDATEUSAGE(0) on your database then check the size now.

When you give no...

Dear All,

Thanks a lot for all your suggestions. really all are useful.

As you know we have 3 types of backups available in SQL Server

Full, Differential and Transactional

Incremental backup can be Differential or T-Log.

Hi steveb,

Thanks for your quick reply, Is there any thing else apart from redudent...

Optimizaton job will run the DBCC DBREINDEX on selected database, If your database size is 10 GB your log file may grow 3 times.