Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 9,244 total)

  • RE: User Permission to view Only View not base tables

    Rechana Rajan - Thursday, January 12, 2017 5:25 AM

    Thanks  John and Perry,

    Sorry for the confusion.

    CREATE VIEW [dbo].[View_1]
    AS
    SELECT RRN.ASettings.oid AS Expr1, RRN.BTType.oid, RRN.CSHistory.sId, dbo.CB.MainProfileID,...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: User Permission to view Only View not base tables

    the ownership chain is broken as you reference object from a different schema.
    Answers to the questions above are required

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server install account question

    Michael L John (1/6/2017)


    Correct.

    The user installing needs to be a local admin on the server. If you are creating a cluster or always on, you need to...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server install account question

    The account used to logon to the server and install the software must be a server administrator.

    The account used to run the service should be a low privilege user...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Question regarding sp_clean_db_free_space

    The following link

    https://msdn.microsoft.com/en-us/library/dd408732(v=sql.110).aspx

    states the following information

    Microsoft Technet


    The length of time required to run sp_clean_db_free_space depends on the size of the file, the available free space, and the capacity of...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL server service restarted frequently in cluster

    no of NICs?

    Teamed?

    No of networks?

    etc, etc

    Throw a dog a bone here!!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL server service restarted frequently in cluster

    you clearly have some sort of network or config issue.

    Can you provide more detail on the network setup on the machines

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Frequent restart of SQL services in cluster

    answered here

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Log Shipping with Cluster Shared Volumes and SQL Virtual Name

    somone else asked about CSV's in this post

    If you want to have a shared location made available then you should create a shared folder cluster resource and place into either...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL server service restarted frequently in cluster

    there are indications that the isalive check has failed this will initiate a restart.

    Can you provide more detail on the network setup on the nodes.

    Are these virtual machines or physical...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Database Backup Encryption

    GilaMonster (1/4/2017)


    Seriously, what is your exact situation?

    Million dollar question 😀

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Database Backup Encryption

    ichervin (12/27/2016)


    Hello all,

    How to recover a database if an encryption key is lost?

    Thanks.

    It's not clear what your issue is here.

    Have taken an encrypted backup in sql server 2014 and now...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: AlwaysOn Availability Group and FCI using CSV

    Lijun Zhang (12/26/2016)


    Hi,

    I am planning to install a 2 nodes FCI using CSV as the primary replica, and a separate standard alone instance as a secondary replica for reporting.

    The official...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: There is insufficient space in the filegroup to complete the emptyfile operation.

    when emptying a file in a filegroup, DBCC will attempt to move the pages to other files in the same group, if there's not enough space in the other files...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: sync two DBs

    If the remote database can be read only log shipping would be your best solution

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 1,036 through 1,050 (of 9,244 total)