SQL Server 7 has the multiprotocol for encrypting the datastream. Books Online should have the information about setting up both the SQL Server and client to use this netlib.

ADO doesn't...

Yes, it can.

Think of a trigger in this instance as a specialized stored procedure. Using a three-part naming convention, you can cross databases. An example of the three part naming...

Can you post the code around and including where QA is telling you there is a syntax error?

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

Use Profiler. You can track who, when, what they did, and what application they used. You can also filter to ensure you only get the database in question.

Write the information...

If you are going through Enterprise Manager, remember that it has to check each and every object for permissions with regards to that role. That's how it's able to display...

If you have a clustered index on a table, you can recreate it on a different filgroup. The data is physically stored in the clustered index, so you'll be effectively...

try telnetting in. From the command line:

telnet <IP address> 1433

If you get a connection refused, it's likely they are blocking port 1433 at the firewall.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish...

Did the IP or the port change? Was it a clustered instance?

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

The first is rather easy. Take a look at the syscolumns table. I'm not at a system where I have access to a SQL Server right now, so you'll need...

Take a look at the following article. It explains how to do it in Dynamic SQL:

http://www.sqlservercentral.com/columnists/rmarda/dynamicvsstatic2.asp

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

Profiler is probably a better option. A trigger can't be put on a SELECT statement. However, some parsing is going to be required.

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.truthsolutions.com/

Without knowing how some of the results are calculated, we'll be taking stabs in the dark and hoping we're right. Can you post a bit about how the columns which...

You didn't say what OS you are using. You can control who has rights to log on locally.

If you are using Windows NT 4.0, bring up User Manager and point...

You'll need to use a second ON to set the filegroup. For instance:

CREATE INDEX IDX_MyTable_TheColumn

ON MyTable (TheColumn)

ON MyNewFilegroup

Here's the link to the Books Online page which...

quote:

---

It's the system guys! Don't start adding variables such as patches, etc. but rather did deeper as to what environmental system changes...