Have to agree with Sergiy on this one.

And with all that having been said, you DON'T want to be shrinking the transaction log after every backup. You just force SQL Server to make it grow again...

With no code, no idea of the data involved, my swag is both will take...

1. Have you verified that the schemas and indexes are identical between databases.

2. Is there any difference the number of rows being insert between the databases.

3. Read...

Garadin (10/31/2008)

---

You don't need a loop, or a cursor. All you need to do is:

1. Create a clustered index on your row# column. (It is most likely...

Also curious, how big was the database you lost?

Making a guess here about nvl...

This:

sysdate between org.effective_start_date and nvl(org.effective_end_date,sysdate)

would be this:

getdate() between org.effective_start_date and isnull(org.effective_end_date, getdate())

what does this do: nvl(org.effective_end_date,sysdate)?

paul.starr (11/3/2008)

---

maybe its this line i have commented out:

how would i write this line:

--and between GetDate()org.effective_start_date and GetDate() org.effective_end_date

data types

EFFECTIVE_START_DATE ...

As you are converting from pl/sql to t-sql, is it safe to say you are also porting the database from oracle to sql server? You provided the data types...

Something is missing somewhere. I don't see anything that would cause this conversion error: Error converting data type nvarchar to float. The only non-character data type is ca.account_established_date,...

What version is MSDE? Can you connect to it with QA? If so, do this: select @@VERSION and report the results.

Here is a starting point: BOL (Books On-Line).

Lookup the following:

sys.databases

sys.tables

sys.columns

sys.types

Missing the data types for org.known_as and ca.attribute3.

You can do this by one of two ways, backup/restore or detach/attach.