Forum Replies Created

Viewing 15 posts - 1,891 through 1,905 (of 1,970 total)

  • RE: How do I change the "grantor" for a user?

    It is hard to tell, as the stored procedure where it is failing is the first one that it hits.

    The weird thing is that, if I connect to...

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: How do I change the "grantor" for a user?

    K. Brian Kelley (8/14/2008)


    Grantor is simply who granted the permissions to the grantee. You can change this by revoking the permissions and regranting it.

    Do the SIDs match up for...

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: How do I generate a database schema in a job?

    Thank you. We don't have VSTE for anybody, let alone DBA's, so I guess I'll go with the PowerShell method.

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: How do I generate a database schema in a job?

    "VSTE for DBAs". What is VSTE?

    I'll review your PowerShell videos, thanks.

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: Cannot shrink my db's log file

    Gail,

    The recovery mode is Bulk-Logged

    No log backups are running, that I can see.

    No replication.

    We don't have a point-in-time recovery requirements for these databases.

    Running the SELECT you specified, for...

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: Virtual Conversions

    This topic is very interesting to me, in fact I've already posted a message about it on this site's forums. My biggest concern is, should we be putting our...

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: SQL Server 2005 and VMware

    Michael Earl (7/17/2008)


    Here is the MS support information link http://support.microsoft.com/kb/897615

    OK, I see by this article[/url] that Microsoft has a working relationship with Novell for virtualization software and Microsoft's software. ...

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: CU KB948109 wouldn't install

    Rod at work (7/14/2008)


    george sibbald (7/11/2008)


    gail, intersting news, thanks, I will hold off too.

    rod, does @@version return 2273 after you install?

    George, I'm getting a 9.00.3068.00 when I run the @@version.

    I'm...

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: CU KB948109 wouldn't install

    george sibbald (7/11/2008)


    gail, intersting news, thanks, I will hold off too.

    rod, does @@version return 2273 after you install?

    George, I'm getting a 9.00.3068.00 when I run the @@version.

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: CU KB948109 wouldn't install

    George, it is a rather large .LOG file (~ 9 MB in size), and I see several errors in it, even at the beginning. However, I will assume that...

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: A discrepancy in the amounts being totaled

    Lynn Pettis (7/3/2008)


    Though I didn't respond to your original post, I assure you, not a problem. Sometimes asking for help is all it takes. In asking for help,...

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: A discrepancy in the amounts being totaled

    OK, this is very weird, but I just re-ran my query again, summing all of the Amounts and GrossReceiptsTax added together, against the fund, and it came out exactly to...

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: A discrepancy in the amounts being totaled

    You're right, I did forget to mention the data types. In the MoneyPools table both the AnnualAllocation and the RemainingValue columns are of type money.

    In the Vouchers table the...

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: Where do I place an occasionally used field?

    Mani Singh (6/25/2008)


    Go with the first approach of changing the size of datatype, but avoid using MAX it is a BLOB type equivalent to text in earlier versions.

    so use it...

    Kindest Regards, Rod Connect with me on LinkedIn.

  • RE: TechEd - Day 2

    Steve, in your editorial you said,

    "TechEd is still disappointing for me this year, with about 6000 people instead of the 11,000+ there has been in the past. That many people...

    Kindest Regards, Rod Connect with me on LinkedIn.

Viewing 15 posts - 1,891 through 1,905 (of 1,970 total)