SSMS about 95% of the time. I find it easier to use. I wish that SSDT was more similar to SSMS because it makes sense to use it...

That's perfect. So simple.

Thank you.

Yes, its being caught by our application. Yes we are on new hardware. We moved SQL and our applications to Windows Servers 2008 from Windows servers 2003.

I dont think its a firewall issue. The timeouts are random (as far as we can tell). During the day we may get 50 to 100 transactions that...

Thank you both for your reply's. It sounds like developer would be the route to go. Sorry about the Server 7 forum. I found a similar post,...

Good Article. I started out my career back in the 80’s as a maintenance mainframe programmer and I still work with existing systems both mainframe and web. ...

Great, Thanks. We were thinking that here also, but wanted to make sure we understood what the numbers were telling us.

Eugene,

First Thanks for your time. I was able to take your sample and use it for my actual set of tables and it worked great.

I do...

I think I got it. There was another problem with the previous code. The relationships were not correct in the XML code. I had ID's of 2...

Thank you Eugene for your post.

This is very close. The code you suplied returns the following. If you take a look, you will se that the first "Table_1"...

Sometimes it seems that IT is its own worst customer. From what I have seen, we do a good job working directly with our "End User" (or customer), but...

I just tried the max. Close, but not quite working. I am getting additional records. I think the reason for this is the "Group by" clause.

I...