Error 3624 Location: fakerowset.cpp:251

Hello,
I have the following error when I want to access the design
mode in Entreprise Manager of some tables :
Microsoft SQL-DMO (ODBC SQLState: HY000)
Error: 3624
Expression: accCategory == ACC_CATEGORY_NORMAL || accCatgegory ==
ACC_CATEGORY_BIT
SOPID: 52
Process ID : 2876
I'm running SQL server 2000 with SP3a.
Thanks for your help
You seem to be running into some sort of ASSERT is what I think. Please run
checkdb on your database, and check on the SQL error logs for any stack
dumps. Please paste the input buffer and short stack dump in this thread
and we can analyse.
Also if corruption is the cause, you also want to get your hw vendors
thoroughly involved and have them check your disk, controllers, etc.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Error 3624 Location: fakerowset.cpp:251

Hello,
I have the following error when I want to access the design
mode in Entreprise Manager of some tables :
Microsoft SQL-DMO (ODBC SQLState: HY000)
Error: 3624
Expression: accCategory == ACC_CATEGORY_NORMAL || accCatgegory == ACC_CATEGORY_BIT
SOPID: 52
Process ID : 2876
I'm running SQL server 2000 with SP3a.
Thanks for your helpYou seem to be running into some sort of ASSERT is what I think. Please run
checkdb on your database, and check on the SQL error logs for any stack
dumps. Please paste the input buffer and short stack dump in this thread
and we can analyse.
Also if corruption is the cause, you also want to get your hw vendors
thoroughly involved and have them check your disk, controllers, etc.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

error 207 when trying to add a new job

when trying to add a new job via sql agent server, receiving a message:
"error sqlstate: 42s33"
error 207: invalid column name 'category_id'
invalid column name 'netsend_address'
invalid column name 'last_netsend_date'
invalid column name 'last_netsend_time.
Hi,
Did you upgraded your SQL server from older version. If yes then the MSDB
upgrade was not done fully. See the below old post for the step by step
solution.
http://groups.google.com/groups?hl=e...lm=0TDE0%23ZdB
HA.187%40cppssbbsa01.microsoft.com
Thanks
Hari
MCDBA
"ed" <ed@.discussions.microsoft.com> wrote in message
news:99EECA57-E7CC-4F36-A248-F97616029E50@.microsoft.com...
> when trying to add a new job via sql agent server, receiving a message:
> "error sqlstate: 42s33"
> error 207: invalid column name 'category_id'
> invalid column name 'netsend_address'
> invalid column name 'last_netsend_date'
> invalid column name 'last_netsend_time.
|||Hi
-As per SQL Server Books Online "This error (error 207) occurs when a column
referenced in a Transact-SQL statement was not found in any table specified
in
the FROM clause of the query.
-Table msdb..sysoperators didn't have the following columns 'category_id', '
netsend_address',' last_netsend_date',' last_netsend_time'
Looks like some problem with MSDB, try and rebuild as suggested in previous
post.
HTH
Regards
Sadeesh
This posting is provided AS IS with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OBuR4L6cEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Did you upgraded your SQL server from older version. If yes then the MSDB
> upgrade was not done fully. See the below old post for the step by step
> solution.
>
> http://groups.google.com/groups?hl=e...lm=0TDE0%23ZdB
> HA.187%40cppssbbsa01.microsoft.com
> Thanks
> Hari
> MCDBA
> "ed" <ed@.discussions.microsoft.com> wrote in message
> news:99EECA57-E7CC-4F36-A248-F97616029E50@.microsoft.com...
>

error 207 when trying to add a new job

when trying to add a new job via sql agent server, receiving a message:
"error sqlstate: 42s33"
error 207: invalid column name 'category_id'
invalid column name 'netsend_address'
invalid column name 'last_netsend_date'
invalid column name 'last_netsend_time.Hi,
Did you upgraded your SQL server from older version. If yes then the MSDB
upgrade was not done fully. See the below old post for the step by step
solution.
http://groups.google.com/groups?hl=...elm=0TDE0%23ZdB
HA.187%40cppssbbsa01.microsoft.com
Thanks
Hari
MCDBA
"ed" <ed@.discussions.microsoft.com> wrote in message
news:99EECA57-E7CC-4F36-A248-F97616029E50@.microsoft.com...
> when trying to add a new job via sql agent server, receiving a message:
> "error sqlstate: 42s33"
> error 207: invalid column name 'category_id'
> invalid column name 'netsend_address'
> invalid column name 'last_netsend_date'
> invalid column name 'last_netsend_time.|||Hi
-As per SQL Server Books Online "This error (error 207) occurs when a column
referenced in a Transact-SQL statement was not found in any table specified
in
the FROM clause of the query.
-Table msdb..sysoperators didn't have the following columns 'category_id', '
netsend_address',' last_netsend_date',' last_netsend_time'
Looks like some problem with MSDB, try and rebuild as suggested in previous
post.
HTH
Regards
Sadeesh
--
This posting is provided AS IS with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OBuR4L6cEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Did you upgraded your SQL server from older version. If yes then the MSDB
> upgrade was not done fully. See the below old post for the step by step
> solution.
>
> [url]http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=0TDE0%23ZdB[/ur
l]
> HA.187%40cppssbbsa01.microsoft.com
> Thanks
> Hari
> MCDBA
> "ed" <ed@.discussions.microsoft.com> wrote in message
> news:99EECA57-E7CC-4F36-A248-F97616029E50@.microsoft.com...
>|||hi,
i didn't upgrage but i restored msdb from backup and it was ok.
thanks.
"Hari Prasad" wrote:

> Hi,
> Did you upgraded your SQL server from older version. If yes then the MSDB
> upgrade was not done fully. See the below old post for the step by step
> solution.
>
> [url]http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=0TDE0%23ZdB[/ur
l]
> HA.187%40cppssbbsa01.microsoft.com
> Thanks
> Hari
> MCDBA
> "ed" <ed@.discussions.microsoft.com> wrote in message
> news:99EECA57-E7CC-4F36-A248-F97616029E50@.microsoft.com...
>
>|||yep some of the columns were missing from the system tables in msdb? resto
red msdb from an old backup.
thanks for your help.
"Sadeesh[MSFT]" wrote:

> Hi
> -As per SQL Server Books Online "This error (error 207) occurs when a colu
mn
> referenced in a Transact-SQL statement was not found in any table specifie
d
> in
> the FROM clause of the query.
> -Table msdb..sysoperators didn't have the following columns 'category_id',
'
> netsend_address',' last_netsend_date',' last_netsend_time'
> Looks like some problem with MSDB, try and rebuild as suggested in previou
s
> post.
> HTH
> Regards
> Sadeesh
> --
> This posting is provided AS IS with no warranties, and confers no rights.
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:OBuR4L6cEHA.3512@.TK2MSFTNGP12.phx.gbl...
>
>