Always remember the clue is usually in the error message.

Translated to English

e can issue a certificate which will match the requirements of SQL SERVER 2012

The certificate must be in the local computer certificate store or the current user.

Current system...

got enough free disk space

got enough free ram

server might be under extreme memory

I would recommend reading chapter 4 of the Accidental DBA Guide on Memory Usage

Why not just drop the database after you have backed it up?

Set Max memory at 26GB or there abouts, leaves enough for the OS to manage itself OK.

If its dedicated I wouldnt worry about min memory so much as only SQL...

Server 2003 32bit Enterprise RAM limit = 32GB

Min Max memory should be set to something reasonable, is this a dedicated server just for SQL or will other apps be running...

Do you have to export to excel? Can you not export to another format, CSV, txt etc?

If it has to be xlsx then you will need to export 1...

Adi Cohn-120898 (12/19/2012)

---

anthony.green (12/19/2012)

---

@@RowCount only looks at the last statement which in this case would be the DECLARE which will always return 0 rows

Use COUNT(*) from the INSERTED table instead.

But...

And which update statement within the trigger?

@@RowCount only looks at the last statement which in this case would be the DECLARE which will always return 0 rows

Use COUNT(*) from the INSERTED table instead.

But if the trigger...

You want to modify the output to one which doesnt happen when you convert a date so you have to manually tell it the format which is why you need...

SELECT '(Expires '+RTRIM(DATENAME(MM, GETDATE()) +','+ RIGHT(CONVERT(VARCHAR(12), GETDATE() ,107),9))+ ')'

Gives

(Expires December, 19, 2012)

Welcome to SCC

Can you please follow the links in my signature to posting, code and data for the best help and also the how to post performance problems so that...

don't remove the whole thing, just remove the spaces.

the string of characters is special and they are removed from posts hence why I need to put spaces in so that...

I was always told to not trust the sys view as it can differ from what was in the table, that was back in SQL 2000 days so unsure if...