I have never really thought about this too much, but you cannot create a sproc with the same name as a table (or any other object for that matter).
create table foo (bar int)
go
create view foo as select * from foo
go
create procedure foo as
begin
select getdate()
end
go
EDIT:
Even in Oracle you cannot name a sproc the same as a table. I guess we have never run into it because we use so many different Schemas in Oracle. In SQL Server everything is owned by dbo (for the most part). Maybe this will be different in sql 2005...
-ec
Rollback
Forum Locked
Posted - 07/21/2004 : 16:58:17
