can you make query analyzer read only so I cannot accidentally thrash the data?

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SQLBill SSC Guru Points: 51440 More actions · Answer 1

No. What would be the purpose? Query Analyzer is so you can run commands against the database.

One solution. Change your permissions on the database to allow you read only.

Another solution. Create a login that is read only and use that login when you use QA.

-SQLBill

sqltung Hall of Fame Points: 3962 More actions · Answer 2

I think SQLBill is right on - especially the option of creating a login that only has read permissions.

However, we should also consider that some data is bad, and needs a good thrashing now and then.

Mike Metcalf SSCrazy Eights Points: 8763 More actions · Answer 3

SSCrazy Eights

Points: 8763

February 10, 2006 at 9:24 am

Bad Data, down boy

homebrew01 SSC Guru Points: 55548 More actions · Answer 4

And some data is so troublesome that it's just best to delete it all and start fresh.

SQLBill SSC Guru Points: 51440 More actions · Answer 5

Darn that data......if it weren't for data, my job would be so much easier.

-SQLBill

adam spencer Hall of Fame Points: 3926 More actions · Answer 6

Hall of Fame

Points: 3926

February 10, 2006 at 12:55 pm

HaHa! Thanks all for the help