Database

Sure. But I didn't fix this yet. Your help is much appreciated. Thanks Happy Coding!

Thanks for the information. Im using SQL Server 2008 R2. And also i need to work with limited set of records from the 50 million records. So im planning to take the required records to seperate temp table and planing to execute the query.

You're welcome :) Out of curiousity, was it caused by the bad idea? Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

Success! I tried the freecache and created a user under the old name and ran a query under that old name. I then deleted the user and all is fine now. The system_user is picking up the new user name. The one thing I did not do is check with the user if the SID had been refreshed overnight, before I made these changes, and whether everything was fixed before I made these changes. Anyway thanks for you help and for replying to my call for help so quickly.:thumbsup: [edit] subject amended “That which can be asserted without evidence, can be dismissed without evidence.” ― Christopher Hitchens

Thank you for the article. I have gone through it earlier but this time it is nice to read again. And I am using System i Navigator. Now in general DB2 or AS400 how can I create a Stored Procedure with parameters for Insert Statement? I totally agree that when everyone in the world is moving with new technologies and migrating data from AS400 to Oracle/SAP or some other things. I am still using this because my boss just loves AS400 like crazy. Your help is much appreciated. Thanks Happy Coding!

You're welcome :)

can not download pro...

Great :)

Well it's not a step by step process. It all depnds on what are you trying to execute and how the layer is structured. Check for SQL server / query optimization and understand the ways to increase the performance. Top 10 steps to optimize data access in SQL Server: Part I (use indexing)[^]

You're welcome. Wrong is evil and must be defeated. - Jeff Ello

Schema is the actual structure of the database described in such a form that understandable to humans... A schema will contain definitions for tables, views, indexes, relations, procedures, functions and every other aspects can be accesses in the db...There is a possibility that for the same database there are several schemas, divided by access rights...So a schema is not equal the database but more a way one can see the database with the proper access rights... Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.

I configure SQL Server Merge Replication, when merger database together, if one of the two server machines damaged or die, the software did not transfer it, i have to manually reset ip to the software to run, how to automatically switch to 1 in 2 server fails ?

No. Just try it. And read up on normalization.

Yes. I understand it. Thank you very much.

Appreciating your help. Thanks very much I will review the function again as I'm not the one who wrote it however I'm trying to optimize a Stored Procedure performance which selects from a lot of tables + calling this function. the last time I executed the procedure it nearly took over 14 minutes without a single result while it was still executing :(

What help do you need? The error tells you exactly what the problem is. There are only 10 types of people in the world, those who understand binary and those who don't.

Thanks alot It works :)

Try removing the option from the configuration file and try again. Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

Thanks Eddy Just got it to work, create database, tables, records make the con strings for that. Better than the oleDB DBF I was going to use, which took 20 sec to write 49 records. Finished the switch to localDB this morning. I have never heard of localDB, but it seems handy for vb.net windows apps.