Forum Replies Created

Viewing 15 posts - 211 through 225 (of 13,460 total)

  • RE: Help on DDL_TABLE_EVENTS for auditing

    i am guessing that maybe the trigger definition should have the ansi settings in it, right?
    CREATE Trigger [Trg_TrackAuditManagement_TABLE]
    on ALL Server
    for DDL_TABLE_EVENTS
    as
    SET...

    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 21, 2019 at 1:22 pm

    #2025158

  • RE: Help on DDL_TABLE_EVENTS for auditing

    i just appended this to your commands, and it worked fine:
    SET ANSI_NULLS ON;
    SET ANSI_PADDING ON;
    SET ANSI_WARNINGS ON;
    SET ARITHABORT ON;
    ...

    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 21, 2019 at 8:22 am

    #2025111

  • RE: Allocate Meetings to Employees (randomly generated) with daily maximum hours set at 5

    is there an assumption that there can only be one meeting for a given hour?
    i would expect you need additional login where if there are two or more meetings...

    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 21, 2019 at 7:24 am

    #2025101

  • RE: Issue with synonyms and linked servers

    yes, your permissions error is related to how you set up the linked server.
    you typically have a few choices, i usually use one of the bottom two from this screenshot,...

    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 20, 2019 at 9:28 am

    #2025029

  • RE: Issue with synonyms and linked servers

    i think this is an intelli Sense question, actually, where you expect the synonyms you are looking for to appear for ease of use, right?
    the synonyms exist, but don't...

    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 20, 2019 at 8:29 am

    #2025018

  • RE: Do I need to add my SQLserver agent service account as a login

    pretty sure neither the SQL account or the SQL agent need any access to the database. they are used to interact with things outside of SQL server instead...for example backup...

    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 19, 2019 at 12:35 pm

    #2024932

  • RE: Script to close the excel file

    i would lean more towards copying the file as a new name, with name featuring the timestamp to the millisecond, and manipulate that.
    also, i would use an isolated copy,...

    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 12, 2019 at 1:58 pm

    #2024268

  • RE: SSIS and BIML

    i do the same as what Martin does, but I am using extended properties for my source of tables instead of something external to the database, 
    the advantage is, when...

    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 12, 2019 at 1:54 pm

    #2024267

  • RE: I? wanted to run a stored proc over 500 databases in production.

    procedure stats is server wide, but your JOIN and WHERE statement limits it to the current database context.
    a minor tweak to use built in finctions and you can get...

    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 11, 2019 at 3:03 pm

    #2024147

  • RE: Quering a Always Encrypted Column with a already encrypted value

    if you have the actual encrypted varbinary value to compare it to, then yes, i believe it will work.
    if you needed to convert a known value to an encrypted...

    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 7, 2019 at 5:49 am

    #2023789

  • RE: Quering a Always Encrypted Column with a already encrypted value

    If your columns have been set with deterministic always encrypted, then the provider does that for you automatically.
    In SQL Server Management Studio or in your regular connection string, 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!

    March 7, 2019 at 5:22 am

    #2023786

  • RE: SQl 2014 Database records have bad data how to clear

    just test your changes via a select query before you implement an actual update:

    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
    IF OBJECT_ID('tempdb.[dbo].[#recording]') IS NOT NULL
    DROP...

    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 4, 2019 at 3:17 pm

    #2023505

  • RE: Applying a differential backup to a replicated DB

    to restore a differential, you need the database to have been restored from a full backup and also be in recovery mode...nothing can read or write to it between when...

    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 1, 2019 at 4:17 am

    #2023279

  • RE: Applying a differential backup to a replicated DB

    I think what you want to do is script out the replication, and fill in the service account passwords if needed in the script.
    then when you restore the 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!

    March 1, 2019 at 3:27 am

    #2023275

  • RE: SQl 2014 instance is DOWN all USER databases will not restore and SQLAGENT will not start. Urgent help required..

    it sounds like you did a lot of unnecessary work.
    you lost the E drive, and should have looped in the SAN Admins to get the drive up. then 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!

    February 28, 2019 at 7:01 pm

    #2023267

Viewing 15 posts - 211 through 225 (of 13,460 total)