Yeah, he doesn't have EM/SQL Server on his machine. I can't see why it would affect the host computer. The DTS package is being loaded on the host...

I'd advise you to use separate sp's. It is perfectly fine to use your application to determin the sp to use. But if you must... this is how...

I know this is an OLD post, but I was looking up info as I found a "solution" to my problem a colleague was having. We learned there is...

make sure the log directory has the appropriate file security settings. are you able to run the dts through enterprise manager?

so I am just taking it as a bug in SQL Server and moving on... I love finding these things, even though I can't do what I want.

huh?

Dionisis,

Good Luck!!!!! I've been involved with way too many of these situations. Best advice I can give you is to make your own database schema and make an...

Thank you for your responses gentlemen. I was hoping to use the table function in a view, so using variable(s) won't work for me. I am unsure about...

they are the same. ON just gets higher precedence.

ORDER BY

CASE WHEN LEFT(projectnum,2) = '99' THEN 19 ELSE 20 END,

projectnum

If you all really want to know my they created the "ON" clause, it's for left/right joins...

SELECT a.*

FROM a

LEFT JOIN b

on a.id = b.id

and b.val > 1

left join c

on isnull(b.id,0)...

JOINS are processed and then the WHERE clause. You can treat the ON clause the same as the WHERE clause, depending how you want to organize your query. ...

No takers?

If you still feel you need 2 databases, I found MSDN's Log Shipping articles...

http://msdn2.microsoft.com/en-us/library/ms151224.aspx

I'm not the best admin in the world, but can't you just port over commands from the log? If a new table is created, it'll be in the log....