For a minute I thought this was a dup post;-)

Stare

diatribe

Besides the expected result, what is the problem with the result set?

Do you have sample data to go with this problem?

Try this tutorial

http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

You could use a logon trigger that logs the connection to a table.

Thanks for the question.

dup question - post response here.

http://www.sqlservercentral.com/Forums/Topic1181290-1063-1.aspx

I think you mean DDL.

One main purpose of a function is to manipulate data and return the result. That can be done without altering structures. If you need...

NJ-DBA (9/26/2011)

---

eh, I did oversimplify. The problem is that there are a large variety of statments... various delete and selects which are formatted as above. I wanted to...

What is the raid level on your drive? How many spindles? Is it SAN or Direct attached? What is the allocation unit size (8k, 64k other)?

I would recommend trying either SQL Compare by Redgate or the free tool DBDiff from codeplex.

http://dbdiff.codeplex.com/

You may want to check Windows Firewall as well. Also, when looking for the UDP, you will be looking for 1434 specifically.

bopeavy (9/26/2011)

---

Ray K (9/26/2011)

---

bopeavy (9/26/2011)

--------------------------------------------------------------------------------

Ray K (9/26/2011)

--------------------------------------------------------------------------------

No...

Thanks for the question.