In addition to JDBC drivers for SQL Server, there are ODBC drivers that run on the *nix systems, too. If you're looking to have a script, this is ideal because...

You'll need to verify the port the remote SQL Server is listening on and makes sure it matches. Also verify both server and client are using TCP/IP as a network...

If the stored procedure prefixed sp_ (whether sp_RunMe or sp__RunMe) is in the master database, no, there's not a performance hit. The reason there's one in the first place is...

You'll need to find some storage solution that both systems can connect to. They are called anything from RAID towers to shared storage arrays to external storage arrays, what have...

This is a work around and I'm not sure the performance hit is worth it. I'm going to assume you're still updating the index on a set schedule, not on...

Sorry it took so long for me to get back on this. Been real busy at work with two back-to-back 13 hour days. Here is a KB article that describes...

Here's the KB article that describes what you are seeing:

http://support.microsoft.com/default.aspx?scid=KB;en-us;q243352

There is a trace flag you can set to prevent these messages. Basically, when ever MSQuery connects, it issues a SET...

What version of IIS?

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

You are correct, NTLM does not support double-hop, period. That is by design in the security mechanisms.

Kereberos supports delegation, but you have to do the configurations on users/servers/etc.

If you are...

If you need to keep backups of your transaction log (there are a lot of factors that determine this), then you can stay in full or bulk logged recovery mode....

Do you mean Verisign instead of Veritas? Veritas makes backup software. Verisign manages domains and is a trusted root certificate authority.

As for Basic authentication... If you install a certificate and...

Is the SQL Server Agent running under an NT account. If so, is this computer still in the domain?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring...

This one is much more critical to client systems. If you're not connecting to the Internet and your SQL Servers aren't Internet facing, you probably want to wait a few...

I'm not seeing anything come up in the MS KB and it's not a situation I've come across before. I thought there was a Russian company that came out with...

That path of options is only available for SQL Server 7.0. If you want to get the SQL 2K transaction log down, here's the KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;272318

Basically, you first execute a...