Forum Replies Created

Viewing 15 posts - 571 through 585 (of 619 total)

  • RE: Executing a SSIS package from a Stored Procedure

    Greg Charles (9/22/2008)


    sri,

    Create the job step and select "SQL Server Integration Services Package" in the "Type" dropdown. When you do, you'll see a bunch of tabs where you can...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Find permissions that are being inherited (secretly)

    all sorted now. thanks for your help. It turned out that the database dbo had been set to a group which mapped to an AD group which was membered by...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Find permissions that are being inherited (secretly)

    The code I run to check permissions is

    use [cadis_release]

    SELECT *

    FROM fn_my_permissions('cadis_release', 'DATABASE');

    GO

    (ran as the user). It seems that some how the user is getting dd_ladmin rights...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: First dance at your wedding...

    Thanks to all for your messages.

    Seems such a long time ago now (24/8/08) but it was a really great evening and all went well.

    And for those of you interested.......

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Migrating Logins from SQL 2000 to SQL 2005

    pri.amin (8/18/2008)


    Would it just be easier to take the DB 'Off line', copy the MDF and LDF files which I need then bring the DB 'Back Online'?

    Would this allow me...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Migrating to 2005

    gtjuri (8/18/2008)


    Is it ok to install first all the DB's from the 2005 server incl. master msdb etc an then detach attach the 2000 db's?

    Keep in mind that the new...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: First dance at your wedding...

    Steve Jones - Editor (8/15/2008)


    grab an adult beverage and enjoy the time with your spouse. Ignore everyone else.

    Its a good idea, but I'm Jewish and anyone (who is Jewish...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Any SQL gurus / n00bs that are closet musicians?

    I love that stuff!!!

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Any SQL gurus / n00bs that are closet musicians?

    maric (8/15/2008)


    I've had 1 album release and 6 remix / compilation releases so far if that counts? 🙂

    Would we have heard of you? MP3 MP3 MP3 😉

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Any SQL gurus / n00bs that are closet musicians?

    I used to play guitar, electric, accoustic, spanish and even bass. Had a Honer Headless (are you impressed Jack?).

    Now just guilty of making occasional Metallica'esc noises on my battered ESP...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: My Sons first birthday this weekend

    aureolin (8/14/2008)


    A big cake with chocolate icing and lots of pictures! Stuff like this comes in real handy when they're 16 and getting interested in girls!!

    Or say they ...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Cant install Integration Services (doesnt appear) and Pendinf Reboot set (and wont go away)

    Nee-Bother guys!

    I've sorted it. Apparently even though it is a none clustered services, because the servers (Windows) are clustered when you remove the 'PendingFileRenameOperations', flag it has to be...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: My Sons first birthday this weekend

    Besides - he can always just chew on the box. High in fiber and good for teething, too!!!!!!!:cool:

    Or he can play with the CD... OOOOOOOOOOOOOOOOOOOh shiny :p

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Is SQL server caching the domain credentials of job owners?

    Agree completely.

    SQL does not (as far as I am aware) cache AD details. What it does cached is the AD SID's which are kept to compare the SID held by...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Truncation of database logs

    andrew gothard (8/13/2008)


    GilaMonster (8/13/2008)


    Schadenfreude-Mei (8/13/2008)


    yeah think so. certainly they offer sunet desert camel rides etc.

    Possibly i wasnt listening to Deborah when she told me.... :unsure:

    Adam Zacks-------------------------------------------Be Nice, Or Leave

Viewing 15 posts - 571 through 585 (of 619 total)