sqlserver 1433¶Ë¿ÚµÄÎÊÌâ(ÕûÁËÒ»ÌìÎÞ¹û,¶¥Ò²ÓзÖ)
xp(sp3)ϵͳ°²×°ÁËsqlserver2000£¬sp3£¬sp4²¹¶¡¶¼´òÁË¡£¶øÇÒ±¾»úÒ²ÄÜÁ¬½Ó·ÃÎÊ¡£
ÎÊÌâÊÇ£º
±¾»útelnet ip 1433 ×ÜÊÇÌáʾÁ¬½Óʧ°Ü£¬
¶øÇÒnetstat -naʱ£¬¿´²»µ½1433¶Ë¿Ú±»Õ¼ÓÃ
(¿Ï¶¨µÄÊÇ£º¶Ë¿ÚÊÇ1433£¬¿ªÆôÁËtcp/ip£¬ÃüÃû¹ÜµÀ·½Ê½..)
·À»ðǽҲ¹Ø±ÕÁË£¬(windows×Ô´ø·À»ðǽҲûÓпªÆô)
ÍøÉϵÄһЩ½â¾ö·½°¸Ò²³¢ÊÔ¹ý(ÀýÈ磺Ìí¼Ó±ðÃû)»¹ÊDz»Ðа¡£¡£¡£¡
Çó¸÷λȺ²ßȺÁ¦°ï½â¾öһЩ.°ï¶¥Ò²ÓзÖ.
¶Ë¿ÚÊÇ1433?´ò¿ªÁË»¹±¾»ú²âÊÔʧ°Ü
Â¥Ö÷µÄÒâ˼ÊDz»ÊÇÔ¶³ÌÁ¬½Ó²»ÄÜʹÓã¿
ÊDz»ÊÇ»¹Í¬Ê±×°ÁË2005?Èç¹ûÊÇ,¶Ë¿Ú±»Õ¼ÓÃÁË,»»¸ö¶Ë¿Ú,»òÊÇжÔØ2005.
ûÓа²×°sqlserver2005£¬Ô¶³ÌÎÞ·¨Á¬½Ó£¬±¾»úÎÞ·¨telnet 1433
¿ÉÒÔ»»¸ö¶Ë¿ÚÊÔÏÂ
ÕÒ±¾»úµÄÔÒò,±¾»ú¶¼²»ÄܲâÊÔtelnet 1433
±¾»útelnet ip 1433 ÌáʾÁ¬½Óʧ°ÜµÄÄǾͺͷÀ»ðǽû¹Øϵ¡£
³¢ÊÔһϣº
1.È·ÈÏSQL·þÎñÒѾÆô¶¯¡£
2.Éí·ÝÑéÖ¤·½Ê½Îª£ºSQL SERVERºÍwindows.
{{----
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
sqlserver´æ´¢¹ý³Ì¸Äoracle
˻ᰡ¡£¡£¡£°ïæ¸Ä¸Ä··
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE tp_Fetch_List(
  ......
ÎÒÏë×öÒ»¸ö´¥·¢Æ÷£¬µ«Ð޸ıíTµÄ×Ö¶ÎC1ʱ£¬ÅжÏÈç¹ûÐ޸ĺóµÄֵΪ-1£¬Ôò¸üбíT¸ÃÐмǼµÄ×Ö¶ÎC2Ϊijֵ¡£
CreateTRIGGER [Tri_UpdateLastSaveDate] ON [dbo].[T]
for UPDATE
AS
BEGIN ......
»¹ÔµÄ±¨´íÐÅÏ¢:
System.Data.SqlClient.SqlError: ±¸·Ý¼¯ÖеÄÊý¾Ý¿â±¸·ÝÓëÏÖÓÐµÄ 'chat_Data' Êý¾Ý¿â²»Í¬¡£ (Microsoft.SqlServer.Smo)
Çë¸÷λ¸ßÊÖ°ïæ½â¾ö
»¹ÔµÄÊý¾Ý¿âÃû×ÖÓ뱸·ÝµÄÊ ......
ÎÒµÄÊý¾Ý¿âͻȻ±¨Ò»¸öºÜÓôÃƵĴíÎ󣬵¼ÖÂÊý¾ÝÎÞ·¨²é¿´£¬
´íÎóÌáʾΪ£º
ÔÚÎļþ 'G:\data\ÆóÒµ¹ÜÀíÊý¾Ý¿â1_data.n ......