can't create table

  • Thread starter Thread starter Peter Kaufman
  • Start date Start date
P

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
 
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
 
It works on other computers here too, but not this particular one.

Thanks anyway,

Peter
 
Back
Top