March 17, 2006 at 9:03 am
I recd an error master.dbo.spt_values while connecting to sql server. I could not connect to the server via EM or QA. I executed u_tables.sql and all looked good.
But now I am getting a master.dbo.spt_datatypes_info error while opening (right click on sproc name and click open) a sproc within QA. I can edit the sproc from both EM and QA.
Any ideas how I can fix this problem.
TIA
March 17, 2006 at 10:35 am
Do the client install & server install have the same servicepack level?
March 17, 2006 at 10:52 am
am trying to access using the client on the server...
March 17, 2006 at 11:36 am
I found that there are 4 tables missing in the master database
spt_datatype_info
spt_datatype_info_ext
spt_provider_types
spt_server_info
I tried to re-install sp4 but it gave me an error and stopped. The problem still exists...
Any ideas other than rebuild master.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply