Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 1,220 total)

  • RE: Warning Cache memory

    I assume that the message reads like the following:

    Warning: SQL cache memory usage: %d (pages). If this condition persists, see the Error Log Messages topic in Troubleshooting.

    Books on line has...

  • RE: Database info, what´s wrong ?!

    I seen this problem too often. The easiest workaround is to right-click on the database (in the left hand screen), goto the view option and select a view that...

  • RE: Platform

    SQL Server ONLY operates under Windows. Depending on the Edition of SQL Server, different versions of Windows is supported.

    This limits your choices of platforms for Oracle and...

  • RE: Question of the Day for 27 Apr 2005

    I think it was poorly worded because the snapshot agent does not apply the snapshot. It creates it. The distribution agent applies the snapshot.

    The wording the question implies...

  • RE: Question of the Day for 27 Apr 2005

    Trick question ? Well, I thought that it was a poorly worded question. As Cindy said, the snapshot agent does not apply snapshots (the distribution agent is responsible...

  • RE: Question of the Day for 06 Apr 2005

    I think the correct answer really is NONE OF THE ABOVE. Your first step really should be to determine what the security requirements are. Otherwise, you will simply...

  • RE: Performance issues on one instance

    Have a look in the SQL Server Log for each instance.  Near the start of it you will see a line that looks like

    Server Process ID is 1234

    In task manager,...

  • RE: Replication - Distribution DB growing

    Check whether the replication cleanup job is running - it is responsible for deleting data from the replication tables once the transactions have been sent to the subscribers.  10GB does...

  • RE: Setting startup service account in EM

    Are you a member of the SQL Server "System Administrators" role ?

  • RE: Calling Java or sytem cmd from WIn32 task

    The command you specify must be a "real file" (i.e. you must be able to see the command you are running as a file and it must be an executable...

  • RE: Change SQL Server 2000 Setup without Uninstalling??

    The name "FRET05\JAN" is a name instance of SQL Server.  You cannot change this without re-installing.

    However, you might be able to create an alias for this using the "Client Network...

  • RE: DayName / Date -- Please HELP !

    Select datename (dw, Entrydate) as 'Day of week' , count(OrderNo) as Number

    From [order-header]

    Where (SUBSTRING(source, 1, 8) = '223WHOLE')

    and EntryDate bewtween  '20040101' AND '20041231' 

    GROUP BYdatename (dw, Entrydate)

  • RE: pass parameters via DTS ?

    Add an activeX task that runs at the start of your package.  In the task, use an inputbox to prompt for the start number. 

    I assume that you want to...

  • RE: changing datatype of primary key field

    You could start with making the changes using EM.  If you make the changes to the parent table, it will make prompt you that the related tables require changes and...

Viewing 15 posts - 1,126 through 1,140 (of 1,220 total)