Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ujjaval
Posting Yak Master
108 Posts |
 Posted - 2007-04-30 : 19:41:06
|
| Hi,One odd thing that I realize about SQL Server 7.0 and I am not sure if this is its usual behavior. I have a database which I upgraded. But the upgrade script didn't have the scripts to create new tables in it. I didn't realize this until I was looking at the database. However, I had few stored procedures which I installed successfully in the database. These stored procedures also had couple of stored procedures which inserts and updates the tables which my upgrade script didn't create. SQL Server didn't complain about these missing tables and successfully install stored procedure for missing tables. Is this how sql server behaves normally???Thanks,Ujjaval |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-30 : 19:46:06
|
| Yes that is normal. This is true even in SQL Server 2005. You won't receive an error until you run the stored procedure.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
About storedprocedure installation