Another has SOS_SCHEDULER_YIELD

MISCELLANEOUS

I used DBCC DBREINDEX which from what I have read, rebuilds them. I have also been looking into latch waits but I am not sure what I should expect from...

I have indexes on most lookups and they were reindexed earlier today. The problems still exists.

Thanks for the input everyone.

I ran DBCC FREEPROCCACHE and was able to get the command to run.

Good calll, I had to delete the last four rows that had been inserted because they contained a %.

Thanks!

I'll take a look at my weekend logic but I have tested it and compared it to just counting by hand and it works fine.

If it's 40 days...

(40...

I forgot to remove the @weekends variable. You can ignore that.

So far my equation works for what I need and I can change it later, the most important...

Apprently string concats are + and not &

I thought this is supposed to be VB.NET?

I can do it with an Active X Script Task.   Thanks guys!

Your source data was data type text? I may have to look at my source again.

The error was converting the data conce it got to the int columns. I'm...

In the data conversion task I tried to do a SUBSTRING(data,16,1) and the next column gave an option for the data output type which I chose DT_I1 but that doesn't...

Definately still run the Analyzer to detect any features that you currently use that are deprecated. It also wouldn't hurt to run some .trc files collected from your production server...

Have you tried connecting using the IP Address? Such as 192.168.1.101\InstanceName ?