Forum Replies Created

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

  • RE: Getting an error "Exception of type 'System.OutOfMemoryException' was thrown." during stored procedure execution

    what your issue. symptoms?

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Missing green arrow on the sql server icon in object explore

    Erik Edvalson (1/14/2013)


    I know that this thread has gone stale without replies for quite some time. However, I was having this same problem and I figured it out. ...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Reinstall after disk failure on Sql 2005 server

    opc.three (7/10/2012)


    you can change the port that instance sql01\sql01 listens on to 1433, the default port for SQL Server. If you do that then users will be able to access...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Changing SQLserver default port

    durai nagarajan (7/10/2012)


    Hello,

    As a part of security, we are planning to change sql server default port.

    what the precations we need to take care and how can we connect using management...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Changing the size of primary file in sql server 2008

    That depends.

    Do you want to shrink or grow the file?

    Is there any data in it?

    Assuming the database is empty and the space allocation was a mistake, go to propertries of...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Mirroring and Clustering

    Thanks Perry.

    We had at the same moment come up with a slightly different solution which tests ok.

    We have created multiple Access-Points per SQL cluster bound to the different pairs of...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Database Mail to Distribution List

    How are you sending the mail fromn SQL? Is it automated through the job agent or using sp_send_mail or something like that?

    Try this:

    1. ensure database mail is enabled.

    2. ensure youu...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Cluster Services

    Ok thanks John,

    Will ensure to put it on the checklist for post-build config changes.:-)

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Cluster Services

    John Mitchell-245523 (6/21/2012)


    Happy to help, Adam. I've done a bit more digging, and, by default, the "Is Alive" check runs every 60 seconds when the cluster service connects to SQL...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: How to release the unallocated sapce in database???

    Lavanyasri (6/21/2012)


    HI ,

    Thanks for the update .

    i run the maintenance plan again with fill factor 90 % , but i did not find any changes in the...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: How to release the unallocated sapce in database???

    Lavanyasri (6/21/2012)


    I think u r not understanding what i am asking . I am not asking amount the memory [RAM], i want to release the Database unallocated space .

    What...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Cluster Services

    John Mitchell-245523 (6/21/2012)


    Schadenfreude-Mei (6/21/2012)


    Our ClusterAdmin account doesnt have any access to SQL. The services are set with our domain credentials for the SQL service account..... Why would you need anything...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Cluster Services

    durai nagarajan (6/21/2012)


    Schadenfreude-Mei (6/21/2012)


    Dinesh-277232 (6/20/2012)


    Clusteradmin account should have public access on SQL Server

    Our ClusterAdmin account doesnt have any access to SQL. The services are set with our domain credentials for...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Cluster Services

    Dinesh-277232 (6/20/2012)


    Clusteradmin account should have public access on SQL Server

    Our ClusterAdmin account doesnt have any access to SQL. The services are set with our domain credentials for the SQL service...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • RE: Upgrade from 9.0.4035 to 9.0.4053

    ran.ovadia (6/20/2012)


    Thanks, I've already seen that but unfortunelty I can't run updates on the machine since it doesn't have WLAN connection...

    I need a link for downloading the installer.

    Thanks,

    Ran.

    Try this, pick...

    Adam Zacks-------------------------------------------Be Nice, Or Leave

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