quote:

---

unfortunately I can not read the article unless I subscribe

---

Hi, StefanJ,

I could summit a request...

there is a very good artical about the disaster recovery.

i wish it helps.

~~~~~~~~~~~~~~~~~

InstantDoc #39657

Recovering from Isolated Corruption

What's the fastest way to get your system running again?

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=39657&

nod; nod;

i used the same device for whole yesterday. but i did clean it with INIT option sometime.

i tested it from scratch today.

so, if i use a brand new device...

i guess it was a holiday yesterday (11.11). it suppose not working.

i tried again, no more errors.

this practice is for a scheduled job that will copy updated...

it worked today.

how?why?

yesterday, i even got a un-documneted error:

Server: Msg 4330, Level...

Hi, Jonathan,

Thanks for testing my script.

I did many tests yesterday, and only one time successed.

I will try it again.

xyz

we are running SQL Server 2000 with sp3 on Windows 2000 advanced server with sp3.

check out this page:

http://support.microsoft.com/default.aspx?scid=kb;en-us;315886

good luck.

too bad, the square box could not be display here.

replace(replace(replace(replace(ltrim(rtrim(YourFieldName)),char(9),''),char(10),''),char(13),''),'SQUARE BOX','')

In the case of the null able fields have blank, tab, line feed or even carriage return and a ' ' characters, the following code may be help:

replace(replace(replace(replace(ltrim(rtrim(YourFieldName)),char(9),''),char(10),''),char(13),''),' ','')

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15377&FORUM_ID=5&CAT_ID=1&Topic_Title=how+can+i+export+xml+from+sql+server++%3F&Forum_Title=Administration>

hope it helps,

can you check the sql-agent account privileges for the access db file.

It's a fact.

I had experienced the same trouble last year. We called the Microsoft helpdesk for trouble shooting and it ended up with switching back to SP1 from SP2 Sql2000....

another solution : convert the date/time into second by reference to a fixed date

example : datediff(ss,@yourdate, getdate())

the sql login works fine without the 'sa' role.