Viewing 15 posts - 37,666 through 37,680 (of 39,506 total)
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
If you haven't read this, it's interesting:
http://www.softwaremarketsolution.com/
from the maintainer of http://www.joelonsoftware.com
Steve Jones
April 4, 2002 at 8:41 pm
Is that true? I thought all comms were across that port. Need to check this out.
Steve Jones
April 4, 2002 at 8:33 pm
There is a white paper on performance tuning here:
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
I think there will be a variety of factors. It seems that the write size of Windows will have something to do...
April 4, 2002 at 6:14 pm
Viewing 15 posts - 37,666 through 37,680 (of 39,506 total)