I need to be sure a table had not been updated since it was created.
Is there a way to extract a log of updates, deletions and inserts commited
against a table from sql server??
TIA

I've an SQL file which contain accent characters to fill my default values
like this:
insert into mtytable.... values('F?vrier')
and also I create storedprocedures which execute some insert / update

What is the best way to set up a datwarehouse? Do I use replication or dts
packages or what? What I need to do is archive production data every two
weeks to this datawarehouse. Then I will need to be able to query the
archive data. What is the best way to do this? And how do I go ...

Hello,  I have a analysis services design question I've been struggling with.
Let me pose the question in simplified terms and hopefully one of you
experts can help me along...
We have cetain tools that go out on jobs.  These tools can perform one or

We are in a typical data warehouse environment where we are running
ETL on a set of tables that are loaded nightly. The same set of tables
are then used to process OLAP cubes (everything is on SQL Server 2000
EE/Analysis Services). Along with cubes, those tables are also used

We have a small data warehouse (less than 50 million rows in roughly
75 gigabytes) however, it is growing steadily.  We have noticed that
we get much better performance on queries when there are no foreign
key constraints.  We have demonstrated a 14% improvement.  I am aware

how can I know or log the volume loaded by my DTS packages?
I need to evaluate the traffic and the bandwidth required.
Does the profiler can provide enough info?
For the moment I work on a copy of the production database. so all is local

I'm new to the whole data warehousing business and I'm going through the
tutorial and as I get to the end where I process the cube I then try to
browse the data and get an error Unable to browse cube. Unspecified Error.
From the research I've done this problem was happening in ...

Now, I use SQL Server 2000 and Analysis Manager.  I have
some problem about transaction logs that have been
expanded day by day for the database of SQL and Ananlysis
Manager.   Currently, size of transaction log files are

I am a semi-experienced DBA, but have some questions regarding the
storage of images inside of SQL Server (which I have never done before).
 I am researching to pros and cons of storing images inside of SQL
Server verses a file server and DB combination (storing the file paths

SQL 2K
I got a SQL job which executes a storedprocedure ,which populates data for a
data warehousing application.
Each day my job execution time increases, but the underlying table from

Hi, All!
I need to help on this problem:
there is a dimension table with this structure in the Staging DB -
Customer_Code      nvarchar(50)