Steve has a review posted on one such product:

http://www.sqlservercentral.com/columnists/sjones/totalsqlanalyzer_1.asp

I'll probably be dis-dba'ed, but so far I don't own a tool to do this either. SP_help isnt bad. Might try combining...

Very cool. Thanks for visiting!

Andy

I dont think you can do it directly when you're using Exec with dynamic sql. Exec is just going to return a 'return' value. Options are to use a variable...

The http://ftp.exe supports the rename command. If you're doing it locally, you can either shell to the OS and simply do a 'rename', or you can use the FileSystemObject and...

This could happen if the db was being replicated and the log reader was not running. Without having it running to 'clear' entries in the log, there is no way...

Wouldnt the trust be working already if you could run the transaction, just not inside the distributed wrapper?

Andy

I've got a short walk through posted:

http://www.sqlservercentral.com/columnists/awarren/loginsusersandrolesgettingstarted.asp

Just a wordier example of what Steve explained!

Andy

My guess is that its a permissions problem. You know you've got connectivity, so that rules just about everything else out except a problem with either the oledb driver or...

If you're returning a recordset, why not create a view and then apply the Top N to the select on the view? Not the TSQL that creates the view, the...

Found a post in the newsgroups that looks like it will help:

http://groups.google.com/groups?hl=en&threadm=%23SfwHLwQBHA.1892%40tkmsftngp05&rnum=1&prev=/groups%3Fq%3Dc:%255Cwindows%255Ctemp.ins%26hl%3Den%26rnum%3D1%26selm%3D%2523SfwHLwQBHA.1892%2540tkmsftngp05

Basically indicates that it might be the location of your temp folder.

Andy

Thanks for the follow up. I agree, thats far more complicated than it should be. Might want to drop a line to sqlwish@microsoft.com, throw them suggestions for next time.

Andy

Worth trying, at least see what happens.

Andy

The easiest way is to save the package as VB source code, then look through it to find the properties you need to change. Once you know the exact syntax,...

Please don't cross post - we check all active discussions daily. Thanks.

Andy

I dont have the URL handy, but MS has a MDAC component checker - should be easy to find on MSDN.

Andy