I think the best way to do this is restrict the permissions to the underlying objects. If the users cannot use a wizard they can still use scripting, .net, or...

Yes - use sys.dm_db_index_physical_stats

something like

select Object_Name(dmv.Object_ID) as TableName

,si.Name as Index_Name

,Avg_Fragmentation_In_Percent

,Fragment_Count

,Avg_Page_Space_Used_In_Percent

,Record_Count

--*

From sys.dm_db_index_physical_stats (

db_id()

,Null

,Null

,Null

,'Sampled'

) dmv

join sys.indexes si

on si.object_id = dmv.object_id

and si.Index_ID = dmv.Index_ID

Where is_Disabled = 0

and dmv.Record_Count >= 100000

and Fragment_Count > 10

And...

Thanks Greg. I already used the script GSquared provided and addressed the objects that needed fixing though. Funny enough there were a few procs that wouldn't create because they were...

I have the following which targets a specific user, but you could easily adapt it to traverse all database principals with

select name from sys.database_principals

where type in ('S','U','G')

and name not...

Thank you GSquared, I had not considered this type of methodology - I believe this will give me exactly what I need with minimal effort on my part. Excellent response...

I would tend to want to use the following becasue it addresses the fact that kill attempts might place certain processes in rollback for significant time periods. Further, if you...

Another option could be an implicit varbinary conversion such as

where message > 0x

The spreadsheet only updates when it is set to or when you tell it to. For instance I usually set mine to update when the spreadsheet first loads. The problem...

The problem with including something like this as a feature is that it has too much variability in its application. For instance you might want to create another user or...

Ok, the below still needs the 2 variable values set. The thing is about this one is that it is database user name specific, so if the usernames are the...

Yes Jeff, thank you for the commentary/explanation/suggestions. Using a staging table will definitely be the way to go for the daily load. I guess whether the incoming records needed to...

I assume everything is in the same domain since it worked for you before you changed the password. Is it possible that when the password was changed the Active Directory...

For the below script just change the 2 variable values at the top to whatever the user names aer you are deeling with. Please let me know if you want...

Thank you all very much for your posts. I will indeed recommend disable/enable for the indexes. I wanted to explore the question of whether the cluster on zip should be...

The bulk insert is being done by the developers in C# and they haven't been getting it to be minimally logged as evidenced by the log file that grew to...