I agree the problem is I did not design this system. The company is purchasing it and leaving me to fix these type issue after implementation. The other problem is...

How do you only encrypt part of the data in a column?

Yes I know! I have not bow down to this yet. I am trying to find a better solution. If triggers would use: for select then I could create a...

Unfortunately I am under the constrant to give access from management to production(stupid) not a copy and the view thing won't work in this case.

I already said I could do (deny or revoke) but it would not allow the developers who are working on the app who have to do selects statements to be...

[Grant said this in another thread]

sp_addextendedproperty is for putting descriptions, etc., on to your SQL server objects. It doesn't do any kind of formatting of any kind. It's for creating...

d.raes

Hi all,

I need help with the following. The code below works fine but I would like to change the subject of mail based on the current date of the database(server)...

This is a repeat posted more than once!

Have you checked for duplicate records?

Phil

My question is what would cause the DYNAMIC cursor to continue to act as a READ ONLY cursor and continue to read the tempdb resultset? I didn't see a DYNAMIC...

Phil

It's not so much using a cursor to do an update, but rather finding the starting record that matches the end record and finding any overlaps in the actual completion...

Sean

I would be willing to bet that you don't need a **cough**cursor**cursor** to do an update. You will benefit in huge performance gains by converting to a set based solution....

kapfundestanley

I configured mirroring on windows 2008 and sql 2008.I have local administrator domain administrator as logins.My problem is I want to deny connections to windows logins...

I'm trying to find out why the updated records are still coming into the cursor after they RECORD_READ is set to 1. I removed the order by statement, but it...

I'm trying to reduce the number of records that are returned with each fetch next using this cursor declaration

DECLARE START_PROCESS CURSOR DYNAMIC FOR

SELECT LOAN_ID, STEP_CODE, ACTUAL_COMPLETION_DATE

FROM #START

WHERE...