sysmail_event_log says Mail Id 1####has been deleted from sysmail_mailitems table. This mail will not be sent.

There are about 3Billion records in the table.

How do i clear this table?

No records in...

Error

---2146827284 - Microsoft Excel cannot access the file 'C:\temp\Book2.xls'. There are several possible reasons: • The file name or path does not exist. --• The file is being used...

Thanks for the reply.  How about the views, how we can audit that info?

i checked the slowness is coming from auditLog table. Its a big table as it stores audit records.

Any idea on how to do that?

Ok Thanks. Actually i am on SQL Server 2005. i was not able to locate 2005 forum.

allocation should exclude weekends and hoildays.

If Jan Budget is $200 and working days in Jan is 20 , So daily budget for each working day should be $10 and for...

Thanks a lot

Perfect.

Trying to create a folder on the network. But even my command says xp_cmdshell 'dir c:\', it errors out with insert fail.

I would like to have it at database level. Depending on what database is getting accessed, I would like to set parameters.

Let me give some background.
We use...

Thanks for the reply. The problem is the output of the stored procedure is a dataset and it could have multiple demand. If there a one demand for a supplyid...

I don't know the DB detail. The Stored procedure gives the list of demand for the supplied SupplierID. We just keep looping thru until we don't find Demand for the...

Here is the Example
Customer Order Line :
ORD00001 - 1
                                         --JOB- JOB0001
                                              ----JOB-JOB0002
                                                  ------JOB-JOB0003
                                                       --------JOB-JOB0004
                                                             ----------MATERIAL-Matl01

ORD09999 - 1
                                         --JOB-...

yes