November 8, 2011 at 5:22 am
Hi ,
In sql server 2000 DTS packages were stored in mater database (in tables)..
In sql server 2005 master database having the only views but not tables as those were stored in resource database..
so how can we fix this issue in upgradation from 2000 to 2005...
One more thing sql server 2000 have no schema concept but in sql server 2005 so how can we proceed.?
Thanks,
Rekha
November 8, 2011 at 5:51 am
AFAIK DTS packages have always been stored in msdb, not in master.
select *
from msdb.dbo.sysdtspackages
The same applies to SQL Server 2005.
I don't think I understand the rest of your question. How does the table/view change in master affect your code? It should not be an issue at all.
On the new schema implementation in SQL Server 2005, the only thing to keep in mind is that schemas have been decoupled from users. Again, it should not be a big deal.
Hope this helps
Gianluca
-- Gianluca Sartori
November 8, 2011 at 5:54 am
gsuvarnarekha (11/8/2011)
In sql server 2000 DTS packages were stored in mater database (in tables)..
No, they were stored in msdb, in the table sysdtspackages. The exact same table is in SQL 2005's msdb.
In sql server 2005 master database having the only views but not tables as those were stored in resource database..
so how can we fix this issue in upgradation from 2000 to 2005...
What issue?
One more thing sql server 2000 have no schema concept but in sql server 2005 so how can we proceed.?
Proceed with what?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply