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 |
|
qkhqkhqkh
Starting Member
1 Post |
 Posted - 2008-10-14 : 03:42:52
|
| when I want to append data to SYTELINE database(sql2000) by tsql,then ,it return an error information ,the error is "not found MASTER.DBO.XP_TIME_ZONE_TIME".COULD DO HELP ME TO resolve it!thanks! |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-10-15 : 14:03:24
|
| Is this a sql 2000 add-on?? The error info says XP_TIME_ZONE_TIME does not exists under MASTER database by owner DBO.Is it installed under a different db owner?? |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-10-17 : 10:34:08
|
| This is not a vanilla S2K extended stored proc. It's definitely an add-on. Be sure it exists in Master, and if it does, as hanbingl suggested, check the owner.Terry |
|
|
|
|
|
|
about master.dbo.xp_time_zone_time