Forum Replies Created

Viewing 15 posts - 2,236 through 2,250 (of 2,487 total)

  • RE: Performance Of THe Server

    Check the SQL Server Logs to see what is happening when you are opening the database. If you see a lot of messages saying "Starting up database XYZ" then the...

    --------------------
    Colt 45 - the original point and click interface

    September 3, 2003 at 2:09 am

    #472318

  • RE: Data from SQL 2000 to Progress9.1d

    Nothing is impossible, sometimes highly unlikely, other times very convoluted, but never impossible.

    We also have Progress on Unix and SQL Server on Windows. We have an ODBC connection to the...

    --------------------
    Colt 45 - the original point and click interface

    September 3, 2003 at 2:05 am

    #472317

  • RE: Slow Server performance

    You could start by setting up a few traces. Take a look at "Monitoring with SQL Profiler" in Books Online.

    Also, if you setup the the trace to run on...

    --------------------
    Colt 45 - the original point and click interface

    September 3, 2003 at 1:47 am

    #472315

  • RE: Running a DTS package

    Just to add steven_white40's reply, if you setup a scheduled task, make sure you disable, or remove, the schedule.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface...

    --------------------
    Colt 45 - the original point and click interface

    September 3, 2003 at 1:26 am

    #472309

  • RE: Read-only Linked Server?

    We probably could but the Progress Server doesn't use security, and we don't have control over it either.

    We have to manage a read-only connection from our end.

    Hope this helps

    Phill Carter

    --------------------

    Colt...

    --------------------
    Colt 45 - the original point and click interface

    September 3, 2003 at 1:21 am

    #472306

  • RE: Data from SQL 2000 to Progress9.1d

    To have Progress access SQL Server databases, I believe you need to run the MS SQL Server Dataserver on the Progress Server.

    If you have a stable ODBC connection to the...

    --------------------
    Colt 45 - the original point and click interface

    September 2, 2003 at 8:19 am

    #472198

  • RE: DTS - loop through ADO recordset- HELP!!!

    Ok, I did misunderstand

    Based on what you have now, I'd add another global variable (maybe glbv_Counter) to act as a counter for your position in the...

    --------------------
    Colt 45 - the original point and click interface

    September 2, 2003 at 7:10 am

    #472176

  • RE: can this script be made quicker/easier

    Take a look at the following,

    http://www.sqlservercentral.com/columnists/bknight/xpfileexist.asp

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

    September 2, 2003 at 6:56 am

    #472174

  • RE: DTS - loop through ADO recordset- HELP!!!

    Maybe I'm a bit confused, but does the second ActiveX script run before the Datapump task? If so, then you probably just need a third ActiveX script after the Datapump...

    --------------------
    Colt 45 - the original point and click interface

    September 1, 2003 at 5:00 pm

    #472133

  • RE: Cycling Those Error Logs

    Nice little script.

    We have something similiar, only the date & time are appended to the filename so the logs don't get overwritten. They also get an extension of .txt which...

    --------------------
    Colt 45 - the original point and click interface

    August 31, 2003 at 7:37 pm

    #472068

  • RE: How to find which procedures user a certain table

    You could also do

    quote:

    SELECT sObj.name

    FROM dbo.sysobjects sObj

    INNER JOIN dbo.syscomments sComm

    ON sObj.id = sComm.id

    WHERE sComm.text LIKE '%tblServerlist%'

    AND sObj.type = 'P'

    --------------------
    Colt 45 - the original point and click interface

    August 31, 2003 at 5:47 pm

    #472064

  • RE: can this script be made quicker/easier

    From the look of your code, basically all you are doing is checking for the existence of a directory.

    Why not use xp_fileexist instead of shelling out to a command prompt?

    Hope...

    --------------------
    Colt 45 - the original point and click interface

    August 31, 2003 at 5:28 pm

    #472063

  • RE: Backup MS SQL server

    Just echoing Steve's comments. Save yourself a possible nightmare down the road.

    In a previous job, we had Arcserve 6 SQL Agent. After working flawlessly for about 8 months it...

    --------------------
    Colt 45 - the original point and click interface

    August 31, 2003 at 5:21 pm

    #472062

  • RE: Task Dependancy on Concurrent Tasks

    Are you sure you have 'On Success' not 'On Completion'?

    With On Success it will wait for both tasks.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

    August 28, 2003 at 7:21 am

    #471806

  • RE: @@LOCK_TIMEOUT

    With a setting of 0, SQL will dynamically allocate locks as needed up to approx 40% of the memory SQL Server currently has allocated to it. If it needs more...

    --------------------
    Colt 45 - the original point and click interface

    August 28, 2003 at 7:18 am

    #471804

    • Viewing 15 posts - 2,236 through 2,250 (of 2,487 total)