<div>
Define what you mean by 'user activity', and give us some more background info. &nbsp;I'm guessing there's a better workaround then detecting user events and executing DDL.
</div>


<div>
What I meant was we still have applications / users running queries (dml only)
</div>


<div>
That's all right, it what I expect. &nbsp;Do you think the SP install will fail because we have query / dml activity during the install?
</div>


<div>
&lt;Can I install a SP while there is some user activity happening &gt;?<br />
if you meant Sql service pack (SP)<br />
answer: NO <br />
plan downtime, have a good DBs backup,make sure all heavy sql processes are done before you start
</div>


<div>
Oh, SP meant Service Pack. &nbsp;I misunderstood this to mean Stored Procedure.
</div>


<div>
Bruno, is this question answered?<br />
If so, please mark one or more comments as solution so this can be closed.<br />
Cheers
</div>


<div>
Recommendation to close this question by accepting the above comments as solutions.
</div>


<div>
<div class="content wysiwyg-content">
Can I install a SP while there is some user activity happening ? &nbsp; I know that nornally a restar of sql server will be required but I want to make sure that the SP install will not fail becuase of user activity.<br />
<br />
Thanks<br />
Bruno
</div>
</div>


Can I install a SP while there is some user activity happening ?   I know that nornally a restar of sql server will be required but I want to make sure that the SP install will not fail becuase of user activity.

Thanks
Bruno

Sql Server - SP - install while there is user activity

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.