"Autogrow of file 'xyz_DS17' in database 'xyz' cancelled or timed out after 30468 ms."

Please refere to "PRB: A Timeout Occurs When a Database Is Automatically Expanding" at http://support.microsoft.com/kb/305635/

When the client...

This would be easy with SQL Server 2005 using the Window function but for SQL Server 2000, four SQL Statements are needed. For demonstration purposes, the system table syscolumns

is...

First, be aware that "IF UPDATE(column)" is true when the column is being set and not that the value of the column is changed.

With this SQL, which changes no values:

Update...

This looks like a relational division problem.

In simple terms, the solution is that the customer qualifies.

when the count of the customer rows that match the criteria is the same as...

Sorry, the column Monday's date is incorrect and needs to be a variation of Sergiy's Friday algorithm:

if object_id('tempdb..#YWK') is not null drop table #YWK

create table #YWK

(yyyyww char(6) not...

Since Sergiy did the hard part, here is an extention to use year and week:

create table #YWK

(yyyyww char(6) not null )

insert into #YWK

(yyyyww )

select '200701' union select '200726' union select...

Please provide DDL and sample data as described at http://www.aspfaq.com/etiquette.asp?id=5006

Using the CASE seems simplier and a comparison of the executions plans between the CASE versus sub-query shows a significant difference that would affect performance.

select  CASE 

 WHEN n1 < n2 and n1...

Check the older versions of errorlog to confirm that TCP/IP protocol was functioning.  If TCP/IP was not functioning, the SP4 install may have failed (with no error message) and the...

If two kids were throwing water balloons, would that be a war?

Those are mild posts.

Take a look at "Is != still used?" at http://www.developersdex.com/sql/message.asp?p=581&r=5834983&Page=1

Please post DDL...

Yes, I have done this but do not recommend using this approach.

Use Enterprise Manager to create SQL scripts for jobs, alerts and operator by  just right clicking the appropriate icon in the folder view...

For column 22 ObjectType, here are the values:

Here are the values for eventclass

It is on the MS site but I already assembled:

The default location specified in Enterprise Manager only applys when creating the database with Enterprise Manager and has no effect on the database file locations when using the command "CREATE DATABASE".

For...