No they're not... only the UserID parameter has a default on it.

Damon is spot on... don't drop the user immediately... just disable it.

Thanks for the compliment, Joel... nice to see...

That's nice... But the OP did say "Unfortunately the only tool available to me right now is sql server 2005. How can I achieve this ?" I'm pretty sure...

This should do it, Mike...

SELECT *

FROM yourtable

WHERE ISDATE(LEFT(yourcolumn,4))=1

AND yourcolumn LIKE '[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9]'

Huh? I must be missing something there...If you only want them if they have "4" for "posuf", then I'm thinking that you need to say that somewhere in the...

Heh... Happy New Year to you to... you should make a good resolution... repeat after me, please... "I will NOT use cursors for simple set based problems." 😛

Heh... see that! Another good answer that wasn't in the possible answers :hehe:

1. is the table locked during the export?

2. what if at that particular moment i have hundreds of new inserts?

3. what would be the best...

I don't know what this table is actually for, but it's generally a bad idea to just flush data down the toilet without carefully considering what that loss of data...

I absolutely agree with Sergiy and Madhivinan... the root problem is that the column is the wrong data type. The datatype for the column should be/must be changed to...

This whole thread and the original concept isn't something I would even consider doing... First, there may be a GUI out there that you don't know about that requires those...

No, it's not possible using BULK INSERT.

Ray, the title of your post hit the nail on the head... get rid of the cursors, plain and simple. I'm not...

... and PLEASE DON'T DOUBLE POST!!!!

http://www.sqlservercentral.com/Forums/Topic436570-338-1.aspx