I bet you are not specifying a column list in your INSEERT statement. Instead

INSERT ScheduleDetailCopied

VALUES( ... )

try this:

INSERT ScheduleDetailCopied( ... )

VALUES( ... )

Run sp_lock @process_id to see what objects are blocked by the given process ID. then think why those objects might be blocked.

You need three INSERT with SELECT statements in one transaction. Put it in a stored procedure, of course. Your statements must go in the order master, detail, subdetail to meet...

My compliments to David Poole for his last comment on the topic.

I also would like to add the following. UDT similar to ty_int does not serve the purpose of enforcing...

Try to run

sp_who2 Active

instead of just sp_who2. It will show you what processes are actually doing something, not idle. Also, can you see what process ID is blocking your...

Again, just write a job that periodically checks for changes in schema_ver column of sysobjects and captures that data in a special user defined table.

Michael

Please never use Enterprise Manager except for read-only purposes. Always create your objects from Query Analizer and store them as script files.

Columns in sysobjects table:

- crdate - date when table was created.

- refdate - not used, reserved for future, currently value is equal to crdate.

- schema_ver - incremented every time schema...

My wife wrote her own utility to compare two databases. Then I built on it for myself and used when ERwin was not available. It is easy considering that everything...

Here is a complete test code for the pubs DB. You need to name the "calculated" column in the view explicitly:

create view vw_test as

SELECTCASE qty

WHEN 0

THENNULL

ELSE1000 / qty

END...

SELECTCASE col_2

WHEN 0

<bla-bla-bla>

ELSEcol_1 / col_2

END

FROMtbl_abc

Sometimes we just have to accept the behavior they provided and hope it is not going to change in the next version.

I would avoid using trigger as hard as I...

You may consider using ERwin (AllFusion) to find all the differences between two databases and generate code that would syncronize them. As far as I can tell from my experience,...

Use the sp_start_job system stored procedure for it. Look for help on it to find the details and other procedures that deal with jobs.

Michael

I agree with those who realize that a great developer does not become a great manager. Those are two different creatures.

The problem is an assumption that to advance in...