RE: [SQLQueriesNoCode] Run queries without LOGGING
- See if this helps:
> -----Original Message-----which is
> From: SQLQueriesNoCode@yahoogroups.com
> [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of faraz faheem
> Sent: Thursday, April 14, 2011 10:24 AM
> To: SQLQueriesNoCode@yahoogroups.com
> Subject: [SQLQueriesNoCode] Run queries without LOGGING
> I am using sql server 2005 standard edition. I import monthly data from
> different sources. my LOG file easily go to 32GB after 4 months data
> around more than 2 million records.LOGGING?
> I m using INSERT INTO SELECT... queries to import data.
> is there anyway i can tell studio management to run this query with
> currently I truncate the log file, but it is impossible to run this
> query on production server due to restriction of data.
> thanks in advance
> Faraz Faheem
> [Non-text portions of this message have been removed]
> Yahoo! Groups Links
I just installed Sybase ASE 15.5
I have creating tables and procedures using scripts. All the tables were created
but when I create the stored procedures (one by one, it only creates up to 8
stored procedures. Is there any lmitation. I actually installed the evaluation
I also tested this on the Free developer edition and the results were the same.
Any ideas why its happening?
[Non-text portions of this message have been removed]