Careful, you'll end up having to spend all day building stored procedures and Crystal Reports for this person. Make sure she only has SELECT permissions. Run profiler to see who is hoggin what resources. You might be the culprit with all your Enterprise Managers and Query Analyzers. . . . . .




>>> "Norkett Margaret " <mssqldba-ezmlmshield-x99807782.[Email address protected] 7/30/2007 11:25:31 AM >>>

I have a developer here who LOVES to use MS Access to create queries and
reports in. She links tables from my SQL2005 database in it and goes to
town. I know I've read on this forum that there is a performance hit
involved with this practice (I think), so would like to take information to
my boss to help him discourage her from this practice.



What say ye?



If you have any questions or concerns, please let me know them.



Margaret Norkett

Database Administrator

* 864-271-6522 ext 222

* 864-270-2884









Experience is the name everyone gives to their mistakes.

Oscar Wilde <http://www.quotationspage.com/quotes/Oscar_Wilde/> , Lady
Windermere's Fan, 1892, Act III
Irish dramatist, novelist, & poet (1854 - 1900)

~





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page