I agree on Kelvin's statement (page 1 of this topic) "using the ANSI standard JOIN syntax or the older syntax using WHERE".

The Join in the ANSI way is just an...

Hi,

Make lists, check and double check them (weekly!!)

Create reports and document them.

Create some more reports and alter the ones you made earlier (a company is always in motion).

Set Security,...

Gate Crusher,

For the SQL 2000 environment we use the XP_SMTP_SEND_MAIL procedure;

Copy the appropriate DLL into the BINN directory

Register this DLL within SQL server

ready for use (script example);

--Within the declare section...

see next post (somthing went wrong posting it)

Haidong Ji,

Try the next script (no e-mail part attached but it schoudn't be that difficult to add it);

CREATE PROCEDURE [dbo].[sp_diskspace]

1) Run the SQL profiler ( choose template or create one yourself )

2) save the tracle to a file

3) Open the trace you just saved and filter the trace

for a...

James,

I wonder why you are sending an e-mail if a job runs OK? I'd rather send one when it fails.

Scan you server(s) on fialed jobs and send an e-mail using...

Philip,

Thank you for replying on my post.

Before testing the scrtip I like to comment on your phrase;

. . . There is a column in this table called 'backed_up_page_count', which records the...

Hi to all.

I think the title "Monitoring File Sizes in SQL Server" is not completely correct.

When noticing this title I thought '"this is what I'm looking for" but it seems to measure the fixed filesize...

Joey,

We face the same problem on Indexes. However I just need one simple job.

Create and SP on one of you databases on your server and executed it using a job...

The database is 20,5 GB in size.

Here is some info

Number of report queries per day          360

Number of Age Analysis queries per day          20

Number of Account Enquiries queries per...

Joe,

For network and servermonitoring we use MOM. It's hugh, pretty fast, and enourmous flexible for all kind of monitoring of various platforms, applications and tools.

The availability check will be for...

Barsuk,

The part you where telling about (almost simulair)  has been invoked already and its even complexer now. (automated updating on some status fields and sending e-mails regarding (un)availebility ).

Right now...

Barsuk,

Searching for a sollution I found the part you mentioned but putting it into a cursor checking a selection of our servers was a liitle more difficult due to the datatypes...

TIA,

Think of introducing MS MOM (on a dedicated server)

or

Try SPOTLIGHT on SQLserver from Quest.

GKramer

The Netherlands