riya_dave, please accept my apology. I have obviously said something that you did not appreciate, and...

Thank you for the vote of trust. Unlike the author(s?) of the CLR String Splitter, who no doubt spent a non-trivial amount of time developing, testing and tuning their object,...

I do not, but I would be happy to mock up some test data and run some tests. I used...

capn.hector (5/11/2012)

---

i believe only when used with CREATE DATABASE. all the DB's we created...

Could be. I did not think SHRINKFILE was sunject to the 'initial size' issue though.

OK, I am with you now. I would run a Trace to see what SSMS is doing. My guess is SSMS does a SHRINKFILE w/ NOTRUNCATE first to bring all...

In a database-level audit I think your options are limited. All sysadmins are mapped into the DB as dbo.

You could run a Trace and filter on the SessionLoginName. This is...

capn.hector (5/11/2012)

---

this comes to the differences of creating a database by a script vs SSMS. we are moving servers and when moving to the new server we are making...

annastassia1935 (5/11/2012)

---

Yes there is resistance. However, I read on this site that it may be better to store the varchar(max) field in a separate table rather than appending it...

CptCrusty1 (5/11/2012)

---

Nah... it was the Texas comment. You'd really love it if you knew that I grew up in Southern CA....

Too basic for you?

CptCrusty1 (5/11/2012)

---

PLEASE... I like SNARKY comments...

Since I have ya'll's attention. Can ya'll recomment a good starting point for more advanced SSIS schtuff? Reading material, things to try,...

Welcome to SSC!

CptCrusty1 (5/11/2012)

---

---Although, don't think I'm ungrateful... I'm always grateful to those with more knowledge, experience, or...

Wow, lazy, sarcastic and ungrateful. Nice combo Cap'n 😛