Forum Replies Created

Viewing 15 posts - 151 through 165 (of 327 total)

  • RE: The Daily Routine

    Steve -

    I'm sure you are giving a "bute" paste (or horse aspirin). Ask your vet for the flavored powder. I find that apple flavored bute powder works well. We...

    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: Where to store SSIS packages?

    I'm sure someone at M$ knows why 😀

    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: Where to store SSIS packages?

    Let me preface this by stating that I am not an IS expert. My packages are fairly simple.

    I prefer the file system with the caveat that it is backed up...

    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: How do I script all database objects through dynamic T-SQL?

    I wouldn't do this in TSQL. Most of the posts have DMO examples but you will need to use SMO since you need it for 2K5. Write it in one...

    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: Why can't T-SQL access Oracle DB when VB6 can?

    Sorry I neglected to say that although I'm testing this scenario on my 32bit PC it will ultimately live on a

    64bit server.

    MS will not produce a 64 bit driver...

    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: Can SSIS detect changes on 500++ tables and its added new rows

    the vendor sometimes add new tables or rename tables without telling us. So my SSIS needs to know these changes for ETL process.

    Hi Kreecha,

    Since the vendor is making...

    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: MS SQL 2000 - How do I track a user who deleted SQL DB objects?

    We use Compliance Managere and it uses a server side trace which is very light weight. It is very rare that it will hit 2% of CPU in Task Manager.

    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: Drivers available for creating linked servers

    OK - I did this on 3 64 bit servers and they all work.

    1 - install the 10g client (.3 version is what I installed)

    2 - install the ODAC...

    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: "too large for the specified buffer size"

    By default, DTS samples the first 8 rows to determine the column size. If you use the Disconnected Edit, you can tell it what the column sizes will be and...

    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: Drivers available for creating linked servers

    I have a 64 bit SQL Server 2005 SP2 on a Windows 2003 x64. The developer said that he needed to use OLE to talk to Oracle so I...

    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: WMI Namespace Error when monitoring SQL Server using MOM 2005

    here is a link I found for troubleshooting WMI Security:

    http://blogs.technet.com/askperf/archive/2007/08/14/wmi-troubleshooting-permissions.aspx

    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: WMI Namespace Error when monitoring SQL Server using MOM 2005

    By default, sysadmins have full access to WMI. I really don't know where to point you if you have sysadmin. Have looked at the MSDN forums?

    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: WMI Namespace Error when monitoring SQL Server using MOM 2005

    There is one other thing you can try. It may be a simple case of "refreshing" WMI.

    You need to be a sysadmin on the server for this. From 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: WMI Namespace Error when monitoring SQL Server using MOM 2005

    I have a problem with WMI Alerts in SQL Server that throws the same error message. I opened a case with MS and it turns out that the sqlwep.dll has...

    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: Connect to SQL Server 2005 Express

    I just tried it and was able to establish a connections and an Execute SQL Task.

    I'm not the best with DTS so I don't know what limitations you may...

    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 - 151 through 165 (of 327 total)