[dba-SQLServer] SQL 2005 Server Management Studio

John Colby jwcolby at ColbyConsulting.com
Sat Jan 28 10:09:13 CST 2006


Ohhhh... Thanks for that.  I'll try it and get back.

The strange part is I would expect it to be R/W directly in SMSE. 


John W. Colby
www.ColbyConsulting.com 


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Saturday, January 28, 2006 10:38 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] SQL 2005 Server Management Studio

john

pt will return ready only. 
try open ur sp and assigning it using command object. dont use set
rst=cnmd.execute.

use

rst.open cnmd

-----Original Message-----
From:	"dba-sqlserver-bounces at databaseadvisors.com"
<dba-sqlserver-bounces at databaseadvisors.com> on behalf of	"John Colby"
<jwcolby at colbyconsulting.com>
Sent:	28 January 2006 15:16
To:	"dba-sqlserver at databaseadvisors.com"
<dba-sqlserver at databaseadvisors.com>
Subject:	Re: [dba-SQLServer] SQL 2005 Server Management Studio

Build a SP in 2005 (express for me).  It is read-only, regardless of whether
I try and edit the data it inside of SMSE or in a pass-through out in
Access.

I am trying to bind a form to a SP recordset.


John W. Colby
www.ColbyConsulting.com 


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Robert L.
Stewart
Sent: Saturday, January 28, 2006 9:37 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] SQL 2005 Server Management Studio

I am already going that way and have been for over a year.  The problem is
that I essentially have wasted the last year because the difference between
VS 2003 and 2005 is so radical.  Now I am relearning.

John,

What is the SPs read-only problem?  Can you explain what you are trying to
do again?

Robert

At 12:00 PM 1/27/2006, you wrote:
>Date: Fri, 27 Jan 2006 12:19:34 -0500
>From: "Susan Harkins" <harkinsss at bellsouth.net>
>Subject: Re: [dba-SQLServer] SQL 2005 Server Management Studio
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <002a01c62365$e41183e0$aeb3d6d1 at SUSANONE>
>Content-Type: text/plain;       charset="us-ascii"
>
>
>To be honest, once I get over the learning curve I am leaning towards 
>abandoning the MDB as a BE.
>
>========John, if I stay in this market, I am seriously considering the 
>same thing.
>
>Susan H.


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list