Thanks, i was using this technique for a while, what i couldn't figure out it how the resultset of all these servers can be store in one table in one...

Finally worked....

sqlcmd -E -i"install.sql" -r1 2> install-err.log 1> install.log

Thanks Gordon....

Has anybody used -r flag, i coudn't find any method to use it though...

and no pointers on google also to use this error trapping method....

any help appriciated....

Try this...

SELECT

user_key AS User_id,

update_date AS createDate

FROM accounting.dbo.user

WHERE user_key IN

(

SELECT

DISTINCT CONVERT(INT, RIGHT(vendor, LEN(vendor)-1)) AS user_key

FROM Prod.dbo.return_vendors)

AND update_date is null or update_date > GETDATE()...

Noel pointed out right its a very good idea to partition the table right away and then insert data in batches based on partition keys....

I used it it a little different fasion: if you are not able to fix it then you can use this also...

procedure stores data in a temp table and then,...

top reason to use select into is to avoid logging...that makes it very fast

Use global temporary tables and outside transactions you will never lock tempdb, no contention issue....

Its using normal...

Thanks Jeff, I was...

PW (4/30/2008)

---

The command is

DBCC Log('YourDatabaseName', 1)

(2nd parameter is level of detail).

Run:

Backup Log YourDatabaseName With truncate_only

Checkpoint

The DBCC results should show only 2 entries

Now run your insert statement. It shouldn't take 10...

Michael Earl (4/30/2008)

---

Do you have an application that will allow you to look at the contents of your log file? If you do, look at what is logged. ...

Michael Earl (4/30/2008)

---

You have a table that has a single integer field and it is a heap.

Every time a transaction is logged against this table, it has to include both...

PW (4/30/2008)

---

Are there indexes on the table being inserted into ?

Are there triggers on the table being inserted into ?

Are there any indexed (materialised) views that reference the table being...

Jack Corbett (4/30/2008)

---

I'm going to throw a guess at this one. You have autogrow on the database and the autogrow process is causing the log file to grow. ...

Excellent article, being relatively new to replication I found it very useful....

George sibbald suggested method will work fine, stop sql, backup system db folder and restrore msdb files and start and see if it works, otherwise stop and replace whole folder...