This reminds me of the emacs vs. vi debates we used to always get in on the Unix side. I use Textpad heavily because it does...

The duration column for audit logout is the total duration of the connection. It's not the time it took for the logout operation. So if you have a connection that's...

It means to add-on to what you said.

It comes from a "piggy-back ride." When kids ride on an adult's back (child's legs around the adult's waist, child's hands/arms around the...

To piggy-back on Frank...

SQL Injection is basically where an attacker can "slip in" another database command on top of a legitimate one. This is typically done against web sites. If...

I have to agree with Mark on this one. I've watched people intentionally not listen to my mother because she was Japanese. It didn't matter that she was speaking perfectly...

quote:

---

I think the BULK INSERT statement is a good substitute to bcp.

---

From a performance perspective,...

As a workaround, you could grant SQL Server logins (I know, I know) and have those SQL Server logins own the jobs. I don't like that solution but if you're...

I know there was a change in TargetServerRole as of SP3. I'll need to compare permissions between the SP2 and SP3 instances I have for testing. That might be the...

Is this within syscomments or in a user table?

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

What service pack is your SQL Server 2000 install?

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:

---

Inattention using master..xp_cmdshell can seriously endanger SQL Server security

---

This article rightfully points out that...

I know there were some MDAC issues with the 2.7 version that came with XP. SQL Server 2000 SP3 put 2.7 SP1 on the SQL Servers. Have you tried upgrading...

Ask your system administrators whether you're on Active Directory or still using NT 4 domain controllers exclusively. From there, they should be able to help you with delegation. The user...

Read this first:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;329329

There is a work around for installing clusters. It's another KB article.

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

Or put a very small tickler file (a few bytes) that transfers right behind it. The tickler file serves as the semaphore to tell you the other file is done.

K....