Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 6,104 total)

  • RE: PDF from SQL Procedure

    It may be because PDF creator installs as a print device... I've seen issues with PDF Creator and other PDF generation tools that work this way unless someone is logged...

    K. Brian Kelley
    @kbriankelley

  • RE: Default NTFS permissions on new DB

    They don't have to know anything about the data. To say that they do is incorrect. This is what they have to know with respect to those files in the...

    K. Brian Kelley
    @kbriankelley

  • RE: Default NTFS permissions on new DB

    What is being asked for is not an invalid implementation. It does not, in any way, impair SQL Server from working. If it did, your argument would have basis. What...

    K. Brian Kelley
    @kbriankelley

  • RE: Default NTFS permissions on new DB

    Gift Peddie,

      On one of your SQL Server 2005 servers, navigate to where the data files are stored at the file system level. This is typically \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data....

    K. Brian Kelley
    @kbriankelley

  • RE: Default NTFS permissions on new DB

    Okay, let's clear up a few things.

    1) It's not an unusual practice to create a development database and then copy or move it to another environment. What I've done in...

    K. Brian Kelley
    @kbriankelley

  • RE: Cannot generate SSPI context.

    If it was an SPN problem, though, this should occur all the time. I'd start by looking at time synchronization. Especially since the first thing a system does is check...

    K. Brian Kelley
    @kbriankelley

  • RE: Employer / Employee - READ FIRST

    Unfortunately, that fine line is going to be determined by your employer. If you're discussing what you'd like to see or what you don't like in general that may be...

    K. Brian Kelley
    @kbriankelley

  • RE: Default NTFS permissions on new DB

    I did a quick search and didn't see it, so in case you haven't done so, have you submitted it as a suggestion here:

    http://connect.microsoft.com/SQLServer

     

    K. Brian Kelley
    @kbriankelley

  • RE: Newbie question - loop thru all tables and create columns

    The GO is a batch separator for clients like Query Analyzer. I tend to add them in when I'm scripting these sorts of things to run manually. That way it's...

    K. Brian Kelley
    @kbriankelley

  • RE: How to Create Linked Server for a MySQL database using SQL Server Management Studio

    Here is the information on how to write for SSC. It's pretty basic, and Steve tends to ensure the articles go in clean and that sort of thing. He's cleaned...

    K. Brian Kelley
    @kbriankelley

  • RE: Default NTFS permissions on new DB

    No. He's referring to file system permissions, not permissions inside SQL Server. In that case he needs for certain personnel to be able to move the databases without being full...

    K. Brian Kelley
    @kbriankelley

  • RE: Default NTFS permissions on new DB

    I'm going to have to go with the original poster here... I'd rather do a file copy than use the wizard. There are a whole host of reasons for this,...

    K. Brian Kelley
    @kbriankelley

  • RE: Default NTFS permissions on new DB

    Tracking the necessary DACLS becomes a nightmare in a large environment.

    Aren't the DAs in a security group already? Couldn't you just script the addition of the ACE for that security...

    K. Brian Kelley
    @kbriankelley

  • RE: Auditing a "drop procedure"

    Well, the reason I remember your name is probably an unusual one. I used to read the X-Men comics a lot as I was growing up. My favorite X-Man was...

    K. Brian Kelley
    @kbriankelley

  • RE: an error occured on the computer running IIS

    Also, check the IIS logs at the time of failure. That may point you to the source of the issue. By default, %systemroot%\system32\logfiles with a separate dir for each web...

    K. Brian Kelley
    @kbriankelley

Viewing 15 posts - 1,816 through 1,830 (of 6,104 total)