Forum Replies Created

Viewing 13 posts - 91 through 103 (of 103 total)

  • RE: Shrink Log

    Thanks Steve I did it and still getting errors

    Errors reads:

    Server: Msg 170, Level 15, State 1, Procedure sp_force_shrink_log, Line 1

    Line 1: Incorrect syntax near 'sp_force_shrink_log'.

    Server: Msg 137, Level 15, State...

  • RE: ZIP from DTS

    I do actually use this option with a few DTS job we have.

    Here is the case:

    Our clients work with an application called BBX (Business Basic) This one is DOS based....

  • RE: Error Import date/time from access to sql 7

    Karen,

    Even though SQL Server and Access talk to each other very well, there are a few things you need to be aware of. One of those is the date data...

  • RE: BCP Error

    Thanks, I will give it a try and let you know.

  • RE: SQL Debugging failed

    Thanks Steve. I haven't have the chance to reboot that machine due to traffic. But I will do it in the morning to see if that solves the problem.

    Thanks...

  • RE: SQL Debugging failed

    Yes. That is where we are at when we got the error message. I did check the SQL Server Service account to check if the problem was permission at the...

  • RE: 4000 Pontential Users

    Thanks Steve. Yes we have requested enough hardware to run this new release.

    At this time we are in NT4 SP 6a and SQL Server 2K, but the new environment will...

  • RE: DTS job Failed, Pkg started manually and work.

    Thank you. Antares, I setup my error log and I will check in more detail. Thanks As soon as I have that info I will come back to the site.

    ...

  • RE: DTS job Failed, Pkg started manually and work.

    Thank you. Antares, I setup my error log and I will check in more detail. Thanks As soon as I have that info I will come back to the site.

    ...

  • RE: DTS job Failed, Pkg started manually and work.

    No Brian. Everything is exactly as always. In the event of any change on account or agent, should the others pkgs fail as well? Because of the nature of the...

  • RE: DTS job Failed, Pkg started manually and work.

    Yes Brian. I a couple of times to see if the job was failing for some other reason. It did failed at the same point. That is why I run...

  • RE: [?] Currency Format [?]

    Thanks Antares,

    My column is Money. If I run a query against my table everything looks fine, the query result shows the amount including the decimal for every amount in the...

  • RE: [?] Currency Format [?]

    Thanks Steve. This my environmet. Server is Windows 2K server SP2, SQL2K SP2. My client is Windows 2K Professional. Using OLE DB

Viewing 13 posts - 91 through 103 (of 103 total)