thanks that worked 🙂 now to move onto the other side, and find out how to get this dang .cmd file to read all the files in a folder directory,...

ahh i gotya, but sadly that would require a link server, and for security purposes, they don't want to link servers 🙁

but that would be a good idea,...

Hey Wendy,

I had a problem similair to that a while back, one thing i did and hopefully this helps, i used a update select statement... or select update...

Thank you everyone for your input, turns out there was another transaction log backup being done... guess as they say, to many hands in the cookie jar?

after i turned that...

Hey Richard,

thanks for the info, i will make sure transaction log backups are disabled on primary, i dont think there is any on the secondary, but i will double check......

Hello Everyone,

hope this error message helps to narrow down what might be wrong, sadly it doesnt help me, i am not sure what to do 🙁

Message

2016-12-27 13:00:02.10*** Error: The log...

ahh yes big thank you 🙂

Thanks Gila for the reply back, just wondering, why would we ignore any page count under 1000? again this for the info.

thanks JustMarie for your input, what and how do i create the configuration file so i can tell it the says FALSE for the "Run64Bit" thing? again its got to...

Hey Spiff, thanks for helping 🙂

Yes this is an actual local drive, its not a mapped drive or anything. The only thing that frustrates me more than anything about my...

hmm, so I think i am catching what you are throwing, I can loop all the ID's, then later add the descriptions to it, after the explode part... will removing...

You are correct SQLGuru, sorry a little background, this is a Exploded BOM Tsql statment that i loop through, finding on the parent child etc. for all parts related to...

Hello,

sorry but here is an update, so i am inserting 1014193 rows, and it made a 175gig temp db data files grow, i am trying to figure out if there...

Thanks for the reply Eric,

we ran into an issue were the store procedure that gets used a lot, was causing the SQL server to peak performance, only after our sr...

Got ya thank you Luis and sorry for the late reply,

so here is another question then, not sure if I should open another forum, but its related to the same,...