Hi,

You may also use sp_cycle_errorlog to close the current log and begin a new one.

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

Cheers,

John

Hi,

You could make use of the Incremental Population method, for defining a Full Text Index. This way, you could schedule a daily job to update to your index to take...

Hi Everyone,

Just to confuse the issue, given that you are working with historical (and therefore I assume relatively static) data, it sounds like you may have a good case for...

Hi,

Sometimes tweaking your IIS settings can help.

Within the Application Pool folder, locate your Report Server and right click > properties. Here you can configure settings for the number of worker...

Hi,

Review and or post your execution plan as this will determine if a table scan is indeed being performed.

Looks like a good case for Full Text Indexing either way, as...

May I ask why you are combining the data into a single string?

I would have thought it would be more beneficial to keep each data item separate to negate the...

You are most welcome.

Hi JWOL,

This can certainly be done as I have implemented such a configuration on a clustered environments.

As I am sure you know, you cannot use the standard connection prompt in...

Hi,

You will need to unpublish the databases that are involved in replication.

The following link should be of use to you.

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

Let me know if I can of any further assistance.

Cheers,

John

Hi

Detaching a database requires exclusive access to the database. If the database that you want to detach is in use, before you can detach it, set the database to SINGLE_USER...