Viewing 15 posts - 37,606 through 37,620 (of 39,456 total)
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
April 6, 2002 at 5:12 pm
Viewing 15 posts - 37,606 through 37,620 (of 39,456 total)