S Hodkinson (7/10/2008)

---

Matt and I are obviously in the same area as I hurtle round the M60 and exit just before the M62 for the very reason Matt gives. ...

Karma, i know how you feel.

To be honest, i have decided to look at other possible roles...even as far as going back to my first place of work to do...

Rupendra,

Seeing as your original post was over two days ago, i am intrigued as to whether CHECKDB has finished now?

Matt.

I feel for you guys. I couldnt sit on a train/tube for an hour with no air conditioning!! Especially stood up with people barging into you all the time.

Matt.

Nope, that should be fine - although you wont be able to connect to an SQL 2005 instances with the Query Analyzer or Enterprise Manager.

Matt.

Are both server's similiar spec?

Have they got any other software running on them like SQL, AD or anything?

Matt

Can you post the Insert statement please?

Thanks,

Matt.

Is it possible you could post the insert statement and the table structure also (probably best if you just generate a CREATE TABLE script for the table in question.

Thanks,

Matt.

You're related to Steve arent you 😛

I would recommend the following book for starting on the MCTS SQL Server 2005 Developer Track:

http://www.amazon.com/MCTS-Self-Paced-Training-70-431-Pro-Certification/dp/073562271X

Thanks, Matt.

Oh, and VMWare is out of the question as its so damn expensive! We want to use MS products as we are MS Partners 🙁

Matt.

Steve, thanks for your input.

Im thinking we may just have to go down the route of having one instance per customer so they would connect to it via username.ourdomain.com.

Citrix is...

If you have a column that has the date the record was inserted stored in it, then i would create a SQL Job to run every night and execute the...

Try this..

DECLARE @resourceId int

SET @resourceId = (SELECT MAX(resourceId) AS resourceID from Resources)+1

INSERT INTO #tempResources (resourceId, FileName, projectid)

SELECT @resourceId, FileName, projectid from #tempOld

WHERE projectid = 20

Have a look in books online for information about sp_configure.

Matt.