> I've tried the procedure with the login name prefixed and
> still the same thing ' cannot be found'.
Are you absolutely sure you're using the correct login as a prefix?
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
>You can restart the system a million times, and that will not help you if
>you are not using the correct login to run the procedure.
Ok, I settled for restarting the server 1262 timesbut still having the same
problem...
seriously.
I've tried the procedure with the login name prefixed and
> I've even restarted the server after creating this new
> procedure and still the system ( CF) can't find it. Even when
> I try to run it again under enterprise manager I get not
> found in system catalog? Funny that it says it cannot be
> found if its clearly displayed ms sql is hell.
Yo
I've even restarted the server after creating this new procedure and still the
system ( CF) can't find it. Even when I try to run it again under enterprise
manager I get not found in system catalog? Funny that it says it cannot be
found if its clearly displayed ms sql is hell.
~
Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 14 June 2005 11:11
To: CF-Talk
Subject: RE: MS SQL - Cannot Find Stored Procedure
> Elaborate please... I'll swear that MM used to recommend this as a
> best practice.. I need all the SQL Server performance I can get, If
> I'm do
al Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 11:11 am
To: CF-Talk
Subject: RE: MS SQL - Cannot Find Stored Procedure
Importance: Low
> Elaborate please... I'll swear that MM used to recommend this
> as a best practice.. I need all the SQL Serv
> Elaborate please... I'll swear that MM used to recommend this
> as a best practice.. I need all the SQL Server performance I
> can get, If I'm doing something wrong I'd like to correct it..
To the best of my knowledge, Macromedia has never recommended this. I can
see why you might want to do i
td. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 11:02 am
To: CF-Talk
Subject: RE: MS SQL - Cannot Find Stored Procedure
Importance: Low
> I've always seen it as a "best practice" I've seen no
> performance hits. I have to deal with FoxPro tables along
> with SQL Server, and this seems to work when the FoxPro guys
> make table changes.
That's about as far from a best practice as you can get, with MS SQL Server.
It's a terrible t
> I've also tried connecting directly to the database as the
> main user ( not SA )... and I get a permission denied error.
>
> Server Msg: 262, State: 42000, [Microsoft][ODBC SQL Server
> Driver][SQL Server]
> CREATE PROCEDURE permission denied in database 'mydbname'.
I'm not sure what you mea
I've also tried connecting directly to the database as the main user ( not SA
)... and I get a permission denied error.
Server Msg: 262, State: 42000, [Microsoft][ODBC SQL Server Driver][SQL Server]
CREATE PROCEDURE permission denied in database 'mydbname'.
~~
nt: Tuesday, June 14, 2005 10:28 am
To: CF-Talk
Subject: RE: MS SQL - Cannot Find Stored Procedure
Importance: Low
> Turn off "maintain connection across requests" in CF Admin under
> Datasources => Your DB Name = Advanced.
thanks, but that didn't seem to work. As a side note
> Turn off "maintain connection across requests" in CF Admin under
> Datasources => Your DB Name = Advanced.
thanks, but that didn't seem to work. As a side note, what are the performance
implications for setting this value true or false?
1
Phone: (703) 995-1737
Fax: (703) 834-5527
-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 14, 2005 10:07 am
To: CF-Talk
Subject: MS SQL - Cannot Find Stored Procedure
Importance: Low
I've created the stored procedure in the Enterprise Manager
I've created the stored procedure in the Enterprise Manager on our Dev Server.
Its the same code that's used on our live site so I know it works. However,
Coldfusion returns an error that says the stored procedure cannot be found.
Another thing : is that when I go to run the stored procedure ag
15 matches
Mail list logo
