Viewing 15 posts - 106 through 120 (of 188 total)
Please look at the example below. It will help you read the trace.
declare @P1 int
set @P1=1
exec sp_prepare
@P1...
November 27, 2006 at 3:06 pm
i wonder if there is a way to read the transaction log and filter needed dml out of it?
October 17, 2006 at 9:50 am
unfortunately tirgger is not an option. I am surprised that in SQL Server there is no way for me to capture DML executed against a specific object.
October 17, 2006 at 7:10 am
is there any way to search for text/ value within xml field?
October 11, 2006 at 1:40 pm
Infact I am looking for a value residing in some column of some table .
October 10, 2006 at 6:58 am
thanks for you replies.
I am looking at the options that I have to create DSN. however I dont see anything in there for mySQL. which driver do you think I...
October 6, 2006 at 8:18 am
and another piece of info... user 'moon' which already exists on Server B is mapped to another database. so I cannot remove it.
September 29, 2006 at 1:56 pm
Its a wonderful solution however has some shortcomings, acknowledged by author himself:
July 27, 2006 at 2:19 pm
Well the more I understand how transaction log backup and regular backup interact while kicked off at the same time as well as prividing comprehensive coverage in case your original...
July 25, 2006 at 11:02 am
Well perhaps I wasnt clear enough. Lets see if the following clears up what I am doing or want to do.
When I do a full database backup to a e.g.....
July 24, 2006 at 9:19 am
RESTORE HEADERONLY
Statement that retrieves all the backup header information for all backup sets on a particular backup device.
July 24, 2006 at 9:15 am
well if I am writing to a backup device, how will identify the transaction logs to be copied to a remote location?
July 24, 2006 at 8:18 am
July 20, 2006 at 8:13 am
seems like for me to be able to get SQL Server alerts I would need a MAPI client. I dont think this can be done using SMTP.. or can it...
July 17, 2006 at 9:26 am
whats the difference between using SMTP or a MAPI compliant email client?
July 17, 2006 at 9:14 am
Viewing 15 posts - 106 through 120 (of 188 total)