Search results for query: *

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...

Hi Keith, Some things to check: - When on the screen "Specify Table Copy or Query", be sure to select "Copy objects and data between SQL Server databases", instead of just "Copy table(s) and view(s) from the source database. Also, on the "Select Objects to...

Hi, ASP and ASP.NET work fine in accessing SQL Server. The performance is dependent on the query and database design. I also recommend using stored procedure calls within your ASP coding, instead of in-line SQL. The connection method you use for an ASP or ASP.NET page can be ADO.NET or...

Hi, MDAC versions 2.5 and earlier cannot connect to a named instance (virtual server) of SQL Server 2000. 2.6 is needed if you plan on referencing a named instance (virtual server). Although if you cannot upgrade to 2.6, you can still create an alias via the Client Network Utility. Best...

Hello, In SQL Server 2000 Enterprise Manager, do the following steps: 1. Expand the server node. 2. Right click the "Data Transformation Services" folder and select Properties. 3. Check the checkbox, "Enable Save To Meta Data Services" Best Regards, Joseph Sack...