here's a slight modification chopping up the results into file date,filesize and filename:

SELECT

SUBSTRING(txtResult,1,20) AS FileDate,

CASE

WHEN txtResult LIKE '%<DIR>%'

...

if the only thing you are after is file size, the DIR command is faster and easier to use to get it; now if you are after information like modified...

it's kind of hard, but you have to make some assumptions based on the sample data.

i'm assuming:

there are TWO chars after the slash to capture.

there is always a space before...

preensheen (10/1/2010)

---

hey, CSV is more like a excel but not like text. So I am assuming there should be way we should be able to do it. May be using...

no, whatever you paste is whatever you paste....

the GRID, by design, cannot show multiple rows...(it's a grid), so for presentation purposes, it replaces CHAR(13) and CHAR(10) as spaces...but the underlying...

right click on the servername...properties...the security tab:

change to failed logins only, and i think you are all set.

in the object explorer on the left, expand your database till you see the table.

right click on that table , and selecte the "Edit Top 200 rows;

you can always change...

from a similar post a while back, someone cobbled together an enhanced version of sp_who, which has an additional xml column of the command being executed.

try this version, named sp_who3:

/***************************************************************************************************************...

if you restored a database that came from a different server, this is a known issue;

USERS in the database are mapped to LOGINS in the master database;

the sql user...

you've got to use a counter or a where statement which preventrs teh same row from being processed.

for example, if your table has an identity column:

dim @start int

dim @end int

SELECT...

Shekhar this is a very common scenario...table changes are made, and procedures that are dependant on that table's schema may fail;

I like to use this cursor *gasp* below, which...

yes that works, but...

not sure by what you mean as a "virtual field"

are you talking about a column in a view, which does not exist in the underlying table?

yes you can, the syntax is the same as when you select something based on other data, just make sure the column name is assigned;

ColumnName = [calculation,case statement, formula,etc]

or

...

another option is to use the SSMS GUI and design the table;

if you add the new column, and make sure you select that it has the identity property, the GUI...