|
Home > Archive > MS SQL Server > October 2006 > Cannot create index, timeout expires (SQL Server Express 2005)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cannot create index, timeout expires (SQL Server Express 2005)
|
|
| sdragolov@gmail.com 2006-10-24, 6:33 pm |
| I am having trouble creating a primary key on a large table (6 mil
rows)... on a SQL Server Express 2005 database...
After I make the changes to the table and Save, the operation starts
but times out after about 30 seconds, saying that the timeout has
expired.
I tried looking for a timeout that would govern this but I have not
been able to find one....
My query execution timeout is set to 0 (which is unlimited), though it
should be irrelevant because this is not a query..... (in fact, I have
no problem running quries that take a few mins)...
Any idea where/what I need to change to resolve this??
Thanks in advance.
| |
| David Browne 2006-10-24, 6:33 pm |
|
<sdragolov@gmail.com> wrote in message
news:1159639554.270613.108730@c28g2000cwb.googlegroups.com...
>I am having trouble creating a primary key on a large table (6 mil
> rows)... on a SQL Server Express 2005 database...
>
> After I make the changes to the table and Save, the operation starts
> but times out after about 30 seconds, saying that the timeout has
> expired.
>
> I tried looking for a timeout that would govern this but I have not
> been able to find one....
>
> My query execution timeout is set to 0 (which is unlimited), though it
> should be irrelevant because this is not a query..... (in fact, I have
> no problem running quries that take a few mins)...
>
> Any idea where/what I need to change to resolve this??
>
What tool are you using to run the query? Can you get a script of the
change and run it in a query window in SQL Server Management Studio?
David
| |
| sdragolov@gmail.com 2006-10-24, 6:33 pm |
| Well, in theory it's not a "query", right?? It's a DDL...
I am using Management Studio - I right click on the table,and do
Modify, then I select the two fields and right click and do "Primary
Key"... Then I finally do Save and that's where the error comes after
about 30 seconds...
I guess I could get the DDL text of adding these PKs and then try to
run that in a query window.... though why would that be any
different...??
David Browne wrote:
> <sdragolov@gmail.com> wrote in message
> news:1159639554.270613.108730@c28g2000cwb.googlegroups.com...
>
>
> What tool are you using to run the query? Can you get a script of the
> change and run it in a query window in SQL Server Management Studio?
>
> David
| |
| David Browne 2006-10-24, 6:33 pm |
|
<sdragolov@gmail.com> wrote in message
news:1159647740.250757.210120@c28g2000cwb.googlegroups.com...
> Well, in theory it's not a "query", right?? It's a DDL...
>
> I am using Management Studio - I right click on the table,and do
> Modify, then I select the two fields and right click and do "Primary
> Key"... Then I finally do Save and that's where the error comes after
> about 30 seconds...
>
> I guess I could get the DDL text of adding these PKs and then try to
> run that in a query window.... though why would that be any
> different...??
Because it's the client tool that generates the timeout, not the server. If
Management Studio will give you the DDL, just run it in a new query window.
David
| |
| Stefan 2006-10-24, 6:33 pm |
| David - your suggestion did work... Thanks!
David Browne wrote:
> <sdragolov@gmail.com> wrote in message
> news:1159647740.250757.210120@c28g2000cwb.googlegroups.com...
>
> Because it's the client tool that generates the timeout, not the server. If
> Management Studio will give you the DDL, just run it in a new query window.
>
> David
|
|
|
|
|