HI,

In enterprise manager expand till tables and right click and select export data.

In DTS wezard u can select the source and destination and number of tables u want to transfer.

HTH

from

Killer

Hi,

I solved the error of remote connection by removing the instance name string from the named pipe string.

but still now i am not able to use BCP utility.

Pls help

from

Killer

hi.

this is not what i need.

i need a query that will give me the record starting with E.

from

killer

Hi Bill,

I create a stored procedure and scheduled a job to reindex the indexex.

I scheduled the job twice a month.

I know the time the reindex in progress user cant use...

 SOrry I dont know why some other user name is attached to my user name.in the post

Dear Sisi,

I checked the Statistics  it is ok as i scheduled a job...

I want to know how often u need to copy the tables data from source to destination.

Then the position will be clear.

from

Killer

dear ,

If u want to backup the database to a network drive then u have to backup the database through code or from the database maintinance plan.

U should have domian...

dear ,

If u want to backup the database to a network drive then u have to backup the database through code or from the database maintinance plan.

U should have domian...

hi.

save u file with the extension .bat.

and try again.

from

killer

hi,

may this give u a way.This is  a script to generate automated passwords.

from now u want to change the password for 100 user.

create a stored procedure which will change the...

Hi,

For currepted table tranfer the Table Design and data to text file and then use DTS for ETL Process.

Killer

Hi,

Backup  Log <database name> with truncate_only

DBCC shrinkfile(Logical file name of log fiel,size u want to shrink)

For future set a Database Optimization Plan which will shrink the file after the backup is...

Hi,

Create a linked server and execute the query using the  (linked server name).

ex: select * form [192.168.1.14].databasename.dbo.tablename

u can also use select * into tablename from [192.168.1.14].databasename.dbo.tablename

from

Killer

Hi,

U can perform this task through DTS package of Sql Server.

U can connect to ur Oracle server and tranfser all the tables.But let oracle create the table in the SQL...

Hi Nitin ,

If u had looked into the question then u might not give me an answer as u had given me.

You need to modify boot.ini by /PAE switch