I think I got this from SSC, but I cannot find the link:

-- Written by: Greg Larsen Date: 06/15/2002

-- All rights reserved Copyright 2002

set nocount on

DECLARE @I INT

DECLARE @C CHAR(8)

SET...

- grant the login the needed rights (tables, views, sprocs,fn,...)

- sp_changedbowner 'sa',true

thank you for the feedback.

Glad to see setspn solved your issue.

Did someone rename a service account ???

In that case, drop the login from sqlserver and add it again.

Sqlserver stores Windows account by its Windows "guid", so dropping an account and...

which network protocols are opened for connections ?

keep in mind if you start an instance manualy you need to start:

net start mssql$instancename

- Doublecheck the cluster account

- bring all resources online except for the sql-instance

- Then use 'net start yourinstance', and check the account has login rights (NO sysadmin auth needed !)

-...

Normaly if you want separate rows, perform separate selects or take things in your own hands(meaning you perform positioning yourself at front end)

Still I'd run SQLUpgradeAdvisor to check the db for possible issues with sql2005 compatibility and try to convice the customer to perform detailed testing with SQL2005 mode !

Keep in mind,...

- first of all you have to be sure you've got a valid backup.

maybe even create a new backup using the backup panels.

(tick "validate backup at the end of backup"...

use a query window in management studio

Check out Restore database in BOL.

restore database yourdatabase

from disk='\\yourfirstserver_UNC\path\backupfile'

-- with move if you want to use new filepaths for mdf and ldf

Your...

how about :

select sum(case when condition1 then 1 else 0 end ) as whatevernameyouwannegiveit

, sum(case when condition2 then 1 else 0 end ) as whatevernameyouwannegiveit_theSecond

from yourobject

have a look in the cluster log as well as the sqlserver errorlog file.

(C:\WINNT\cluster\cluster.log)

all service accounts that have a relation to your sqlserver instance need at least instance level login auth.

The clusterservice account ('RTDOMAU\svc-proxy-pclust') just needs login rights to the sqlserver instance...

use yourdb;

-- Based on (class=0,object_id=27199197,column_id=0,referenced_major_id=11199140

select object_name( 11199140 ) as ToBeRevised

, object_name( 27199197 ) as ToBeRevisedToo