If it didn't give you an error on "dir c:\..." just file not found, then the file isnt there or it is hidden.  The path is there.

Make sure what server...

just to be certain try

master..xp_cmdshell "dir c:\test2.txt"

to see if your sqlserver session really does see/have permissions to the directory.

If it does... Idunno. It's a 3rd party thing... mayby try full UNC...

You have me confused. 

Perhaps you are trying to do what MSSQL allows you to do: detach and attach.  If that is the case it is not allowed in Sybase....

Is that file in the C:\ directory of the server and not the client?  It needs to be or you need to use a UNC to have the server go...

lost my post I guess.. here goes again:

you need to know the key columns for the tables:

SELECT key columns, MAX( change_date--orwhatevertheauditcolumnis)

FROM audittable GROUP BY key columns

then you can use...

Then you could always break the statement into multiple filters

where substring(a.text, 1, 8000) = substring( b.text, 1, 8000)

  and substring(a.text, 8001, 8000) = substring( b.text, 8001, 8000)

  and substring(a.text, 16001,...

sp_dropdevice not working?

in dos command line you can wrap paths with double quotes

select 'copy "\\ really long path or whatever.txt" ... '

first off, are you doing a DBCC DROPCLEANBUFFERS between each test to make sure that the faster run isn't faster because of HDD IO?

Three cheers for Arizona and Hawaii: We don't need no steenking DST.

(But why is it colder here in Phoenix today than in New York?  One of nature's cruel jokes?)

I have one fundamental problem with software licensing: they want to disclaim any responsibility for faults.  They need to either treat it as any other product or accept full responsibility,...

I think I'd go the user defined function route:

First, your group bridge table is probably normalized, so I'd write a function that concatenates your DRGkey into a sorted, comma delimited...

It's all about how your application will query it (and/or needs it sorted).

If you frequently select all orders for a given date, probably have a secondary index on order_date.

If you...

What's wrong with summing the length field in the syscolumns table? (where id = object_id( tablename ) )

(Hate to be the cynic, but that's what I do best...)

Steiger's Law simply put:  (Sooner or later) Any organization will always evolve to the point that its existence is more...