The RAQ Report guys are getting on my nerves. I'm tempted to make an announcement that I would not recommend doing business with them as they are disruptive and not...

Sent George a note. We'll sort him out.

Bru is correct. You cannot share the data files for load balancing. There is a shared READ system using a SAN for Enterprise edition, but it will not work for...

Views and stored procedures are used for two different things. A view encapsulates a single query and presents it as a table. A stored procedure is a code block.

What I'd...

Are you returning results to users or are they doing some processing?

If not results, why not a batch file? Or very simple VB Script that gets parameters?

If they need results,...

I'm mostly with Elliot here. I've heard the issues with GUIDs and they can be a problem. The upside is that the client can generate them, which can reduce contention....

Are you calling the 2nd script from the same program? We used to add the SPID to a table, and then each call from a program could insert rows and...

I think you'll need to install a v6.5 server, attach those files, and then upgrade. If I remember right, you need to create a database in 6.5 using the correct...

It does depend, but you could take a reasonable server, say an x86 or x64 with 4GB of RAM, 2 cores, and try some common things. Maybe querying some order/order...

An interesting debate. From the overall tone, I think that lots of people use C# for personal reasons, or because they find work with it, not because it's better than...

That's roughly what happens. I think it's transactions that affect pages written to the backup, meaning changed while the backup is in process.

The error shows you are connecting with named pipes. You might have something changed in your SSMS connection dialog. Double check all settings that you are using TCPIP.

Also, the name...

HOW are you connecting? SQL Auth, Windows Auth, what are you typing in SSMS? That is some of the information we need to help you solve this.

The windows machine you...

Jeff Moden (11/12/2009)

---

Heh... I have an odd personal preference... I don't like languages that require semi-colons or line continuation characters. It seems that they should all be smarter than...

finally done getting kids off and feeding the beasts around here. Lucky there's no wind. I'll check the poll now and see what I think of the temperature. I'd like...