dbmail is the new native sql server mail system (smtp based) for SQL 2005. The xp_sendmail extended stored procedure is an extension developed because the native SQLMail system on SQL...

is there any reason why you can't use database mail which comes with SQL 05? It has full 64 bit support.

I coded around the limitation by breaking the select into two statements, basically doing a select distinct id into a temp table and then doing another select based on the...

there are some tools to do this such as Apex SQLDOC or you can use the built in meta data functions.

dbcc shrinkfile

how is the application connecting to the SQL Server? Maybe your connection string needs modified.

take a look at this tool provided for free by MS.

SQL Server Health and History Tool (SQLH2)

just google it and you will find lots of info about SQLH2

are all of the fill factors the same? If so just set the default to that value.

this is the code for fn_trace_gettable:

create function system_function_schema.fn_trace_gettable

(@filename nvarchar(256),

@numfiles int = -1)

returns table as

return select * from OpenRowset(TrcTable, @filename, @numfiles)

No mention of Tempdb anywhere, The OpenRowSet function must...