You've looked in the Knowledge Base and I did a search there, too, and the only thing that came up was for Enterprise Manager, which doesn't describe the issue. ...

Our DBAs have local administrative rights to most boxes. Boxes that are within the control of the DBA team are configured in this manner. The rationale is pretty...

There's this, but it's through EM:

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

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Interesting. How are you handling a trend analysis that would go across the year end? Say looking at 6 months from Oct 2001 - Mar 2002?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Consider this:

(a) User has to realize that decryption tools are available for SQL Server.

(b) User has to know how to fire up and use Profiler

(c) User probably knows how to...

As far as where to save, Brian Knight addresses the issue in an article:

http://www.sqlservercentral.com/columnists/bknight/savingpackages.asp

Security and the like I know we've discussed in the forums. You might do a search...

mbova, here's the deal on security.

If we build stored procedures that contain only static SQL statements, we can take advantage of ownership chains. For instance, dbo owns the stored...

Each active instance requires a separate license. That's why you can get away with a single SQL Server license for an Active/Passive setup, but you need two licenses for...

I teach Children's Church at my local place of worship and I used to teach alcohol/drug prevention, but I have no teaching experience in the technology sector. I just...

The person you are talking about is Brian Knight. Brian's books are great and in talking with him through emails I've learned a lot, too. His articles on...

One other place you might want to look is at an article by Neil Boyle. It covers the topic of JOINs and might also be helpful:

http://www.sqlservercentral.com/columnists/nboyle/ansijoins.asp

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

Since it is a Proliant, you may want to head over to the support site:

http://activeanswers.compaq.com

There are is a performance analyzer tool that runs on a separate system and uses the...

Ok, let's step through this one join at a time. For table aliasing I tend to use the first letter of each word for the table, so you'll see the...

Something doesn't mesh. Your processor queue length is high. Your page faults/sec is high, but your processor utilization is at 1%? Usually when there is excessive paging,...

Since your new to triggers and it looks like you're dealing with a ticketing system, one thing to be aware of is that triggers in SQL Server 7 and the...