April 18, 2011 at 1:37 pm
The developer complaining that when he using vb script to load the 7000 odd rows into the table in sql server 2008, in the mid of loading rows his getting the error sql server doen't exist or access denied. why this is happening
To trace out the above situation what steps do i need to follow, If run the profiler what option I need to select in profiler.
April 19, 2011 at 7:16 am
That error should only happen when connecting and if the developer is loading the 7000 rows at once it should be in across one connection. Sounds like the VB Script is connecting and disconnecting on each row being loaded.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 21, 2011 at 12:24 am
Not exactly what you mentioned I run the profiler when the developer start the loading, I havent find the exact reason but i found that checkpoint issue but I am not clear about to resolve the issue can you please suggest me how to solve the checkpoint_queue issue
April 21, 2011 at 9:16 am
A checkpoint should not cause connectivity issues. A checkpoint is just mark in the transaction log to signify what transactions can be overwritten because they have completed.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply