Viewing 15 posts - 37,651 through 37,665 (of 39,506 total)
You can use SQL logins and everyone will have to log into SQL.
If you want integrated logins, then the Novell server will have to synch with the NT domain, or...
April 10, 2002 at 11:46 am
I'm not sure if this is the same error, but I used to get these on appends periodically. I deleted the file and it recreated it and it worked the...
April 10, 2002 at 11:26 am
I believe the total is 256 per select. So I thnk this is the max you can use.
Steve Jones
April 9, 2002 at 4:16 pm
Shouldn't, but that is interesting. I believe that sp_sqlagent_refresh_job is just getting the latest status of a job. At least that's what it looks like.
I have some jobs which have...
April 9, 2002 at 4:08 pm
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
Viewing 15 posts - 37,651 through 37,665 (of 39,506 total)