ok since our connections are read only web connections killing sessions doesn't hurt anything, IMHO. I do use the roll back immediate in my code to alter the DB, but...

Hi -

OK so when I say step(s) you say batch(s) because that is how SQL executes it as batches. As far as the Single User Mode, I took your suggestion...

Hi -

One more follow up question I am trying to understand how jobs really work. When I had this job as 'all in one step' it worked most of...

Hi thanks - that will help with one of the issues we are having but I guess I didn't ask my question correctly.

What I am trying to understand is...

the alter db was an extra step I put in after the switch over to SQL Server 2008 when reading about getting exclusive access. There were a few applications that...

Oh one more point. My input is an OLE DB source, and my destination is a SQL Server destination. My import version had these both as OLE DB and I...

Zach,

Actually when I said changes, I meant the data changes, not any database schema changes. We are updating tables in the database and then shipping those updates across the enviroments.

Joe

Maybe I didn't undertand these responses, I tried restoring the databases with the NORECOVERY option and it didn't work. Any example sql so maybe I can figure out what I...

Terry,

Where is the client? (seperate machine from your SQL Server?) If you are running the exe for the sp on the same machine as the server, that is why it...

thank you

quote:

---

We have a production server that is up 24/7. Right now the properties of the tempdb are set to automaticlly grow files...

thank you. I wasn't how my sql was supposed to be ordered, it worked, so I now I have it for future reference,

I want to add additional data where the primary key doesn't exist. For example, I have PK's 1-100, I have new records 101-150. I want to add those 50 new...