As I say, this is a MS SQL forum, not a MySQL forum, I do not know MySQL.

The example I gave was for MS SQL, you will need to find...

Ok, so your in simple, thats ok just would dictate the way to go when purging.

So the options are

1 - Add more disk space

2 - Purge data and perform...

Hi

This is a Microsoft SQL server forum, not a MySQL forum.

While a number of people here may have MySQL experience, you may be best posting this on a dedicated MySQL...

Use msdb.dbo.sysmail_delete_log_sp and msdb.dbo.sysmail_delete_mailitems_sp to delete from the two tables.

Add more space - if possible

Purge data - to release space from inside the data files, will need to be done in small chunks due to it needing to log...

There is remote query timeout setting in SQL but that only takes affect if you are quering a remote server using something like linked servers, there is nothing in SQL...

As far as I know, connection pooling is done in the app as its an application thing, not a SQL thing.

As for the time out, that is set at the...

Do not cross post, it fragments replies.

All replies here please http://www.sqlservercentral.com/Forums/Topic1406204-150-1.aspx

Have you debugged the query using the parameters that dont work in the report directly against the databases to see what the performance of the query with them paramateres is?

fatinnadiah88 (1/13/2013)

---

Anyone have any idea why I receive this error on SQL job?

Step ID1

ServerSRIN_SVRA

Job Name1 Year Backup Maintain BDSBPM.Subplan_1

Step NameSubplan_1

Duration00:00:34

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

Executed as user:...

Have you debugged to code to ensure that all connection object are being closed, dissposed and set to nothing. 12000 SPIDs for 15-20 active at anyone time seems a...

APA0876 (1/11/2013)

---

anthony.green (1/11/2013)

---

I would completly re-write it all, for one all the tables used are depreciated and are in the product for SQL 2000 compatability only, you really should be...

I would strongly recomment reading through the stairways section on SSIS.

But every task is control flow.

Only task that is data flow enabled is a DFT.

I would strongly recommend trying to...

ALTER DATABASE XXX SET NEW_BROKER WITH ROLLBACK IMMEDIATE

First stop everything that uses service broker in MSDB, like DBMail or anything you have created manually.

For the time being you could setup replication yourself (for real time reporting) or enable CDC (change data capture) and then you can transfer out the changed data nightly to...