Forum Replies Created

Viewing 15 posts - 46 through 60 (of 101 total)

  • RE: SQL mail hangs

    what mail are you using. mapi client (outlook) or smtp (IIS).

    if outlook have you opened outlook and tried sending a mail from their.

  • RE: FullTextCatalogProperty (Index and log sizes)

    sorry i think i misread you first entry. What procedure are you using to investigate your catalogs?

    their is a sp_fulltext_service 'Cleanup' wich i use to cleanup all fulltext catalogs. their are...

  • RE: Sql Agent job results to text file

    I'm not really woried about comments in the file. its just their are about 700 lines of script to create logins all ending with [SQLSTATE 01000] . why does it...

  • RE: Local system account failing to authenticate

    According to microsoft it should work under mixed mode. but i had this problem but only on certain agent tasks like task with cross server queries. Hence i created a windows login...

  • RE: Restore roles ?

    Cant you just give him db_owner permissions for the database he can restore.

  • RE: FullTextCatalogProperty (Index and log sizes)

    the logs should take care of themselves depending on what model you are using.

    that is database properties--> options tab. Model.

     

    If the model is set to full the transcation logs will...

  • RE: NotesSQL odbc connection

    does this limit pose a problem for u?, if so i would be intrested in what method you are going to use? I am trying out xml (dxl) but seem...

  • RE: Replication between 2000 and 6.5

    Normally the days mis data from other sites is replicated to our server where it is consolidated into a report database.

  • RE: @@SERVERNAME

    I have had problems like this and tried to sort out by tring to run this sp. in the end i uninstalled publishing and reinstalled again.

  • RE: Date formats

    I think that is the problem other servers default is british englich wheras this server they are english. i transferred these logins using the dts task seems strange it changed...

  • RE: Date formats

    they are all in GMT london.

  • RE: QOD 12 Sept 03

    The Category for this was under dts, deffinatley noyhing to do with dts should have been under olap

  • RE: QOD 08/29/2003 answer is incorrect

    the so called correct answer todays question implies that by adding 'WITH ROLLBACK AFTER 30 SECONDS' means you will be disconneted in 30 secs. this is wrong the database automatically...

  • RE: DTS fails when scheduled

    When you schedule the dts package it uses the sql Agent logon to do the dts tasks. So say the sql tasks does not have permission to access the disk...

  • RE: How to execute DTS code in parallel???

    if you are going to use an activex script to branch into all you parallel tasks in the script you can set the source and destination propeties of the connection...

Viewing 15 posts - 46 through 60 (of 101 total)