Northwind, Pubs, others

sql server only comes with adventure works, but many walkthroughs demand others, including Darwish. Where can I download them.

I'm sure this has been asked before. I've searched all three. Only pubs showed up, and the request wasn't answered.

dennist685The Northwind sample database ships with Visual Studio. I don't believe it will be available as a separate download. If you are an MSDN subscriber you can search MSDN for it.

Dan|||I installed vs 2005 AND vs 2003 on two different computers. Search, Google desktop search, and msn desktop search can't find them. Hmm.

dennist685|||You can download pubs and northwind from this location: http://www.microsoft.com/downloads/details.aspx?familyid=06616212-0356-46a0-8da2-eebc53a68034&displaylang=en

Regards,|||galle, thanks,

But I had found them myself. Just at that moment my RSS told me the final product was available. I'm uninstalling everything now.

dennist685

Non-Admi users accessing jobs in Enterpise Manager

Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
Igor
Yes, but you'd have to code your own stored procedure and it would not be
called from SQL EM. You'd have to let them just execute it from Query
Analyzer or some other client-side tool.
You could always build your own Admin Interface using SQL-DMO.
Sincerely,
Anthony Thomas

"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:uVvyHrAAFHA.2316@.TK2MSFTNGP15.phx.gbl...
Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
Igor

Non-Admi users accessing jobs in Enterpise Manager

Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
IgorYes, but you'd have to code your own stored procedure and it would not be
called from SQL EM. You'd have to let them just execute it from Query
Analyzer or some other client-side tool.
You could always build your own Admin Interface using SQL-DMO.
Sincerely,
Anthony Thomas
"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:uVvyHrAAFHA.2316@.TK2MSFTNGP15.phx.gbl...
Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
Igor

Non-Admi users accessing jobs in Enterpise Manager

Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
IgorYes, but you'd have to code your own stored procedure and it would not be
called from SQL EM. You'd have to let them just execute it from Query
Analyzer or some other client-side tool.
You could always build your own Admin Interface using SQL-DMO.
Sincerely,
Anthony Thomas
"Igor Marchenko" <igormarchenko@.hotmail.com> wrote in message
news:uVvyHrAAFHA.2316@.TK2MSFTNGP15.phx.gbl...
Hello!
I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?
Thanks,
Igor