Thanks!

If it is the tempdb.mdf then restarting will reset the size to the original creation size which is likely a couple mb. However you will want to identify the...

Use sp_send_dbmail. There is the following parameter.

Per Bol:

@query = ] 'query'

Is a query to execute. The results of the query can be attached as a file, or included...

This is what the code looks like (top portion is just to generate your sample data). Hope it helps.

DECLARE @Tbl AS TABLE (

[Name] VARCHAR(10),

Question VARCHAR(10),

Answer VARCHAR(10)

)

INSERT INTO @Tbl

SELECT 'A',...

I would create a profiler job that captures events for that database and filter it for truncate commands. That should get you the informaiton you need.

There are also some microsfot reports and tools you can use to get some of this information.

http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

and the SQLH2

http://www.microsoft.com/downloads/details.aspx?familyid=EEDD10D6-75F7-4763-86DE-D2347B8B5F89&displaylang=en

I assume this code is part of a trigger? Are you sure there are records in the deleted virtual table?

Its not an Excel file, so you can't do excel specific formatting. You are essentially creating a csv file and calling it .xls which Excel automatically opens and applys...

Can you explain what you mean by the first 10? With out knowing your data or what you mean by the first 10 records I would limit the SELECT...

Interesting question. I am not sure of the best way to do this either but I will give it some more thought. But my initial thought is just...

This can easily be done with a CTE and RANK() function. Something like the following example:

DECLARE @Temp AS TABLE (

DayId INT,

Hits INT,

Title VARCHAR(20)

)

INSERT INTO @Temp

VALUES (4112, 20, 'Gone with...

Can you just do a simple where clause as follows or was there a reason for the EXISTS() use?

SELECT T_Customers.CustomerID, T_Customers.CustTypeID, T_Customers.Surname, T_Customers.Forename, T_Customers.TitleID, T_Customers.Ref1,

...

Don't use two sets...

update crt_student_test2

set crt_student_test2.class_id = cactus.cactus,

crt_student_test2.ClassID_Updt = 'Y'

where cactus.teacher = crt_student_test2.class_id

and crt_student_test2.school_year = 2008

...

It sounds like you are running the MSDE versus the full version of SQL if you don't have a graphical UI for the sp4 install. Is this correct? ...

Bitwise comparison to a binary representaiton. Looks like 0X40 is a log file.

http://msdn.microsoft.com/en-us/library/ms178009(SQL.90).aspx