some of your part codes do not contain a colon then; add a WHERE statement:

WHERE CHARINDEX(':', PART_CODE) > 0

sure, here's a basic example.

in any query window with SSMS:

begin tran

select * from example with (tablockx)

the with(TABLOCKX) gives you an excluseive table lock.

now if you try in a second query...

only on stored procedures, you can reference a table that does not exist, and the proc will still compile successfully; they call it delayed name resolution.

so you'd be able to...

no matter what the linked server type is, you can use this command:

EXEC dbo.sp_Tables_Ex myLinkedServer

that will list all the tables available in the linked server...whether sql,access,oracle,or whatever...i...

You've kind of hit on all the high points yourself, so i'll just expound a bit.

first, format-wise, a trace is a trace; it's designed to capture exactly 64 columns of...

J-F, to find non-compliant data with high ascii, i think you can just use this:

select * from @test where value like '%[^''a-Z .,-]%'

i think you'd use a Tally table...

if that is a specific product, i think you'd have to add the synonyms to the theosaurus file right?

it's the same concept if i search fro "camero", but i...

the original statement used to create a table is not saved/stored anywhere;

all you can do is generate a statement which would create the table; it probably would not be exactly...

i don't believe...

I looked at your datafile,a nd because some records will contain multiple CrLf,s you will have to use SSIS or BCP, as suggested above.

on the SQL 2005 server, you will...

http://www.sqlservercentral.com/search/?q=audit

audit has way to many connotations...

audit data changes? backups success/failures? diskspace?usernames and roles? login successes/failures? servers on a network and all their versions?

tell us what you are wanting to...

ok i see what you are trying to do;

in order for this to work, the acount that is running the services will need domain admin priviledges in order to browse...

from what i just read WNetGetUniversalName 2will give you the UNC path to a shared resorce, but not a local resource;

i think you'd have to build that yourself, and could...

not sure how much help this really is;

but i found it in two places

by running "NET USE" in a command window, i get results that i could use with xp_cmdshell:

Status...

for the ziptestserver plan, the QueryPlan DegreeOfParallelism="1", but for the homecexecution plan, it's QueryPlan DegreeOfParallelism="0";

it looks like the rest of the plan is exactly the same though;

Jeff mentioned it...