Hi,

As far as I know there is no inbuilt system for this. But you can do that if you can write your customized queries for getting the data...

Hi,

You can check out the errors in http://technet.microsoft.com/en-us/library/ms164086(SQL.90).aspx. I think one of the index is corrupted in your database. Can you run a DBCC...

Hi,

I am sorry to say that there may be some other problems too like locking mechanism etc... as this is performance related problem. Just check...

Hi,

After writing a trigger in new query window Please press f5. Once you press f5 sql server will try to execute the code written in the query...

Hi,

There may be no of reasons why it is happening.

1. Do you have indexes on those tables.

2. When did you update your indexes and statistics last.

3. Do you...

Hi,

check this link http://www.sqldts.com/224.aspx

Thanks

Chandra Mohan N

Hi,

I think this might help you to resolve your problem http://www.sqlskills.com/BLOGS/PAUL/category/CHECKDB-From-Every-Angle.aspx. And also I think there is a video on DBCC CHECKDB by paul.

Thanks

Chandra Mohan...

Hi,

SQL Service was unable to start due to invalid password for the account which you are using for running sql server. Give the correct password in the services.msc...

Hi,

Why you are using winrar or any other zipping software to zip the backup files. Its better to go with lite speed. I had seen...

Hi,

I recommend you to check out BOL so that you can get more info there.

Thanks

Chandra Mohan N

Can you tell me whether my post helped you ?

Hi,

select @@version shows the os level where you are checking for service pack. You can check the current service pack for sql server using the...

Hi,

It totally depends on you. I recommend you to go ahead and do the certification. Some employers recruit candidates who are ms certified only.

Thanks

Chandra Mohan N

Hi,

Try to use sp_droppublication and sp_dropmergepublication. You can find more info on them at bol.

Thanks

Chandra Mohan N

Hi,

In replication monitor right click on publisher server and click on publisher settings and increase the refresh rate from default of 5 seconds to 60...