The memory manager in SQL2K is supposed to handle memory across multiple instances reasonably well, but to be honest, my shop has not put it to the test. We have...

SQL Server 2000 is a cluster-aware application if you want to use Windows 2000 Advanced Server and cluster it. We do that for several Active/Active clusters where I work. Brian...

Check the database compatibility in the database properties It's probably set for 65 (SQL Server 6.5). TOP wasn't a valid keyword in SQL Server 6.5.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish...

The main reason I don't like the anonymous account is because it gives users behind the firewall access to the SQL Server unless you firewall it or put ACLs on...

Oh wait, you're running an EXEC command inside the stored procedure? If so, then the EXEC command actually executes the command in another batch... new batch, automatic permissions check.

If that's...

Was the debugger installed on the server during the install? Also, do you mean sysadmin as opposed to dbo rights?

K. Brian Kelley

http://www.truthsolutions.com/

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

Steve's second approach, with matching Windows users (passwords, too) on both web server and SQL Server is what I'd recommend. There are some weaknesses with SQL Server logins, susceptible to...

A small clarification:

If the stored procedure references an object (table, view, user-defined function, another stored procedure) and both the calling stored procedure and the object have the same owner, permissions...

Yes, SQL Server does, but through the Tabular Data Stream protocol (also used by Sybase). If you look at a network frame you'll see the raw data. But this isn't...

You cannot depend on the recordset coming back in a particular order unless you specify an ORDER BY clause. Generally, you'll see behavior where the order comes back matching the...

I have a Getting Started page on Perl. I've also listed some of the books you'll want to look at to get started. The Learning Perl in Win32 Systems is...

Easiest way to think of it:

With a join I put the data in two tables side-by-side. However, since I determine how the rows match up (table1.col1 = table2.col2 for instance),...

There was a PK and there was a clustered index. The clustered index changed due to an analysis of usage in order to provide greater performance... developers' stored procedures didn't...

One of the concepts about relational database theory is you don't assume any specific ordering unless explicitly qualified by an ORDER BY clause. Our development group was tripped up by...

I give. Why is someone with a non Red Gate email address advertising Red Gate's software? Especially when Red Gate has purchased ad space on SQLServerCentral.com...

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to...