This is a particularly alarming statement:

quote:

---

I have a stopred prodedure with a transaction in it , which includes some static and dynamically...

If you're following Microsoft's recommended security document (assuming you're using IIS), your IIS box basically doesn't talk via UDP and you limit the TCP ports to what the web server...

When you say you'd like to mix the two queries, I'm thinking you want to take all the rows in SQL Server that aren't found in the progress database and...

Also, how are you configured to talk to that server from the client? Named Pipes or TCP/IP? Make sure in Client Network Utility that TCP/IP is set higher...

Here in the US, though, certification isn't a guarantee of skill. We saw a trend where the bootcamps were getting very successful at training people to pass the exams,...

For the first part, a string > 4000 characters, you've always got the option of the text data type.

As for union, the sort is going to be on...

We don't have any of the commercial packages, so I ended up writing a DTS job that checks once an hour for servers in a given list. It tries...

About the only thing I've found that even comes to close doesn't really. However, you may have a look at the operations guide:

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/default.asp

K. Brian Kelley

bk@warpdrivedesign.org

I believe the limitation in 6.5 for varchar was 255. It increased to 8000 in version 7.0. So you can't explicitly increase the varchar size past the limit.

K....

That's what it must be. I think I'm still on SP1.

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

Yup. My goof. My brain processed ROWCOUNT because he wanted n rows.

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

Stand-alone:

Profile created in Outlook for the same user account that runs the SQL Server service. Outlook can be used to send and receive mail.

Deno, it sounds like...

Have you gone into the Server Network Utility on the boxes and set the default ports for the instance(s) involved?

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/