SQL_Surfer (2/17/2012)

---

I think i will do a fresh install of 2008 R2; and here will be my steps..Please correct me if I miss out anything.

1) Backup/detach databases from 2005.

2) Script...

speak to SAP and ask which SP is being called

run a profile trace, perform the task and look at the SP's being called

haven't we already had a topic on this

http://www.sqlservercentral.com/Forums/Topic1253238-1550-1.aspx

take a look through your error log as to why the filegroup when offline.

if the error can be fixed, do so and bring the filegroup back online and backup

otherwise change...

not to worry, easy one that, especially for just three characters difference in the SP name

please read through this url, it will detail how to give permission to the SQL service account so it can register/deregister the SPN on startup and shutdown

http://technet.microsoft.com/en-us/library/cc773257%28v=ws.10%29.aspx

and this url

http://technet.microsoft.com/en-us/library/bb735885.aspx

thats to add a user to a DB role, for a server role you need

sp_addsrvrolemember

might want to wrap this in sp_msforeachdb and strip out some of the stuff you dont need

select * from sys.database_role_members drm

join sys.database_principals dp

ON drm.role_principal_id = dp.principal_id

join

sys.database_principals...

You cant create custom server roles unless you have SQL 2012.

You will get that error as the account which SQL is running as doesnt have access to register/deregister the SPN. As pointed out above, if your not planning on...

Might be a good palce to start

http://technet.microsoft.com/en-us/library/cc917680.aspx#XSLTsection129121120120

the only thing that happens is outside of the local scope is the file copy so you should only need file share ports opening, typically 445 would also open up...

first stop the SSRS service

then detach/move files/attach or backup/drop/restore or alter database/stop sql/move files/restart sql

then restart SSRS

with cte1 as

(

SELECT ROW_NUMBER() OVER (ORDER BY [Name]) AS RowId,[Name]

FROM #Temp

)

update #temp

set ID = rowid

from

#temp t1

inner join

cte1 c

on t1.Name = c.name

timestamp is a row versioning method so you cant explicitly give it a value it has to generate it itself, you could set a default but they each row will...