This will work and can be a good way to minimise downtime at cutover.

I would ask why you are going for SQL2017 rather than SQL2019 or SQL2022. In your position...

• This reply was modified 2 years, 5 months ago by EdVassie.
• This reply was modified 2 years, 5 months ago by EdVassie.

One problem you will have to deal with is authentication.  My old place wanted to do something similar and authentication was the biggest problem.

Microsoft allow a greater range of identity...

Likewise,

You can lead a user to data but you can't make them think.

Maybe you should ask them to name a sport where the winning team from 20 years ago could still be a winning team today using the same players.

Their formerly winning...

• This reply was modified 2 years, 6 months ago by EdVassie.

I would not do this. If pushed very very hard by my management to do this I would resign.

The risks of having an unrecoverable system are very high. I remember...

I was hoping you would answer the questions I gave regarding host and client OS. It means I have to guess things with this response.

SQL2005 can be installed on W2000...

• This reply was modified 2 years, 6 months ago by EdVassie.

I am assuming you are trying to connect to the SQL cluster via the virtual base only. You do not use any instance name when connecting to a SQL cluster.

If...

I am not sure this is a SQL2005 problem, or that it is any type of a problem.  When you connect to a clustered instance surely you should connect via...

The only constant is change.  Domain knowledge covers the gap between the perfection of everything being exchangeable (fungible) for the ideal widget for today, and the reality of keeping an...

The first time I presented at a conference, the speaking in front of an audience was not a problem.

I think a large part of that was in the years before...

The application team are saying the database is the problem. Do they have any evidence to prove this.

A well written API will have debug facilities that can produce a trace...

I have had to do similar things, such as changing the clustered index column or 'correcting' varchar(max) to varchar(pick-a-number). Sad to say my bedroom wall is covered in scribblings, I...

I do not understand why you are keen on separating natural and surrogate keys.

In my experience any rules that require thought and skills to implement very rarely survive the tenure...

Grant is totally right.

I will add my voice to using snapshot isolation level, it fixed a shed load of blocking problems in my old place, particularly those from third-party applications....

A man named Paul once wrote "All things are possible but not all things are desirable".

An upgrade in place should work, but scores about 9.9 out of 10 on a...