please help if anybody is aware of this HTTP 401 unauthorized access while connecting ssrs2008 from remote web server...production issue is going on

would appreaiate the reply

I can see the mount point details from veritas enterprise manager but willbe good if somebody has some script-cmd to check mount point thru cmd line

Hi, Thanks for reply;

Sometimes the disk is having the mounted volume inside.

Suppose you have I drive having 50Gb free space out of 100GB and might it contain some folder...

Hi, Thanks for reply;

Sometimes the disk is having the mounted volume inside.

Suppose you have I drive having 50Gb free space out of 100GB and might it contain some folder...

might this query will provide me the queryplan but could i will understand that which query is related to which spid/application.

For eg if i am troubleshooting the slowmess of spid...

Sorry to say pradeep but you didn't understand my question, I am talking about a running query in production

Hi Pradeep thanks for response, might i am asking a stupid ques, but i am not having too deep knowledge in sql server, Could u pls help me to explain...

my replication is on sqlserver 2000, and yestrday we face one issue of latency and app team was asking the details. but i was not sure coz of which table/publ...

I am talking about a live query in production so we cant do a lot analysis, just in a short how can i see whether my query is doing a...

i have seen repl monitor but i dont think that it will show that which publ is causing latency, there are approx 30 publ and its difficult to check each...

just try to generate script by right click database and generate scripts,

please try the below things to change ownership to sa

============================================

how to change ownership of job to sa

========================================

fire the below sql stmt; it will generate exec sp cmds, select the specific...

thanks for valuable suggestion,

table created sucessfully, do i need to change something in stored procedure ,views etc code also,

Hi see I am running the below code after extracting by script and it gives me error msg

incorrect syntax near ")"

Server: Msg 170, Level 15, State 1, Line 8

Line...

Hi Thanks for your reply, I have tried that option by selecting 2000 version, but when it ran on sql server 2000 it says error and not able to proceed...