Aaron N. Cutshall (9/12/2011)

---

So am I. Having paid into government programs & scams all my life (taxes, Social [in]Security, medicare, FUT...

Aaron N. Cutshall (9/12/2011)

---

Dave, I beg to disagree. As an HIE, while it is important to have APPROPRIATE access to APPROPRIATE medical records to provide the services that we...

"Trusted" means that the credentials of whoever is currently logged in (you) running the program will be used to connect to SQL Server. I have never actually tried specifying a...

bcp won't convert direct to those formats. You would have to export (to say, CSV) then import into those other databases.

Another option is to write your own conversion program...

okay about you not being able to do anything with the rest of the code. I am still curious as to why you need to update stats every day... usually...

try using a try - catch scenario. That is, do the update statistics in the try and in the catch detect the 1205 error and retry if it indicates the...

The defense rests.

Only issue...

You need two inserts in a transaction to do this correctly.

First insert the necessary parent rows into TableB (I assume one of the columns of @TV) then do the insert...

I don't think the difference would really be measurable, especially in terms of some process you do once a day. Having said that my vote would be to truncate then...

I assume you are running the sqlcmd's from a batch file ?

after each sqlcmd use : IF ERRORLEVEL 1 goto ......

which will evaluate to TRUE for any non-zero...

bill.saunders1 (9/3/2011)

---

Asking where I park is like asking me where they whip me when I get to work. One hopes that the rising price of gas will make people...

Those of us who drive motorcycles to work get to park in a couple of spots right next to the building under some great shade. I parked there today...

I thought you were referring to the transaction log. You can compact the database file also if it is larger than you need to hold the data currently in there.

Look...

The log file must be large enough to fully contain the largest transactions between checkpoints. Once you system has reached its normal throughput you can shrink the transaction log and...