It comes and goes in waves. Plenty of new people being thrown into SQL Server every day, struggling to learn.

Most people aren't like those of you that answer questions. They're...

I doubt I'm more biased than anyone else that doesn't work for a vendor of a platform, or doesn't belive in Open Source.

I've made my living off SQL Server, but...

I've tried two things. One, give each developer their own schema on a central server and then "change object owner" when things move to the point where we want them...

Marios,

What are you trying to do? They usually perform separate actions, but if you are looking to just update another server, I might recommend looking at Service Broker.

Typically there's a utility with the hardware vendor that can check this, but it's an OS level task, not something you can see from SQL.

As mentioned, contact your Windows admin.

Not likely to hit Phoenix, but Vegas would work. Orlando, Dallas are other locations they've used.

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.