Implementing data access control in this manner is considered a security best practice. Ownership chains were put into SQL Server for this purpose.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to...

More of a semantics issue... Using Profiler works if you can be in place prior to the install. However, if the install already occurred or the vendor did something like...

So far as I am aware, the BOL install is completely separate from the SQL Server binaries.

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

Speaking of which... latest version of Books Online:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Get it as it corrects a lot of errors and also covers the changes made in SP3.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide...

The script is for SQL Server 7.0 because it resolves an issue where the log shrink was a deferred operation in SQL Server 7.0 The behavior was changed in SQL...

INF: TCP Ports Needed for Communication to SQL Server Through a Firewall

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

INF: Replication Setup Over a Firewall

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

To avoid risk, set the SQL Servers to communicate with each other directly, specifying...

Yes, you can do this. After you've renamed the second server at the operating system level, you'll need to perform the steps found in "Renaming a Server" in Books Online....

Excellent!

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

quote:

---

And besides a competitor can always just write their own version by studing the functionality of yours and not really have to...

Can you post the last ten 10 lines or so from your sqlsp.log? Typically it's in C:\WINNT\ or C:\WINDOWS\ or wherever your system root is.

There was a problem in SP2...

Unfortunately, competitors who want to figure out how your code works will disassemble, use profiler, etc., to do so. The key is to do as much as is reasonable to...

Are you using a Named Instance (Server\Instance Name)? MDAC 2.5 and below doesn't support them unless you use an alias and manually specify the TCP port.

Also, is your server listening...

Yup. That's what I was getting at. Here's the KB article that describes the issue:

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

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

I haven't done any extended stored procedure development myself, but I do know Microsoft has a HOW TO: Knowledge Base article on extended stored procedures. There are some things about...

Connecting via Exchange isn't the same as logging on to the domain, unfortunately. You actually would have to add the workstations to the domain and then have the users also...