[dba-SQLServer]Cross posted: Upsizing usys tables

John,

This is one I know from experience.  SQL Server doesn't like that table
name.  If you name them something else first, they'll get upsized.  I
ran into this with some Usys tables I had in a database we upsized on a
contract project.

Charlotte Foust

>  -----Original Message-----
> From: 	dba-sqlserver-admin at databaseadvisors.com
> [mailto:dba-sqlserver-admin at databaseadvisors.com]  On Behalf Of John
> W. Colby
> Sent:	Tuesday, February 25, 2003 2:31 PM
> To:	dba-sqlserver at databaseadvisors.com
> Subject:	RE: [dba-SQLServer]Cross posted: Upsizing usys tables
> 
> Actually they are needed.  These are USYS tables, not MSYS tables.
> USYS tables are tables that the DEVELOPER builds that he wants hidden.
> In this case they are tables that drive my framework (SysVars), as
> well as my security stuff.
> 
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
> 
> -----Original Message-----
> From: dba-sqlserver-admin at databaseadvisors.com
> [mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of Mike and
> Doris Manning
> Sent: Tuesday, February 25, 2003 4:57 PM
> To: dba-sqlserver at databaseadvisors.com
> Subject: RE: [dba-SQLServer]Cross posted: Upsizing usys tables
> 
> 
> These are not needed in the upsize.  Don't worry about them.
> 
> Doris Manning
> Database Administrator
> Hargrove Inc.
> www.hargroveinc.com
> 
> 
> -----Original Message-----
> From: dba-sqlserver-admin at databaseadvisors.com
> [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of John W.
> Colby
> Sent: Tuesday, February 25, 2003 02:13 PM
> To: AccessD-SQLServer; AccessD
> Subject: [dba-SQLServer]Cross posted: Upsizing usys tables
> 
> 
> usys tables are tables which in Access appear to be system tables,
> i.e. are
> hidden when the "don't show system tables" is checked.  They are not
> showing
> for the upsize.  Do I have to change their name, or is there a tweak
> to make
> it upsize usys tables?
> 
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
> 
> ----------------------------------------------------
> Is email taking over your day?  Manage your time with eMailBoss. Try
> it
> free!  http://www.eMailBoss.com
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> 
> 
> ----------------------------------------------------
> Is email taking over your day?  Manage your time with eMailBoss.  
> Try it free!  http://www.eMailBoss.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030225/c00b81c7/attachment.html>