9.00.3042 had a bug where a maint plan would only run against the first database listed.

fixed in 9.00.3054

http://support.microsoft.com/?kbid=934458

consider applying Cumulative Update #3 (August 2007). KB ;939537...

you are on Xeon processor - so i am assuming 64 bit SQL Server installation as well

- if you have not done so far, implement "Lock pages in memory" for...

What failed? SP2 or 9.00.3050 ?

you can re-run the failed patch/or SP2.

Put your wish to SQL Dev Team @

https://connect.microsoft.com/sql

can't see ur image files

Applications such as ASP.NET use connection pool. so any website session can send any TSQL query on any of the connections that are pooled.

To ensure that the current page...

Try this.

0. run update statistics with fullscan on all tables involved (by means of PK/FK)

1. run a sql profiler trace before running update. include execution plan events (showplan...

SQL Linked servers uses OLEDB.

Create a test.udl file on your box, use that to create an OLEDB connection string. And create a Linked server with that.

Check sybase's documentation for...

- get an account that can access the given share. say domain\usera.

- start SQL with that account

or

- write a procedure in SQL that calls

xp_cmdshell 'net use...

SQL 2005 - XML way

select col1, stuff( ( select ','+ col2

from tab1 t1

where t2.col1 = t1.col1

for xml path('')

),1,1,'')

from tab1 t2

group by col1

order by col1

SELECT TOP 100 'CREATE NONCLUSTERED INDEX IX1_' + object_name(c.object_id) + left(cast(newid() as varchar(500)),5) + char(10)

+ ' on ' + object_name(c.object_id)

+ '('

+ case when c.equality_columns is not null and c.inequality_columns is...

PAGEIOLATCH_SH simply means that the SPID is waiting for some page to be brought into memory (from database files on disk).

Investigate if your IO is a bottleneck. or see...

A BLUE SCREEN (popularly called bugcheck ) is a fault occouring in Windows Kernel mode.

Any user mode process such as SQL (or a notepad or any) CAN NOT cause...

There is some misconception arounf this Scheduler error message.

Simply said, one of the SQL Server thread was executing a function call and did not yield within 120 seconds.

The...

when procedure was taking a longer time from web site, what was the waittype / waittime of that SPID in sysprocesses ?

was it blocked by some other SPID ?...