Forum Replies Created

Viewing 15 posts - 196 through 210 (of 279 total)

  • RE: DDL Trigger Required

    ... but as Gail mentioned before, there should be no reason for you not to talk with them and explain why their actions could (and will) cause problems. Ultimately, if...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 22, 2009 at 7:05 am

    #1028278

  • RE: SSRS Connection Issues

    Jason Shadonix (7/21/2009)

    It still didn't work, so just for fun I rebooted the server, and when it came up it magically worked.

    Thanks!

    😀 following the old motto, when everything else fails,...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 21, 2009 at 12:10 pm

    #1027829

  • RE: SMS from SQL Server

    Sending SMS directly from any app requires a GSM modem/gateway and software to handle it. There's options to use services that offer that, but most have minimum commitments and hence...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 17, 2009 at 9:32 am

    #1026261

  • RE: Changing SQL Server licensing model

    In 2005 there is no place to provide the licensing information on install, so it is not limited or registered anywhere. You only have to be compliant with acquiring and...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 17, 2009 at 9:25 am

    #1026255

  • RE: licensing audit

    MANU (7/16/2009)

    Chris,

    Its there in 2005 too.

    http://msdn.microsoft.com/en-us/library/ms174396(SQL.90).aspx

    MJ

    It is there, but the "correct" values are not there,ie "LicenseType" is DISABLED and "NumLicenses" is NULL because, at least with a fresh...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 16, 2009 at 10:03 am

    #1025760

  • RE: Is that true that we can not install database engine other than C drive in Clustered environment?

    rambilla4 (7/13/2009)

    We have only one local drive i.e C drive and the rest are shared drives. So if we have any other local drive other than C drive, we can...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 14, 2009 at 8:51 am

    #1024446

  • RE: Is that true that we can not install database engine other than C drive in Clustered environment?

    The SQL binaries can be installed on any local drive, not only the system drive... We have several clustered SQL servers and on all we have the binaries on the...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 13, 2009 at 1:04 pm

    #1024107

  • RE: How to Create and Start SQL Server Trace Automatically

    DBA Cabuloso (7/10/2009)Do you know some way to enable the trace without using the profiler, save the data in tables, instead of in files? I really prefer to save in...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 10, 2009 at 1:41 pm

    #1023311

  • RE: Restriction in the number of records updated

    Luiz (7/10/2009)

    So I guess I'll just live with the risk.

    ... and good backup policy 🙂

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 10, 2009 at 9:18 am

    #1023129

  • RE: When to add new instances

    Adding additional instances could, I believe, create additional maintenance headaches too. Now your instances will share memory/cpu/disk and you would have to carefully configure and monitor these per instance.

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 10, 2009 at 8:55 am

    #1023107

  • RE: Brushing up index creation

    BOL will give you all those answers....

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 10, 2009 at 8:29 am

    #1023070

  • RE: SQL2005 SP3 UpdateTemp folder 'redirection'

    SQL Noob (7/6/2009)

    what about the other node? in my experience all the updates starting with SP2 you run on one node and that's it

    That might be true for...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 6, 2009 at 1:52 pm

    #1020626

  • RE: Limit users with Management Studio Accessing a DB

    Moreover, you mention in the beginning:

    We have a DB that uses Windows Authentication, all domain users have INSERT/UPDATE/DELETE access to all table

    and then

    We have an application that...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 6, 2009 at 1:07 pm

    #1020602

  • RE: Limit users with Management Studio Accessing a DB

    Gaby Abed (7/6/2009)

    Third party app unfortunately that uses SQL Logins, not domain. It's a great start though, gives us food for thought. And we'll definitely test it in...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 6, 2009 at 1:04 pm

    #1020596

  • RE: Limit users with Management Studio Accessing a DB

    Gaby Abed (7/6/2009)

    Tim, looks like a great idea. I was wondering if this trigger would impact a really busy server where lots of logins occur? For example, we...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

    July 6, 2009 at 12:48 pm

    #1020578

Viewing 15 posts - 196 through 210 (of 279 total)