If the application was designed for MSSQL I don't think it will run on MySQL. It could, but I don't think it will.

The same applies to the web server: if...

Duplicate post.

Add your replies to this thread:

http://www.sqlservercentral.com/Forums/Topic768480-146-1.aspx

I had the same issue with AS/400 and I noticed that mostly depends on how the provider is loaded.

I suggest you load the provider out of process and always use...

If you are running an ASP.NET application, I guess the application is the only thing accessing DB from the host machine, so you could simply set up a profiler filter...

... or Spaceball's Barf (Barfolomew for the formal ones)!!

I could aspire to be Chewbacca at most...;-)

Probably it won't fix anything, but I usually run stored procedures with ADODB.Command objects.

At least I'm sure it maps variable types correctly.

If you want to trap what happens inside the...

This works for minimally logged operations, such as BULK INSERT.

For "normal" inserts the operation is fully logged.

BULK LOGGED recovery model does not allow point in time recovery.

BOL recommends backing up...

From BOL:

Under the bulk-logged recovery model, if a log backup covers any bulk operations, the log backup contains both log records and the data pages that were changed by bulk...

Lynn, I see some "green" missing from your avatar today, could that be a problem with my display options? 😀

Barry is leading a new wave...

English is not my first language, so I'm sure any comment...

I'm not sure I understand what you want to do.

I suggest you post your tables definition, some sample data, what you have coded so far and the desired output.

See this...

Your post does not contain any information that could allow anybody to help you.

I suggest you take a look at this article and add some more info on your post.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Regards

Gianluca

You could add EXECUTE AS OWNER to the procedure that contains the xp_cmdshell call.

This allows the user to execute that particular procedure with the rights of the user that owns...

GilaMonster (8/10/2009)

Be patient. It's not finished yet. If you're keen...