I looked at it and found nothing. I had the server engineer group look at it and they found nothing. I even rebooted it and did the file...

Yes it is scheduled through SQLAgent. The job says it is successfull but when you go into the job and look at the steps they all say successfull but...

I would agree, process of elimination is the way to go. See if you can shutdown your AV services and disable them and watch to see if that last...

Rebuild your indexes on a somewhat regular basis, defrag the hard drive if possible, look for tuning indexes and keep stats up-to-date. Those things will help out performance as...

Very interesting topic! I have only been to old and new Cleveland Indians and new and old Cincy Reds. The old ones were... concrete bowls to get...

I know. The ID I was using is a full admin to the server too so I did not understand. However, when you open it up as RUN AS Admin...

I faced this EXACT issue two weeks ago. The resolution I found myself was that when you goto CMD prompt do not just open it, right click and say...

Consolidate from our standpoint has resulted because of this situation. A handful of SQL Servers we had here that were underutilized for two different reasons. One was that...

The age old topic... support support support..... We have apps that do not uspport SQL 2008 yet so we are stuck on 2005. It takes time when you...

OK, thanks. I did not know that it was depreciated in 2005/08.

Couldn't one just 'pin' the tables in the specific database and that would hold them in memory? I have never done this but I have heard of it.

Yes, I have said that for years. You DO have to have the talent. I could not hit 400 or 500 HRs. I also don't blame the...

The timing is interesting. I think it has more to do with him now being a coach for the Cardinals. He was going to be hounded by reporters...

Oh yes, understood. The table was empty and apps. folks wanted it changed to be auto-increment.

Great, thanks a million to both of you. I found the option, Designers, Table & DB Designers Prevent Changes, removed check in box and I am able...