Forum Replies Created

Viewing 15 posts - 1 through 15 (of 34 total)

  • RE: Lost Connection with Windows Server 2003

    Check that the windows firewall is not enabled on the server. and that there are no settings closing off the default SQL ports.

     

    M

  • RE: DTS date issues

    Hi John,

    Thanks again for the reply. Thats one of the things I tried at the very begining. Initially it was set at being just english(US English). So then when this...

  • RE: DTS date issues

    Hi John,

    Cheers for the reply. See the thing is that the dates are sent in from local offices to an exchange mailbox. From this my task retrieves the file and...

  • RE: Database Design Query

    Guys,

    Thanks for the prompt replies... They've certainly sent me in the right direction. Upon talking to the developers more, I've found that they're going to need some sort of fuzzy...

  • RE: problems in activare Analysis Services

    Also,

    Make sure that you have installed Service Pack 3 a or 4 for analysis services... You will get a load of errors otherwise.

    M

     

  • RE: Monitoring DBS activity in SQL

    You can use the profiler available with SQL. Log all the StmtCompleted::BatchCompleted statements and write it to a table... this will tell you all that has been executed by the...

  • RE: DEAULT DATABASE

    I had the same problem before,

    What you can do is create a new database with the new collation, script out the old DB and apply it to the new database...

  • RE: unable to browse data from analysis services

    Hi,

    Installation of SP3 will solve that... make sure you are part of the OLAP admin group and that the users have access to the shared area on their machine where...

  • RE: table name that contains the list of files that were restored in a database

    Folks,

    This query when executed on the master table will list all the full databse backups in the last 25 hours... It can of course be manipulated to log backups[ type='L'

    ]...

  • RE: maintenance job not removing old backup/transaction files...

    hi Folks

    Had the same problem and and it was because on of the jobs is failing right click on the maintenance plan; clikc on history and check the success of...

  • RE: Administrative Software Solutions

    While you are looking at the QUest site; it would be no harm to look at TOAD.this is a top product for Oracle anyway so I reckon it would be...

  • RE: problem when browsing data from cube

    SP3 should resolve this... I had this same problem and thats what it was...

  • RE: Moving Servers

    Can you access, the internet?

    If the backup isnt that big try sending it by email? If this is not an option which I presume it isnt try this...

    Did you say they...

  • RE: Secure Sql Enterprise Manager

    Yeah as Sufian said,

    Just add the users in the security folder of SQLServer and put them under the role of Administrator, thus if you only add administrators, only administrators will be...

  • RE: Buffer Sizes

    Its a java.sql.Exception error, is this database the backend for a java application, find the function in the code that is throwing the exception and post that, it could be...

Viewing 15 posts - 1 through 15 (of 34 total)