i think you need to execute a script after the dacpac deployment.

a dacpac will create tables and objects, but there's no scripting involved, so no, no script can be appended...

holy crap the new format of the website plays holy hell with code i took a lot of time to comment well and make sharp looking.

here is an older example i used to use, that assumes you have a list of server sin Central Management Servers

for each server, i may run a query per server,...

• This reply was modified 6 years, 6 months ago by Lowell.
• This reply was modified 6 years, 6 months ago by Lowell.
• This reply was modified 6 years, 6 months ago by Lowell. Reason: updated to working tested code with query provided

the six month/180 day evaluation is not that painful in a lab.

it is great practice to build machines over and over, join them to your lab's domain, and ideally, you...

oops i missed the variable value request.

you need the data type and the value:

$node.VariableValue.DataType

$node.VariableValue.'#text'

this was an interesting request for me.

i was able to do to this via powershell and shredding the xml of each dtsx package.

the script below scans a whole folder and...

auditing inserts is "excessively repetitively redundant", i would only audit updates and deletes, as you have the original data in the table, if no updates occurred. do you REALLY need...

• This reply was modified 6 years, 7 months ago by Lowell.

I may be jaded on this one.

I have seen three separate start-and-fail-to-implement initiatives to use Master Data Management at my current work location,and a total of half a dozen implementations...

first thing i would look at was HEAP tables. unless you get a table lock, you could have rows that were deleted but never returned their space back to the...

San_kan1gb;

I believe this article was reposted from the original~12 years ago, i'll see if i can recover the links. the proc has gone through a slew of changes since then..matching...

• This reply was modified 6 years, 8 months ago by Lowell.

Express editions have  a setting called autoclose, which turns off the database when it has been idle for a while in order to save resources, since an express edition is...

• This reply was modified 6 years, 8 months ago by Lowell.

no.

you can never restore a database from a higher version of SQL to a lower version. you will need to upgrade your 2014 instances to be 2017 as well.

a database...

the built in role ddl_admin allows the database user to drop/create/alter any object in the database; so it's not limited to just tables, it's procs/views/schemas etc as well

for...

you could create an extended event to capture linked server activity, based on the event sqlserver.oledb_data_read, but what are you trying to capture?
my testing of this EE was a little...

a post here has exactly what you are after, i think:
https://dba.stackexchange.com/questions/151136/how-to-script-statistics-in-sql-server-using-t-sql

just append your WHERE statement tot eh results to limit it to a single table:
[code...