Do the appdomain errors mean issues with the server/database?

Does this error mean trouble?

Error:appdomain is marked for unload due to memory pressure.

Would giving "the sql server service account the right to prevent the operating system from paging its memory to disk" get rid of this error ?

i.e

Click Start.

2. Go to...

Min memory:0 MB

Max memory:2147483647 MB

We have 8Gb RAM on the computer

Should I decrease the max memory to 7GB ?

If i choose to do this how I do it.Do I have...

Does not work.....

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting datetime from character string.

DOes not work....

.ldf - log files

.dfb-diff backup files

.mdb - master database backup...Is .mdf used only for the backup of the master database?

.bak....Does having .bak extension means it is a full back?

How do...

no errors...the above sql does not return any data.

Thanks Jeff. Works like a charm !

appreciate your replies...working on it...will get back to you.

thanks

Col1 Col2 Col3 Col4 Col5 Col6

ted

This is what I got in the result.

I have 50000 rows in my original table

Thanks

If there are multiple delimiters in the substring ... how do I modify the query ?

Thanks

With CTE .... in sql 2000 gives me a syntax error...any other way of doing this ?

Server: Msg 156, Level 15, State 1, Line 13

Incorrect syntax near the keyword...

How do I import the text file into 2 different tables using SSIS .

The consistent data into 1 table and the other inconsistent data rows into a different table .

those are the columns

a b c d e f

a b c d e f

a b c d e f g h

a b c d e f

a b...

Apparently I wouldn't have asked if I wanted to import into 1 column 🙂

columns are