Re: Little Lock Symbols

if I 'check (green check)' it, the programs returns: "query excecuted
successfully".

Yes, if you hold your mouse over the green check you decided to click, you
will see that means "parse" (syntax check). The success message means that
the command didn't have any syntax errors.

Then when I try to run as suggested the command errors out saying "There
is
no text for object 'SQL_myquery'"

Are you sure your query is running in the correct database? When you
right-clicked "the database" was it db_ReportSource, or some other database?
Are you sure you were in an Object Explorer context of the correct server?
What happens when you execute the following in a properly created New Query
window:

USE db_ReportSource;
GO
EXEC SQL_myquery;
GO
EXEC dbo.SQL_myquery;
GO

?

Could the file actuallly be residing on the other users machine and not in
SQL Server? or network?

No, from your earlier description, this is a stored procedure in a database.
There are many differences between a stored procedure in the database and a
file in the file system. They are certainly not the same, and a file
somewhere on your network is certainly not going to magically appear under
the stored procedures node in object explorer.

A


.

Relevant Pages

  • Re: Catch... try block
    ... I would, instead, use ExecuteNonQuery on a stored procedure and ... As for why you are not getting the success message, ... entered the database without problem, there was no error, and there is no ... I would redesign for success rather than failure (the exception). ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Call stored procedure
    ... somebody know how can I call a stored procedure from visual basic 6.0? ... ¤ And this sp return a value. ... The syntax may depend upon the database you are working with. ...
    (microsoft.public.vb.database.ado)
  • Re: to optimize a select join
    ... My preferred garden variety of databases has a syntax extension ... Rows form EMP? ... Every database has its own syntax for outer joins. ... To make long story short, I hate ANSI joins, with passion. ...
    (comp.lang.php)
  • Re: Using query values for field name in table
    ... You didn't need to change the syntax on the Fields collection to get it to ... See http://www.QBuilt.com for all your database needs. ... >>> Dim dbsGeneralThoracic As Database ... >>> Dim fOpenedDB As Boolean ...
    (microsoft.public.access.modulesdaovba)
  • Re: Importing from another database on same server using SQL Server Express
    ... Even with these other techniques, ... problem is not the syntax of the query but something else. ... otherwise identical database into a more recent copy. ... The multi-part identifier "OldDatabase.dbo.Table.PK" could not be ...
    (microsoft.public.sqlserver.msde)