Forum Replies Created

Viewing 15 posts - 4,291 through 4,305 (of 13,459 total)

  • RE: How to implement this DDL trigger?

    glad it's working for you!

    one more thing to consider:

    if you create a new database via a RESTORE, that does not trigger the CREATE_DATABASE event. that triggers the event AUDIT_BACKUP_RESTORE_EVENT, which...

    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!

    December 3, 2012 at 9:55 am

    #1564962

  • RE: SQL Query performing really slow

    you need to provide more details; the actual execution plan would tell us exactly what happened,a nd we could identify the items in the execution plan that is causing performance...

    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!

    December 3, 2012 at 8:14 am

    #1564896

  • RE: Run a Query on a Database Restore

    I'm sure you have to use extended events, specifically on the

    AUDIT_BACKUP_RESTORE_EVENT

    I did something as a prototype that did a few things on my dev server;

    if you restored 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!

    December 3, 2012 at 6:55 am

    #1564859

  • RE: How to implement this DDL trigger?

    yeah, i just scripted a CREATE DATABASE from the GUI; you can see it does a bunch of alters for the properties after it does the create:

    CREATE DATABASE [Example] 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!

    December 3, 2012 at 6:45 am

    #1564853

  • RE: How to implement this DDL trigger?

    the event data is going to have the new database name...it's already been changed by thetime you get to the ddl trigger, unless you force a rollback.

    you could rollback ,...

    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!

    December 3, 2012 at 6:30 am

    #1564846

  • RE: How to implement this DDL trigger?

    arunyadav007 pointed you in the right direction, here's a code model for your trigger.

    I',m not sure if you are just inserting the changes, updating existing, or what;

    i'd think there needs...

    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!

    December 3, 2012 at 6:10 am

    #1564838

  • RE: Syntax request needed. Merge an 'openquery' select towards linkedserver

    you just need to add an alias, sorry:

    select * from openquery([abc],'SELECT

    ...

    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!

    November 30, 2012 at 2:49 pm

    #1564582

  • RE: Error accessing views for specific accounts that should have access

    crowellc (11/30/2012)

    I’m seeing the following error message when I try to query seven specific views in a database: Msg 18456, Level 14, State 1, Line 1 Login failed for user...

    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!

    November 30, 2012 at 2:46 pm

    #1564581

  • RE: Syntax request needed. Merge an 'openquery' select towards linkedserver

    in that case, assuming you wanted the value as columns again like your first query, it would go like this...notice i did a simple cross join, on a table we...

    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!

    November 30, 2012 at 12:55 pm

    #1564546

  • RE: Find all columns that might contain SSN numbers

    ugg that is tough; you might even have columns that don't store the the number as a varchar without dashes 9and leave the presentation layer to dash-ify it, or even...

    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!

    November 29, 2012 at 1:27 pm

    #1564007

  • RE: Rename a Named Instance in a 2008 R2 Cluster

    you are correct;

    there is no way to rename an instance; you have to install a new one with the new name, and drop the old when when you are ready.

    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!

    November 29, 2012 at 12:10 pm

    #1563967

  • RE: SQL Storing Too Much Data

    davas (11/29/2012)

    Thank you both for your quick replies! I've created a clustered index and now the table reports as being 600MB as expected so that's great.

    Just wondered why the sp_spaceused...

    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!

    November 29, 2012 at 9:48 am

    #1563892

  • RE: SQL Storing Too Much Data

    A HEAP table (without a clustered index) has a table size which includes the space of all the deleted rows, that ever existed, EVER.

    so if you insert and delete a...

    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!

    November 29, 2012 at 9:33 am

    #1563879

  • RE: Mail queued, not delivered

    for the individual emails, do they all have the same error message?

    maybe something changed outside of your control, like a firewall blocking port 25 traffic, a DNS error or something...

    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!

    November 29, 2012 at 9:01 am

    #1563859

  • RE: How to import Excel file into SQL?

    tantcu (11/28/2012)

    Do you know how to do it with macro?

    any macro is going to have too many specifics...you have to build the macro before you can use it, and that...

    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!

    November 28, 2012 at 2:59 pm

    #1563473

Viewing 15 posts - 4,291 through 4,305 (of 13,459 total)