Does Service Pack 2 affect Client Tools?

Hello,

Does Service Pack 2 affect client tools? In other words, if you have a client machine with just the tools installed (management studio, BIDS, etc) do I need to run the SP2 package on this client as well?

Regards, Jeroen

YES. Always update ALL clients to the same SP as the servers.

|||thnx Tom...sql

Does MS SQLServer support auditing in the way that you can for Sybase?

I know that there are tools like Lumigent, but an wondering about the
internal facilities to track events such as table creation, security
operations (add login, add role), and such.

Under Sybase, there is a set of procedures that permit you to set
theses events and to record the results for later extraction and
analysis.

The Profiler seems to have a lot of the same functionality but this
appears to be more along the lines of running a monitor.

Can the events be tracked without Profiler running?

Can the events being tracked be recorded in the system of SQLServer
logs?byrocat (bdealhoy@.sympatico.ca) writes:
> I know that there are tools like Lumigent, but an wondering about the
> internal facilities to track events such as table creation, security
> operations (add login, add role), and such.
> Under Sybase, there is a set of procedures that permit you to set
> theses events and to record the results for later extraction and
> analysis.
> The Profiler seems to have a lot of the same functionality but this
> appears to be more along the lines of running a monitor.
> Can the events be tracked without Profiler running?

Yes. But I am not going to say that it is particular appealing.

The good news is that in SQL Server 2005, currently in beta, you can
define triggers on database and server level, which makes this sort of
auditing a lot more reasonable to do.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland, would you haoppen to have an URL to a Technote or soemthing
similar that lays out the procedures for setting auditing of events
other than logins?|||byrocat (bdealhoy@.sympatico.ca) writes:
> Erland, would you haoppen to have an URL to a Technote or soemthing
> similar that lays out the procedures for setting auditing of events
> other than logins?

You mean with Profiler? No, I don't have any reference any such texts.

You can look up C2 auditing in Books Online, but you will not find much.
There is a reference to a "C2 Administrator's and User's Security Guide",
but there is no link.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||"byrocat" <bdealhoy@.sympatico.ca> wrote in message
news:1123616848.996208.232970@.o13g2000cwo.googlegr oups.com...
> Erland, would you haoppen to have an URL to a Technote or soemthing
> similar that lays out the procedures for setting auditing of events
> other than logins?

See sp_trace_create (and related procs) in Books Online. I agree with Erland
that it's not always perfect, but you can trace anything that Profiler can
trace, which obviously extends beyond just login events.

Simon

Documenting Tables and Stored Procs

Looking for suggestions on tools to document both SQL Server and Axapta DB's
Preferably freeware as I have very small budget to work with.
Also a book or online documentation on best practice database documentation
that I could do myself would be nice.
Thanks in advance
Check out the SQL Server Central Script Library at
http://www.sqlservercentral.com/scri...tions/1608.asp
"Pat Brown" <PatBrown@.discussions.microsoft.com> wrote in message
news:7EA6B991-FF30-4796-87B0-4F37A3D9F64D@.microsoft.com...
> Looking for suggestions on tools to document both SQL Server and Axapta
> DB's
> Preferably freeware as I have very small budget to work with.
> Also a book or online documentation on best practice database
> documentation
> that I could do myself would be nice.
> Thanks in advance

Documenting SQL Jobs

Does anyone know any tools or scripts to use for
documenting SQL Jobs. I need to take the results and
create an excel or word file for management. I would need
it to list the job name, schedule, frequency...so on.
Trying to script this is not easy in that the sysjobs and
sysjobschedules tables use numbers to represent everything
about the schedule and all.
Any help is appreciated.
Thanks,
Van JonesHow about a simple SQL Query, and put the output in Excel? The tables you
need to read from aren't that difficult to work with. Only mess is the
dateformat and frequency stuff, but there is some good stuff at
www.SQLDev.Net that help you with this.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Van Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:0dbd01c3a485$acb49fb0$a401280a@.phx.gbl...
> Does anyone know any tools or scripts to use for
> documenting SQL Jobs. I need to take the results and
> create an excel or word file for management. I would need
> it to list the job name, schedule, frequency...so on.
> Trying to script this is not easy in that the sysjobs and
> sysjobschedules tables use numbers to represent everything
> about the schedule and all.
> Any help is appreciated.
> Thanks,
> Van Jones|||Hey thanks for the reply Tibor. I've been down that road
before a couple years ago and didn't have a great deal of
luck. I got it to work, but it wasn't very clean. I was
just hoping for a tool to do it for me. However, I saw a
reply from Sue under dbforums to the same question that
had the following article listed:
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=15560
It has a sp called usp_Scheduled_Jobs that will do it all
for you....extremely nice and useful.
Thanks,
Van Jones
MCDBA, MCSE, MCSA, MCAD
>--Original Message--
>How about a simple SQL Query, and put the output in
Excel? The tables you
>need to read from aren't that difficult to work with.
Only mess is the
>dateformat and frequency stuff, but there is some good
stuff at
>www.SQLDev.Net that help you with this.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Van Jones" <anonymous@.discussions.microsoft.com> wrote
in message
>news:0dbd01c3a485$acb49fb0$a401280a@.phx.gbl...
>> Does anyone know any tools or scripts to use for
>> documenting SQL Jobs. I need to take the results and
>> create an excel or word file for management. I would
need
>> it to list the job name, schedule, frequency...so on.
>> Trying to script this is not easy in that the sysjobs
and
>> sysjobschedules tables use numbers to represent
everything
>> about the schedule and all.
>> Any help is appreciated.
>> Thanks,
>> Van Jones
>
>.
>|||OK, I just wanted to point the option of using these tables, in case you
haven't used them already. Yes, some things aren't that easy to deal with
(mostly the freq- things, IMO). Hopefully Sue's proc will help you :-)
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Van Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:0ded01c3a48e$787439a0$a601280a@.phx.gbl...
> Hey thanks for the reply Tibor. I've been down that road
> before a couple years ago and didn't have a great deal of
> luck. I got it to work, but it wasn't very clean. I was
> just hoping for a tool to do it for me. However, I saw a
> reply from Sue under dbforums to the same question that
> had the following article listed:
> http://www.sqlmag.com/Articles/Index.cfm?ArticleID=15560
> It has a sp called usp_Scheduled_Jobs that will do it all
> for you....extremely nice and useful.
> Thanks,
> Van Jones
> MCDBA, MCSE, MCSA, MCAD
> >--Original Message--
> >How about a simple SQL Query, and put the output in
> Excel? The tables you
> >need to read from aren't that difficult to work with.
> Only mess is the
> >dateformat and frequency stuff, but there is some good
> stuff at
> >www.SQLDev.Net that help you with this.
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Van Jones" <anonymous@.discussions.microsoft.com> wrote
> in message
> >news:0dbd01c3a485$acb49fb0$a401280a@.phx.gbl...
> >> Does anyone know any tools or scripts to use for
> >> documenting SQL Jobs. I need to take the results and
> >> create an excel or word file for management. I would
> need
> >> it to list the job name, schedule, frequency...so on.
> >> Trying to script this is not easy in that the sysjobs
> and
> >> sysjobschedules tables use numbers to represent
> everything
> >> about the schedule and all.
> >>
> >> Any help is appreciated.
> >>
> >> Thanks,
> >>
> >> Van Jones
> >
> >
> >.
> >|||It's a reference to an article in SQL mag a couple of years
or so ago that has a pretty nice script to grab the job,
schedule, avg run time, max run time, some other properties.
It's pretty good - I've used it quite a bit with just a
couple modifications.
-Sue
On Thu, 6 Nov 2003 18:58:09 +0100, "Tibor Karaszi"
<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote:
>OK, I just wanted to point the option of using these tables, in case you
>haven't used them already. Yes, some things aren't that easy to deal with
>(mostly the freq- things, IMO). Hopefully Sue's proc will help you :-)

Documenting existing stored procedures

Does anyone have any scripts, or know of any tools, that can scan through all of the SPs that I have inherited, documenting details?
ThxThis will retrieve the name and text of all the stored procedures.

SELECT a.name, b.text
FROM sysobjects a INNER JOIN syscomments b ON
a.id = b.id
WHERE
a.xtype = 'P'

This will retrieve the input parameters for all stored procedures in a database:

SELECT a.name, b.*
FROM sysobjects a INNER JOIN syscolumns b ON
a.id = b.id
WHERE
a.xtype = 'P'

What else are you looking to do?|||thanks! :o :o|||Did you use Enterprise Manager to script out the stored procedures and the like?

You can use this to Search your database (http://weblogs.sqlteam.com/brettk/archive/2004/02/05/841.aspx)

Good Luck

Documentation Tools for SSB?

Does anyone know if there are automated documentation tools around that will produce docs for Service Broker objects?

Thanks,

AndrewM

There is no tool for documentation, but there is one for retrieving a more formal specification (Called service listing). It's called Service Listings Manager and Remus has contributed that to the code gallery. You might want to use that as a starting point to build a doc generator.

Documentation / Metadata tools

Hi,

I heard about some upcomming tools... About logging and metadata management (Donald told in the IT Forum about that) and some documentation tools (I don't remember anymore who mentioned that)...

Are there any specific dates/previews/feature lists?

Thanks,We are planning to release metadata analyzer, viewer and two or three sample metadata reports some time in December. The plan is to have it as shared source sample, so that one can learn how it works and, if needed, build custom solution.|||There is also a tool called the documentor that will document the contents of packages etc. Release date is still TBD.
K|||Kirk,

thanks for the confirmation... Great thing, I'm very curious about the features...|||Michael,

so this will analyse all the XML files in a project (?) and show usage paths of information (where does it come from, where is it going, where is it used)?

This would be very very helpful...

Thanks,