Viewing 15 posts - 3,046 through 3,060 (of 6,216 total)
We'll try to look into it. Brian has been investigating whether to upgrade Snitz or to move to a different package, so we've put some other changes on hold pending...
October 22, 2002 at 11:21 am
October 22, 2002 at 11:18 am
As far as I know that should work too. Just use the method that saves to the server.
Andy
October 22, 2002 at 5:09 am
We've just adopted the requirement that all developers attain MCAD within one year. We're pushing hard to transition to .Net and this is a good way to drive the learning....
October 22, 2002 at 5:08 am
I believe so, along with the new MCAD for developers.
Andy
October 21, 2002 at 4:57 pm
Alternatively you can drop them in the db_denyreader/writer - not exactly the same as revoke but often pretty handy.
Andy
October 21, 2002 at 4:54 pm
We typically change the access to whatever account sql runs under plus domain admins, remove everyone. Nobody needs to be doing nothing on those drives!
Andy
October 21, 2002 at 4:50 pm
Attach/detach really just adds/removes a row from sysdatabases. Beyond that to copy the mdf without detaching you have to stop the service on both machines. Both are valid techniques and...
October 21, 2002 at 1:47 pm
Its not common behavior but occasionally I do get the odd result from SQL Agent.
Andy
October 21, 2002 at 11:00 am
I'd be reluctant to rely on the data tier - sooner or later someone will bypass it to do direct updates for whatever reason. Nope, you can't pass params in....
October 21, 2002 at 10:58 am
October 21, 2002 at 9:40 am
Transactional will work I think - been a while since I used Access as a client. I'll look, maybe someone else will remember in the interim! Merge might be a...
October 21, 2002 at 4:59 am
In my experience the only place that delegation really matters in SQL is when you're setting up linked servers and want to pass through the NT credentials. Impersonation is also...
October 20, 2002 at 7:59 pm
Viewing 15 posts - 3,046 through 3,060 (of 6,216 total)