I have a thought..

Login as the SQLAdmin user either through Remote Desktop or on the console itself and see if you can get to that location. If it...

When you reference the bat files is it on a default share C$ or such or one you created yourself? Check the permissions on the share, administrators don't bypass...

gregory.anderson (12/3/2009)

---

I'm not sure if I follow yours completely....but I'll try again.

I have two servers, ServerA, and ServerB.

ServerA holds SQL Server Agent

ServerB holds asp.net application code

The job on ServerA calls...

Wow, that interface sucks..

I think it is going to be hard to do (mainly because I don't have a good enough understanding of this POS modem..)

I have tried not to...

So you have SQL and SQL Agent on server A and you call an OS command on Server B and you get an Access Denied.

Ok, how are you calling it...

It looks like your PC is directly on the net, if so what filtering and such is the router doing? Is it acting as a firewall?

I think that the...

It sounds like you might have inconsistent end of line characters and what that means is that it isn't able to tell that the line is done and to start...

Inserted is only available in the trigger. I don't even think it can be used in a sub-sproc. The query there is not executed in the same context...

Probably not wrong but you need to test for the right value. You check for blank with "", with " " you are checking for a space. It...

And Bru is right on track with the difficulties associated with setting up test/dev systems when the DB's all need to be in sync. I had to deal with...

Do you know if the record failing is NULL or blank? Also your code shows " " and not "" there is a difference. Also you should put...

A recent poster mentioned having to trust somebody sometime and I largely agree, but the compliance (internal controls, whatever) group doesn't need high level access, they need to be able...

On one side I somewhat agree with the concept of seperation of duties, the problem is that I have seen it taken WAY too far, particularly in big companies and...

You might do a check to see if it is null or blank before you do the conversion. Or you could add a derived column task before this and...

And MS certainly knows about it:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125117

CEWII