This procedure will maintain the sysproperties table by wrapping system procedures: • sp_addextendedproperty • sp_dropextendedproperty • sp_updateextendedproperty The parameters are: • @object -- primary name of the object being to be maintained. • @column -- column or parameter […]
2007-07-04
425 reads
This procedure will maintain the sysproperties table by wrapping system procedures: • sp_addextendedproperty • sp_dropextendedproperty • sp_updateextendedproperty The parameters are: • @object -- primary name of the object being to be maintained. • @column -- column or parameter […]
2007-07-04
87 reads
By Steve Jones
I had a customer recently ask about a change in one of their constraints...
This is not database related, so if you’re not interested in hearing about something...
By Steve Jones
SQL Saturday Austin 2025 is in just a few days. I am honored to...
Comments posted to this topic are about the item fetch an execution plan from...
Is there a best practice way for the team to keep track of changes...
I have a query that is performing poorly It has a left join to...
I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?
See possible answers