http://www.connectionstrings.com

It might also be that the connectivity drivers are not installed on your machine.

Next time please start a new thread. You're likelier to get more help faster...

SQLRNNR (8/24/2011)

---

Ninja's_RGR'us (8/24/2011)

---

Ninja's_RGR'us (8/23/2011)

---

The one that really bug me (and yes it happens far too often) is someone who ask a question.

And then 15 minutes later will reping on the...

SQLRNNR (8/24/2011)

---

I know of a few consultants looking...

Ninja's_RGR'us (8/23/2011)

---

The one that really bug me (and yes it happens far too often) is someone who ask a question.

And then 15 minutes later will reping on the same thread,...

If we knew we'd have told you by now.

What problem is this causing you that this can't wait a couple hours?

dstyles (8/24/2011)

---

The thing is that I have both installed on here. Can just detatch it from the SQL Express and then log onto the full verion and connect it...

Tell them about the risk. This is something real easy to do with vms.

If ANYTHING goes wrong, and it DOES. Then you're screwed with in place upgrade.

What's worst?...

Michael Valentine Jones (8/23/2011)

---

Ninja's_RGR'us (8/22/2011)

---

Michael Valentine Jones (8/22/2011)

---

According to this link, all of the following upgrades are supported for both x86 and x64:

http://msdn.microsoft.com/en-us/library/ms143393(v=SQL.100).aspx

From:

SQL Server 2008 Enterprise Evaluation

To:

SQL Server 2008...

This is why doing side by side install is often the best choice.

Make a new server, backup / restore and test the new system through and through.

Once you're done restore...

I've rarely if ever saw the need to get an actual count like that.

What do you need it for later in the code?

Any reason why you can't do if exists...

The one that really bug me (and yes it happens far too often) is someone who ask a question.

And then 15 minutes later will reping on the same thread, and...

Any reason you can't use COUNT(*)?

This will always use the smallest index to return the result (least reads, hence the fastest).

Can't say it's the best option here since I don't...

Good point Grant, maybe you need a 3rd person to sit in 🙂

That would work once the columns' name are corrected.

DELETE X FROM TABLEX X INNER JOIN DATABASEZ.DBO.TABLE1 T2 ON X.TBXRefNo = T2.DBZRefNo

WHERE (T2.DBZRefName = 'XYZ')