trying to refresh data

[qwertyjjj]

nope, same error.
It's almost like it's expecting a SQL query but because all the data came from a stored procedure on the server it doesn't know what to order by

 

[boblarson]

Well, I can try my own test here with a SQL installation. I'll try it and let you know how it goes.

 

[boblarson]

I just thought of something. I don't know how to create a stored procedure on my SQL Server 2005 Express edition without any UI. I can do a linked table but that won't be the same.

 

[qwertyjjj]

Code goes:

CREATE PROCEDURE namehere

AS

SELECT fieldname, fieldname, fieldname
FROM tablename

GO

 

[boblarson]

Code goes:

CREATE PROCEDURE namehere

AS

SELECT fieldname, fieldname, fieldname
FROM tablename

GO

See there's still a lot I don't even know. My ignorance of this subject will be displayed further when I say, "Where do I use that?" I know I can use the SQL Query Analyzer in the Enterprise Tools (at least when I worked with MSDE and SQL 2000).

 

[qwertyjjj]

Yep just type it into the query analyzer and run it.
After that if you need to change it you need to use ALTER PROCEDURE

 

[boblarson]

That's the problem. I don't have access to query analyzer.

By the way are you using SQL 2000 or 2005?

 

[qwertyjjj]

SQL 2000.
Doesn't SQL express come with some sort of analyzer?
If it has enterprise manager then you can right click on stored procedures, goto new, and then put some sql code in.

 

[boblarson]

No, it doesn't come with any management tools. That's a point of consternation as they give it to you but don't give you much of anything to work with it.