Like a hammer and a screwdriver, both are tools used to build with.

Sometimes the hammer is better to use than the screwdriver, or the other way around, depending on the...

Jeff, it could be due to the fact that the op posed the question some 2+ years ago

/Kenneth

Well, the solution is pretty straightforward - You can't do it.

To clarify a bit, you can't 'select column from exec procedure' in a direct fashion.

You have to do as posted...

Yes, it does. That's what the -S<servername> parameter says...

/Kenneth

bcp T1 out D:\Archive -S <Server_Name> -U <username> -P <pwd> -b 10000 -c -t |;

.. is this the actual commandline? It looks a bit fishy in two places.

Unless you want your file...

There's a lot of places where you can find info on this subject.

Here's one as a starter:

http://sqljunkies.com/Article/F30B1E5F-F50F-40A8-96F2-476CEAD46C79.scuk

If you google on 'sql server disaster planning' you'll get several more links.

The...

RIGHT joins is only there for us mere mortals. For SQL Server, there is only LEFT joins.

Try these two:

select *

from sysobjects so

left join syscolumns sc

on so.id = sc.id

select *

from syscolumns sc

right join sysobjects...

Basically, if the requirement is to find the string 'mystring' anywhere within that 255 varchar column

(ie in the beginning, middle or end) - then there is *no* reason not...

That is correct.

N'somestring' denotes that this is a unicode string

/Kenneth

While it's possible, I wouldn't recommend putting in control chars into your data.

Eventually, it's very likely it will give you more troubles than joy.

Should you, by any chance, need to...

Yes, that was the point

The temptable was just for illustration.

You were supposed to substitute it with your actual table.

/Kenneth

You could do it like this;

create table #x ( weirdcodes varchar(20) not null )

go

insert #x select 'XX/\/\/\/\####'

go

select weirdcodes,

 (datalength(weirdcodes) - datalength(replace(weirdcodes, 'X', ''))) as 'X',

 (datalength(weirdcodes) - datalength(replace(weirdcodes,...

That makes sense, in that case there's not much point in doing continous backups - you just need one (until the day that something in the static db *does* change...

For further information about CHECKPOINT, DBCC and other stuff you hear about, BOL (Books On Line) is a very good place to start where you can find explanations.

/Kenneth

Probably the easiest would be to set up a profiler trace filtered on the particular user.

/Kenneth