What are your recommendations as far as debugging stored procedures / functions without SSMS?

Thanks.

Hi Keith,

Thanks for the suggestions. I appreciate it.

And I apologize for the slow feedback and lack of it. I was on another project, putting out another fire. I have...

Frankly,...

Awesome! Awesome! That worked.

Thanks a bunch.

If you allow access to the file system, realize that the SSIS packages will execute from wherever the dtexec command is given. So if it's given from the user's workstation,...

OK. Thanks for the clarification.

If it's inserted from an online form, there's a cause for concern because, if you can insert HTML tags, you can insert sql injection / cross site scripting?

On the other...

No apologies necessary. I totally understand. 🙂

Unfortunately, this place I'm currently volunteering is still very heavy on SQL Server 2k.

Nevertheless, thank you very much for your help.

Thanks for the tip, John.

And OPC, thank you for the link. I was able to run the script on SQL Server 2008. You don't by any chance have a script...

I hope you are not initialising the file every time you write to it? If you are you wont be able to restore as you need the whole collection of...

Haven't tried this yet http://qa.sqlservercentral.com/articles/delete/96780/ because I completed the archiving project a few weeks ago. But will definitely try it the next round of archiving. Thought I...

For future reference to anyone experiencing this issue:

I just installed SQL Server 2000 Client Tools - Enterprise Manager and moved the package. That resolved all the issues. My guess is...

My mistake ... checked with her this morning and she was just trying to open the package from Sql Server Enterprise Manager 2000 when she got the error message.

Edit: Do...

Thank you all for the corrections.

Anyone with any comments on how do I archive the database? Since MSSQL doesn't support UNC path for MDF - getting error "the file...

Thanks for the reply.

It's on MSSQL 2000 database. My client is SSMS 2008. Sorry for the confusion.

Dev is in full backup mode.

Edit: In Oracle, there's a data pump...