Forum Replies Created

Viewing 15 posts - 196 through 210 (of 13,460 total)

  • Reply To: How execute SELECT query in Sql server Post-Deployment Script

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 3, 2019 at 8:57 pm

    #3649923

  • Reply To: Looking for Step by Step Instructions for SQL Server Loop using Powershell

    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.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 1, 2019 at 12:36 am

    #3649214

  • Reply To: Looking for Step by Step Instructions for SQL Server Loop using Powershell

    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, 11 months ago by Lowell.
    • This reply was modified 6 years, 11 months ago by Lowell.
    • This reply was modified 6 years, 11 months ago by Lowell. Reason: updated to working tested code with query provided

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 1, 2019 at 12:35 am

    #3649213

  • Reply To: home lab set up

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 9, 2019 at 2:04 pm

    #3639080

  • Reply To: List all of the variables in a package

    oops i missed the variable value request.

    you need the data type and the value:

    $node.VariableValue.DataType

    $node.VariableValue.'#text'

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 9, 2019 at 12:49 pm

    #3639008

  • Reply To: List all of the variables in a package

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 9, 2019 at 12:42 pm

    #3639005

  • Reply To: how to encapsulate the same code block with inserted vs deleted in a trigger.

     

    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 7 years ago by Lowell.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    May 8, 2019 at 8:20 pm

    #3638617

  • Reply To: Master Data Management (MDM) Tools by Microsoft

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 24, 2019 at 2:02 pm

    #3531001

  • Reply To: Express edition DB crossing limit

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 22, 2019 at 9:09 pm

    #3518056

  • Reply To: Create Table DDL via TSQL

    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 7 years, 1 months ago by Lowell.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 16, 2019 at 10:53 am

    #3406513

  • Reply To: Database goes "In Recovery" Mode Automatically

    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 7 years, 1 months ago by Lowell.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 10, 2019 at 12:55 pm

    #3090264

  • Reply To: Moving backuped db's from SQL 2017 to SQL 2014

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 10, 2019 at 12:24 pm

    #3089722

  • RE: Permissions

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 22, 2019 at 3:24 pm

    #2025282

  • RE: SQL server logs

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 22, 2019 at 7:30 am

    #2025202

  • RE: Dynamic script to script out statistics before dropping them

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 22, 2019 at 6:27 am

    #2025191

Viewing 15 posts - 196 through 210 (of 13,460 total)