you can create a script of the existing job by right clicking on the job, then 'All Tasks' the Generate SQL Scripts.

When implementing a 4node cluster, you may also consider your OS. I think Win2K Advanced Server supports only up to 2node. You have to go to Datacenter to...

SQL Server will try to shrink the files when found out that the files has about 25% of free space during its periodic checks (checkpoints). It also reduces the...

quote:

---

I wonder if anyone can help me decided the best coding to choose for this job

Insert into tablec

Select a.col1, a.col2, b.col1, b.col2...

what is the package trying to accomplish?

I run into similar problem when trying to call a oracle script using sql+ from DTS package. I forgot 'exit' command...

I think the error is undocumented. You may want to send the erorlog together with the stack dump file to Microsoft.

if the table is small, then dts package should be ok, but you may run into issues in the long term.

if you have only select privilege on the...

I prefer using bcp specially when inserting millions of rows.

he deleted all the rows, so i dont see any problem with reseeding it to 1.

I am no very sure but I think temp tables are not permitted on the DTS packages.

you can verify it for yourself.

look for any process that is blocking your transaction.

you may want to change the way you are recreating your table. try creating the target table schema with your additional identity column first, then move the data using 'insert...

I would suggest to put the indexes back once all the data are loaded. doing it this way will yield better performance.

I already encounter the same problem and what I did is I shrink the file in a small chunk. On my case, I shrink it by 1GB at a...

quote:

---

Is there a way to check what happened to a specific database at a particular time? Are there any logs? ...