Looking for something analogous to the Create Or Replace option in Oracle. Is there an equivalent command in SQL Server?ALTER PROC <PROC Name>
You want to do this because of the GRANTS?
SQL Server sometimes tends to be finicky...I alway DROP & CREATE, then GRANT|||Hey man, thanks for the reply. I'm just trying to get use to SQL Server and I'm working on a script to create a db, tables, grants, yadayadayada.
I guess that no different then any other ANSI stanard DB...
Drop... DUH! my bad, boy am I rusty...
:o
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment