Ahh. it's nice to see normalisation being mentioned.

What about SAP or Postgresql on Linux as alternatives ?

what kind of access do you have to the database ?

looks like your permissions are set to read only.

it might be an idea to have a chat with your DBA

if your identity cols are all primary keys you could use

select CONSTRAINT_CATALOG AS [Database], TABLE_NAME

from INFORMATION_SCHEMA.TABLE_CONSTRAINTS

where CONSTRAINT_TYPE = 'PRIMARY KEY'

which will return the database name and table name

not ideal but...

I think you can also set up a maintenace job to shrink the db - or set up a job to do both and run it every day/week to suit...

Fantastic !

An addition would be the "Smoke Blowers" article can be found at http://www.angrycoder.com/article.aspx?cid=1&y=2003&m=4&d=2

spot on

glad to be of help

had another think about this and i would suggest rethinking your solution.

getting the top 500 rows in the database will mean that the 4 apps getting them are going to...

Have a look at

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_set-set_74bw.asp

Choose an isolation level such as read uncommitted and that should allow the second query to read the updated flag whilst the first transaction is still waiting...

i don't know of any other way ....

I would allways go down the transaction route but this would depend on the level of expertise in your situation.

If you explain in more detail what your application does and...

are your inserts and updates wrapped in transaction blocks with a suitable isolation level ?

where is the free downloads section ?

i've just had a look for it and can't find it ...

I have some code written in C# that dumps all users, table defs, and permissions to local files on disk.

The code installs as a service and would only need a...

I have some C# code that dumps table defs and permissions using DMO.

If you want it let me know.

Steve

Your server must be set to run in a mode that supports versioning if you are using statement level versioning. The flag is /T3970 in beta 1.

Each database needs to...