Forum Replies Created

Viewing 15 posts - 346 through 360 (of 966 total)

  • RE: start sql

    Use the -m startup parameter.

    Using the SQL Server Service Startup Options

    Joie Andrew
    "Since 1982"

  • RE: SQL Server 2008 on windows 8

    You can't. That is an Enterprise product meant for server OSes. You need to install Developer Edition if you want to look at Enterprise Edition features on Windows 8....

    Joie Andrew
    "Since 1982"

  • RE: sa can't access but newly created user performed like sa

    Are you the DBA for the instance? If not you need to get with the DBA to resolve.

    How do you know that the newly created user has anything to...

    Joie Andrew
    "Since 1982"

  • RE: trace -2543

    Not positive. It does not look like a documented trace flag. The closest thing I have found suggests that it might be related to memory dumps.

    Updated: Microsoft SQL Server Trace...

    Joie Andrew
    "Since 1982"

  • RE: Re-named failover nodes for SQL cluster and broke it!

    Did you research this any before renaming the nodes, or did you just do this to see what would happen? I hope this is not a production box.

    Check these out....

    Joie Andrew
    "Since 1982"

  • RE: Errors in SSRS logs

    Does the account the application is running under have permissions to the report? How are permissions to the underlying data sources setup?

    Joie Andrew
    "Since 1982"

  • RE: Report Rendering Issue

    So you are looking for a string with single quotes in your WHERE clause, or you are just returning data with single quotes in them?

    Joie Andrew
    "Since 1982"

  • RE: Report Rendering Issue

    What I didn't realize is that even though I wasn't using that dataset for the parameter, because there was a query associated with the dataset, SSRS must still run that...

    Joie Andrew
    "Since 1982"

  • RE: SSL Certificate for SSRS

    Did you get a certificate response from the CA that you are getting the cert issued through? Normally (at least in the org's that I have worked with) you submit...

    Joie Andrew
    "Since 1982"

  • RE: Report Rendering Issue

    How is the dataset in the subreport getting the data? Is it running a query against the datasource or a stored procedure? If you can write it as a stored...

    Joie Andrew
    "Since 1982"

  • RE: OSQL Not listing All databases

    If you can connect without specifying the dbname what result do get from the following query:

    SELECT name FROM sysdatabases ORDER BY name;

    GO

    Joie Andrew
    "Since 1982"

  • RE: SAN Migration - DataFiles movement to new drives

    Since this is a clustered environment and you are adding new disks after you have migrated the data over (and before you try starting up services) you will need to...

    Joie Andrew
    "Since 1982"

  • RE: 10 Myths about Backups in SQL Server

    [/url]

    Great article by Paul Randal as related to this discussion. My mistake.

    Joie Andrew
    "Since 1982"

  • RE: 10 Myths about Backups in SQL Server

    Nice article. One thing though. You list this:

    Myth 6: Full and differential backup breaks the log chain

    This is a misnomer. A full backup restarts the log chain. So if you...

    Joie Andrew
    "Since 1982"

  • RE: Problem with agent service accounts?

    When you try and start the SQL Agent service under a local account and it fails do you get any logon failures in the security log in Event Viewer? If...

    Joie Andrew
    "Since 1982"

Viewing 15 posts - 346 through 360 (of 966 total)