The job is not running at all and not giving any errors. When I checked with right clicking on the job view the job history it says "no job history".

venkatesh

Thanks Andy, I know about this before but i was not sure about it and moreover nobody has clear answers prior to last two answers.

venkatesh

Is there any way where we can give alias to the login as dbo.

venkatesh

I understand that we can change the object owner after creation of object by the below procedure, but is their any way while creating object logging through non-sysadmin login. Please...

The reason I am asking is , there is a replication setup for one of our client database and sometime the client side DBA will create objects in our databases,...

HI I understand but, i didn't got exactly on what privelges the dts will run the package.

venkatesh

hi Andy, Thanks for your prompt replay, But i have a problem. I am trying to convert the database from SQL SERVER to ORACLE, I think there was some confusion...

Hi Andy,

I got you, but i am new to this SQL environment, what is batch size, let me know how to set the batch size and if you have any...

Thanks david and steve. I will check with the client for the all the log files.

venkatesh

Hi Andy,

By any way we can by pass the log files and create the database with only MDF file. IF yes let me know.

one more thing i also...

Hi Steve, Here is the code ran and error messsage.

EXEC sp_attach_db @dbname = N'PMOPS',

@filename1 = N'E:\Program Files\Microsoft SQL Server\MSSQL\Data\OrderProcessing_data.mdf',

@filename2 = N'E:\Program Files\Microsoft...

Hi Andy,

I tried the same thing, like rename the log file and attach the single datafile with sp_attach_single_file_db, This gives the same error.

Please Advise.

Venkatesh

venkatesh

Hi Andy, Thanks for replaying to my mail. I tested in my test box it works fine with different database. But this database files are sent by client,...