Thank you for your response,

I have a package and it is one of the 3 deployed packages in a folder. Do I need other two packages as well to deploy...

Thank you all for your inputs these are really helpful.

Esha

Bellow is the code:

-- getting required columns to a temporary table

SELECT LTRIM(RTRIM(Zip)) Zip, Code ,LTRIM(RTRIM(City)) CLLI, LTRIM(RTRIM(City)) CLLI,LTRIM(RTRIM(State)) State,Processed ,LTRIM(RTRIM(A))[A],LTRIM(RTRIM())

,LTRIM(RTRIM([C]))[C],LTRIM(RTRIM([D]))[D],LTRIM(RTRIM([E]))[E],LTRIM(RTRIM([F]))[F],LTRIM(RTRIM([G]))[G],LTRIM(RTRIM(H))H ,LTRIM(RTRIM(I)) I

INTO #IMS_StgTemp FROM IMS_StgUpload WHERE (Processed IS NULL...

Thank you very much for your help.

Can you please elaborate on what preferences mean while selecting a data model tool.

Would the size of the database and the servers on which...

Thank you for your quick response.

I am looking for the MSSQL Server databases, Oracle databases & BI as well. Is there any best modeling tool which can accommodate all.

Esha

I have a clustered and non-clustered index on LID in tables 1&3 but not in 2 & 4. The execution plan for the update statement includes execution plan for the...

In Tables 1&3 there are over 2000 records,tables 2 & 4 there are over 20 million records.

The trigger should be fired on an update, there are no recursive triggers on...

An overview of the trigger - There are two databases DB1-Transactional and DB2-Archive. There are two tables from each database, Tables1 & 2 from DB1 and Tables 3&4 from DB2.

The...

As you mentioned that the user is from different domain. Verify the user permissions to the other domain with network.May be that is causing the issue.

I had this issue myself...

Please share your ideas

Swetha K

Should we have to work on deleting the Registry entries while removing the default instance.

Swetha K

used shape2sql tool. Running shape2sql.exe I selected the file needed to upload, configured the server and table which is used for inserting records, checked create spatial index and planar geometry.

and...

I have selected the file which needs to be uploaded but it doesnt show me the column names and doesnt import any data though hit upload button.

I should also be...

I have recommended the same Derrick.

Thank you for your prompt response.

Swetha

Thank you so much Derrick, for your response.

Named pipes - I have enabled now and tried. The port number is connected to 1433.

Had the following error:

*****************************************************************************************

Error Location: App_Code\clsCommon.vb\fnLoginUser

Error Message:

System.InvalidOperationException:...