Discussion:
extended properties error
(too old to reply)
bobh
2012-11-14 13:31:16 UTC
Permalink
Hi All,

I'm having an issue with upsizing a table to SQLServer........ In
Access2003 I'm using the upsizing wizard and it will upload the table
to SQLServer and when it's finished uploading the records it starts
displaying the same error for each field in the table; the error
message is


EXEC sp_addextendedproperty N'Attribtes', N'user', N'dbo', N'table',
N'tblRejectsYTD', N'Column', N'RRejct1'
Server Error 15135: Object is invalid. Extended properties are not
permitted on 'dbo.tblReRejectsYTD.RRejct1', or the object does not
exist.


I have no idea where this is coming from Access or SQLServer,
in the upsizing wizard there is no option to set 'extended
properties.
I don't even know what is meant by 'extended properties'.
what is it?, where is it set?? and how do I turn it off???
thanks
bobh.
Erland Sommarskog
2012-11-14 13:41:52 UTC
Permalink
Post by bobh
I'm having an issue with upsizing a table to SQLServer........ In
Access2003 I'm using the upsizing wizard and it will upload the table
to SQLServer and when it's finished uploading the records it starts
displaying the same error for each field in the table; the error
message is
EXEC sp_addextendedproperty N'Attribtes', N'user', N'dbo', N'table',
N'tblRejectsYTD', N'Column', N'RRejct1'
Server Error 15135: Object is invalid. Extended properties are not
permitted on 'dbo.tblReRejectsYTD.RRejct1', or the object does not
exist.
I have no idea where this is coming from Access or SQLServer,
in the upsizing wizard there is no option to set 'extended
properties.
I don't even know what is meant by 'extended properties'.
what is it?, where is it set?? and how do I turn it off???
Extended properties is indeed an SQL Server feature. It permits you to store
various information about table, columns and other objects.

I have no knowledge about the upsizing wizard, but I assume that it adds
some information from Access to be pretty. What I have heard from people
that knows both Access and SQL Server is that you are better off not using
the wizard, but instead make a proper migration. The wizard may seem like
a quick way, but since Access and SQL Server are so radically different
products, there is all reason to make a complete overhaul.
--
Erland Sommarskog, SQL Server MVP, ***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
bobh
2012-11-16 13:19:33 UTC
Permalink
Post by Erland Sommarskog
I'm having an issue with upsizing a table to SQLServer........  In
Access2003 I'm using the upsizing wizard and it will upload the table
to SQLServer and when it's finished uploading the records it starts
displaying the same error for each field in the table; the error
message is
EXEC sp_addextendedproperty N'Attribtes', N'user', N'dbo', N'table',
N'tblRejectsYTD', N'Column', N'RRejct1'
Server Error 15135: Object is invalid. Extended properties are not
permitted on 'dbo.tblReRejectsYTD.RRejct1', or the object does not
exist.
I have no idea where this is coming from Access or SQLServer,
in the upsizing wizard there is no option to set 'extended
properties.
I don't even know what is meant by 'extended properties'.
what is it?, where is it set?? and how do I turn it off???
Extended properties is indeed an SQL Server feature. It permits you to store
various information about table, columns and other objects.
I have no knowledge about the upsizing wizard, but I assume that it adds
some information from Access to be pretty. What I have heard from people
that knows both Access and SQL Server is that you are better off not using
the wizard, but instead make a proper migration. The wizard may seem like
a quick way, but since Access and SQL Server are so radically different
products, there is all reason to make a complete overhaul.
--
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Hide quoted text -
- Show quoted text -
thanks for the reply but if as you say;
Post by Erland Sommarskog
Extended properties is indeed an SQL Server feature. It permits you to store
various information about table, columns and other objects.
how do I turn it off ???
bobh.
Bob Barrows
2012-11-16 17:12:16 UTC
Permalink
Post by bobh
Post by Erland Sommarskog
I'm having an issue with upsizing a table to SQLServer........ In
Access2003 I'm using the upsizing wizard and it will upload the
table to SQLServer and when it's finished uploading the records it
starts displaying the same error for each field in the table; the
error message is
EXEC sp_addextendedproperty N'Attribtes', N'user', N'dbo', N'table',
N'tblRejectsYTD', N'Column', N'RRejct1'
Server Error 15135: Object is invalid. Extended properties are not
permitted on 'dbo.tblReRejectsYTD.RRejct1', or the object does not
exist.
I have no idea where this is coming from Access or SQLServer,
in the upsizing wizard there is no option to set 'extended
properties.
I don't even know what is meant by 'extended properties'.
what is it?, where is it set?? and how do I turn it off???
Extended properties is indeed an SQL Server feature. It permits you to store
various information about table, columns and other objects.
I have no knowledge about the upsizing wizard, but I assume that it adds
some information from Access to be pretty. What I have heard from people
that knows both Access and SQL Server is that you are better off not using
the wizard, but instead make a proper migration. The wizard may seem like
a quick way, but since Access and SQL Server are so radically
different
products, there is all reason to make a complete overhaul.
--
Books Online for SQL Server 2005
athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000
athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx-
Hide quoted text -
- Show quoted text -
thanks for the reply but if as you say;
Post by Erland Sommarskog
Extended properties is indeed an SQL Server feature. It permits you to store
various information about table, columns and other objects.
how do I turn it off ???
It's not something you "turn off" in sql server: it's a property you either
choose or choose not to populate.It's like asking how to "turn off" the
Datasource property of a control in Access, or the Description property of a
table in Access.
Something just occurred to me - perhaps the Description property of
tblRejects in Access has text in it which the upsizing wizard is attempting
to put in the extended properties of the sql server table. Try deleting the
description in Access and try again.
Bob Barrows
2012-11-16 17:12:16 UTC
Permalink
Post by bobh
Post by Erland Sommarskog
I'm having an issue with upsizing a table to SQLServer........ In
Access2003 I'm using the upsizing wizard and it will upload the
table to SQLServer and when it's finished uploading the records it
starts displaying the same error for each field in the table; the
error message is
EXEC sp_addextendedproperty N'Attribtes', N'user', N'dbo', N'table',
N'tblRejectsYTD', N'Column', N'RRejct1'
Server Error 15135: Object is invalid. Extended properties are not
permitted on 'dbo.tblReRejectsYTD.RRejct1', or the object does not
exist.
I have no idea where this is coming from Access or SQLServer,
in the upsizing wizard there is no option to set 'extended
properties.
I don't even know what is meant by 'extended properties'.
what is it?, where is it set?? and how do I turn it off???
Extended properties is indeed an SQL Server feature. It permits you to store
various information about table, columns and other objects.
I have no knowledge about the upsizing wizard, but I assume that it adds
some information from Access to be pretty. What I have heard from people
that knows both Access and SQL Server is that you are better off not using
the wizard, but instead make a proper migration. The wizard may seem like
a quick way, but since Access and SQL Server are so radically
different
products, there is all reason to make a complete overhaul.
--
Books Online for SQL Server 2005
athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000
athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx-
Hide quoted text -
- Show quoted text -
thanks for the reply but if as you say;
Post by Erland Sommarskog
Extended properties is indeed an SQL Server feature. It permits you to store
various information about table, columns and other objects.
how do I turn it off ???
It's not something you "turn off" in sql server: it's a property you either
choose or choose not to populate.It's like asking how to "turn off" the
Datasource property of a control in Access, or the Description property of a
table in Access.
Something just occurred to me - perhaps the Description property of
tblRejects in Access has text in it which the upsizing wizard is attempting
to put in the extended properties of the sql server table. Try deleting the
description in Access and try again.
bobh
2012-11-19 14:15:42 UTC
Permalink
Post by Bob Barrows
Post by bobh
Post by Erland Sommarskog
I'm having an issue with upsizing a table to SQLServer........ In
Access2003 I'm using the upsizing wizard and it will upload the
table to SQLServer and when it's finished uploading the records it
starts displaying the same error for each field in the table; the
error message is
EXEC sp_addextendedproperty N'Attribtes', N'user', N'dbo', N'table',
N'tblRejectsYTD', N'Column', N'RRejct1'
Server Error 15135: Object is invalid. Extended properties are not
permitted on 'dbo.tblReRejectsYTD.RRejct1', or the object does not
exist.
I have no idea where this is coming from Access or SQLServer,
in the upsizing wizard there is no option to set 'extended
properties.
I don't even know what is meant by 'extended properties'.
what is it?, where is it set?? and how do I turn it off???
Extended properties is indeed an SQL Server feature. It permits you to store
various information about table, columns and other objects.
I have no knowledge about the upsizing wizard, but I assume that it adds
some information from Access to be pretty. What I have heard from people
that knows both Access and SQL Server is that you are better off not using
the wizard, but instead make a proper migration. The wizard may seem like
a quick way, but since Access and SQL Server are so radically different
products, there is all reason to make a complete overhaul.
--
Books Online for SQL Server 2005
athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000
athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx-
Hide quoted text -
- Show quoted text -
thanks for the reply but if as you say;
Post by Erland Sommarskog
Extended properties is indeed an SQL Server feature. It permits you to store
various information about table, columns and other objects.
how do I turn it off ???
It's not something you "turn off" in sql server: it's a property you either
choose or choose not to populate.It's like asking how to "turn off" the
Datasource property of a control in Access, or the Description property of a
table in Access.
Something just occurred to me - perhaps the Description property of
tblRejects in Access has text in it which the upsizing wizard is attempting
to put in the extended properties of the sql server table. Try deleting the
description in Access and try again.- Hide quoted text -
- Show quoted text -
I think you got it....... good catch. Thanks for your help :)

The Access table I was trying to upsize using the upsizing wizard had
descriptions in about half the fields and when looking at the upsized
table in SQLServer none of those descriptions where uploaded.
I can’t test using this table it’s to big but the next table I upsize
which is a smaller recordset I’ll test the ‘description’ and confirm
if that is what is causing the errors messages, at least for me.
bobh.
bobh
2012-11-20 18:41:04 UTC
Permalink
Post by Bob Barrows
Post by bobh
Post by Erland Sommarskog
I'm having an issue with upsizing a table to SQLServer........ In
Access2003 I'm using the upsizing wizard and it will upload the
table to SQLServer and when it's finished uploading the records it
starts displaying the same error for each field in the table; the
error message is
EXEC sp_addextendedproperty N'Attribtes', N'user', N'dbo', N'table',
N'tblRejectsYTD', N'Column', N'RRejct1'
Server Error 15135: Object is invalid. Extended properties are not
permitted on 'dbo.tblReRejectsYTD.RRejct1', or the object does not
exist.
I have no idea where this is coming from Access or SQLServer,
in the upsizing wizard there is no option to set 'extended
properties.
I don't even know what is meant by 'extended properties'.
what is it?, where is it set?? and how do I turn it off???
Extended properties is indeed an SQL Server feature. It permits you to store
various information about table, columns and other objects.
I have no knowledge about the upsizing wizard, but I assume that it adds
some information from Access to be pretty. What I have heard from people
that knows both Access and SQL Server is that you are better off not using
the wizard, but instead make a proper migration. The wizard may seem like
a quick way, but since Access and SQL Server are so radically different
products, there is all reason to make a complete overhaul.
--
Books Online for SQL Server 2005
athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000
athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx-
Hide quoted text -
- Show quoted text -
thanks for the reply but if as you say;
Post by Erland Sommarskog
Extended properties is indeed an SQL Server feature. It permits you to store
various information about table, columns and other objects.
how do I turn it off ???
It's not something you "turn off" in sql server: it's a property you either
choose or choose not to populate.It's like asking how to "turn off" the
Datasource property of a control in Access, or the Description property of a
table in Access.
Something just occurred to me - perhaps the Description property of
tblRejects in Access has text in it which the upsizing wizard is attempting
to put in the extended properties of the sql server table. Try deleting the
description in Access and try again.- Hide quoted text -
- Show quoted text -
I tried removing all descriptions and even idexes on a small Access
table and then using the upsizing wizard tried to upload that table to
SQLServer and after it uploaded it went thru and gave the same "EXEC
sp_addextendedproperty " error for each field that was in the table.
Maybe I'll just have to bit the bullet and log into SQLServer and pull
the data up instead of using the upsizing wizard to push the data up
to SQLServer.

bobh.

Continue reading on narkive:
Loading...