The issue with cross-database access also applies to cross-database ownership chaining with respect to valid users. If a login doesn't have a valid user in a second database (and guest...

By default, BUILTIN\Administrators are sysadmins so far as SQL Server or MSDE is concerned. That means if you connect to the MSDE with an account that's an administrator on the...

Just to verify (the braindead because I've worked too many hours check)...

Your max characters per column (Tools | Options | Results tab) is set > 267, right?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start...

Looking at sysprocesses, does one or more SPIDs seem to be hogging most of the resources?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Yes. You want to use the DOMAIN\UserName structure. The AD form (user principal name) of UserName@Domain is not currently supported in SQL Server 2000.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide...

One other trick I've seen sometimes work is to bring up the Client Network Utility (cliconfg.exe) and manually define the alias using Named Pipes. I've not had to resort to...

No C2 Auditing is through SQL Server. This is different than the Application Event Log. You can alter the Application Event Log size (and Overwrite behavior) by using one of...

We'll likely push MS03-033 first. We've seen upgrading MDAC versions can sometimes break apps... especially some of our homegrown ones (don't ask). In either case, the order of the day...

We go a step further because we've had cases where the MSSQLSERVER service (and the MSSQL$<Instance Name> services) have been up when you check the service but for whatever reason...

quote:

---

This is rediculous. Why do I have to be absolutely dependant on an e-mail server's 24/7 availiability in order to get email...

What is contained in the sqlstp.log file (found in %SYSTEMROOT%, usually C:\WINNT)? Any indications of what the error is?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring...

What process is running near 100%? Is it SQL Server? You can check this using task manager or through Perfmon (Process counters).

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL...

Also, which event log is full? There are settings to bring down the system if the security log is full. These aren't usually turned on by default, but they can...

The SMTP service makes the box an SMTP server. However, this is probably not what you want. You probably just want to find out what the SMTP server is for...

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...