The Microsoft Way is to told you that SQL 2000 on Windows 2003 is not supported.

You can use it any way, but the best is:

Ignore the message, install sql 2000...

Yes it runs, but when you use Servers with instance names it didn´t work.

I will spend a lot of time to fix the problem, but i don´t have checked the...

You can test it. You can use thew northwind or pubs database. The script creates  new tables for each SQL Server in your invoirment(linked Servers)called "servername"data.

The script works wheen you...

Yes see my second script i sayd it works fine, but i cant do this with the varialbe @servername, the affect gives a error like this:

Line 9: Incorrect syntax near...

The solution i try is.

take a backup every Sunday sheduled by an backup job.

Every time I change Data in an Job or Maintain user accounts I run the Job manually.

You...

Hi all,

can you check the account who runs the job in job properties!!

It musnt be a problem with the service accounts. When you design a job with your account, the...

Thanks All.

I think I must learn about a lot of ASP.NET

Marvin thanks for your bidding to give me some samples, please put the samles here.

My introduction is to create...

Ok,

I have

2 Lap Tops (XPSP2).

include VPC Images of WXP,W2K3 Adv Srv, Professional and Win98

1 W2k3 Server ADC, Exchange, SQL

1 Red Hat Linux Server running Apache and Firewall Services.

Kind Regards

Michael...

oke thank you, i will test this soulution tomorrow in my test enviorment.

I will post the solution when it works fine.

Regards

Michael

Hi,

you can use the following:

Backup LOG [Database] with truncate_only.

Use BOL to show the syntax of DBCC Shrink file statement, to minimize your log file.

Be shure, that you dackup your database...

that is fine, then i will go to implement the job in NetIQ and post it here.

Regards

Michael

Hi Gurbaksh,

no is the essential NETIQ AppManager, there are couters for DB - Space and Service Monitoring, but i need a construct to monitor failed Jobs.

Regards

Michael

after you had truncated the log file you can shrink the file by:

DBCC SHRINKFILE

    ( { file_name | file_id }

        { [ , target_size ]

            | [ , { EMPTYFILE...

I think this helps to find the right time:

select DATEPART(hh,getdate())as stunde,DATEPART(mi,getdate()) as minute

or do it so...

declare @hour CHAR(2)

declare @minute char(2)

set @hour = DATEPART(hh,getdate())

set @minute =DATEPART(mi,getdate())

print @hour+@minute

For future use you can set the Database in dbo use only, than you never had this problem.

I think it is the better way to do any administration jobs on...