Hi Preethi:

you have to type full absolute path. like \\ApplicationDevelopment\Ram\Elib_cmf_feed.mdb.

As far as I know, there is no column level encryption ot data encryption in sql server 2000. In sql server 2005 you can do column level encryption. You can...

go to security-> logins.

select username. right click -> properties

and then select the database and the grant the database access . You  can do that now.

in query analyzer

use <databasename>

go

exec sp_change_users_login 'Update_one','Username' ,'username'

go

Then go and grant the database access. You will be able to do.

Thanks, I solved my problem

Hi:

I got the same issue. I resolved in this way.

Change the compatability level to sql server 2005(90)

Now you can create database diagram

Thanks,

Prema

Atlast I found out the solution and successfully replicated the sde data

would you please explain how to set dynamic names task in sql server 2000

Thanks

generate the sql script for the main database and run that script in current database query analyzer. So , you can create the all table structures of main  under the...

Instead of restoring the main database to the current one, try to export all the data from the main to current one. So that you can have the both databases

I assume RRn values only will be differed and remaining columns have same values in the duplicate rows. In that case write Sql statement like this

select max(RRN) as RRN, ProductID,...

For the first time

back up <logfile_name> with_truncate only.

After  that, issue the dbcc shrinkfile command.

After that set the database maintenance plan to take back up of transaction logs every...

In DTS designer, create source database and target database.

create execute sql task in dts designer. In that, write update statement as philcart mentioned. Create "on success" workflow from source to...

How do I make connections from source to target. What transformations do i have to specify.(Copy column, Activex script.) If Activex Script How to write it. Because I am new...

 You may ask to write report on your server and don't check  delete old files in that report. You can have the all job history