also take a look at sp_msforeachtable

e.g

sp_msforeachtable 'exec sp_spaceused [?]'

that link is good tells you the cause and how to work around it

you need to read the error log, either the SQL error log or the windows error log...

take a look for the performance dashboard reports for SQL 2005

also on a side note, this is the 2008 section, you will get the...

full text catalogs are not tables, they are usually stored on their own filegroup

so as the error states take a look through your error log to find when the filegroups...

what information do you want, how big a table is in terms of its storage?

there are the reports at db level which gives that kind of information

right click a DB,...

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...