Search results for query: *

Thanks I got it working!

I have a question regarding having a temp table created in my trigger CREATE TRIGGER ins_employee_details ON employee_details FOR INSERT AS DECLARE @mytable table (RequiredAction_Id int IDENTITY (1, 1), RequiredAction varchar(50) NOT NULL , RequiredActionDescription ntext NULL , DueDateInDays...

I am replicating a table with a text column from adaptive server 12.00.7 to a sybase adaptive anywhere db. The text column does not get replicated sometimes. Could someone tell me how I can trouble shoot what the problem is since it really does not really have a pattern. Thanks for your help

Thanks SantaMufasa!

Do I need to have multiple listeners if I have multiple datbases? Thanks

Will there be any performance problems due to tempdb growth? And how can I minimize its growth on big data loads? Thanks

I have a DTS task that creates tables/loads data from Oracle to SQLServer/create indexes/foreign keys and triggers as individual tasks. When the ORacle to SQLServer import task happens I can see my tempdb getting full very quick. In ~ 45 mins it grew to 1 GB. The options that I have set on the...

Thanks Vongrunt! Appreciate all your hel;p , also the article is very useful Thanks again

Andel/vongrunt Thanks for your reply. My insert batch size was set to 0. I have now set it as 100000. I am trying to understand the real need for the log in this case is that the 100000 rows will be stored in the log and when the 100000 th row gets inserted in the log it will commit to the db...

Yes the recovery model is set to simple. I am still not sure why the log get filled when I have the truncate log option set and why does it even try to fill the log when it is doing a DTS? Is it not a BCC equivalent style of loading data? By having a primary key during a DTS import, will it...

Thanks vongrunt for your reply! Well if you see my earlier post I had mentioned that I ran the sp_dboption t truncate the log on checkpoint exec sp_dboption @dbname = '<db_name>', @optname = 'trunc. log on chkpt.', @optvalue = 'true' Can you thorw more light on what you mean by...

I am not able to truncate the log as well. Any help is appreciated as how I can import without the log taking up my almost half of my hardrive? ALso why does it take 30 Gb of log space for a 15 GB DB? Any suggestions would be helpful Thanks

I am importing data from a 15 GB Oracle database into SQL Server using DTS. It bombs while doing the last 4 tables saying " Could not allocate space for object <table_name> in database <database_name> because the 'Primary' filegroup is full. I have everyhting setup for autoincrement of log and...

Thats it!! Thanks MR Denny..

I saved a DTS package on machine A as a structured storage file with a name of XXX.dts. On machine B when I click open package I am able to see the XXX.dts on the network dive but when I open it and save it, I expected that the XXX.dts should appear on machine B, under Local packages. But I am...

Thanks SQLSister!

Is there an example of an INSERT and the SELECT that used SCOPE_IDENTITY to return the identity field ?  The examples I am finding use stored procedures.. Thanks

After selecting the DB I want to backup whenI clickon Backup I get the following error "This wizard can only be launched when connected to a OMS. Launch the application and connect to the OMS before trying to launch the wizard again." I just created the OMS database and changed the pwd and am...

Thanks Jon!! I am trying to create a package and see how this goes.. Thanks again!

I have several tables in Oracle with 30 - 50 million records. I want to write a DTS package and export to MSSQL Server. I have been currently using Enterprise manager to create a DTS package and run it after the package is created. What is the best way to approach this? Should I use DTS run...