yep, all programming starts with copy & paste.

did anyone modify the dts-package from his/her client connecting to the server (and not being at the server-console ?

MDAC can cause some pains in this case because dts stores (client)-objects.

maybe a stored proc can give the solution ?

watch out for noeld's litle typo

, SUM(CASE WHEN MONTH(workdate) = 11 THEN bhrs ELSE 0 END ) as Dec

--should be ---------------------------12

sql2k with sp3a on a multiprocessor box ? There is an issue with count(*). Hotfix is available at MS.

Might be the issue described at http://support.microsoft.com/default.aspx?scid=kb;en;241643. Forwarded it to my Windows administrators.

http://www.databasejournal.com/scripts/article.php/1496451

-- Update Originating_Server sysjobs !! for SQLAgent

http://support.microsoft.com/default.aspx?scid=kb;en-us;281642

  SQL7.0 http://ambrosoli.com/ambrosoli/how_to_rename_a_sql_server_7_0.htm

If you connect using ip there is no problem, if you connect using sqlservername, you'll have to modify the...

having the same issue

It will work for the default instance, but not for the others.

all clients are on winXP sp1 with SQL2k sp3a (re-apply did not help).

ping is no problem.

I can register the sqlserver when I don't have EM browsing for servers.

SQLServiceManager also...

Like Frank Kalis and MrSQL said. Probably one db sould do fine.

The most frequently made worst practise is that one is tempted to go for phisical solutions without even having...

I don't use sqlmaint, but use my own dbreindex-generator. The main reason is that on our ERP-system (24/7) there is always a lock on a certain table.

On our MES-system,...

with

<< SELECT JOBID, JOBTITLE, JOBPOSTEDDATE

  FROM JOB_POSTINGS  ORDER BY CONVERT(VARCHAR(5), JOBPOSTEDDATE, 108) ASC >>

your query only sorts on the TIME(HH:mm)-part of your datetime (108format check BOL) !

If that is wat you want, your...

we have such "dynamic" tables.

parametertable

  ( tablename, colparam, colname, startdatetime , enddatetime, whodidit)

table

   (datetimeInsert, d001 float, d002 float, d003 varchar(500), ...)

In the presentation layer, the...

my 2ct:

Thé main advantage is 'meaningless primary keys' !

Some use identity others use uniqueidentifier to do this.

Disadvantage of uniqueidentifier :

   -...

can do

but I 've just foundout that the bo-client's mdac is not at 2.6 yet

I hope their helpdesk...