Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JoeSack

    Insert Error..Data Overflow

    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".
  2. JoeSack

    Task

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

    Limiting the actions of a user on a certain host.

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

    auditing a hosts activities

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

    Date lost when importing from Access

    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".
  6. JoeSack

    Insert Error..Data Overflow

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

    How can I save XML result set in a file using query analyzer

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

    Issues connecting via tcp/ip

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

    Mutating table in SQL Server 2000 triggers

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

    Kicking off DTS package from T-SQL

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

    How to rollback the tasks into a package

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

    Is MDAC 2.6 needed to connect to SQL Server thru ODBC?

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

    Is MDAC 2.6 needed to connect to SQL Server thru ODBC?

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

    SQL: Records from two views into one

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

    Can not Parse SQL via DTS Wizard ?

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

    Newbie Question: DTS and Relationships

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

    Best method to access Sql Server on Intranet?

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

    Is MDAC 2.6 needed to connect to SQL Server thru ODBC?

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

    Saving DTS Package as MetaData

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

Part and Inventory Search

Back
Top