473,322 Members | 1,522 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

random execution of stored procs in ADP

I have see this bug 12 times in the past year. On 3 or 4 different
machines.

1) cut and paste a bunch of sprocs
2) change between query analyzer and Access (using the taskbar)
3) changing back to Access will launch sprocs randomly

I have seen it 12 times and I have gotten nothing but lip.

Test this, diagnose it and fix it Microsoft.
Nov 13 '05 #1
6 1277
aaron kempf wrote:
I have see this bug 12 times in the past year. On 3 or 4 different
machines.

1) cut and paste a bunch of sprocs
2) change between query analyzer and Access (using the taskbar)
3) changing back to Access will launch sprocs randomly

I have seen it 12 times and I have gotten nothing but lip.

Test this, diagnose it and fix it Microsoft.


The purpose of usenet groups such as this is for peer help, users
helping other users and general discussion.

Trying to get MS to fix a bug is best taken up with Microsoft directly.
Ranting in a news group is not the way to go about it.

Nov 13 '05 #2
Trev@Work wrote:
aaron kempf wrote:
I have see this bug 12 times in the past year. On 3 or 4 different
machines.
The purpose of usenet groups such as this is for peer help, users
helping other users and general discussion.

Trying to get MS to fix a bug is best taken up with Microsoft directly.
Ranting in a news group is not the way to go about it.

Different formulation could be in order, too.

It may just help to let something out anyway. The nice thing about news
groups is that you can be heard and nobody needs to take offense.
(Sometimes I find it hard to resist the temptation :-) )

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #3
Bas Cost Budde wrote:
Trev@Work wrote:
aaron kempf wrote:
I have see this bug 12 times in the past year. On 3 or 4 different
machines.


The purpose of usenet groups such as this is for peer help, users
helping other users and general discussion.

Trying to get MS to fix a bug is best taken up with Microsoft
directly. Ranting in a news group is not the way to go about it.

Different formulation could be in order, too.

It may just help to let something out anyway. The nice thing about news
groups is that you can be heard and nobody needs to take offense.
(Sometimes I find it hard to resist the temptation :-) )


No offence was taken, just trying to help the guy by steering him in the
right direction.

--
This sig left intentionally blank
Nov 13 '05 #4
Trevor Best wrote:
No offence was taken, just trying to help the guy by steering him in the
right direction.


Oh, I didn't want to suggest you took offense. On the very contrary, I
read a very to the point remark. I find it hard to express that using
just ASCII, you know.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #5
All I know is that I have contacted Microsoft about this repeatedly;
and they refuse to do anything about it.

It isn't our job to test your products, Microsoft-- your 'QUALITY OF
SERVICE' is entirely unacceptbale.

I have been posting in the Microsoft newsgroup, but they started
censoring me

IT REALLY PISSES ME OFF THAT SPROCS RANDOMLY LAUNCH THEMSELVES AND
MICROSOFT WON'T DO ANYTHING ABOUT IT

It has to do with switching focus between Query Analyzer and Access.
I have seen it a dozen times on 3 or 4 different machines.

We cannot afford to have such a rinky-dink program interfacing with
OUR MISSION CRITICAL SQL SERVER DATABASES.

FIX YOUR PRODUCTS, MICROSOFT

FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT
FIX YOUR PRODUCTS, MICROSOFT


Bas Cost Budde <b.*********@heuvelqop.nl> wrote in message news:<co**********@news2.solcon.nl>...
Trevor Best wrote:
No offence was taken, just trying to help the guy by steering him in the
right direction.


Oh, I didn't want to suggest you took offense. On the very contrary, I
read a very to the point remark. I find it hard to express that using
just ASCII, you know.

Nov 13 '05 #6
aaron kempf wrote:
All I know is that I have contacted Microsoft about this repeatedly;
and they refuse to do anything about it.

It isn't our job to test your products, Microsoft-- your 'QUALITY OF
SERVICE' is entirely unacceptbale.

I have been posting in the Microsoft newsgroup, but they started
censoring me

IT REALLY PISSES ME OFF THAT SPROCS RANDOMLY LAUNCH THEMSELVES AND
MICROSOFT WON'T DO ANYTHING ABOUT IT

It has to do with switching focus between Query Analyzer and Access.
I have seen it a dozen times on 3 or 4 different machines.

We cannot afford to have such a rinky-dink program interfacing with
OUR MISSION CRITICAL SQL SERVER DATABASES.

FIX YOUR PRODUCTS, MICROSOFT


[snip]

What was it you wanted MS to do again? <g>

I use Query Analyser to write stored procedures, just use the object
browser in the left hand pane, brwose to the SPs in whatever database,
right click and select "Edit". I've not used ADPs but used to use EM for
the procs but got fed up with the way that...

a) Stored procedure editor is modal so if you want to look at a
table/view you had to open another instance of EM and
b) The tab stops were hard set at 8 characters, I couldn't find a way to
change it like you can in QA.

It takes a bit of getting used to in that you have to press the play
button to save the proc (as it's an "Alter Procedure" statement) instead
of hitting a save button, which would just save a script somewhere on
your hard disk (defaulting to "My Documents", where everyone wants to
save SQL scripts >-) :rolleyes:)

For something that looks a bit like Notepad on steroids, Query Analyser
has got to be one of the most versitile applications around.

--
This sig left intentionally blank
Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Robin Hammond | last post by:
Can anybody tell me why a) when running a stored proc from an asp page to return a recordset the command succeeds if the sp queries an existing table directly, but b) if the stored proc populates...
1
by: LineVoltageHalogen | last post by:
Greetings All, currentley there is a heated discussion in my place of work over which method is better/more efficient for simple selects. Background: 1.) Simple Application that uses sql server...
3
by: hrishy | last post by:
Hi Db2ers I am a newbie starting out in the fascinating world of IBM.Could anybody let me know in what version the sql /PL language was introduced..Can you also let me know what is the language...
7
by: trint | last post by:
My boss wants me to use stored procedures, but I thought somehow that using c# that ADO.Net was better. Any help is appreciated. Thanks, Trint
45
by: John | last post by:
Hi When developing vb.bet winform apps bound to sql server datasource, is it preferable to use SELECTs or stored procedure to read and write data from/to SQL Server? Why? Thanks Regards
1
by: kentk | last post by:
Is there a difference in how SQL Server 7 and SQL 2000 processes SQL passed from a program by an ADO command object. Reason I ask is I rewrote a couple applications a couple years ago were the SQL...
15
by: Burt | last post by:
I'm a stored proc guy, but a lot of people at my company use inline sql in their apps, sometimes putting the sql in a text file, sometimes hardcoding it. They don't see much benefit from procs, and...
8
by: Frank Calahan | last post by:
I've been looking at LINQ and it seems very nice to be able to make queries in code, but I use stored procs for efficiency. If LINQ to SQL only works with SQL Server and stored procs are more...
5
by: Bogdan | last post by:
Hi, I have a stored procedure that uses JOINs to return columns from multiple tables. I also have another stored proc that that takes a series of params and updates multiple tables. I used the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.