Does it mean that isdate('1752/01/01 00:00:00') return false while isdate('1753/01/01 00:00:00') return true? (yyyy/mm/dd hh:mm:ss)

thank you

Thanks a lot

CirquedeSQLeil (12/15/2009)

---

Anything that is Serverview is not a MS SQL product. They are 3rd party apps being installed into SQL server. As for the service names with Serverview...

BTW, are these MSSQL$SQLSERVERVIEW and SQLAGENT$SQLSERVERVIEW services belongs to SQL Server 2005 Enterprise Edition products, or other 3rd party application products? Thanks a lot.

Thanks and regards,

Wallace

BTW, I grep the error log whenever fail to start SQLAGENT$SQLSERVERVIEW service when reboot server:

Agent Log:

2009-12-15 13:00:07 - ! [241] Startup error: Unable to initialize error reporting system (reason: The...

CirquedeSQLeil (12/14/2009)

---

SQLAGENT$SQLSERVERVIEW is The SQL Agent Service that controls your SQL Jobs. Since your 3rd party app relies on some jobs to keep DB trimmed and cleaned out, you...

Chan Wai Yin (12/14/2009)

---

Chan Wai Yin (12/13/2009)

---

CirquedeSQLeil (12/13/2009)

---

The default will depend on your server configurations. If your model DB is set to full recovery - then you will get...

Chan Wai Yin (12/13/2009)

---

CirquedeSQLeil (12/13/2009)

---

The default will depend on your server configurations. If your model DB is set to full recovery - then you will get full recovery when...

CirquedeSQLeil (12/13/2009)

---

The default will depend on your server configurations. If your model DB is set to full recovery - then you will get full recovery when you install your...

CirquedeSQLeil (12/13/2009)

---

Chan Wai Yin (12/13/2009)

---

CirquedeSQLeil (12/12/2009)

---

What recovery model are you using?

If full, you should do a full db backup and then schedule transaction log backups.

Once the transaction log has been...

CirquedeSQLeil (12/12/2009)

---

What recovery model are you using?

If full, you should do a full db backup and then schedule transaction log backups.

Once the transaction log has been backed up, you will...

CirquedeSQLeil (12/11/2009)

---

Those steps are a heirarchical structure for getting to your database server. The database engine is the guts of your RDBMS. It does not grow - it...

CirquedeSQLeil (12/11/2009)

---

When you say "Desktop Engine File," what are you actually referring to? Do you mean the log file, are you referring to a witness server that is monitoring...

Thanks for your reply.

Actually this SQL server Desktop Engine file grow to 3 to 4 GB while our current data file only 100 to 200 MB. Is it bulky operation(i.e....