Recent content by JoeSack

It shouldn't have a problem with that time format, no. Datetime should be able to store the full date and time. Best Regards, Joseph Sack, http://www.JoeSack.com Author of "SQL Server 2000 Fast Answers for DBAs and Developers".

Hi, DTS may not be necessary for what you are looking for. You could set up a linked server to Server 2 on Server 1, then create a stored procedure that checks data on the second server and inserts or updates data accordingly. You can then schedule the execution of the stored procedure as a...

Hi, Found your newer thread, and now found this one which you referred to. Access to SQL Server is only controlled by logins, and not by the host machine. Use SQL Profiler (or a server-side profile trace) to monitor a host's activity. Best Regards, Joseph Sack, http://www.JoeSack.com Author...

Hi, I didn't see your previous post - but regarding the monitoring of a host's activity, you can use SQL Profiler (either the client tool, or a server-side trace). You can then filter the hostname to be equal to the host you wish to monitor. This assumes you are concerned with monitoring the...

Hi, What is the field datatype you are importing into (where the data is being lost). Are you using Text? or Varchar/Char? Best Regards, Joseph Sack, http://www.JoeSack.com Author of "SQL Server 2000 Fast Answers for DBAs and Developers".

Hi, You may have dates in the Access database that are out of range for SQL Server. Access supports dates as far back as Jan 1, 100, while SQL Server only supports dates back to Jan 1, 1753. Check the Access data for bad entries (missing chunks of the date). Best Regards, Joseph Sack...

Hi, You could use the sp_makewebtask system stored procedure. sp_makewebtask @outputfile = 'c:\temp\authors.xml', @query='select * from leaders for xml auto', @templatefile = 'c:\temp\template.tpl' The template file, to quote from BOL, "contains information on the formatting...

Hi, This could be caused by a number of issues. Here is an article that helps review several methods for troubleshooting, "How to troubleshoot connectivity issues in SQL Server 2000": http://support.microsoft.com/default.aspx?scid=kb;en-us;827422 Best Regards, Joseph Sack...

Hi, I'm not an Oracle guy - but I did do a little research on your question. From what I've read, there is no SQL Server issue with referencing modified data. SQL Server statement level triggers are allowed to reference the changing data, and will not produce a mutating error. Best...

Hi, I haven't seen this error before, but I would go about troubleshooting it in the following way: Run the package manually, server-side, logging in via Terminal Services (or at the server itself) and execute the package from Enterprise Manager. This usually reveals errors that are obscured...

Hi, In addition to the main DTS package property, each task needs to be explicitly joined to the transaction (which also requires Distributed Transaction Coordinator to be running). For each task in the transaction, right-click it and select workflow->workflow properties. On the options-tab...

With regards to your original question, MDAC 2.6 is not necessary for an ODBC connection to a non-Virtual Server instance. So based on your situation, sounds like you should be okay. What error are you getting when you set up the ODBC connection? Best Regards, Joseph Sack...

Sure, If you have a SQL Server installation set up with a Named Instance on it, an example of it's name would be "ServerA\Instance1". A default instance of SQL Server would just be named "ServerA". If your MDAC is pre-2.6, you would not be able to connect to the named...

Hi, You could use a UNION operation. For example: SELECT ID, RInv as Invoice, RAmount as Amount, RDate as , RAmtPaid as AmtPaid FROM View1 UNION SELECT CInv, CAmount, CDate, CAmtPaid FROM View2 I added the "as" in order to display the fields in the view as you indicated... Best...

Hi, Without seeing the statement causing the issue, I'm not sure the exact reason... But, I can tell you that I've sometimes made temporary views around complicated SELECT queries, for use in exporting the data. Wrapping the SQL in a view sometimes allows the DTS Export wizard to parse without...