Hope below link will help

http://rafael-salas.blogspot.com/2007/02/ssis-loop-through-files-in-date-range.html

Anyway if you want to still change the owner of DTS package then use undocumented SP in MSDB to do it (sp_reassign_dtspackageowner [@name =] 'name',

[@id =] 'id',

[@newloginname =] 'newloginname'

Try COLLATE function in your query,

Performance wise OPENQUERY is little more efficient .

This Third shared disk is for transational log files(ldf) for your database, if you don't want to put these on seperate disk that data files(MDF) you only need 2 shared...

IF the disk where you are moving the Master database is iunder SQL Server Dependency and you have properly given path in surface configration with -d and -l parameter and...

Todd

If you are using any Customize piece for SQL Server from Vendor then Locking Login may be additional feature they might have introduce in that Software , so for that...

SQL Server 2000 won't lock/disable the Login as this feature is availble in SQL Server 2005 not in 2000.

USE Databasename

GO

Exec sp_changedbowner 'new login name'

Like

Select * from linkedservername.databasename.schema.table or view name

eg-- Select * from server1.master.dbo.sysdatabases

SELECT name

FROM sysobjects

WHERE xtype='U'

AND objectproperty(object_id(name),'TableHasForeignKey')= 0

ORDER BY 1

you can check the -g parameter option for incresing memory area for application , not good practice but can be helpfull sometime

try a shot

declare @number varchar(10)

set @number =(select distinct Number from tablename where conditions)

select '00'+ @number

I won't find any problem with this syntax SELECT * into Tbl_Cars FROM V_Cars.

Why it's showing odd results for you.

Just rename the name cloumn with any other name as below.then it will works

Use adventureworks

go

select name as colname, *

from production.product

ORDER BY [name]

Try it now.

Thanks