the four part name does work...just very slow.

I can run the same query under iSeries navigator and get results in matter of seconds.  But through linked server it takes 45+...

This may be result of moving databases from one server to another where User1's sid was the same as the dbo's.

You may want to try:

exec sp_change_users_login 'report'

this will show all...

If the SQL Server you are trying to register is not using the default port of 1433, you will need to setup a system dsn pointing to the correct port.

the four part name should be:

linked server name..schema name.table name

ex. linked server name = ORACLEPROD

     schema name = DBOWNER

     table name = TBLA

     four part name should be ORACLEPROD..DBOWNER.TBLA

     NOTE: the four part...

Do you have iSeries client installed on the SQL Server box?

Have you created the linked server on the SQL Server box?

the four part name should be:

<linked server name>.<catalog/database name>.<library/schema  name>.<table...

use dbcc shrinkfile(fileid,size in mb).  this will shrinkfile the file regardless of its orginial defined size.  fileid is in sysfiles.

We are in the process of moving two of our sql7 servers to another box.  Here is what we are doing:

1. recreate all the logins (sql, nt user, nt groups)...

in vbscript you can set main = DTSTaskExecResult_Success or DTSTaskExecResult_Failure

try this:

exec master.dbo.xp_sendmail 'your email address',

@subject='server name Job Failures',

@query='

select b.server, a.name, b.step_name, b.sql_message_id, b.sql_severity,

b.message

from msdb.dbo.sysjobs a, msdb.dbo.sysjobhistory b

where a.job_id = b.job_id

and...

since the database does not exists in the new server the attach command will fail...try this create the database on the new server, detach the database and reattach the "copied"...

changes to the attribute of an existing column in your user table will cause crdate in sysobjects to change

Try this query:

select substring(a.table_name,1,18) as Table_Name,

substring(a.column_name,1,30) as Column_Name,

substring(a.data_type,1,8) as Data_Type,

substring(cast(a.character_maximum_length as char),1,6) as Max_Length,

substring(cast(a.numeric_precision as char),1,4) as Num_Precision,

substring(cast(a.numeric_scale as char),1,4) as Scale,

substring(a.column_default,1,20) as Column_Default,...

try this:

exec sp_attach_db 'activesales' ,'e:\Program Files\Microsoft SQL Server\MSSQL\Data\ActiveSales_Data.MDF'

I'm assuming that your database name is activesales and not as_2.

We use this procedure when want to resize our log files...sql server will...