Viewing 15 posts - 37,906 through 37,920 (of 39,757 total)
hopefully you have some other pk that you can use. Match up on the dup field and pick the min or max of hte pk.
If you do not have this,...
April 9, 2002 at 4:04 pm
April 9, 2002 at 1:06 pm
April 9, 2002 at 1:06 pm
April 9, 2002 at 10:48 am
Use a text datatype or multiple tables/rows. Not sure how this will work with a bulk copy out, have to test it.
Steve Jones
April 9, 2002 at 10:38 am
Might be slow to rollback, but I agree with Antares, a reboot might be necessary.
Are there any blocks showing? Can you trace back the blocks and kill the root process?
Steve...
April 9, 2002 at 10:25 am
When you connect, your auth information is returned by user_name() and suser_name(). These are the db user and system user respectively. You can check for these in the trigger.
Steve Jones
April 9, 2002 at 10:21 am
they attach through a backup named pipes and yes they paid for the api call to MS. It basically uses the same method that MS uses, though for some reason...
April 8, 2002 at 4:30 pm
Don't think this is available. You can check the logs, but that isn't an easy task.
Steve Jones
April 8, 2002 at 3:28 pm
April 8, 2002 at 3:25 pm
Not sure of the problem. Can you post the table and trigger code. Also, the original table and alter code?
Steve Jones
April 8, 2002 at 11:47 am
There are issues in how the virtual log files are created for the logs. Search the scripts area for a shrink procedure that should help there. Not sure about the...
April 8, 2002 at 10:17 am
I don't think you can do this with T-SQL easily. Of course, you could probably whip up an ADO/ASP tool in about 15 minutes.
The biggest issue is backup and restore,...
April 8, 2002 at 10:10 am
Does the user exist? Are these two differnt domains? Pls provide some more information about how you are doing this.
Steve Jones
April 8, 2002 at 9:58 am
You need to setup SQL Mail and use xp_sendmail.
Some resources:http://www.sqlservercentral.com/columnists/sjones/sqlmailresources.asp
Steve Jones
April 8, 2002 at 9:52 am
Viewing 15 posts - 37,906 through 37,920 (of 39,757 total)