1) Nope. It's the new security settings.

2) Again, check the security settings. The full text agent id must have domain rights.

At minimum, select

SQL Server Database Services

Workstation components, Books Online development tools

Use the built-in system account

Have all three start up

If you find you want the other parts later on, you can...

You want the x86 version. The rest of the process is fairly simple. If you have any specific questions feel free to ask. The more specific you...

If you post the code you're using, we might be able to help.

In the meantime, you might want to check out this link and the referenced resources:

http://www.karaszi.com/SQLServer/info_datetime.asp

My PDA/phone came with Bubble Breaker. That's become my commute-time amusement in addition to the old standard Solitaire. I'm thinking about finding some new games but just haven't...

Replace the CTE with a temp table including an identity column. Insert into that with an order by and then query the temp table.

Have a look at the ROW_NUMBER() function.

Something like this:

with er as

(select ROW_NUMBER() OVER (ORDER BY HireDate) as rn,

HireDate,

EmpId

from EmployeeTable)

select rn from er where EmpId = 1001

What kind of jobs are they?

Have you tried stopping and restarting the Agent?

Other than that, I'd try KILL of the GUID.

Beyond that, I don't know.

Do let us know what you...

What's the request_session_id?

KILL 'TheGuid'

GO

KILL 'TheGuid' WITH STATUSONLY

GO --to check the status of the rollback

works just fine in QA

There's a resource_database_id column in sys.dm_tran_locks. Just filter to your troubled DB....

What is the data you're getting back? It's possible you have orphaned transactions (which don't show up via other routes). If that's the case, you'll have to kill...

See if you've got anything hanging out here:

SELECT request_session_id, request_owner_guid

FROM

sys.dm_tran_locks

Have a look here:

http://sqlblog.com/blogs/kalen_delaney/archive/2007/10/09/geek-city-detecting-overflowing-columns.aspx

for some discussion on the storage/usage of overflow columns (which is what you're talking about).

? Nothing you've said should stop you from running Upgrade Advisor. It's independent of a 2K5 install.

Upgrade Advisor is designed to run on a 2K machine. Either...

One thought...

SQL Server 2005 handles stored procs differently than in 2000. Essentially 2K5 verifies dependencies at install time rather than at execute time (as 2000 did). So, if...

There's a prior thread here somewhere about running in compatibility mode. In a nutshell, there are some issues with it.

Run the Upgrade Advisor against the database and see what...