Quick hint, write a select to find the rows you want to update first. Make sure that it returns the data you need.

To follow on with Joie's note, here's an article: http://www.sqlservercentral.com/articles/Administration/implementing_efs/870/

dstanger-666122 (10/25/2012)

---

Hi Steve,

Regarding "I wrote that calculated data growth for all databases on an instance and then used that to calculate how many days would elapse before I ran out...

I swear I moved Mendenhall off and another RB on, but apparently not. The SF defense rocks and Fitzgerald (once again) does nothing.

I give up. Can't seem to get anything...

A driver installed on whatever machine is running SSIS. Usually this is the same SQL Server instance, but it does not have to be.

I intended UPDATE statement. I know that an update can be a delete/insert at times under the covers, but since I have not found documentation that links this issue to...

It depends. If the FK column is used in the queries, I'd combine them. If it's not, then it won't help you.

You do want an index with the FK column...

powershell.

http://ask.sqlservercentral.com/questions/1568/execute-a-query-against-multiple-servers.html

If I understand, you want to allow a user to change permissions on a view they have access to, correct? Not change the view, but the permissions?

I think you need...

When I worked at JD Edwards, OneWorld stuck an MSDE (Express) instance on client machines to cache some data.

This

and this

are contradictory statements. Your explanation needs to be clearer. Do you...

This is a little silly, IMHO.

Send them a backup, let them make changes, and then use diff tools, like SQL Compare/Data Compare from Red Gate (Disclosure, I work for Red...

Yes. Well not quit, but looked for a new job and moved on a couple times. The lack of challenge or excitement is a problem in work.

One time it was...

I dislike linked servers, especially do non-SQL databases since I have seen errors, especially memory errors from third party drivers in the past. This is usually over time, and in...

I tend to do what VikingDBA has done. I don't always have 3 roles, but I do always have the user role, and an admin role. Note the latter isn't...