SQAPro (7/9/2009)

---

homebrew01 (7/9/2009)

---

Seems like yesterday's issues with the site are continuing today. Look at all the other multiple...

Won't the the automatic startup have a problem because the trace file name specified will already exist from before the shutdown ? TraceFile.trc TraceFile_1.trc etc So...

What format is the Oracle data ? Is it just 1 table in a flat file ? If so, maybe you could import it the same way you'd...

Right, so you need to compare the values of inserted and...

Lynn Pettis (7/9/2009)

---

Running a server side trace is not too intrusive, depending on what you are capturing and can be left running while SQL Server is up and running. ...

You can also purchase a 3rd party tool such as Idera's Compliance Manager. It will give you everything you want, and can be configured to send you email alerts when...

Seems like yesterday's issues with the site are continuing today. Look at all the other multiple posts:w00t:

Mods need...

If you want to run procedure from scripts, rather than the GUI, you can use the GUI to get everything set, then choose "Script to Query Window". That will build...

Jeff Moden (7/4/2009)

---

A better question would be, why...

Why do you want to restore Dev onto Production ? What will happen to all your production data ?

Roy Ernest (6/30/2009)

---

I think it is the number of days since 01/01/1930.

"This system uses "date" field that are calculated as # of days since...

Sorry ... edited above.

Here's a sanitized version, with unrelated fields removed:

CREATE TABLE employee(

emp_id int NOT NULL,

first_name varchar(15) NULL,

middle_name varchar(15) NULL,

last_name varchar(20) NULL,

company_sys_id int NULL,

dept_id int NULL,

eff_start_date int NOT NULL,

eff_stop_date int NOT NULL

.

.

.

emp_id ...

Lynn Pettis (6/30/2009)

---

I'd still like the DDL for the tables and some sample data. I'd like to be sure that you get an answer that ensures you get the...

Thanks ! Assuming you meant: Select...