Recent content by DLSQL

Is your main objective to transfer DTS packages from a test server to a production server? If so you can use DTSBackup, and it will transfer the package. I believe the tool is free. Just search in google for DTSBackup. DL MCDBA, MCSD, MCT, etc.

We are experiencing a similar issue with our ASP.NET application. I will check with our principal programmer on that to see if he has any resolution DL MCDBA, MCSD, MCT, etc.

Since you have the linked server setup you can use the following stored procedures to see what catalaogs and tables exist: sp_linkedservers sp_primarykeys sp_catalogs sp_indexes sp_column_privileges sp_table_privileges sp_columns_ex sp_tables_ex sp_foreignkeys like so exec...

r937 I have a way to make this easier in the future. http://support.microsoft.com/default.aspx?kbid=239454 This article describes a tool on the SQL 7 CD that allows you to export the SQL package to a VB file. The VB file uses the SQL 7 DTS Object model to build a package. Inside the code you...

You have two approaches: Linked servers or Data Transformation Services (DTS). With Linked Servers you create a linked server connection (go to Security in EM). Then you right four part queries: Insert LinkedServer.Catalog.owner.table (col1, col2) SELECT col1, col2 from mytable. With DTS you...

My only suggestion for your error is to carefully examine equivalency of data types between Delphi and SQL. Perhaps the Delphi Integer is 32 bit instead of 16 bit (like small int) or perhaps WideString is expecting Unicode (nvarchar) HTH, DL MCDBA, MCSD, MCT, etc.

--A Join with a correlated Subquery should do the trick -- Assumming that enteredTime is a DateTime field. SELECT r.cbr, Region, enteredTime, Score FROM tCBR r JOIN tScore s ON r.cbr = s.cbr WHERE enteredTime = (SELECT Max(enteredTime) FROM tScore WHERE tScore.cbr = r.cbr) DL MCDBA...

Are you using and MDB or an Access Data Project? If an MDB how are you connecting to execute the sproc? DL MCDBA, MCSD, MCT, etc.

Yes. Although when I referred to sp_oa I was referring to a set of sprocs: sp_OACreate, sp_OAMethod, sp_OAGetProperty, sp_OASetProperty, and sp_OADestroy (there are others). If you look these up in the BOL you should get a good idea of how to call a COM component from a sproc or sql script...

Do you mean that your SQL Server Stored Procedure needs to interact with another web server to submit some data for processing and then get the results back? Your best bet would be to create a component in VB that can open a URL, parse the results and return what you need. Then this object...

What version of Access? Are you using and MDB or an Access Data Project? If an MDB how are you connecting to execute the sproc? DL MCDBA, MCSD, MCT, etc.

I presume you are on SQL 2000 and you are using Disconnected Edit to rename the tasks. The problem is that the steps refer to the tasks by name. So you have to go into the properties of each step and change the task to which it points for execution. There may be other places where you need to...

This should do it: SELECT DISTINCT FH.UniqueID, dbo.lookUp(@tempUid) FROM FileHieararchy FH INNER JOIN tbl_File_Views F_V ON F_V.UniqueID = FH.UniqueID INNER JOIN tbl_File_ViewDetails F_VD ON F_VD.GroupID = F_V.GroupID INNER JOIN tbl_File_Details F_D ON F_D.FileID = F_VD.FileID...

If you get the error when you click on the Server Icon in EM then I would wager that your SQL Service is not started. Use the SQL Service Manager to see if the service is started (or using the Services applet in Administrative tools). If not look in the Event Viewer in both System and...

Yes. The Distributor and the Publisher can be on the same machine. Yes the Distributor and subscriber can be on the same machine but only for one subscriber. Unless you are republishing several times. In fact you can have the Publisher, Distributor and Subscriber all be on the same machine (I...