Forum Replies Created

Viewing 15 posts - 226 through 240 (of 644 total)

  • RE: Unable to connect to one of Production database through SSMS

    Try adding the hostname entry for the production server in the host file on dev box & check. It seems DNS resolution is not working properly.

    July 12, 2012 at 5:14 am

    #1511977

  • RE: Log Shipping Restor job failed

    jugo.pinky (7/12/2012)

    Dear Anthony,

    actually i configured this in client server.so i dont know whether they deleted or not.

    but can u pls tell me what to do now

    1. Disable log shipping jobs...

    July 12, 2012 at 4:58 am

    #1511975

  • RE: DTA and SQL Server profiler

    Grant Fritchey (7/11/2012)

    Divine Flame (7/11/2012)

    I don't find DTA very useful. If we want to get the missing index recommendations, DMVs (such as sys.dm_db_missing_index_details) are more helpful.

    And the missing index information...

    July 11, 2012 at 8:04 am

    #1511558

  • RE: Index Types

    10 is the right answer! not sure how correct answer has been concluded to be (10,12). Interesting that according to the author it is the correct answer as per BOL:w00t:!...

    July 11, 2012 at 7:57 am

    #1511549

  • RE: String Length

    Good question!

    July 11, 2012 at 7:20 am

    #1511526

  • RE: EXEC xp_cmdshell

    Nagabhushan (7/10/2012)

    EXEC xp_cmdshell 'findstr "DWG" E:\ABC\XYZ\123a.TXT > E:\ABC\XYZ\987a.TXT'

    file is not creating while execute in SSMS, but if we execute same command in command prompt it is creating file, can you...

    July 11, 2012 at 6:26 am

    #1511487

  • RE: Connection Failed Issue

    krishnaprasad14 (7/11/2012)

    Have test the Connesction String and its working fine.

    Thank you

    Run below command from a command prompt on the server hosting the application.

    telnet <SQL Server IP> <SQL Server Port...

    July 11, 2012 at 6:23 am

    #1511483

  • RE: Mirroring errors

    adb2303 (7/9/2012)

    Turns out that something's wrong with our mirror server. I mirrored elsewhere and it works fine.

    Basically, I am testing mirroring between SQL Server Client Access Points in 2...

    July 11, 2012 at 6:17 am

    #1511475

  • RE: DTA and SQL Server profiler

    I don't find DTA very useful. If we want to get the missing index recommendations, DMVs (such as sys.dm_db_missing_index_details) are more helpful.

    July 11, 2012 at 6:07 am

    #1511466

  • RE: Unable to set filegroup to read only

    raotor (7/11/2012)

    There were no message returned as a result of performing the DBCC CHECKDB command with the options you specified other than telling me that the command was successful.

    If I...

    July 11, 2012 at 5:59 am

    #1511463

  • RE: How to Send mail from Sql mail to mobile ?

    You should contact to your exchange administrator in this case. It seems as some security (permissions) issue.

    July 11, 2012 at 5:34 am

    #1511451

  • RE: Help Can't start the SQL Service

    junlong_9292 (7/6/2012)

    As per the topic,

    I can't seem to start my SQL services. It always give me this error. Any expert out there can help me?

    What error do you get in...

    July 6, 2012 at 6:59 am

    #1509665

  • RE: What could break Log Shipping / Mirroring

    n00bDBA (7/3/2012)

    Hi all,

    I was looking around and trying to find known issues with using either Mirroring or Log Shipping. From what i read if a app runs Truncate table,...

    July 3, 2012 at 7:25 am

    #1508227

  • RE: Applying SQL SP and Windows Patches

    If you are concerned about log shipping then it is more or less same proces as applying it on a normal server. Yes, you are right about the thing that...

    June 22, 2012 at 3:53 am

    #1504408

  • RE: The Sequence Object in SQL Server 2012

    As many posters have said above, the article doesn't really provide the real world example on where to use sequences.

    June 4, 2012 at 4:38 am

    #1496407

Viewing 15 posts - 226 through 240 (of 644 total)