SQL Server 2000 is "Terminal Services aware" while SQL Server 7.0 is not. That goes for their service packs as well. I believe I read it in one of their...

Just a small point. Aliases are provided for backward compatibility. How long that will stay around is a good question.

K. Brian Kelley

http://www.truthsolutions.com/

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

I would go with #1.

#1:

1 Operation to read all rows > #

1 Operation to update a single row

#2:

1 Operation to read all rows not flagged

1 Operation to update all rows...

Found it:

http://www.sqlsecurity.com/DesktopDefault.aspx?tabindex=1&tabid=2

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

Also keep in mind this stops the "only curious." Granted that's probably 98% of the looks. However, if a sysadmin wanted to get at the data, he or she would...

You mean master... Syslogins is in master.

Did no one remember the sa password? If so, set the registry key to 2 as suggested and you can log in as sa....

Mine may be that my mail server no longer is accepting the forward... I'm going to repoint my profile temporarily.

K. Brian Kelley

http://www.truthsolutions.com/

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

Haven't gotten one in a long while. actually, no mail to my sqlservercentral.com mail address. Not sure if there's an issue.

K. Brian Kelley

http://www.truthsolutions.com/

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

You can always ensure a password is asked for on a restore if the backup has been password protected. However, there is no way to force the password on the...

SQL Server MVP Vyas Kondreddi has a couple of articles on federated databases on his website. Here's a link to one of them:

http://vyaskn.tripod.com/what_are_federated_databases.htm

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to...

Yes, but it was in an emergency situation where the second node was dead. Worked with some great folks from Microsoft's Rapid Response Team to get it back up over...

Transaction log shipping is not real-time. It works basically like this:

1) Server A takes a transaction log backup

2) Server A copies the backup to a share point

3) Server B picks...

It depends... some teens have a very good relationship with their parents. Others don't. Can't speak as a parent of a teen but I can speak as someone who worked...

Out of curiousity, is the SQL Server running under the LocalSystem account or is running under a defined Windows account?

K. Brian Kelley

http://www.truthsolutions.com/

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

Need some clarification on your setup here because there are some things that seem a bit confusing.

This is to clarify NT 4.0 versus Active Directory:

1) Are you still using Windows...