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...

If only you had that (old) backup. With full logging, all could be restored to the point where you dropped the object(s).

(then you could restore to an alternate db with...

It surely would, but I would like to have some alternatives, because of # of clients using BO.

e.g. Windows aliassing the server. But I cannot seem to get to the...

-dbcc updateusage can help out. statistics get a bit messy when you use truncate table every now and then.

-then dbcc spaceused your db and look for fragmentation rates.

-make sure you...

Do you have (not simple) logging ?

maybe log-explorer (lumigent) or log-pi can help out ?

or http://www.logpi.com  

you could use xp_logininfo, but imo you'd better use the security-capabilities of sqlserver.

e.g. grant a nt-group as db-user and then grant it the needed (sp) rights.

because then you avoid over-authorised...