do i need special permissions to run the XP_CMDSHELL? Its weird when i execute it from my machine it works but when i put it in a job it doesn't

thanks!

hi Adam, so there is no way to use a sql task to zip using windows?

yes i have allowed remote connections to the destination server. can you tell me how to check for the port number? also, do you why then when i connect...

sorry that is a fictious name, it is sql server 2005

thank you guys!

in the profiler in the reads column for the audit logout class event de number is very high. We have been having problems with our web application(slowness and timeout...

I really don' t think it is a procedure, my profiler shows the event class logout audit for the .net sql server client, textdata column is empty, does this make...

hi I am having the same problem, and i think adding my login to the Distributed COM Users Properties could be the answer, is there any requirements to do this?

yes i did it through access and it worked!!!! thank you!!!!! 🙂

I have to do this update in a server(production) where adhoc queries are not allowed, i also tried doing it by creating a table in my development server with the...

at this time i have this in current table:

ItemNumber Price

Item1 22.09

Item2 ...

sorry i wasn't clear. I have Item1, item2, item3 already in my table. I need to update the existing prices. 😀

thanks, no that's enough rights, i just want to be able to view. thank youuu

thanks this sounds exactly what i need, do you know what other permissions does this grant? also i could only view not make changes correct?