Viewing 15 posts - 37,876 through 37,890 (of 39,720 total)
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
Some good threads on this:
Another one somewhere.
Also you have to backup the image db, which is a load. Takes backup and restore time. If you want to do this, I'd...
April 5, 2002 at 1:37 pm
Good suggestions. If you have the app, I'd also do the following:
Run profiler and track the longest running queries that take more than some value (1sec, 10 sec. whatever) to...
April 5, 2002 at 1:23 pm
I'd use a queueing method, not a trigger to do this. Setup your trigger to insert a value in a table that you need. Then setup a DTS package or...
April 5, 2002 at 12:13 pm
What do you mean you "restrictied access"? Can you post the GRANT, ReVOKE or DENY statements?
When you access from another db, what user is being used?
Security is user and...
April 5, 2002 at 11:35 am
April 5, 2002 at 11:12 am
April 4, 2002 at 8:49 pm
Viewing 15 posts - 37,876 through 37,890 (of 39,720 total)