Forum Replies Created

Viewing 15 posts - 61 through 75 (of 243 total)

  • RE: AWE

    jezza101 (7/28/2010)

    sudhakara (7/28/2010)

    But i dont know why only 4 GB can able to access even if i have 6 GB of RAM in my system.

    You might find the answer here.

    😉

    Hi,

    Thanks...

    July 28, 2010 at 2:51 am

    #1199118

  • RE: Backup fails when trying to remove old backup files

    Steve Jones - Editor (1/3/2006)

    I'd guess some type of backup grabbing the file. Any delay would cause SQL to fail as it's very intolerant of delays.

    Hi,

    I have set retention period...

    July 28, 2010 at 2:44 am

    #1199117

  • RE: AWE

    smackie1973 (7/27/2010)

    Win 32bit STANDARD can only use 4Gb RAM maximum. To use more than this you would need to install Enterprise Edition.

    To allow SQL Server to access this extra memory...

    July 28, 2010 at 12:25 am

    #1199079

  • RE: xp_cmdshell

    Adiga (7/23/2010)

    Check if some settings on the server is blocking access on Port 25. Also check with the Messaging Team, if they had changed something.

    Regarding TELNET not showing the desired...

    July 23, 2010 at 2:41 pm

    #1197777

  • RE: AWE

    Adiga (7/23/2010)

    This is official documentation of AWE

    Thanks for your reply, but can you let me know answer for my previous question ?

    July 23, 2010 at 2:39 pm

    #1197774

  • RE: Need help with XP_Cmdshell and Telnet

    Lynn Pettis (8/16/2007)

    try:<P class=MsoNormal><FONT face="Courier New" color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">exec xp_cmdshell 'telnet aukebper.dc-dublin.de 1521'</SPAN></FONT><P class=MsoNormal><FONT face="Courier New" color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier...

    July 23, 2010 at 10:23 am

    #1197611

  • RE: Sql Server 2005

    doobya (7/18/2010)

    I think it is related to permissions

    try changing MSSQLSERVER service login to "Local System"

    on my box the problem went at that point

    I still haven't located the exact problem yet...

    July 18, 2010 at 11:22 am

    #1194640

  • RE: SQL Agent

    magasvs (7/15/2010)

    Hi,

    Verify registry keys permissions for the service account. Full list of required permissions is here: http://support.microsoft.com/kb/283811

    Thanks for your reply. I will check and let you know.

    July 16, 2010 at 2:40 pm

    #1194362

  • RE: XP_Cmdshell

    Amit Pandey DeBugSQL (7/14/2010)

    This is due to the length of the string that you are passing.

    Use quotes like I have used below:

    This will work

    xp_cmdshell 'dir C:\"Program Files"'

    This will NOT...

    July 14, 2010 at 3:57 am

    #1192650

  • RE: Log Backup Failed.

    Hi,

    Thanks for your reply.

    July 3, 2010 at 10:11 am

    #1188530

  • RE: Alive

    Steve Jones - Editor (6/30/2010)

    If you just want to get notified if SQL is down, not Windows, Go to the control panel, look for services, look for the SQL Server....

    June 30, 2010 at 6:41 pm

    #1187416

  • RE: Alive

    Jeff Moden (6/30/2010)

    PaulB-TheOneAndOnly (6/30/2010)

    sudhakara (6/30/2010)

    Can you suggest me the best way to send a alert message when sql server has been stopped for log time ? example by using the...

    June 30, 2010 at 6:41 pm

    #1187415

  • RE: Alive

    PaulB-TheOneAndOnly (6/30/2010)

    sudhakara (6/30/2010)

    Can you suggest me the best way to send a alert message when sql server has been stopped for log time ? example by using the another sql...

    June 30, 2010 at 6:40 pm

    #1187414

  • RE: Alive

    Steve Jones - Editor (6/30/2010)

    The service has a series of options, depending on your OS, to run a command. You can use that.

    Thanks for your reply. Kindly the give me...

    June 30, 2010 at 12:20 pm

    #1187265

  • RE: Login Request Failed.

    magasvs (6/17/2010)

    You can open SQLDump00NN.txt file in the same folder.

    Is this the new SQL Server instance or you used it before? Were you able to connected to the SQL Server...

    June 17, 2010 at 9:34 am

    #1181659

Viewing 15 posts - 61 through 75 (of 243 total)