Yes you can.  As long as you know the column names, and don't use IMAGE types.

create table #foo (

Type Varchar(50),

Qty  Int,

Notes Varchar(50))

Insert #foo

select 'apple', 3, 'Fruit'

union

select 'kangaroo', 4, 'Animal'

union

select 1,2,'penguin'

declare...

Hi Jimmy,

I'm sorry that it has taken so long to reply.  I got a little busy...  Unfortunately, I don't know the answer to your question.  It was so long ago...

http://openvpn.net/ is an open source VPN solution that includes compression.  It might do what you want.

hth jg

Hi Jimmy,

You might need to do this: http://support.microsoft.com/kb/817064/

Windows 2003 changes the default settings for DTC

hth jg

Yes, that is the default setting in the ODBC driver.  SQL probably overrides that with the default transaction isolation level of READ COMITTED.

Even the lowest isolation level is READ UNCOMMITTED...

John,

If the optimizer thinks that it is going to return a significant portion of a table, it may (correctly) decide that it would be faster to scan the table than...

Hello,

You might try setting the commit mode to "Commit Immediate(*NONE)" in the ODBC configuration.  The setting is on the "server" tab, "advanced" button of the ODBC settings.

jg

You may certainly set up a 3 node cluster, provided that you get the right OS and SQL versions.

You could use Active/Active/Passive so that the Passive node is a standby...

I've had that sort of thing happen when I call an application from SQL server, and then terminate the application "forcibly".  The SPID will not finish rollback because the nonexistent...

 I'll quote an expert:

I would go on the server and run the Surface Area Configuration tool toensure all the items listed there are set up correctly.--Andrew J. Kelly ...

Test?  We're supposed to test the stored procedures?

You could try connecting to 127.0.0.1 from one of the cluster nodes using the cluster administrator. That works for me, although my cluster group is up.

What is interesting is that the cluster...

Have a look at this KB article.  You might be able to change the persistent state and restart the cluster service.

http://support.microsoft.com/kb/259243/en-us

Can you check to see if the cluster service is running on the physical nodes of the cluster?  If it's not, try starting it.

The [model] database is the "template" for creating new databases.  If you make changes to model, then new databases will include the changes when they are created.

Although I agree that...