In SQL Server 2008 there is a permissions VIEW SERVER STATE. What rights this permission give to user? What SQL Server mean by SERVER STATE?
Is it "safe" to delete any of the subfolders in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\
from my drive to free up space?
Or is it needed for upgrade/uninstall and other patches? Right now the Update Cache
folder contains KB968369 (sp1) which takes up 416mb, which seems like a candidate for freeing up space.
I have tried installing SQL Server 2008 multiple times on my machine, and I always receive this error about 3/4 of the way through: '' is not a valid login or you do not have permission.
I use SYSTEM user for install, when i try to use my admin login/password installation manager shows other errors.
Is there a way to find out the progress of DBCC SHRINKFILE
statement?
Here is how I was running it
dbcc shrinkfile('main_data', 250000)
I am running above statement on both SQL Server 2005 and 2008.
[UPDATE] Here is the query I ran to check the progress and the text that's being run.
select T.text, R.Status, R.Command, DatabaseName = db_name(R.database_id)
, R.cpu_time, R.total_elapsed_time, R.percent_complete
from sys.dm_exec_requests R
cross apply sys.dm_exec_sql_text(R.sql_handle) T
How do you add an administrator user to SQL Server 2008?