can't create table

[Peter Kaufman]

Access 2003 ADP SQL Server 2000 SP4 backend.

ALTER PROC procTEST
AS

SET NOCOUNT ON
CREATE TABLE mylogintable
(
date_in datetime,
user_id int
)
GO

Any ideas why no error, but no table is created? Or alternately how to
troubleshoot the problem? It's sure to turn out to be something
stupid, but I can't pin it down.

I am definitely connected to the right server and looking for it in
the right db, and am an admin. If I run the proc twice, there is no
error that it already exists.

Thanks,

Peter

 

[Tom Ellison]

Dear Peter:

The code you showed is to alter an existing stored procedure. If you then
execute the stored procedure, it should create the table. It works on my
system. Specifically, as I did not initially have the stored procedure, I
changed it to:

CREATE PROC procTEST

It creates the stored procedure.

Then, when I ran the stored procedure, it created the table.

I'm not sure where your problem lies. Perhaps this will help.

Tom Ellison

 

[Peter Kaufman]

It works on other computers here too, but not this particular one.

Thanks anyway,

Peter