Have you tried save the result set into a temp table and send out to users with xp_sendmail? Of course you have configure your SQL Server mail.

quote:

---

My tempdb database is 28 GB

---

Did you rename both MDF and LDF files of...

Which SQL Server version and service pack are you running? Has any changes made recently such as service pack and MDAC? Can you identify which SQL statements are generating this...

Ok, "SQL2KDeskSP3.exe" is only be used for Microsoft standard MSDE version. For example, when install .NET Framework SDK, a customized MSDE is also be installed. A special SP3 for this...

Are you running standard MSDE or customized MSDE that comes from your verdor's application? What application is it?

Use fn_listextendedproperty to return extended property values of database objects.

SELECT *

FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', 'yourtablename', 'column', 'yourcolumnname')

Read this KB article to see how to resolve error 7391. http://support.microsoft.com/default.aspx?scid=kb;en-us;306212

You can start/stop MSDTC service from control panel --> services.

Edited by - Allen_Cui on 04/29/2003 07:35:36 AM

Bosco,

Try setup.exe /upgradesp sqlrun blanksapwd=1 /l*v c:\msde2000_sp3.log

Do you have primary key defined in your SQL Server table?

Edited by - Allen_Cui on 04/29/2003 07:25:02 AM

Be aware removing 'BUILTIN\Administrators' login from SQL Server might cause problems such as cluster SQL Server and full text service. See KBs below for issues and solutions.

http://support.microsoft.com/default.aspx?scid=kb;en-us;263712

http://support.microsoft.com/default.aspx?scid=kb;en-us;295034

http://support.microsoft.com/default.aspx?scid=kb;en-us;317746

Did you have difficult to extract SP2 to other directory? If you are, See KB as following.

http://support.microsoft.com/default.aspx?scid=kb;en-us;301913

Or explain more details about your problem.

1. Right Click on Data Transformation Services and select Import Data.

2. Select Data Source to Microsoft Access.

3. In File Name enter the full path to the Access database.

4. In username...

First to detach the database, rename the log file, re-attach the database back with 'sp_attach_single_file_db' and a new log file will be created. If everything goes well, delete the old...

Check Microsoft Training Site at http://www.microsoft.com/traincert/training/moc/sql2000.asp.

You may also consider to attend PASS conference on Nov in Seattle. http://www.sqlpass.org

Are you talking about ODBC trace log file? If you are, go to control panel, ODBC data source administrator to see whether ODBC trace is truned on. Stop the trace...