tempdb is located to the other drive and we have lot of space on that drive.

Job has scheduled for updating the data from source to target. For that one we have created SSIS package.

Databse backup we used to take in other drive.

I am Not askin about blocking. when I run sp_who2 , i got in command menu SET OPTION ON . I want to know , what does it...

Thanks Keith for replying so quick.

one more is question : I have sql server 2008R2(RTM) and two production database is running. And from one week client has complaining slowness issue....

Thanks for the reply,

I want to ask ...

for file uploading(ex: excel, csv or word) in database, what should be access required to the user.

thanks

still you are not getting me. whatever u sent the query, yesterday i ran all the query. The last one query was executed upto 1 hr and its...

Hi Bekker,

Thanks for the reply,

I ran the query, i found that noone is using that DB.

Actually I have a problem that I am not able to do in Single...

yes I am sure becoz I ahve only given the permission, and I have checked so many times.

I am not able to understand, why they are not able to connect...

Sorry I am correctiong the question

Thanks for the sharing information...But still I am not sure.

My team is working on this application from past 2 years but still they did not...

Hi All,

Thanks for the sharing information...But still I am not sure.

My team is working on this application from past 2 years but still they did not find solution.

When all the...

There is one application in our organization. At starting they got the data from the client and our people were uploading the data manually and what manager did he assigned...

Hi ,

Thanks for the information.

I am explaining clearly....

For uploading data we are using SSIS package , through application more than one user try to upload excel file at the same...

whenever we try to upload the data...the application will be hang or it stop uploading data.

please tell me how to resolve this issue

Thanks in avance

Thanks for the reply...

I want to clear my question , I think this will be easy to understand.

we have a production DB. we have millions of data which client is...

Thanks for the reply.

This is production DB. we have millions of data which client is keep sending and we have created SSIS package to copy data from excel to the...