Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sinjin67
Yak Posting Veteran
53 Posts |
 Posted - 2007-12-30 : 16:17:13
|
| I am sorry to ask a newbie question but I am hoping someone might be able to show/explain this to me.Scenerio is as followsI have succeded in importing my foxpro table using the upsize wizardto SQL Express. All my records are there. just under 90,000 total.I then attempt to set a PK and Identity Column using the StudioManager. I get the following error message when I try to savethe changes.'contact1' table- Unable to create index 'PK_contact1'. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Could not create constraint.I would like to mention when I following the same procedurewith just a 1000 records everything works fine.Most of the reading I have done and looked up on google all pointto the .NET or the application I am developing is the root cause.But in this case I am using the SQL Studio Manager to setup withand have not been able to find a clear answer how to change thetimeout in the Studio ManagerAny help would be great. I will keep reading but I could reallyuse a pointer here if someone can share..Thanks again. |
|
|
sinjin67
Yak Posting Veteran
53 Posts |
Posted - 2007-12-31 : 11:34:40
|
| I was able to find the answer to this. In case someone else may run into this.When you first load the Studio Manager - Select the Optionsbutton. You can change the connection time there. For testingI set mine to 9999 and everything worked fine after that.Hope this helps another... |
 |
|
|
|
|
|
Timeout expired question