15,895,084 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Amol_B (Top 60 by date)
Amol_B
13-May-16 0:49am
View
Thanks. so does it mean if the option is set to zero, then you cannot access sql server database from other machine ?
Amol_B
8-Feb-16 3:05am
View
HiI am facing the same issue.
Any suggestions in this is highly appreciated.
Amol_B
27-Oct-15 7:02am
View
Thanks for your reply.
Product Code is fine and that can be updated. ( i did edited end part of my question - how to get correct Error code). Basically i am expecting Error code 1683 to be returned so that my another module can catch it, but setup always returns Error Code 1603
Amol_B
26-Oct-15 7:36am
View
Thanks.
Amol_B
27-Oct-14 8:53am
View
If you got answer to your Question mark it as answer, accept solution and close the question
Amol_B
7-Oct-14 4:18am
View
Reason for my vote of 1 \n Are you writing Article just to gain CP points? what is new the it ? You are just repeating something whihc is very basic and it is there from long time.
Amol_B
18-Aug-14 8:25am
View
Very Nice +5
Amol_B
13-Aug-14 7:58am
View
Thanks a lot... Exact one..
below Code project Article Explains it
http://www.codeproject.com/Tips/668042/SQL-Server-2012-Auto-Identity-Column-Value-Jump-Is
Amol_B
13-Aug-14 7:58am
View
Got this Article on CP itself..
http://www.codeproject.com/Tips/668042/SQL-Server-2012-Auto-Identity-Column-Value-Jump-Is
Amol_B
13-Aug-14 7:40am
View
Thanks for Reply. Yes, i am sure about scenarios happening,it is not deleted row scenarios.
In my case 'new again' row will have key value as 1007
Amol_B
13-Aug-14 6:54am
View
What exactly do you want?
Amol_B
13-Aug-14 1:02am
View
Yes , i Agree... that's what i said 'may not be the best'
Amol_B
12-Aug-14 4:51am
View
You want everything ready ? Does Google not work on Your Machine?
Amol_B
6-Aug-14 6:31am
View
Do you need to calculate Due date based on Start Date ?
Amol_B
13-Jun-14 5:53am
View
Thanks for the link.
Amol_B
2-Jun-14 8:01am
View
Reason for my vote of 1 \n Too Complex!
There is simple one-liner solution for this.
Amol_B
22-May-14 4:40am
View
Thanks
Amol_B
22-May-14 1:55am
View
Thanks DamithSL, but it has to take historical data in account. To Determine average use within period of 2 to 3 years and determine trend.
Amol_B
21-Nov-13 4:09am
View
+5 :)
Amol_B
21-Nov-13 4:03am
View
Please elaborate you question
Amol_B
28-Oct-13 8:21am
View
Nice one
Amol_B
28-Oct-13 7:18am
View
You are welcome!
Amol_B
25-Oct-13 0:50am
View
Cheers! Just want to demonstrate a way without using aggregate function
Amol_B
23-Oct-13 9:12am
View
Reason for my vote of 1 \n That's an update with inner join. What new in it? what you are trying to say?
Amol_B
21-Oct-13 8:15am
View
Once you install your setup file, it will extract application in C:\Program Files (or other location if you chosen) Go to that location edit app.config file and save it. this way you can change connection string. Note that name of app.config file will be application.config(if your application name is abc.exe then config file will be abc.config
Amol_B
15-Oct-13 4:58am
View
Reason for my vote of 4 \n good!
Amol_B
8-Oct-13 0:57am
View
perfect +5
Amol_B
1-Oct-13 2:38am
View
Good One+5
Amol_B
24-Sep-13 2:38am
View
Reason for my vote of 5 \n Gosh, i never noticed that.
Thanks! 5
Amol_B
24-Jul-13 6:47am
View
Thanks
Amol_B
12-Jul-13 5:38am
View
it seems varchar to me.
or you want new line character ?
Amol_B
11-Jul-13 2:08am
View
Reason for my vote of 4 \n Good! But there are already several articles written on this subject.
Amol_B
10-Jul-13 9:50am
View
Thanks Pablo!
Amol_B
9-Jul-13 8:35am
View
That should solve problem for sure
Amol_B
9-Jul-13 8:13am
View
oh... in that case you can check
select * from INFORMATION_SCHEMA.ROUTINES WHERE SPECIFIC_NAME = 'InsertUpdateLocation' OR ROUTINE_NAME = '_InsertUpdateLocation'
and check here if specific schema is DBO . if it is not then you can face this problem.
Amol_B
9-Jul-13 6:43am
View
Reason for my vote of 1 \n too simple and not even a tip
Amol_B
28-Jun-13 2:58am
View
if you column data type is date time then it will return proper results. it seems that you are storing date as varchar column
Amol_B
25-Jun-13 1:15am
View
Please elaborate
Amol_B
20-Jun-13 10:36am
View
Nice.. if u can share the answer as well then it will help others
Amol_B
18-Jun-13 8:42am
View
please Check updated solution.
If it helps you mark it as answer
Note that this is general idea, there might be another way of doing this
Amol_B
18-Jun-13 2:30am
View
Did you got answer for this... if not i can try for the same
Amol_B
17-Jun-13 1:22am
View
Please elaborate your question.
Amol_B
12-Jun-13 4:48am
View
please mark it as answer if it helps.
Amol_B
12-Jun-13 3:22am
View
can you elaborate your question
Amol_B
9-Jun-13 4:00am
View
Good links, +5!
Thanks
Amol_B
7-Jun-13 2:05am
View
Thanks Sergey.
I tried to keep CPU Usage and other things similar.
I understand that plan cache reuse plays important part here but still there is lot of variation in execution time
Amol_B
29-May-13 4:59am
View
Instead of Asking a Question You can simply Google it
Amol_B
22-May-13 8:18am
View
Use keywords like distinct or check you code for repeated logic
Amol_B
21-May-13 2:07am
View
Do not use all text in capitals.. this is shouting
Amol_B
7-May-13 1:10am
View
Experience is the best book
Amol_B
6-May-13 5:12am
View
this question has been asked several times... you can get answer if you search it
Amol_B
6-May-13 0:52am
View
Thanks.
Amol_B
2-May-13 2:21am
View
do you want to set label value before form 2 is called or after?
Amol_B
29-Apr-13 8:06am
View
does this screen is displayed while you install application?
You can add custom dialog screen instead
Amol_B
7-Mar-13 4:28am
View
Have you googled it?
Amol_B
21-Feb-13 0:47am
View
+5
Amol_B
24-Jan-13 5:24am
View
This can be achieved by using PIVOT
Amol_B
23-Jan-13 4:48am
View
"the connection property has not been set or is null" is indication of non initialization of connection. You are reading string from config file, but are you using it in connection?
Amol_B
31-Oct-12 2:32am
View
Reason for my vote of 5
Excellent!
Amol_B
14-May-12 7:57am
View
Reason for my vote of 2
simple
Show More