Have you looked at the web server and it's language/character set configuration ? I assume this because of the .asp mentioned for you front end ? Have you also checked...

If you set up an additional database for developers to execute 'read only' queries on the same production server you may have issues other than locking. These might include overall...

It appears thet your SQL server is using all of the memory you have allocated to it normally. Usually once you reach the limit of the memory that you have...

Glad to help brighten your day !

They must have revised it in the last month or two is my guess. I still have the original download from the MS web site (it's about 4-5 years old !!!)....

Here's the link to download the system tables map that Colin references if you do not have the CD: http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

No DBA should be without it !

SET PROTECT_PRODUCTION_DATA_INTEGRITY_MODE ON

Developers running queries in production ??? That implies that they are 'developing'. A rather severe violation of protocols.

SET EXTREMIST_MODE ON

Solutions:

• Death by hanging
• Death by firing squad
• Death by lethal injection
• Death...

Now if you're a GUI DBA then you love SSMS, but I'm old school - command line all the way. I'm already swearing everytime I start up SSMS ... EM...

Colin --> no problemo

Jeff --> great analogy

Unfortunately in that version of SYbase there is not one. Also another thought comes to mind. You will also probably need to have 'ts-support' role as well.

My Sybase is a little rusty ... especially v11.9.2 ...

sp_configure 'allow updates',1

go

reconfigure with override

go

update master..sysdatabases set status = 512 where name = 'your database name'

go

sp_configure 'allow updates',0go

reconfigure with override

go

An interesting subject. My thoughts are this: I have always exceeded expectations in my career with every employer. The unfortunate fact of life is that they, the employers, seldom live...

Those aluminum block Vegas were ahead of their time. Heat was the enemy. An aftermarkey steel cylinder insert sleeve and new pistons made 'em run 4-ever. Unfortunately not many people...

Aside from looking at the table, index structrue and queries againset the database/tables, well that's a touhg one. However ...

Here's my 'short list' for tuning:

Round I

    DBCC UPDATEUSAGE

    UPDATE...

I dunno ... call me practical - a car is transportation.

call me cynical - in my opinion 'concepts' cars are like vapor-ware.