Forum Replies Created

Viewing 15 posts - 331 through 345 (of 789 total)

  • RE: Security

    Lee From Bangalore (5/4/2009)

    Thanks Dugi

    the users are administrator in Operating system

    In sql server also they have Sysadmin.

    But in sql server I dont want to give the sysadmin role to those...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    May 4, 2009 at 3:43 am

    #987993

  • RE: Security

    Dugi (5/4/2009)

    Lee From Bangalore (5/4/2009)

    In my server few users are administrators like user1,user2,user3.

    but in sql server access, I need to give few roles only to those users, How can I...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    May 4, 2009 at 3:41 am

    #987991

  • RE: Security

    Lee From Bangalore (5/4/2009)

    Hi Dugi

    I mean

    In windows server the users(admin rights) are rights to access sql server, right

    But I need to give few roles only to access sql...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    May 4, 2009 at 3:35 am

    #987987

  • RE: Security

    Lee From Bangalore (5/4/2009)

    In my server few users are administrators like user1,user2,user3.

    but in sql server access, I need to give few roles only to those users, How can I Give?

    ...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    May 4, 2009 at 3:16 am

    #987982

  • RE: How to Stop audit trace files?

    a.bommersbach (4/30/2009)

    Upps, that's the place where I didn't look. It's right - under properties the "C2 auditing" was enabled.

    I was going crazy because all tries with exec sp_configure... ended...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    May 3, 2009 at 4:21 am

    #987803

  • RE: How to Stop audit trace files?

    Check in the Server properties on the security, you have Enable C2 audit tracing - check if it is on or off !?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 30, 2009 at 7:56 am

    #986668

  • RE: How to Stop audit trace files?

    I hope that this info can help you!

    http://www.sqlservercentral.com/articles/Monitoring/basicsofc2auditing/1547/%5B/url%5D

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 30, 2009 at 7:53 am

    #986667

  • RE: Table content comparing

    Just curious, what version of Oracle!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 30, 2009 at 5:44 am

    #986582

  • RE: It Department Org Structure

    First, wrong section to post it!

    Second, it depends from your company objectives and services!

    Anyway, IT Dep should have the head of IT Dep

    Networking and System sector

    Database and Application sector

    BackOffice and...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 30, 2009 at 5:16 am

    #986567

  • RE: SQL 2005 Express daily backup

    Phil C (4/29/2009)

    I've used a combination of these two products with great success to run backups and maintenance to schedule for Express edition:

    ExpressMaint Utility: http://www.sqldbatips.com/showarticle.asp?ID=29

    SQLScheduler: http://www.lazycoding.com/products.aspx

    Yes, in the Internet you...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 29, 2009 at 5:18 am

    #985789

  • RE: Partitioning in SQL Server 2008

    Hmmm if you compare with SQL Server 2005 here in SQL Server 2008 now is much easy how to partitioning because you have wizards, all what you need to do...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 29, 2009 at 3:44 am

    #985730

  • RE: SQL 2005 Express daily backup

    Kiran Cherupally (4/28/2009)

    Please read this blog post. It explains how to schedule daily backup of sql server database.

    http://cherupally.blogspot.com/2009/04/schedule-daily-backup-for-sql-server_27.html

    -Kiran

    Yes, but you should know that we are discussing for SQL Express Edition,...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 28, 2009 at 5:23 am

    #984972

  • RE: Setting Up Database Mail - SQL School Video

    Thnx Andy, nice one I like it! 😉

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 28, 2009 at 12:44 am

    #984855

  • RE: creating stored procedures

    bvinay57 (4/22/2009)

    Hi to everyone i am a newbie to ms sql i am creating a stored procedure to retrive data for the logged user pls give me some examples.

    Thanx ...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 22, 2009 at 7:05 am

    #982162

  • RE: Username visible in emails

    GilaMonster (4/14/2009)

    Steve, would it be possible to include the username of the sender in emails that are sent via the forum. I keep having people mail me with questions and...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    April 17, 2009 at 7:25 am

    #979653

Viewing 15 posts - 331 through 345 (of 789 total)