cengland0 (8/28/2009)

---

This one caught me too. In 2000, it was a table but they switched it to a view in 2005 for backwards compatibility. The question specifically asks...

I had a nice long reply going and apparently there is a session time out enabled which...

Thanks for the info...just one quick comment

wouldn't 1 & 2 be taken care of if I ran...

Lamprey13 (7/24/2009)

---

I can't answer your question directly as I do not have much experience with linked servers, and frankly I do not like them. But, you might want to look...

Hi Gail,

There are regular scheduled maintenance checks performed nightly on this server and all have been clean.

I spoke with my boss regarding this issue and he said it happens as a result of the combo of SQL 7 and the manner in which this process is...

I am holding off for the moment...

The calling database was very small (300 mb's) so the DBCC command went pretty...

got it figured out...basically I didn't figure out how to work 'as is' with calling the bat file directly...

What I did do is have to go into the .bat file...

Lamprey13 (5/15/2009)

---

Berry had some good suggestions. Those "catch-alls" can be nasty. I just did a quick glance and didn't see a real reason why this is all dynamic. I'm sure...

OK so I took a step back and decieded to re-review everything involved and decided to do the obvious and evaluate the tables with a DBCC showcontig and get an...

Hi Barry...

Let me start by saying thanks for looking at this question and giving a great answer...I didn't even catch that portion of the code...I was fixated on the UDF's...

Here is a sample of a file that would not function correctly when I imported it on a fresh re-install of SSMS 2005 SP3 on my laptop...

I couldn't see anything...

Steve Jones - Editor (4/27/2009)

---

Lee,

Thanks for the update, and that is strange. I wonder if there is something weird in the XML file that contains the configuration.

Perhaps some weird connection...

Jeffrey Williams (4/27/2009)

---

I would look at WMI settings on the server and the laptop. SSMS uses WMI to connect to the server and to perform service start/stop etc...

I have...

Hi Steve,

I think you were right...something must have been borked on my laptop or at least I think it is...

I went to a different server (only thing I had available)...