The last time this question came up in the forums, that was the case as well.

You might check the database properties and see if someone changed the setting for...

According to this KB article, you'll have to run the DBCC command outside of the maintenance plan as a T-SQL job step.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q301292

It's a problem with all SQL 2K versions. It...

Brian Knight has written an article giving 10 steps on how to secure your SQL Server:

http://www.sqlservercentral.com/columnists/bknight/10securingyoursqlserver.asp

Another good resource is Chip Andrews' SQLSecurity.com site. Here's the link to the checklist he...

Can your system ping the server? Did any sort of network activity happen since the last time you connected? What OS is both the client and the Server running?

K. Brian...

Microsoft is very clear that you have to buy a license per processor in the server.

http://www.microsoft.com/sql/howtobuy/production.asp

Relevant quote:

quote:

---

Processor license. Requires a single...

If it's only a handful of addresses which should be used a lot, you always have the option of adding a Personal Address Book (PAB) or Outlook Contacts and telling...

Here are some KB articles that are probably relevant:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q218172

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q305711

The first speaks directly to the issue you are having. The second gives another possible reason for the error you are seeing....

Keep in mind if you are simply talking between the two servers (and not needing to use the linked server connection from another client), the double-hop issue won't occur. In...

If you have an idea of what time period you usually get hammered, you could always create a trace of what's going on. You can schedule a trace to begin...

I think the idea of multiple files and filegroups is typically not employed in conjunction with RAID for the test.

In a production environment, if you're using RAID 0, RAID 1+0,...

Sounds like a double-hop issue and there's no work around if you want to use NT authentication all the way through. Double-hop is prohibited in NTLM (the security mechanism for...

You'll want to be careful of the results brought back by sp_depends. The system stored procedure sp_depends queries the sysdepends system tables to find dependencies. However, there are cases where...

Take a look at the sp_changeobjectowner stored procedure.

You can easily write a query that retrieves a list of objects owned by the user (sysobjects table is perfect for this)...

Make sure the account has "Log On as a Service" rights (local security policy) on the local box as well. That's the first place to look. However, if the login...

We have a dedicated file server for all full, differential, and tran log backups for the DBA group to use. Had something to do with me being a DBA pushing...