Archived Months
January 2003
March 2003
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
July 2007
August 2007
September 2007
October 2007
all groups > sql server misc > november 2005

Enterprise Manager - problem
Posted by Mr Curious at 11/22/2005 10:25:04 AM
I have a problem with Enterprise Manager - when I refresh list of tables or databases it hangs (is not responding) for long time - about 10-30 minutes. What is more important during my refreshement users are unable to work normally - it hangs entire server. Some other details: 1. I am only dbo ...more >>


sql code left outer join
Posted by Raj at 11/21/2005 12:00:00 AM
Hi, I'm trying to left outer join two tables onto one. For some reason the table is losing some of the left table data (vw_standard_costing_items). Please can you tell me why, and a fix please? I'm left outer joining vw_standard_costing_budgeted_amount and vw_standard_costing_pur...more >>

Documentation of the database
Posted by Hallgeir at 11/14/2005 8:14:37 AM
I need to document my database with all its table, filds, trigger, procedures, views, relations etc. With 130 tables this seem to be a pretty big job, but I'm wondering if anyone could recomand a program that could help me with this task. I guess I'm not the first one with this kind of probl...more >>

need help importing ddl to sql server
Posted by comic_rage NO[at]SPAM yahoo.com at 11/9/2005 7:18:41 AM
Hi, I am new at sql server. I have a ddl to import the database with its tables to sql server. When I open the sql server enterprise manager, I only see Microsoft SQL Servers/SQL Server Group. There is a (No items) below the SQL Server Group. I don't see any opens to import the ddl or create ...more >>

DELETING 100 million from a table weekly SQl SERVER 2000
Posted by harish at 11/4/2005 7:46:57 PM
DELETING 100 million from a table weekly SQl SERVER 2000 Hi All We have a table in SQL SERVER 2000 which has about 250 million records and this will be growing by 100 million every week. At a time the table should contain just 13 weeks of data. when the 14th week data needs to be loaded the...more >>



DevelopmentNow Blog