Awesome GS thank you for the post very good info.

Always a great feeling. hahaha

Most likely i would have Powershell control it and call a SP in SQL kinda of the best of both worlds. My job is more sys admin than DBA and...

Jeff Moden (2/16/2012)

---

cw.izatt (2/16/2012)

---

After thinking...

First question, What account does it run under when scheduled? any ideas on what piece is failing? My thought is that it is a permission issue and that is why...

After thinking about it either...

Please give more info, but why would you use a loop for something like that?

I agree with above, why handle all of that inside SQL?

Jeff Moden (1/9/2012)

---

@cw.izatt ,

Did you actually check for an absence of FKs or just an absence of PKs? I ask because UNIQUE constraints will suffice for the instantiation of...

I will give a really good example: we recently installed imaging software from one of our vendors and when i was trying to check to make sure all of our...

Just as a note, make sure you spec out the server for growth meaning don't short your self on spindles and ram you might need a year from now.

I will add I am new to SQL and been at my sys admin job for over a year now and I have full control over our databases. I am...

these might help

http://www.thewebsiteisdown.com/

Lowell (6/23/2011)

---

ok, BULK insert's about a zillion times easier to use than SSIS.

your original table definition that you posted is missing two columns that appear in your data, country, and...

Welsh Corgi (6/23/2011)

---

dji (6/23/2011)

---

The SSIS method would require learning a whole new language by the sounds of things? My only experience with SSIS is through the wizard which offers no...