Search results for query: *

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

Do I need to have multiple listeners if I have multiple datbases? 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...

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...

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...

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...

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...

My DTS package from ORacle to MSSQL seems to be not running. Though it seems to be running there is a status:386 below th eprogress bar. ANy ideas as to what the problem might be? Thanks

Is there a way to get all the tables counts as a report on my database without doing select count(*) for each tables individually? Thanks

I am doing an initial load on a db which has several tables with 2 million records. 1. Is it good practise to have to automatically extend datafile when full? 2. To increment the datafile by 1000kb? 3. The maximum size to be unlimited or have a value? Thanks

How can we do differntial backup in SQLServer? How is it ( I mean the process) different than the full backup? Thanks

Could some one tell where I can find a good backup process that I can implement for a 300 gb db? I have a Database maintenenace plan setup but would like to hear your thoughts as to what I should or should not do. Also how big is a VLDB? When can you call a DB a VLDB? Thanks

Is there a DTS log that has the table names and the number of records that got imported into a DB? I did find a DTS package log that is not really helpful for me. Cause I need to know how many records got imported from the source db and whether there were any errors during the process. Thanks Josh

Though I know that "when a new row is added to a full index page, SQL Server moves approximately half the rows to a new page to make room for the new row." I have few questions.. 1) A full index page is a 8kb page that is indexed with a clustered or non-clustered index right? Let us say I...

I am rewriting triggers in Oracle to SQL Server and I am running into some problems In Oracle I can change the column SUBS1 new value to a substring of another columns value :new.SUBS1:= SUBSTR(:new.MR_ADAM_KEY,1,9) In SQL I have tried something like this Declare @as_temp varchar(20) select...

Even though I have a Begin and End around the Rollback transaction why do I get this error? Is this anything do with this option "XACT_ABORT" ? Below is my code. Could you please tell where I am going wrong? if not exists (select * from inserted where subs1 is null) Begin RAISERROR...

I have a very simple if condition. If the if condition fails I want to raise error. I keep getting "Incorrect syntax near the keyword Begin". Here is snippet of the code If Not isnull (inserted.subs1," ") BEGIN RAISERROR ('Field SUBS1 Is Read Only. Updating this field will cause loss of...

Are there any known problems with running Sybase 11.5 on a 2003 server? How stable is it? DO I have to upgrade to a 12.0? Thanks Any suggestions are welcome