ok, so a lot of rows, but how big is it in MB.. If it is 44M rows of very narrow data then it shouldn't be too bad, if...

As a policy I recommend NEVER using NOLOCK when the data you are reading is reasonably possible to change and if a change would potentially cause an issue..

What...

I think I read that as two seperate jobs with different names at the same time?

If so then yes, provided that they don't conflict with each other.. If they...

Is one of the connections to an excel file? I have seen this error MANY times when a connection is pointing at an excel file that somebody has open..

CEWII

In the olden days (sql 6.5) I believe it used 37K/connection, I believe the new number is high 40K/low 50K. Using that number you would be using 55MB for...

If you saved the package and opened it as a different user then it cannot remember the password because it would be encrypted just for that user.. Try to...

At this point you are not trying to operate on any sub-directories, you are trying to get a directory and sub-directories with spaces are easily handled by that process so...

Perhaps being less abstract in your request might be beneficial, what precisely do you want to give a non-admin user the ability to accomplish?

Can I ask a different question, what is the latency between the local machine and the remote, depending on the mirroring mode you might have to wait for both to...

master and msdb cannot be detached, they are required for system use.. You *might* be able to do a db backup then restore of master and msdb. ...

I am pretty sure you cannot do that with Reporting Services, I'm guessing you will have to build an App to do that..

CEWII

Well, it seems there are not some functions is the derived column component that I thought were there.. Given that I have an alternate solution.. As long as you...

It will have to wait until monday.. I won't have time this weekend..

CEWII

If you set transact abort at the 1st sproc it will be the option for all sub sprocs unless they change it themselves..

CEWII

Well then I'm guessing that it is alright then..

CEWII