Is this what you're...

Could you post the VB code where you try to connect please?

Re Reporting services. You can create reports with parameters. Users can then enter values they like. Is very much...

And also you can only put a single index on a table var - the primary key. Not great if you would like an index on a non-unique column.

Rule of...

TablockX isn't an an isolation level. It's a lock hint.

You should be able to just do the delete then the insert within the transaction. In the default isolation level, exclusive...

Double post.

Direct replies to the following thread please - CPUs on a machine

Indeed there is.

exec xp_msver 'ProcessorCount' -- There are a lot of other options on msver. Well worth a look.

It depends whether the apps are connecting using the sa account, or if they have their own accounts.

In your favourite querying tool

select * from sysprocesses where spid>50 --(the where is...

I did some thinking on this whole discussion on the drive home.

Karthikeyan, no disrespect intended, but from what I've seen, you're probably better, at least for now, not worrying about...

If you're using 2000, it's best to post in the SQL 2000 forums. In the 2005...

Could you post the exact...

The in-memory page structure (where rows are stored) is the same as the on-disk structure. That's why I pointed you at the storage engin posts.

Paul goes into a lot...

Can't see anything obviously wrong. Do you get the same if you run the two queries seperatly?

In your convert, replace the round bracket around Time with []. Might be related,...

I can't think offhand of a better way. Can you post all the index definitions for the table please.

You may want to consider making the index on PupilID unique. That...

Put a large box under your chair. 😉 :hehe: :hehe:

The same way they get stored on disk.