Forum Replies Created

Viewing 15 posts - 16 through 30 (of 360 total)

  • RE: query required

    ramyours2003 (3/20/2015)


    I need a query to get the number of user count based on the hits on the database on a day wise .

    Does your database have a...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Grant read-only access to Windows logins on a remote standby database

    We want to be able to use Windows Authentication mode on the server of the secondary database. But since the two domains differ, is it possible to even achieve this?...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: SQL Server Clustering and CSV's

    I am assuming if there is a LUN failure a failover will be performed.In case of a LUN failure I dont have to worry about data loss if...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: SQL Server Clustering and CSV's

    I wanted to know if it is possible to setup sql 2012 clustering with clustered shared volumes. I read here http://technet.microsoft.com/en-us/library/jj612868.aspx that it CSV does not support the Microsoft SQL...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Backup Encryption options with SQL Server 2008 R2 SE?

    Thanks a lot for the inputs. My initial thought was to use the option MediaPassword while backing up a database and script out the database backup instead of using a...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: connection string issue in app with integrated security

    Robert klimes (8/21/2013)


    I think you only need to change the web.config integrated security value if you wanted to use pass through authentication (ie use logged in to website is logged...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: connection string issue in app with integrated security

    Robert klimes (8/21/2013)


    you need to change the application pool identity to your domain user "appuser.xyz.local" and disable Anonymous authentication and enable Windows Auth in the website.

    OK..I will do that and...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Performance Issue: Where do you look?

    Do you have a baseline of how your procedures should perform?...

    This means that should someone report any slowness we can compare how the procedures have performed before till now and...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Setting up server to add a node to a cluster.

    I am guessing we add the node back into windows clustering and make it aware of the storage then add the node to sql clustering via sql install. Is that...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Performance Issue: Where do you look?

    And one more

    * Check the query execution plans for the slow running queries and see if there are any table scans and add indexes appropriately (again adding/dropping indexes should be...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Clustering Question

    Then I think double take's HA solution to protect SQL Server is something that I shd be looking at, since we are not interested in implementing something from scratch.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Clustering Question

    OK. But the requirement is strange. This is a company with all new IT and development team. None of us are completely aware of where the actual 40+(none of us...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Database in Recovery Pending State

    Check for the location where your ldf and mdf files are and As long as you have them try doing a detach/attach and it should bring the database to a...

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Exec msdb.dbo.sp_send_dbmail (zipped and password protected) issue

    password protected?

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

  • RE: Conversion failed when converting from a character string to uniqueidentifier

    cast on JID fixed the issue.

    “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

Viewing 15 posts - 16 through 30 (of 360 total)