Michael Maddison
mmaddison at optusnet.com.au
Sat Sep 11 04:29:35 CDT 2004
I presume you are using DTS? You can edit the create table script when setting the destination. You might want to copy it to QA and a replace on the 8000 cheers Michael M -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of John W. Colby Sent: Saturday, 11 September 2004 1:25 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] What determines default I am trying to import one a small subset of one of my import files into a new table. The import fails "not enough storage". When I look at the table definition (it creates the table, but fails on import) the field defs are varchar 8000. The other machine was bringing them in as nvarchar 50. I have to believe that this is the problem. How do I cause the table build to use nvarchar 50 instead of varchar 8000? John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: Friday, September 10, 2004 1:56 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Can I abort EM job? aborting the job now won't cause you to loose data, but it will cause additional delays as the log files have to be used to restore the database to before you ran your job. On Fri, 10 Sep 2004 01:04:12 -0400, Arthur Fuller <artful at rogers.com> wrote: > One thing that you absolutely must check as soon as possible is the > data type of all your columns. Any Ntext fields should be converted to > text, since this data is not for consumption in 2-byte countries. > > You always need twice or thrice the space that any given SQL job will > consume. That's a basic rule of thumb. Don't shoot the messenger. > > I hope the client is paying you a lot for this gig, JC, because you're > soon going to be as hairless as Andre Agassi. > > A. > > > > -----Original Message----- > From: dba-sqlserver-bounces at databaseadvisors.com > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John > W. Colby > Sent: Thursday, September 09, 2004 9:53 PM > To: dba-sqlserver at databaseadvisors.com > Subject: [dba-SQLServer] Can I abort EM job? > > Well... > > I turned logging back on (bad move) then tried to add an identity > field to my table. Two days later... The log file has run out of room > (200g) the data files are about to run out of room etc. It gave me a > warning that the original table was built without ANSI Null or some > such and that it was going to build a new table with that turned on. > > So... Is there any halting the process? If I do will it roll back > (for two damn days)? Am I screwed and just have to load the data all > over again? > > John W. Colby > www.ColbyConsulting.com > > -----Original Message----- > From: dba-sqlserver-bounces at databaseadvisors.com > [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John > W. Colby > Sent: Thursday, September 09, 2004 1:41 PM > To: dba-sqlserver at databaseadvisors.com > Subject: [dba-SQLServer] SQL Server Backup > > Can anyone explain to me what SQL Server does when it backs up. I > have this largish database that I need to backup and I need to know if > I need the same amount of room for the backup as is used for the db > itself, if compression is used, how much it helps etc. > > John W. Colby > www.ColbyConsulting.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 > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- -Francisco _______________________________________________ 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.718 / Virus Database: 474 - Release Date: 9/07/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.718 / Virus Database: 474 - Release Date: 9/07/2004