64λSQL Server2005·ÃÎÊ32λSQL Server2000µÄÎÊÌâ
HR·þÎñÆ÷£º ²Ù×÷ϵͳ->32λWindows2000 SP4 Êý¾Ý¿â->32λSQL Server2000
OA·þÎñÆ÷£º ²Ù×÷ϵͳ->64λWindows2003 SP2 Êý¾Ý¿â->64λSQL Server2005
OAÏîÄ¿ÖУ¬ÐèÒª´ÓHR·þÎñÆ÷ÖÐÈ¡µÃÓû§µÄÊÖ»úºÅ¡£¶ÔÕâÖÖÇé¿ö£¬ÎÒÒÔÇ°¶¼ÊÇʹÓý¨Á¢Á´½Ó·þÎñÆ÷µÄ·½Ê½£¬ÓÚÊÇ£¬ºÜ¿ìµØдºÃ½Å±¾£¬°ÑHR·þÎñÆ÷×¢²áÁË£º
exec sp_dropserver 'HRServer', 'droplogins'
exec sp_addlinkedserver 'HRServer', '', 'SQLOLEDB', '10.101.166.38'
exec sp_addlinkedsrvlogin 'HRServer', 'false', null, 'sa', 'buaa369'
È»ºóÖ´ÐвéѯÓï¾ä£º
select top 10 * from HRServer.testdb.dbo.EmpContactMethod
½á¹û£¬²¢Ã»ÓгöÏÖÊìϤµÄÏÔʾ¼Ç¼»Ã棬ֱ½Ó±¨´íÁË¡£¡£¡££¨Ó¢Îİ棩
OLE DB provider "SQLNCLI" for linked server "hrserver" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "hrserver" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
ÏûÏ¢ 53£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 0 ÐÐ
Named Pipes Provider: Could not open a connection to SQL Server [53].
´Ëʱ£¬Èç¹ûÔÚÆóÒµ¹ÜÀíÆ÷ÖÐ×¢²áÕâ¸öHR·þÎñÆ÷£¬×öÏàÓ¦µÄ²éѯ¶¼Ã»ÎÊÌâ°¡¡£¡£¡£¡£
ÕâºÜÄÖÐÄÄÅ¡£
µ½CSDNÉϵÚÒ»´ÎÇóÖú£¬ËµÊÇ°æ±¾²»¶Ô£¬ÐèÒªSQL Server2000Ðè°²×°SP3»òSP4²¹¶¡¡£
¸½°æ±¾²éѯ½Å±¾£ºSELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
°æ±¾ºÅ¶ÔÓ¦£º
&nbs
Ïà¹ØÎĵµ£º
½ñÌì¸ø´ó¼Ò·ÖÏíÒ»ÏÂÈçºÎ±¸·ÝºÍ»Ø¸´sql server Êý¾Ý£¬
Ê×ÏÈÈ·±£Äã¾ßÓÐDBµÄ×î¸ßȨÏÞ
ÔÚJAVA´úÂëÖÐ Äã¿ÉÒÔÕâÑùдpublic class Opp extends TestCase{
public void test1()
{
try
{
Connection con = DBUtils.getConn();
String sql="backup database tdzl to disk='d:\\tdzl.bak'";
Statement st = con.c ......
±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Ò»)--sum()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(¶þ)--max()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(Èý)--row_number() /rank()/dense_rank()
[Oracle]¸ßЧµÄSQLÓï¾äÖ®·ÖÎöº¯Êý(ËÄ)--lag()/lead()
Èç¹ûÎÒÃÇ°´ÕÕʾÀýÏëµÃµ½Ã¿¸ö²¿ÃÅнˮֵ×î¸ßµÄ¹ÍÔ±µÄ¼Í¼£¬¿ÉÒÔÓÐËÄÖÖ·½·¨ÊµÏÖ£ ......
±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Ò»)--αÁÐROWNUMʹÓü¼ÇÉ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(¶þ)--±êÁ¿×Ó²éѯ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Èý)--PackageµÄÓŵã
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(ËÄ)--ÅúÁ¿´¦Àí
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Îå)--µ÷Óô洢¹ý³Ì·µ»Ø½á¹û¼¯
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Áù)- ......
±¾ÏµÁÐÎÄÕµ¼º½
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Ò»)--αÁÐROWNUMʹÓü¼ÇÉ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(¶þ)--±êÁ¿×Ó²éѯ
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Èý)--PackageµÄÓŵã
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(ËÄ)--ÅúÁ¿´¦Àí
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Îå)--µ÷Óô洢¹ý³Ì·µ»Ø½á¹û¼¯
[Oracle]¸ßЧµÄPL/SQL³ÌÐòÉè¼Æ(Áù)- ......
12 Essential Steps After Installing SQL Server
By : Sadequl Hussain
Jul 13, 2009
from: http://www.sql-server-performance.com/articles/dba/post_installation_steps_p1.aspx
Rolling out SQL Servers is a key task for
DBAs. While for some DBAs this can be a frequent exercise, others wi ......