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 >>
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 >>
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 >>
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
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 >>