Here is the sample

where is join between systemdata and resident table?

In Query Analyzer, click tools/options/results

You have option to save result to file.

Product Support Services.

MSDN article relate to problem (solution) has the PSS ID Number. In the old day it was called Q303715 in the case.

Check following article: PSS ID Number: 303715

42000 indicates some kind of access violation.

Check DotsJrOld_db_200308211730.BAK, if exists, try to rename it. You may experience difficulty.

Authentication mode is a server base option, not an individual base.

If you change from SQL Server and Windows to Windows only, the existing sql server login will not be used...

If list of fields are pre-defined, then data type and length are known. They should not be 500,000 'text' fields.

Table with userid, fieldid (reference those pre-defined fields) and value...

Change database option 'AUTOCLOSE' to true.

For syntax, check BOL for alter database

Did you mean sp_addlinkedsrvlogin

Try

sp_addlinkedsrvlogin 'CNRDAPRD', 'false', null, 'ORA logon', 'ORA password'

save following to DelHeaderLine.wsf

Usage sample:

DelHeaderLine source destination

It copy the source file to destination without the first line.

<job id="DelHeaderLine">

  <runtime>

     <description>Delete text file header line</description>

     <named name="SFile"

         helpstring="Source file"

         type="string"

         required="true"

    ...

select object_name(parent_obj) from sysobjects where id = @@procid

alter function fn_reverse (@strin varchar(4000))

returns varchar(4000)

as

begin

 declare @return varchar(4000)

 declare @ascii smallint, @numeric bit, @space smallint, @start smallint, @garbage varchar(30)

 declare @i smallint, @j-2 smallint

 select @i = 1, @start = 1, @garbage =...

exec ('kill '+cast(@blk as varchar))

liebla,

In your SQL7 environment, how did you failover two defaults if one node die?

SQL7 will run one version on a machine.