<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6249.1">
<TITLE>RE: [dba-SQLServer]Cross posted: Upsizing usys tables</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Comic Sans MS">John,</FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Comic Sans MS">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.</FONT></P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Comic Sans MS">Charlotte Foust</FONT>
</P>
<UL>
<P><FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Tahoma">-----Original Message-----</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">From: </FONT></B> <FONT SIZE=1 FACE="Tahoma">dba-sqlserver-admin@databaseadvisors.com [</FONT><A HREF="mailto:dba-sqlserver-admin@databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=1 FACE="Tahoma">mailto:dba-sqlserver-admin@databaseadvisors.com</FONT></U></A><FONT SIZE=1 FACE="Tahoma">] </FONT><B> <FONT SIZE=1 FACE="Tahoma">On Behalf Of</FONT></B> <FONT SIZE=1 FACE="Tahoma">John W. Colby</FONT></P>
<P><B><FONT SIZE=1 FACE="Tahoma">Sent: </FONT></B> <FONT SIZE=1 FACE="Tahoma">Tuesday, February 25, 2003 2:31 PM</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">To: </FONT></B> <FONT SIZE=1 FACE="Tahoma">dba-sqlserver@databaseadvisors.com</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Subject: </FONT></B> <FONT SIZE=1 FACE="Tahoma">RE: [dba-SQLServer]Cross posted: Upsizing usys tables</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">John W. Colby</FONT>
<BR><FONT SIZE=2 FACE="Arial">Colby Consulting</FONT>
<BR><A HREF="file://www.ColbyConsulting.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.ColbyConsulting.com</FONT></U></A>
</P>
<P><FONT SIZE=2 FACE="Arial">-----Original Message-----</FONT>
<BR><FONT SIZE=2 FACE="Arial">From: dba-sqlserver-admin@databaseadvisors.com</FONT>
<BR><FONT SIZE=2 FACE="Arial">[</FONT><A HREF="mailto:dba-sqlserver-admin@databaseadvisors.com]On"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:dba-sqlserver-admin@databaseadvisors.com]On</FONT></U></A><FONT SIZE=2 FACE="Arial"> Behalf Of Mike and</FONT>
<BR><FONT SIZE=2 FACE="Arial">Doris Manning</FONT>
<BR><FONT SIZE=2 FACE="Arial">Sent: Tuesday, February 25, 2003 4:57 PM</FONT>
<BR><FONT SIZE=2 FACE="Arial">To: dba-sqlserver@databaseadvisors.com</FONT>
<BR><FONT SIZE=2 FACE="Arial">Subject: RE: [dba-SQLServer]Cross posted: Upsizing usys tables</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">These are not needed in the upsize. Don't worry about them.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Doris Manning</FONT>
<BR><FONT SIZE=2 FACE="Arial">Database Administrator</FONT>
<BR><FONT SIZE=2 FACE="Arial">Hargrove Inc.</FONT>
<BR><A HREF="file://www.hargroveinc.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.hargroveinc.com</FONT></U></A>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">-----Original Message-----</FONT>
<BR><FONT SIZE=2 FACE="Arial">From: dba-sqlserver-admin@databaseadvisors.com</FONT>
<BR><FONT SIZE=2 FACE="Arial">[</FONT><A HREF="mailto:dba-sqlserver-admin@databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:dba-sqlserver-admin@databaseadvisors.com</FONT></U></A><FONT SIZE=2 FACE="Arial">] On Behalf Of John W. Colby</FONT>
<BR><FONT SIZE=2 FACE="Arial">Sent: Tuesday, February 25, 2003 02:13 PM</FONT>
<BR><FONT SIZE=2 FACE="Arial">To: AccessD-SQLServer; AccessD</FONT>
<BR><FONT SIZE=2 FACE="Arial">Subject: [dba-SQLServer]Cross posted: Upsizing usys tables</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">usys tables are tables which in Access appear to be system tables, i.e. are</FONT>
<BR><FONT SIZE=2 FACE="Arial">hidden when the "don't show system tables" is checked. They are not showing</FONT>
<BR><FONT SIZE=2 FACE="Arial">for the upsize. Do I have to change their name, or is there a tweak to make</FONT>
<BR><FONT SIZE=2 FACE="Arial">it upsize usys tables?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">John W. Colby</FONT>
<BR><FONT SIZE=2 FACE="Arial">Colby Consulting</FONT>
<BR><A HREF="file://www.ColbyConsulting.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.ColbyConsulting.com</FONT></U></A>
</P>
<P><FONT SIZE=2 FACE="Arial">----------------------------------------------------</FONT>
<BR><FONT SIZE=2 FACE="Arial">Is email taking over your day? Manage your time with eMailBoss. Try it</FONT>
<BR><FONT SIZE=2 FACE="Arial">free! </FONT><A HREF="http://www.eMailBoss.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.eMailBoss.com</FONT></U></A>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">_______________________________________________</FONT>
<BR><FONT SIZE=2 FACE="Arial">dba-SQLServer mailing list</FONT>
<BR><FONT SIZE=2 FACE="Arial">dba-SQLServer@databaseadvisors.com</FONT>
<BR><A HREF="http://databaseadvisors.com/mailman/listinfo/dba-sqlserver"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://databaseadvisors.com/mailman/listinfo/dba-sqlserver</FONT></U></A>
<BR><A HREF="http://www.databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.databaseadvisors.com</FONT></U></A>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">_______________________________________________</FONT>
<BR><FONT SIZE=2 FACE="Arial">dba-SQLServer mailing list</FONT>
<BR><FONT SIZE=2 FACE="Arial">dba-SQLServer@databaseadvisors.com</FONT>
<BR><A HREF="http://databaseadvisors.com/mailman/listinfo/dba-sqlserver"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://databaseadvisors.com/mailman/listinfo/dba-sqlserver</FONT></U></A>
<BR><A HREF="http://www.databaseadvisors.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.databaseadvisors.com</FONT></U></A>
</P>
<BR>
<BR>
<BR>
<P><FONT SIZE=2 FACE="Arial">----------------------------------------------------</FONT>
<BR><FONT SIZE=2 FACE="Arial">Is email taking over your day? Manage your time with eMailBoss. </FONT>
<BR><FONT SIZE=2 FACE="Arial">Try it free! </FONT><A HREF="http://www.eMailBoss.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.eMailBoss.com</FONT></U></A>
</P>
</UL>
</BODY>
</HTML>