Forum Replies Created

Viewing 15 posts - 316 through 330 (of 1,366 total)

  • RE: Error 8601

    saimsaboor (6/21/2016)


    It might possible the table is having column store index and user is trying to do operations i.e. insert, update or delete. In that case this error can happen....

  • RE: SQL Server 2014 Connectivity

    narayanamoorthy.a (6/20/2016)


    Hi,

    There are three SQL 2014 instances in my LIVE box, one runs in 1433, other in 1434 and next other in 1435. I am able to connect SQL 2014...

  • RE: Table Size & Page Count

    Thanks a lot Gail.

  • RE: Table Size & Page Count

    GilaMonster (6/19/2016)


    Depending how the 'table size' is being calculated, it may not take the LOB columns into account.

    Used below script by Bill Graziano.

    /**************************************************************************************

    *

    * BigTables.sql

    * Bill Graziano (SQLTeam.com)

    * ...

  • RE: Table Size & Page Count

    GilaMonster (6/19/2016)


    VastSQL (6/19/2016)


    Table got a column with datatype varbinary(Max) which stores attachment.

    That's probably why. Varchar(max) columns are stored out of row, so depending how that 'table size' is being calculated,...

  • RE: recover the data

    k2000.rajesh (6/16/2016)


    can you guide me how to recover the data

    The full back up was taken at 7:00 AM

    Users did the work till 4:30 PM

    Records were deleted at 4:45 PM

    I want...

  • RE: Restoring a database (without effecting original) - to test the retore process...

    jellybean (6/13/2016)


    Hi,

    Hope this is the right forum. I using SQL Server 2014 and want to test the "restore" process is working correctly. What I wan to do is restore an...

  • RE: sql server 2014 installation issue

    naveenareddy.dba (6/4/2016)


    Hi

    While installing sql server 2014, its asking to restart the computer.

    after deleted pending file rename operations and restarted also its giving the same error.

    please any one can help me,to...

  • RE: Service Broker & Query Notification

    Anyone on this?

  • RE: SQL back Job is failing

    Are you taking backup to a different location or on same server?

    Are you getting any error while taking backup manually using the same windows acccount?

  • RE: Log backup taking long.

    tmmutsetse (5/23/2016)


    Hi Experts,

    can you please advise my log backup is taking long to finish.It normaly takes less than 12minutes but its running upto 2 hrs.

    I am checking the logs i...

  • RE: Can't restore a DB

    monterorf (5/17/2016)


    Hello friends, i really hope you may help me.

    I've trying to restore a db since 2 days ago and it simply can't be restored.

    I've tried from the wizard...

  • RE: SQL Server Connectivity

    Steve Jones - SSC Editor (5/17/2016)


    Need TCP 1433.

    You can explicitly connect to a server on a port. The first item below connects to the instance named "myserver" on port 1433...

  • RE: SQL Server Connectivity

    Welsh Corgi (5/17/2016)


    Did you try and execute IPCONFIG from the Server? Do you have the correct IP Address?

    Thanks Welshi,

    Connecting using VPN which allocate dynamic IP in same range but.

  • RE: SQL Server Connectivity

    Welsh Corgi (5/17/2016)


    Can you ping the Server?

    Can you remote into that Server, launch SQL Server Configuration Manager and check the configuration settings?

    Cant ping to server.

    RDP,yes. TCP\IP is enabled, Remote connections...

Viewing 15 posts - 316 through 330 (of 1,366 total)