This help?

http://www.sqlservercentral.com/scripts/SQL+2000/Permissions/

This is almost always hardware. Freezing like this could be bad hardware, strange drivers, anything like that.

If you have rights in the database, you should be able to browse the objects.

You don't necessarily get these rights all the time. Someone could have removed rights to all...

Use dateadd and datepart.

Looks like a compilation error, not one connecting to SQL. What platforms are you using?

Are you trying to get users to run it from another DB?

Gail has a great solution to limit vulnerabilities.

Moved to a better forum.

A PK is used to uniquely identify a row. If you need 2 (or more) fields to do this, you have a composite or compound key....

They should always have been important, but I think their relative value diminished relative to skills and certifications for awhile.

I'd argue it's ignorance on the part of managers.

They're looking at time = productivity, and then they're the same ones that complain that people don't get enough done when they're...

I hear you, but how do you balance that with work calling you at home?

I think we have to get past the "hours worked" in IT at least, and perhaps...

Authors get copies, I'll send out copies to those, uh, slackers that don't make PASS when I get back. 😀

They're all here, have to ship them back to Denver. Cutoff...

Anonymous post:

I am a Sr DBA and data architect. The number of hours I actually work depend on my position/contract and the day. Sometimes it'a even less than an hour,...

Anonymous response:

Steve,

I've been subscribed to your newsletter for about 6 months now and enjoy it quite a bit. I am the Systems Architect for a medium sized online and...

Anonymous post:

On a slow day I work 8 hours. I usually feel like I get very little accomplished in those 8 hours and those hours will have to include...