sure hope we can help, it's honestly very satisfying to help someone eliminate a cursor when possible.

ok, you've got a cursor, and it's doing something...SELECTING and matching with your WHERE...

not directly like that, no.

If you have a stored procedure that returns data, you can insert it into a temp table, and have the cursor go through THAT.

no, adding a...

i create a a view for every trace i create; it's just much easier to access.

from there, i can group the data however i need to, since it's just an...

my first guess looks pretty good;

just using row number, and joining the data against itself:

WITH MySampleData

AS

(

SELECT row_number() OVER(partition by date order by date,time,seqno) AS RW,

*

from #tmp...

niladri.primalink (5/7/2013)

---

Hi SSC,

thanks for your reply. I need to check how many times my query has been modified and from which IP as the users are using the same user...

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...