We have three clustered servers with their own external storage arrays as well as a clustered SQL Server install where the drives are part of our SAN. The SAN-based one...

You've indicated they are in different domains. Are there any other differences, such as a firewall in between or anything of that sort?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to...

If you point to logical linked server names (based on purpose) rather than physical names, then you would just have to know what logical linked servers you need and create...

Ack. That's true about selecting against anything that starts with john. Thanks for the catch, Paul, and the fix, David. But I agree in that it is non-SARGable. Probably would...

After looking at the other topics in the T-SQL forum, this is actually a duplicate question with a different topic title. Continue the thread in the following discussion:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8474&FORUM_ID=8&CAT_ID=1&Topic_Title=%2D+Syntax+Question&Forum_Title=T%2DSQL

K. Brian Kelley

http://www.truthsolutions.com/

Author:...

Try this:

SELECT

    FullName

FROM Users

WHERE CHARINDEX(fname, @Param1) > 0

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

One thing I'd urge anyone to consider when asking the question, "Why are you writing an article on something that's already covered in the knowledge base?" is the fact that...

Your best bet is to encrypt the username and/or password on the application side. Otherwise, a sysadmin could see it coming across in plaintext using either Profiler or DBCC INPUTBUFFER()....

I'm not sure you can do exactly what you're trying to do in SQL Server 7.0. What Microsoft typically recommends is to run a check every five minutes to capture...

What information are you trying to move from these databases?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

A good history can be found in Kalen Delaney's Inside SQL Server 7 or Inside SQL Server 2000. It covers the difference.

Both use T-SQL, so the commandsets are very similar,...

Yup, and from a security perspective this makes a lot of sense. Consider the following scenario:

Instead of the current behavior, SQL Server searches in the local database first for any...

Oh yeah... tech support on SQL Server isn't very good from Lawson. Apparently, the same is true of Oracle. There are serveral newsgroups on Topica (http://www.topica.com), the most prominent being...

What version of the environment and what version of the application?

Peculiarities:

• Like with PeopleSoft, binary sort order, case sensitive (this isn't a SQL Server default)
• there are a set of utilities on...

No, but I've been working on a series about connecting through Perl. Just haven't had time to put the finishing touches. Might be good to do one on network tracing...