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 |
|
Hans Gregorich
Starting Member
1 Post |
 Posted - 2009-09-30 : 10:39:32
|
| Hi,I'm new with sqlsever 2008 and have to migrate data from 2000 to 2008.On the 2000 sqlserver we have tables in the sys schema. I wanted to create the same tables in the sys schema on 2008, but it seems there is no way.Is there any way to do that, because we have many reports, apps etc. which reference the schema 'SYS.tablenamexy', in order to avoid changing all that stuff.Any hint is very appreciatedBest RegardsHans |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-09-30 : 11:40:18
|
| This would be a bad idea. Even if you could guarantee that you are not accidentally using one of the names that SQL Server is using, you may not be able to guarantee what is added in future service packs. |
 |
|
|
|
|
|
creating tables in sys schema