Forum Replies Created

Viewing 15 posts - 31 through 45 (of 327 total)

  • RE: Server Configuration Change Events

    Thanks but unfortunately I can't use this since it requires SSIS on the target. Our environment doesn't allow SSIS on the database servers. I can't even download it an play...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Are DacPacs ready for prime-time?

    TomThomson

    I don't really understand the point of this shiny new tool.

    it's a typical misuse of XML probably arising from people being hypnotised by the ridiculous hype that XML...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: ALTER TRACE

    Are you running Profiler from your desktop? If so, it sounds like the desktop tools didn't install properly.

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Out-grid view data display

    Does this Out-gridview page offer any OK button to close the screen?

    No - you will need to create your own DataGridView in order to have buttons, highlighting, etc. and you...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Scripting SQL Server databases with SMO using EnforceScriptingOptions

    Thank you both, I'll look into it.

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Scripting SQL Server databases with SMO using EnforceScriptingOptions

    Thanks for the info. Do you know if a message is outputted when an encrypted object is encountered? I currently check for IsEncrypted and write a message to the...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Specifying Faiover partner in OpenRowset

    I know this post is old but in case some else is looking for an answer this works for me:

    select

    *

    from openrowset( 'SQLNCLI','Provider=SQLNCLI; 'DataSource=Server1;FailoverPartner=Server2;Database=MyDB;trusted_connection=yes;','select top 10 from Database1.dbo.Table1'

    ...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: OPENROWSET with UNC works from server, not from client

    I can't help you with a solution but I can tell what the issue is. Kerberos multiple hops. You are starting from your client connecting to server 1 and then...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: The Geek Christmas Poll

    A teenage mood detector

    Kids are gone (yea!) Now I need wife mood detector:-P

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Data Preservation

    Back in the "Dark Ages" (1985), I worked for a major insurance firm (COBOL programmer). It was decided that in addition to tape storage, all "important" documents would be stored...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Visitor Parking

    Another twist, one that I prefer, is park anywhere other than a reserved spot (generally paid for in some form and the vehicle will have some sort of identification). Park...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Copy logins through Database Copy Wizard

    In your previous post you put in the begining of the error message - Login failed for - but didn't put in the rest. Please put the entire...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Copy logins through Database Copy Wizard

    What is the error message that you are getting? I haven't used the copy wizard in ages, but I'm fairly certain that it doesn not bring the passwords over for...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: A New Look

    I like the cleaner look, but overall, I'm not happy with it. It's harder to read with a lot of wasted space.

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

  • RE: Write PowerShell Output to SQL Server Table

    Schleep - thanks for your example. I have a few places where it can be utilized but I have a question about it. While I am not very good...

    MG

    "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
    Tony Hoare

    "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

Viewing 15 posts - 31 through 45 (of 327 total)