Forum Replies Created

Viewing 15 posts - 556 through 570 (of 761 total)

  • RE: How I can Connect The ODBC?

    al_yamama_1980 (4/30/2012)

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ [Instance Name]\MSSQLServer\SuperSocketNetLib\Tcp\REG_SZ TcpPort=

    This means that there is no registry entry for the default port that SQL Server is listening to. You can edit it as mentioned...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 30, 2012 at 2:43 am

    #1481056

  • RE: TRIGGERS

    From what I understand, the first two requirements are not Trigger requirements at all. You can do the following for your requirements:

    1. If there is no @ symbol exists...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 30, 2012 at 1:14 am

    #1481040

  • RE: How I can Connect The ODBC?

    The following link might help you:

    SQL Server May Not Listen on TCP/IP Sockets When TCP/IP is the Only Protocol

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 30, 2012 at 12:13 am

    #1481030

  • RE: Custom Xml and Sql Server 2008

    Please post the data and the query you used.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 30, 2012 at 12:06 am

    #1481029

  • RE: Replacement for Cursors

    Jeff Moden (4/28/2012)

    vinu512 (4/27/2012)

    Thank you Mr. Moden.

    I've just started as a DBA(a while back) and have no idea where I will end up with it. But I am definitely loving...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 29, 2012 at 10:19 pm

    #1481019

  • RE: Unicode is not working in SQL 2000

    MysteryJimbo (4/28/2012)

    vinu512 (4/28/2012)

    Sql Server 2005/2008 very well support Unicode. You just need to insert data correctly. Plus, you need to use data types like nvarchar for good performance.

    You dont necessarily...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 28, 2012 at 6:27 am

    #1480839

  • RE: Unicode is not working in SQL 2000

    Sql Server 2005/2008 very well support Unicode. You just need to insert data correctly. Plus, you need to use data types like nvarchar for good performance.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 28, 2012 at 5:13 am

    #1480836

  • RE: SQL Server Database Replication. URGENT PLEASE

    vinu512 (4/28/2012)

    fmaruf (4/28/2012)

    Hi,

    I hope everybody is doing well.

    I have two Windows Server 2003 Servers. On both servers, we have installed same application and SQL Server 2008 database. Both servers are...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 28, 2012 at 3:15 am

    #1480820

  • RE: Inculude column index

    Included columns improve the performance of Select queries. But, having too many Included columns decreases the performance of Insert, Update, or Delete operations to the underlying table or indexed view...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 28, 2012 at 2:29 am

    #1480817

  • RE: upgrade advisor -- method not found

    maryamzolfaghar (4/28/2012)

    I have the upgrade advisor installed on a server, but I still get the same errors

    I want to upgrade from sql 2000 to 2008

    I get errors like:

    method not found...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 28, 2012 at 1:27 am

    #1480816

  • RE: SQL Server Database Replication. URGENT PLEASE

    fmaruf (4/28/2012)

    Hi,

    I hope everybody is doing well.

    I have two Windows Server 2003 Servers. On both servers, we have installed same application and SQL Server 2008 database. Both servers are located...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 28, 2012 at 1:24 am

    #1480815

  • RE: Unicode is not working in SQL 2000

    jbkumar03 (4/27/2012)

    Hi Friends,

    I have Sql 2000. Since their a problem with unicode.

    I have a doubt.whether Sql 2005/2008 will support unicode.

    Problem arises with unicode is Unique key is Ariseing Error for...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 28, 2012 at 1:13 am

    #1480813

  • RE: It is possible to convert Sql 2000 to 2008

    jbkumar03 (4/27/2012)

    Hi Friends,

    I need to upgrade my Sql Server from sql 2000 to Sql 2008.

    Is there any problem will arise or any syntax issue will come..

    Can any know...

    whether u have...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 28, 2012 at 12:22 am

    #1480805

  • RE: Replacement for Cursors

    Thank you Mr. Moden.

    I've just started as a DBA(a while back) and have no idea where I will end up with it. But I am definitely loving what I am...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 11:32 pm

    #1480796

  • RE: DTS--issue

    DTS does not work in 64 bit runtime

    Try this:

    Use 32bit runtime option for SQL Agent

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 11:20 pm

    #1480794

Viewing 15 posts - 556 through 570 (of 761 total)