Forum Replies Created

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

  • RE: DBA without sa rights???

    Agreed...

  • RE: DBA without sa rights???

    It is a tiny little database that has absolutely no impact. It will hardly be noticed and again, I even had permission from his junior network admin whom he put...

  • RE: DBA without sa rights???

    I'm the only DBA that our organization has. There are others that "know enough to be dangerous" that can at least create a database and point an application to it....

  • RE: DBA without sa rights???

    Thanks all for the feedback.

    Thom - I guess I needed to be brought back down. I know it would be considered a security violation, just had hopes. I know SQL...

  • RE: Recovery model for subscription database

    Thank you! I have searched for hours and couldn't seem to find this simple tidbit of information.

  • RE: Query eDirectory

    I actually do load it into a staging table first since I have to separate staff and students into different tables and create a column in the destination table from...

  • RE: Query eDirectory

    Hi Rich, Don't knock your VBS solution! It is a good solution. The solution we were running with C# was started by another co-worker, I just took and finished it...

  • RE: Query eDirectory

    I never installed anything from Novell on my server.

    I had the full version of Visual Studio 2008 so I'm guessing that had installed those libraries.

    I would NOT install any Novell...

  • RE: Query eDirectory

    I'm not sure what you may be missing. Sounds to me like something is not properly loaded on your computer, whether that be in the OS itself or in BIDS.

    Just...

  • RE: Getting incorrect results from SELECT inside of a stored procedure.

    That isn't the point at which the problem is occurring. The @Counter and IF statement at that early point in the procedure is working as expected. It is further down...

  • RE: AD Username change causing problems

    Awesome, don't know why I couldn't find that one. It worked!

  • RE: AD Username change causing problems

    It occurs whenever I adjust maintenance plans and add new publications/subscriptions.

    Is there really no way to change my username?

  • RE: AD Username change causing problems

    When I change the job owner to sa, it works fine. Problem is that when I create new replication publications or subscriptions, it defaults to me being the owner. I...

  • RE: AD Username change causing problems

    Is there a way to modify my login to change it from jpowers to jim.powers? That would solve the problems since it would be able to find me in AD...

  • RE: Query eDirectory

    Hi All,

    I finally found a solution! I created an SSIS package and used the Script Component as the source with the destination being my SQL Table. The script I used...

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