so where is the change required. Can you help me for that. I am very bad at scripting. please

i nhave a script here that was given by a friend but still when run is it creates locks. he told me that this script will rebuild/reorganise indexes online. any...

thanks

thanks a lot all. appreciate that.

but friend once again can get the exact syntax with parameters.

select * from sys.dm_db_index_physical_stats ????

please ...

but i atleast need a query to see size of index in a table. or can we check from the management studio itself?

Thanks bitbucket-25253 the output is what i want but just need to add one column that says table name.

Name ...

any ideas friends?

so where should be the create procedure statement be. sorry for that but i i totally blank.

no that does not work

any ideas friends?

thanks will let you know if that works.

actually this is a job that runs every day i.e backup and restore to a new server. so i cannot create a new backup set every day. actually the new...

where you see the \ is the windows authenticated user.

any idea friends what's going out in the script