you cannot find past events if they were not captured by some sort of auditing that YOU added...If You don't have a previous auditing setup like Adi Cohn mentioned,...

sp_send_dbmail runs in the msdb database...so either your query needs to explicitly state teh database name, or the @execute_query_database must be supplied.

example :

@query = 'select FName as first,

LName as...

here is a very basic MERGE exampel that might help, and of course you should read up on it in your books and in SQL Books Online:

MERGE INTO dbo.tableA AS...

Asita, the question itself seems a lot like homework; Also, to get intelligent answers, you really need to provide DDL and sample data, to avoid a lot of assumptions, and...

no need to stop the instance, i'd think.

you can force the database offline, and take it back with a couple of commands, i'd think:

ALTER DATABASE Test SET OFFLINE WITH ROLLBACK...

the clustered index, just because it is sorted,...

note you replied to a thread more than two years old.

nope not from SQL;

you can have the application do it,and pass the user to SQL in the CONTEXTINFO, but once connected via a SQL user, no domain info can be...

almost certainly permissions, because the call to disk is not going to use the account you are expecting it to.

when you access any resource OUTSIDE of SQL server, like network...

yeah you'll need to go thru the script and tweak it;

for example @ line 151 there's one section here that fails if you have longer database names than 20 characters:

CREATE...

the FROM property for bulk insert must be a static string...it cannot be created from appended variables.

BULK INSERT BULKACT FROM 'c:\Export_o.txt'

to do what you want, you need everything to be...

here's one solution using a scalar function. I don't wnat to hog the thread, so I'll leave it to others to post a nice ITVF function featuring cross apply, which...

Sorrry kev i might have bben too brief on the explanation.

The sheet nin the excel needs to have column names in the first row and data in the subsequent rows.

I...

i was thinking the same as opc.three;

it's a false cause-effect i bet;

i'm thinking that procedures started sucking-performance-wise because of stale statistics, and the clearing of the proc cache, which occurs...

the problem is this case statement in the query:

CASE f.maxsize

WHEN -1

THEN -1

WHEN 0

THEN...