http://www.sqlmag.com/authors/author/author/5777528/rsscomment/5777528en-USFri, 25 May 2012 08:44:41 GMTFri, 25 May 2012 08:44:41 GMThttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorThu, 28 Dec 2006 05:04:35 GMT
for the person looking to see if a linked server exists, you can check the output of sp_LinkedServers, or you can do what the sp_linkedServers procedure does and run the following select * from master.dbo.sysservers Where srvname = @YourLInkedServerName]]>SageThu, 28 Dec 2006 05:04:35 GMThttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorhttp://www.sqlmag.com/article/auditing/configuring-sql-server-2000-options#commentsAnchorWed, 29 Jun 2005 18:17:29 GMT
I didn’t post the original question about changing the font in the stored procedure window, but THANK YOU! This has made my job so much easier.]]>Anonymous User Wed, 29 Jun 2005 18:17:29 GMThttp://www.sqlmag.com/article/auditing/configuring-sql-server-2000-options#commentsAnchorhttp://www.sqlmag.com/article/auditing/configuring-sql-server-2000-options#commentsAnchorTue, 21 Jun 2005 13:43:31 GMT
To change the font in the stored procedure window, right click inside the window and choose font. The setting will be permanently retained.]]>Anonymous User Tue, 21 Jun 2005 13:43:31 GMThttp://www.sqlmag.com/article/auditing/configuring-sql-server-2000-options#commentsAnchorhttp://www.sqlmag.com/article/auditing/configuring-sql-server-2000-options#commentsAnchorMon, 02 May 2005 04:55:38 GMT
Is there any way to change the font size/name in the stored procedure window since it’s often hard on the eyes ]]>Anonymous User Mon, 02 May 2005 04:55:38 GMThttp://www.sqlmag.com/article/auditing/configuring-sql-server-2000-options#commentsAnchorhttp://www.sqlmag.com/article/clustering/clustering-sql-server#commentsAnchorSun, 17 Apr 2005 04:42:53 GMT
Brian there is a little more to clustering than the information presented in this article. ]]>ANDREWSun, 17 Apr 2005 04:42:53 GMThttp://www.sqlmag.com/article/clustering/clustering-sql-server#commentsAnchorhttp://www.sqlmag.com/article/auditing/configuring-sql-server-2000-options#commentsAnchorTue, 08 Mar 2005 10:02:24 GMT
Is there any way to change the font size/name in the stored procedure window since it’s often hard on the eyes]]>Anonymous User Tue, 08 Mar 2005 10:02:24 GMThttp://www.sqlmag.com/article/auditing/configuring-sql-server-2000-options#commentsAnchorhttp://www.sqlmag.com/article/sql-server-70/sql-server-7-0-service-pack-2#commentsAnchorThu, 27 Jan 2005 07:00:08 GMT
vfggr]]>Anonymous User Thu, 27 Jan 2005 07:00:08 GMThttp://www.sqlmag.com/article/sql-server-70/sql-server-7-0-service-pack-2#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorTue, 23 Nov 2004 14:55:29 GMT
My shop recently installed a packed application which uses SQL Server 2000 as the database and UDB on AIX as the enterprise database to replicate data to and from. We use the Linked server with IBM OLE DB provider to access the enterprise data. The vendor for the package application recommends us to enable "ALLOW INPROCESS" option on the linked server. On the daily basis we run two batch jobs to upload and download (replicate) data between the two heterogenous databases. However, we are experiencing memory problem after a few runs of the batch jobs. The memory usage of the SQL server grows every time we run the batch and did not release it (the memory). As a temporary solution, we have to stop and start the SQL server. To us, it looks like a memory leaks, however Microsoft technical does not agree with it. Do you have any hints or tips how to resolve it. Perhaps some option parameters that we have to check on or off ? Thank you. Regards, T Tan tantekh@manulife.com]]>Anonymous User Tue, 23 Nov 2004 14:55:29 GMThttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorWed, 17 Nov 2004 11:33:19 GMT
I have stored procedure that I am running in SQL Server 2000 that uses the OpenQuery(). This works great when I run it from SQL Server, but I try to execute it in a Visual Basic app using ADO and I get the following message: [OLE/DB provider returned message: [Microsoft][ODBC driver for Oracle]Driver not capable]. I was wondering if anyone knew of a solution as to why this happens. Many thanks in advance. Eddie]]>Anonymous User Wed, 17 Nov 2004 11:33:19 GMThttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorThu, 04 Nov 2004 12:04:07 GMT
I am using IBMDADB2 as well and the four part query was returning the same responses for me. It was only when I used openquery() that I was able to get results.]]>Anonymous User Thu, 04 Nov 2004 12:04:07 GMThttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorhttp://www.sqlmag.com/article/clustering/clustering-sql-server#commentsAnchorFri, 03 Sep 2004 02:12:44 GMT
great]]>ASFENFri, 03 Sep 2004 02:12:44 GMThttp://www.sqlmag.com/article/clustering/clustering-sql-server#commentsAnchorhttp://www.sqlmag.com/article/auditing/configuring-sql-server-2000-options#commentsAnchorSun, 04 Apr 2004 04:43:17 GMT
hello could you send to me about SQL personal ED Thank]]>Nguyenduyhai Sun, 04 Apr 2004 04:43:17 GMThttp://www.sqlmag.com/article/auditing/configuring-sql-server-2000-options#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorMon, 08 Mar 2004 20:02:05 GMT
I tried to create linked server to access in SQL sever using the steps outlined in this article. However, I keep getting the error 7339 message . I tried to look up explanation for this error on the net and tried to resolve it based on the suggestions listed in those articles but with no success. Also I tried to set up a linked server to dataware house its giving me err 7303, could not initialize the provider IBMDADB2, this comes if I use the provider IBM OLE DB Provider for DB2 servers, the DSN for datawarehouse has been set up using IBM DB2 ODBC DRIVER. If I use MS OLE DB FOR ODBC DRIVER for datawarehouse than I get err 7399. Can you please let me where I am going wrong. I have wasted a lot of time on this. Your help is much appreciated Nalina]]>Nalina Mon, 08 Mar 2004 20:02:05 GMThttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorThu, 04 Mar 2004 09:01:51 GMT
I can’t find in this article how can i check if linked server already exist? Thanks]]>DmitryThu, 04 Mar 2004 09:01:51 GMThttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorhttp://www.sqlmag.com/article/ftp/dts-grows-up#commentsAnchorMon, 01 Dec 2003 18:43:30 GMT
I agree that DTS is a real treat - especially if you have users who need to update huge amount of data on a monthly basis into the companies accounting system. - and this is where my problem lies - I (and many, many other developers also) need information on specifically how to call DTS packages from ASP.NET, as one would do in VB - and not by calling a storedproc. An example would be that I need to open the DTS package and replace the source file with the selected file that has set up the remittance advices for import. I also need to generate a batch number and make sure the batch number has actually been used during the import. If each step is tested, and no error was found, and the batch number has changed from the old batch number to the new one, I know the DTS executed successfully. I can then supply the users with the correct batch number for reference that they will find in the accounting system. There are issues with the ASPNET user to use the DTSpkg.dll file. One has to grant ASPNET user the privilege to open and execute the dll. - That is all I know so far and still cannot get it to work. If you have any idea on how to open and execute a DTS package from ASP.NET, that will be an enourmous step towards making ASP.NET work as a ’Web application’ and not just a web page. There is no reference to this problem on Microsoft.com and I can find no reference either on the web. Thanks in advance. Graham]]>Graham Beetge Mon, 01 Dec 2003 18:43:30 GMThttp://www.sqlmag.com/article/ftp/dts-grows-up#commentsAnchorhttp://www.sqlmag.com/article/clustering/clustering-sql-server#commentsAnchorSun, 28 Sep 2003 07:09:18 GMT
Clustering SQL Server When I select/attempt to access the side bar "Network Setup Options" I receive the following: Sorry, but you entered a document ID that does not exist on this site. Appreciate any help you can provide. Thank you PJR Contact id = 112556]]>Paul Roy Sun, 28 Sep 2003 07:09:18 GMThttp://www.sqlmag.com/article/clustering/clustering-sql-server#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorThu, 10 Oct 2002 07:03:01 GMT
I have configured a linkedserver in SQL Server 2000 to a DB2 (AS/400) database using Microsoft’s Oledb provider for DB2. I’m also using Host Integration Server with SP1 as my gateway. I can issue "select" statements through the server but "Inserts", "updates" and "deletes" do not work. Can you help me with this?]]>Chris Singleton Thu, 10 Oct 2002 07:03:01 GMThttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorWed, 03 Oct 2001 09:52:32 GMT
I was wondering if it’s possible to edit the values in a query of a LinkedServer?]]>Rick Bray Wed, 03 Oct 2001 09:52:32 GMThttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorhttp://www.sqlmag.com/article/ftp/dts-grows-up#commentsAnchorFri, 27 Jul 2001 11:51:50 GMT
DTS has improved in SQL 2000, however there’s still room for improvement. The FTP process only works one way (receiving files), how about sending???]]>Jerry Burns Fri, 27 Jul 2001 11:51:50 GMThttp://www.sqlmag.com/article/ftp/dts-grows-up#commentsAnchorhttp://www.sqlmag.com/article/auditing/sqlaudit-1-7#commentsAnchorMon, 30 Apr 2001 02:52:20 GMT
i am trying to access the web site(www.redmatrix.com) for 2 weeks now,nothing is there,does anyone know if they still exist ?]]>Danny Ravid Mon, 30 Apr 2001 02:52:20 GMThttp://www.sqlmag.com/article/auditing/sqlaudit-1-7#commentsAnchorhttp://www.sqlmag.com/article/ftp/dts-grows-up#commentsAnchorTue, 27 Mar 2001 18:23:46 GMT
DTS is certainly getting more reusable. But when I use global variables (e.g., gvServer to change the Data Source and gvDB to change the Catalog), the Data Pump is still looking for xxx.dbo.table on the new server (which generates an error if the xxx database doesn’t exist on the new server)instead of yyy.dbo.table, where xxx is the old gvDB value and yyy is the new gvDB value. Am I missing something? Thanks for any comments.]]>Robert Couldry Tue, 27 Mar 2001 18:23:46 GMThttp://www.sqlmag.com/article/ftp/dts-grows-up#commentsAnchorhttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchorMon, 24 Jul 2000 12:04:42 GMT
I have an Oracle 8i running on NT and the Select statement using the OPENQUERY method mentioned in your article (SELECT * FROM OPENQUERY(LINKEDSERVER, "SELECT * FROM northwind..Categories where CategoryName Like ’Sea%’") does not work with quotation marks. It works with a single quote but then I have trouble with the WHERE statement ( ’Sea%’ ) Can you help me with this problem? Jose Lucero Real Property Technologies]]>Jose Mon, 24 Jul 2000 12:04:42 GMThttp://www.sqlmag.com/article/enterprise-manager/linked-servers#commentsAnchor