Viewing 15 posts - 4,066 through 4,080 (of 6,105 total)
Find out from your system or mail administrators the name (or IP address) of your SMTP server.
If you're going to use SQLMail, read through this Knowledge Base article, as...
August 24, 2003 at 8:37 am
The patch for security bulletin MS03-033 supercedes this patch. So if you've not applied either and you know you're going to apply MS03-033, you just need to apply the later...
August 24, 2003 at 8:14 am
Not IT related, but the biggest pet peeve I've dealt with lately: Parents yelling (not cheering, but criticizing) at their 4 and 5 year-olds playing a soccer game. It's bad...
August 19, 2003 at 2:05 pm
I would generally agree. Use of DENY should be a last resort.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
August 19, 2003 at 2:02 pm
quote:
Is it ok/safe to revoke public select access to all the system tables ?
This really...
August 19, 2003 at 8:56 am
You might want to take a look at some of the dynamic SQL articles by Robert Marda. He covers how to get more flexibility in your stored procedures without having...
August 18, 2003 at 8:46 pm
I'm in agreement with you, Andy. I don't much like service accounts and I hate application roles. Maybe hate isn't a strong enough rule... if you try to do things...
August 16, 2003 at 11:00 am
This is a known no-no because the SQL Server will attempt to startup in a pending state and eventually fail as you've seen. The cluster account must be a sysadmin....
August 15, 2003 at 2:32 pm
Skip the associate/acquaintance/friend thing. Just say, "This is <name>." Of course, if you can't remember the name that may be a problem.
And yeah, in the US, being in...
August 15, 2003 at 1:05 pm
This might be of some help:
http://www.microsoft.com/sql/howtobuy/faq.asp
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
August 15, 2003 at 12:59 pm
What's being reported in your sqlstp.log files on both nodes? They should be in %systemroot% (usually C:\WINNT or C:\WINDOWS).
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring...
August 15, 2003 at 12:53 pm
SQLearner2, it can't hurt to submit your resume anyhow. Don't know if Microsoft is checking back on this forum. Worst they can do is not give you a call and...
August 15, 2003 at 12:48 pm
In practice, yes, you are correct. Part of the frustration is the following when you set c2 (even to the same value it was previously):
August 15, 2003 at 12:43 pm
This is easily accomplished in one of two ways.
(1) Service accounts under which the components run (Windows authentication).
(2) Grant users the right to connect to the database using Windows...
August 15, 2003 at 12:25 pm
#2 is required. From BOL:
quote:
When using sp_configure, you must run either RECONFIGURE or RECONFIGURE WITH OVERRIDE after setting a configuration option.
August 15, 2003 at 7:12 am
Viewing 15 posts - 4,066 through 4,080 (of 6,105 total)