I'm trying to execute a "DELETE FROM table" command from a query window in
SQL Server 2005 Management Studio, but the query times out after 30 seconds.
How do I increase this timeout value?
Olav
Olav,
Follow the menu path:
Tools
Options
Then in the popup box:
Query Execution
SQL Server
General
Set Execution Timeout to 0
RLS
"Olav" <x@.y.com> wrote in message
news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
> I'm trying to execute a "DELETE FROM table" command from a query window in
> SQL Server 2005 Management Studio, but the query times out after 30
> seconds.
> How do I increase this timeout value?
> Olav
>
|||The timeout in that dialog is set to 0 and still the query times out in 30
seconds.
Olav
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
> Olav,
> Follow the menu path:
> Tools
> Options
> Then in the popup box:
> Query Execution
> SQL Server
> General
> Set Execution Timeout to 0
> RLS
> "Olav" <x@.y.com> wrote in message
> news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
>
|||"Olav" <x@.y.com> wrote in message
news:eodLwsLnHHA.3968@.TK2MSFTNGP06.phx.gbl...
> The timeout in that dialog is set to 0 and still the query times out in 30
> seconds.
I believe it's timing out because some other process is blocking it. Not
because the query itself is taking too long.
Find out what's blocking it and fix that.
> Olav
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||Olav,
Greg could be right, but I would not expect a block to cause a timeout
unless the connection timeout period was exceeded. There is no limit to how
long a block can be held, just a limit to how long you are willing to wait
for it.
Could you check your server to see if the "query wait" option is configured
to something other than -1?
RLF
"Olav" <x@.y.com> wrote in message
news:eodLwsLnHHA.3968@.TK2MSFTNGP06.phx.gbl...
> The timeout in that dialog is set to 0 and still the query times out in 30
> seconds.
> Olav
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
>
Showing posts with label increase. Show all posts
Showing posts with label increase. Show all posts
Friday, March 23, 2012
How to increase timeout?
I'm trying to execute a "DELETE FROM table" command from a query window in
SQL Server 2005 Management Studio, but the query times out after 30 seconds.
How do I increase this timeout value?
OlavOlav,
Follow the menu path:
Tools
Options
Then in the popup box:
Query Execution
SQL Server
General
Set Execution Timeout to 0
RLS
"Olav" <x@.y.com> wrote in message
news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
> I'm trying to execute a "DELETE FROM table" command from a query window in
> SQL Server 2005 Management Studio, but the query times out after 30
> seconds.
> How do I increase this timeout value?
> Olav
>|||The timeout in that dialog is set to 0 and still the query times out in 30
seconds.
Olav
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
> Olav,
> Follow the menu path:
> Tools
> Options
> Then in the popup box:
> Query Execution
> SQL Server
> General
> Set Execution Timeout to 0
> RLS
> "Olav" <x@.y.com> wrote in message
> news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
>> I'm trying to execute a "DELETE FROM table" command from a query window
>> in SQL Server 2005 Management Studio, but the query times out after 30
>> seconds.
>> How do I increase this timeout value?
>> Olav
>|||"Olav" <x@.y.com> wrote in message
news:eodLwsLnHHA.3968@.TK2MSFTNGP06.phx.gbl...
> The timeout in that dialog is set to 0 and still the query times out in 30
> seconds.
I believe it's timing out because some other process is blocking it. Not
because the query itself is taking too long.
Find out what's blocking it and fix that.
> Olav
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
>> Olav,
>> Follow the menu path:
>> Tools
>> Options
>> Then in the popup box:
>> Query Execution
>> SQL Server
>> General
>> Set Execution Timeout to 0
>> RLS
>> "Olav" <x@.y.com> wrote in message
>> news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
>> I'm trying to execute a "DELETE FROM table" command from a query window
>> in SQL Server 2005 Management Studio, but the query times out after 30
>> seconds.
>> How do I increase this timeout value?
>> Olav
>>
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Olav,
Greg could be right, but I would not expect a block to cause a timeout
unless the connection timeout period was exceeded. There is no limit to how
long a block can be held, just a limit to how long you are willing to wait
for it.
Could you check your server to see if the "query wait" option is configured
to something other than -1?
RLF
"Olav" <x@.y.com> wrote in message
news:eodLwsLnHHA.3968@.TK2MSFTNGP06.phx.gbl...
> The timeout in that dialog is set to 0 and still the query times out in 30
> seconds.
> Olav
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
>> Olav,
>> Follow the menu path:
>> Tools
>> Options
>> Then in the popup box:
>> Query Execution
>> SQL Server
>> General
>> Set Execution Timeout to 0
>> RLS
>> "Olav" <x@.y.com> wrote in message
>> news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
>> I'm trying to execute a "DELETE FROM table" command from a query window
>> in SQL Server 2005 Management Studio, but the query times out after 30
>> seconds.
>> How do I increase this timeout value?
>> Olav
>>
>
SQL Server 2005 Management Studio, but the query times out after 30 seconds.
How do I increase this timeout value?
OlavOlav,
Follow the menu path:
Tools
Options
Then in the popup box:
Query Execution
SQL Server
General
Set Execution Timeout to 0
RLS
"Olav" <x@.y.com> wrote in message
news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
> I'm trying to execute a "DELETE FROM table" command from a query window in
> SQL Server 2005 Management Studio, but the query times out after 30
> seconds.
> How do I increase this timeout value?
> Olav
>|||The timeout in that dialog is set to 0 and still the query times out in 30
seconds.
Olav
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
> Olav,
> Follow the menu path:
> Tools
> Options
> Then in the popup box:
> Query Execution
> SQL Server
> General
> Set Execution Timeout to 0
> RLS
> "Olav" <x@.y.com> wrote in message
> news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
>> I'm trying to execute a "DELETE FROM table" command from a query window
>> in SQL Server 2005 Management Studio, but the query times out after 30
>> seconds.
>> How do I increase this timeout value?
>> Olav
>|||"Olav" <x@.y.com> wrote in message
news:eodLwsLnHHA.3968@.TK2MSFTNGP06.phx.gbl...
> The timeout in that dialog is set to 0 and still the query times out in 30
> seconds.
I believe it's timing out because some other process is blocking it. Not
because the query itself is taking too long.
Find out what's blocking it and fix that.
> Olav
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
>> Olav,
>> Follow the menu path:
>> Tools
>> Options
>> Then in the popup box:
>> Query Execution
>> SQL Server
>> General
>> Set Execution Timeout to 0
>> RLS
>> "Olav" <x@.y.com> wrote in message
>> news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
>> I'm trying to execute a "DELETE FROM table" command from a query window
>> in SQL Server 2005 Management Studio, but the query times out after 30
>> seconds.
>> How do I increase this timeout value?
>> Olav
>>
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Olav,
Greg could be right, but I would not expect a block to cause a timeout
unless the connection timeout period was exceeded. There is no limit to how
long a block can be held, just a limit to how long you are willing to wait
for it.
Could you check your server to see if the "query wait" option is configured
to something other than -1?
RLF
"Olav" <x@.y.com> wrote in message
news:eodLwsLnHHA.3968@.TK2MSFTNGP06.phx.gbl...
> The timeout in that dialog is set to 0 and still the query times out in 30
> seconds.
> Olav
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
>> Olav,
>> Follow the menu path:
>> Tools
>> Options
>> Then in the popup box:
>> Query Execution
>> SQL Server
>> General
>> Set Execution Timeout to 0
>> RLS
>> "Olav" <x@.y.com> wrote in message
>> news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
>> I'm trying to execute a "DELETE FROM table" command from a query window
>> in SQL Server 2005 Management Studio, but the query times out after 30
>> seconds.
>> How do I increase this timeout value?
>> Olav
>>
>
How to increase timeout?
I'm trying to execute a "DELETE FROM table" command from a query window in
SQL Server 2005 Management Studio, but the query times out after 30 seconds.
How do I increase this timeout value?
OlavOlav,
Follow the menu path:
Tools
Options
Then in the popup box:
Query Execution
SQL Server
General
Set Execution Timeout to 0
RLS
"Olav" <x@.y.com> wrote in message
news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
> I'm trying to execute a "DELETE FROM table" command from a query window in
> SQL Server 2005 Management Studio, but the query times out after 30
> seconds.
> How do I increase this timeout value?
> Olav
>|||The timeout in that dialog is set to 0 and still the query times out in 30
seconds.
Olav
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
> Olav,
> Follow the menu path:
> Tools
> Options
> Then in the popup box:
> Query Execution
> SQL Server
> General
> Set Execution Timeout to 0
> RLS
> "Olav" <x@.y.com> wrote in message
> news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
>|||"Olav" <x@.y.com> wrote in message
news:eodLwsLnHHA.3968@.TK2MSFTNGP06.phx.gbl...
> The timeout in that dialog is set to 0 and still the query times out in 30
> seconds.
I believe it's timing out because some other process is blocking it. Not
because the query itself is taking too long.
Find out what's blocking it and fix that.
> Olav
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Olav,
Greg could be right, but I would not expect a block to cause a timeout
unless the connection timeout period was exceeded. There is no limit to how
long a block can be held, just a limit to how long you are willing to wait
for it.
Could you check your server to see if the "query wait" option is configured
to something other than -1?
RLF
"Olav" <x@.y.com> wrote in message
news:eodLwsLnHHA.3968@.TK2MSFTNGP06.phx.gbl...
> The timeout in that dialog is set to 0 and still the query times out in 30
> seconds.
> Olav
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
>sql
SQL Server 2005 Management Studio, but the query times out after 30 seconds.
How do I increase this timeout value?
OlavOlav,
Follow the menu path:
Tools
Options
Then in the popup box:
Query Execution
SQL Server
General
Set Execution Timeout to 0
RLS
"Olav" <x@.y.com> wrote in message
news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
> I'm trying to execute a "DELETE FROM table" command from a query window in
> SQL Server 2005 Management Studio, but the query times out after 30
> seconds.
> How do I increase this timeout value?
> Olav
>|||The timeout in that dialog is set to 0 and still the query times out in 30
seconds.
Olav
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
> Olav,
> Follow the menu path:
> Tools
> Options
> Then in the popup box:
> Query Execution
> SQL Server
> General
> Set Execution Timeout to 0
> RLS
> "Olav" <x@.y.com> wrote in message
> news:%23rf%23mTLnHHA.4848@.TK2MSFTNGP05.phx.gbl...
>|||"Olav" <x@.y.com> wrote in message
news:eodLwsLnHHA.3968@.TK2MSFTNGP06.phx.gbl...
> The timeout in that dialog is set to 0 and still the query times out in 30
> seconds.
I believe it's timing out because some other process is blocking it. Not
because the query itself is taking too long.
Find out what's blocking it and fix that.
> Olav
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Olav,
Greg could be right, but I would not expect a block to cause a timeout
unless the connection timeout period was exceeded. There is no limit to how
long a block can be held, just a limit to how long you are willing to wait
for it.
Could you check your server to see if the "query wait" option is configured
to something other than -1?
RLF
"Olav" <x@.y.com> wrote in message
news:eodLwsLnHHA.3968@.TK2MSFTNGP06.phx.gbl...
> The timeout in that dialog is set to 0 and still the query times out in 30
> seconds.
> Olav
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:OTsNMkLnHHA.5068@.TK2MSFTNGP05.phx.gbl...
>sql
How to increase the SQL Server memory
We are using SQL server 7.0, our users use to connect to SQL server remotely using Visual Basic Application. When all the users are connected it keeps on increasing the memory utilization and at 1,836,848 KB memory utilization it stops increasing the memory i.e memory utilization become stangnet. The actual amount of physical Memory is around 5GB but SQL server dont increase it after the treshhold level and the performance of the server get affected badly. Any one please suggest me the possible solution.In Enterprise Manager,
- right click on the server name and choose properties.
- choose memory tab
You should be able to set your min/max memory settings there. Also look into worker threads (on the processor tab).
Something else to think about,
How big is the DB (Gigs) ? How big are the tables being referenced? Perhaps something could be re-designed to make things more efficient. Are there a lot of table scans where you could have indexes, etc..?
Also,
Open the performance moniter and check the sql counters..
More info at -> http://www.sql-server-performance.com/performance_monitor_tips.asp|||It looks like you're running Standard Edition of SQL2K, which will not recognize any more memory, period! You need to upgrade to Enterprise and then you'll have more options:
1. /3GB in boot.ini will allow SQL Server to use more than the default 2GB
2. /PAE in boot.ini and enabling AWE on SQL Server will give SQL service whatever amount you specify.
- right click on the server name and choose properties.
- choose memory tab
You should be able to set your min/max memory settings there. Also look into worker threads (on the processor tab).
Something else to think about,
How big is the DB (Gigs) ? How big are the tables being referenced? Perhaps something could be re-designed to make things more efficient. Are there a lot of table scans where you could have indexes, etc..?
Also,
Open the performance moniter and check the sql counters..
More info at -> http://www.sql-server-performance.com/performance_monitor_tips.asp|||It looks like you're running Standard Edition of SQL2K, which will not recognize any more memory, period! You need to upgrade to Enterprise and then you'll have more options:
1. /3GB in boot.ini will allow SQL Server to use more than the default 2GB
2. /PAE in boot.ini and enabling AWE on SQL Server will give SQL service whatever amount you specify.
How to Increase the number of Seats and Processors after Installation.
Hi,
While installing SQL Server(2000) we will be asked to give the info
regarding
the Number of Seats(per seat) and Processors(per processor). If there
are more
licenses bought after the installation how to increase these values or
configure
the server to accept more clients/users?
thanx
Hi,
We can increase the count; but we can not change directly the licensing mode
ie; from Per seat to Per processor or vice versa.
Increase the license count using "Control Panel -- SQL Serevr Licensiong
OPTIONS...
THanks
Hari
SQL Server MVP
"sasiraj" <vardhansasi@.gmail.com> wrote in message
news:1130432522.930497.324510@.g14g2000cwa.googlegr oups.com...
> Hi,
> While installing SQL Server(2000) we will be asked to give the info
> regarding
> the Number of Seats(per seat) and Processors(per processor). If there
> are more
> licenses bought after the installation how to increase these values or
> configure
> the server to accept more clients/users?
> thanx
>
While installing SQL Server(2000) we will be asked to give the info
regarding
the Number of Seats(per seat) and Processors(per processor). If there
are more
licenses bought after the installation how to increase these values or
configure
the server to accept more clients/users?
thanx
Hi,
We can increase the count; but we can not change directly the licensing mode
ie; from Per seat to Per processor or vice versa.
Increase the license count using "Control Panel -- SQL Serevr Licensiong
OPTIONS...
THanks
Hari
SQL Server MVP
"sasiraj" <vardhansasi@.gmail.com> wrote in message
news:1130432522.930497.324510@.g14g2000cwa.googlegr oups.com...
> Hi,
> While installing SQL Server(2000) we will be asked to give the info
> regarding
> the Number of Seats(per seat) and Processors(per processor). If there
> are more
> licenses bought after the installation how to increase these values or
> configure
> the server to accept more clients/users?
> thanx
>
How to Increase the number of Seats and Processors after Installation.
Hi,
While installing SQL Server(2000) we will be asked to give the info
regarding
the Number of Seats(per seat) and Processors(per processor). If there
are more
licenses bought after the installation how to increase these values or
configure
the server to accept more clients/users?
thanxHi,
We can increase the count; but we can not change directly the licensing mode
ie; from Per seat to Per processor or vice versa.
Increase the license count using "Control Panel -- SQL Serevr Licensiong
OPTIONS...
THanks
Hari
SQL Server MVP
"sasiraj" <vardhansasi@.gmail.com> wrote in message
news:1130432522.930497.324510@.g14g2000cwa.googlegroups.com...
> Hi,
> While installing SQL Server(2000) we will be asked to give the info
> regarding
> the Number of Seats(per seat) and Processors(per processor). If there
> are more
> licenses bought after the installation how to increase these values or
> configure
> the server to accept more clients/users?
> thanx
>
While installing SQL Server(2000) we will be asked to give the info
regarding
the Number of Seats(per seat) and Processors(per processor). If there
are more
licenses bought after the installation how to increase these values or
configure
the server to accept more clients/users?
thanxHi,
We can increase the count; but we can not change directly the licensing mode
ie; from Per seat to Per processor or vice versa.
Increase the license count using "Control Panel -- SQL Serevr Licensiong
OPTIONS...
THanks
Hari
SQL Server MVP
"sasiraj" <vardhansasi@.gmail.com> wrote in message
news:1130432522.930497.324510@.g14g2000cwa.googlegroups.com...
> Hi,
> While installing SQL Server(2000) we will be asked to give the info
> regarding
> the Number of Seats(per seat) and Processors(per processor). If there
> are more
> licenses bought after the installation how to increase these values or
> configure
> the server to accept more clients/users?
> thanx
>
How to Increase the number of Seats and Processors after Installation.
Hi,
While installing SQL Server(2000) we will be asked to give the info
regarding
the Number of Seats(per seat) and Processors(per processor). If there
are more
licenses bought after the installation how to increase these values or
configure
the server to accept more clients/users?
thanxHi,
We can increase the count; but we can not change directly the licensing mode
ie; from Per seat to Per processor or vice versa.
Increase the license count using "Control Panel -- SQL Serevr Licensiong
OPTIONS...
THanks
Hari
SQL Server MVP
"sasiraj" <vardhansasi@.gmail.com> wrote in message
news:1130432522.930497.324510@.g14g2000cwa.googlegroups.com...
> Hi,
> While installing SQL Server(2000) we will be asked to give the info
> regarding
> the Number of Seats(per seat) and Processors(per processor). If there
> are more
> licenses bought after the installation how to increase these values or
> configure
> the server to accept more clients/users?
> thanx
>
While installing SQL Server(2000) we will be asked to give the info
regarding
the Number of Seats(per seat) and Processors(per processor). If there
are more
licenses bought after the installation how to increase these values or
configure
the server to accept more clients/users?
thanxHi,
We can increase the count; but we can not change directly the licensing mode
ie; from Per seat to Per processor or vice versa.
Increase the license count using "Control Panel -- SQL Serevr Licensiong
OPTIONS...
THanks
Hari
SQL Server MVP
"sasiraj" <vardhansasi@.gmail.com> wrote in message
news:1130432522.930497.324510@.g14g2000cwa.googlegroups.com...
> Hi,
> While installing SQL Server(2000) we will be asked to give the info
> regarding
> the Number of Seats(per seat) and Processors(per processor). If there
> are more
> licenses bought after the installation how to increase these values or
> configure
> the server to accept more clients/users?
> thanx
>
How to increase the number of allowed queries?
Hi there,
our SQL server 2000 running on Windows 2000 server is optimised for 8
queries, how can I increase the number of simultaneous queries?
Thanks
Nico
sp_configure 'user connections', 0
go
reconfigure
go
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico
|||Seems you are running either MSDE (Desktop Engine) or Personal Editions. These are constrained to 8
concurrent queries, since they are basically free software. If you want to get rid of the
constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edition.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico
|||Thanks for the answer
I'll go check in the help file what it does.
"Adam Machanic" wrote:
> sp_configure 'user connections', 0
> go
> reconfigure
> go
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
>
>
|||Maybe I didn't write the right questions, here it is again
I get a message in the event viewer saying that the SQL server was optimized
for 8 queries and that there was 10 queries more.
How can I optimize the server for more queries?
Thanks
"Nico" wrote:
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico
|||See my other reply. You need to buy and install "a proper" SQL Server to get rid of this performance
throttling.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:84290A0D-D078-4892-81F8-CB8F96E8D345@.microsoft.com...[vbcol=seagreen]
> Maybe I didn't write the right questions, here it is again
> I get a message in the event viewer saying that the SQL server was optimized
> for 8 queries and that there was 10 queries more.
> How can I optimize the server for more queries?
> Thanks
> "Nico" wrote:
|||ok thanks. You are right, the server is installed with the personnal edition.
We have the standard edition, I should reinstall it with the standard edition.
Is there anything I should do before uninstalling the personnal edition et
reinstalling with the Standard edition?
Thank you
"Tibor Karaszi" wrote:
> Seems you are running either MSDE (Desktop Engine) or Personal Editions. These are constrained to 8
> concurrent queries, since they are basically free software. If you want to get rid of the
> constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edition.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
>
|||If you don't need to save anything in the system databases, it is easy:
Backup all user databases. Stop SQL Server and also save the database files (safety measure). Remove
SQL Server. Install SE. Restore the user databases.
If you want to retain the stuff in the system databases, it is more complex. Some of below links
should help you:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:C3C00883-884D-498A-995B-4CC38495C880@.microsoft.com...[vbcol=seagreen]
> ok thanks. You are right, the server is installed with the personnal edition.
> We have the standard edition, I should reinstall it with the standard edition.
> Is there anything I should do before uninstalling the personnal edition et
> reinstalling with the Standard edition?
> Thank you
> "Tibor Karaszi" wrote:
|||Thank you
"Tibor Karaszi" wrote:
> If you don't need to save anything in the system databases, it is easy:
> Backup all user databases. Stop SQL Server and also save the database files (safety measure). Remove
> SQL Server. Install SE. Restore the user databases.
> If you want to retain the stuff in the system databases, it is more complex. Some of below links
> should help you:
> Moving SQL Server Databases
> http://www.support.microsoft.com/?id=224071
> Moving Databases between Servers
> http://www.support.microsoft.com/?id=314546
> Using WITH MOVE in a Restore to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465
> How To Transfer Logins and Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=246133
> Mapping Logins & SIDs after a Restore
> http://www.support.microsoft.com/?id=298897
> Utility to map users to the correct login
> http://www.dbmaint.com/SyncSqlLogins.asp
> How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
> http://www.support.microsoft.com/?id=240872
> User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
> Disaster Recovery Articles for SQL Server
> http://www.support.microsoft.com/?id=307775
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:C3C00883-884D-498A-995B-4CC38495C880@.microsoft.com...
>
sql
our SQL server 2000 running on Windows 2000 server is optimised for 8
queries, how can I increase the number of simultaneous queries?
Thanks
Nico
sp_configure 'user connections', 0
go
reconfigure
go
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico
|||Seems you are running either MSDE (Desktop Engine) or Personal Editions. These are constrained to 8
concurrent queries, since they are basically free software. If you want to get rid of the
constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edition.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico
|||Thanks for the answer
I'll go check in the help file what it does.
"Adam Machanic" wrote:
> sp_configure 'user connections', 0
> go
> reconfigure
> go
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
>
>
|||Maybe I didn't write the right questions, here it is again
I get a message in the event viewer saying that the SQL server was optimized
for 8 queries and that there was 10 queries more.
How can I optimize the server for more queries?
Thanks
"Nico" wrote:
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico
|||See my other reply. You need to buy and install "a proper" SQL Server to get rid of this performance
throttling.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:84290A0D-D078-4892-81F8-CB8F96E8D345@.microsoft.com...[vbcol=seagreen]
> Maybe I didn't write the right questions, here it is again
> I get a message in the event viewer saying that the SQL server was optimized
> for 8 queries and that there was 10 queries more.
> How can I optimize the server for more queries?
> Thanks
> "Nico" wrote:
|||ok thanks. You are right, the server is installed with the personnal edition.
We have the standard edition, I should reinstall it with the standard edition.
Is there anything I should do before uninstalling the personnal edition et
reinstalling with the Standard edition?
Thank you
"Tibor Karaszi" wrote:
> Seems you are running either MSDE (Desktop Engine) or Personal Editions. These are constrained to 8
> concurrent queries, since they are basically free software. If you want to get rid of the
> constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edition.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
>
|||If you don't need to save anything in the system databases, it is easy:
Backup all user databases. Stop SQL Server and also save the database files (safety measure). Remove
SQL Server. Install SE. Restore the user databases.
If you want to retain the stuff in the system databases, it is more complex. Some of below links
should help you:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:C3C00883-884D-498A-995B-4CC38495C880@.microsoft.com...[vbcol=seagreen]
> ok thanks. You are right, the server is installed with the personnal edition.
> We have the standard edition, I should reinstall it with the standard edition.
> Is there anything I should do before uninstalling the personnal edition et
> reinstalling with the Standard edition?
> Thank you
> "Tibor Karaszi" wrote:
|||Thank you
"Tibor Karaszi" wrote:
> If you don't need to save anything in the system databases, it is easy:
> Backup all user databases. Stop SQL Server and also save the database files (safety measure). Remove
> SQL Server. Install SE. Restore the user databases.
> If you want to retain the stuff in the system databases, it is more complex. Some of below links
> should help you:
> Moving SQL Server Databases
> http://www.support.microsoft.com/?id=224071
> Moving Databases between Servers
> http://www.support.microsoft.com/?id=314546
> Using WITH MOVE in a Restore to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465
> How To Transfer Logins and Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=246133
> Mapping Logins & SIDs after a Restore
> http://www.support.microsoft.com/?id=298897
> Utility to map users to the correct login
> http://www.dbmaint.com/SyncSqlLogins.asp
> How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
> http://www.support.microsoft.com/?id=240872
> User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
> Disaster Recovery Articles for SQL Server
> http://www.support.microsoft.com/?id=307775
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:C3C00883-884D-498A-995B-4CC38495C880@.microsoft.com...
>
sql
How to increase the number of allowed queries?
Hi there,
our SQL server 2000 running on Windows 2000 server is optimised for 8
queries, how can I increase the number of simultaneous queries?
Thanks
Nicosp_configure 'user connections', 0
go
reconfigure
go
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico|||Seems you are running either MSDE (Desktop Engine) or Personal Editions. The
se are constrained to 8
concurrent queries, since they are basically free software. If you want to g
et rid of the
constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edi
tion.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico|||Thanks for the answer
I'll go check in the help file what it does.
"Adam Machanic" wrote:
> sp_configure 'user connections', 0
> go
> reconfigure
> go
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
>
>|||Maybe I didn't write the right questions, here it is again
I get a message in the event viewer saying that the SQL server was optimized
for 8 queries and that there was 10 queries more.
How can I optimize the server for more queries?
Thanks
"Nico" wrote:
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico|||See my other reply. You need to buy and install "a proper" SQL Server to get
rid of this performance
throttling.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:84290A0D-D078-4892-81F8-CB8F96E8D345@.microsoft.com...[vbcol=seagreen]
> Maybe I didn't write the right questions, here it is again
> I get a message in the event viewer saying that the SQL server was optimiz
ed
> for 8 queries and that there was 10 queries more.
> How can I optimize the server for more queries?
> Thanks
> "Nico" wrote:
>|||ok thanks. You are right, the server is installed with the personnal edition
.
We have the standard edition, I should reinstall it with the standard editio
n.
Is there anything I should do before uninstalling the personnal edition et
reinstalling with the Standard edition?
Thank you
"Tibor Karaszi" wrote:
> Seems you are running either MSDE (Desktop Engine) or Personal Editions. T
hese are constrained to 8
> concurrent queries, since they are basically free software. If you want to
get rid of the
> constraint, buy either Workgroup Edition, Standard Edition or Enterprise E
dition.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
>|||If you don't need to save anything in the system databases, it is easy:
Backup all user databases. Stop SQL Server and also save the database files
(safety measure). Remove
SQL Server. Install SE. Restore the user databases.
If you want to retain the stuff in the system databases, it is more complex.
Some of below links
should help you:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Server
s
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:C3C00883-884D-498A-995B-4CC38495C880@.microsoft.com...[vbcol=seagreen]
> ok thanks. You are right, the server is installed with the personnal editi
on.
> We have the standard edition, I should reinstall it with the standard edit
ion.
> Is there anything I should do before uninstalling the personnal edition et
> reinstalling with the Standard edition?
> Thank you
> "Tibor Karaszi" wrote:
>|||Thank you
"Tibor Karaszi" wrote:
> If you don't need to save anything in the system databases, it is easy:
> Backup all user databases. Stop SQL Server and also save the database file
s (safety measure). Remove
> SQL Server. Install SE. Restore the user databases.
> If you want to retain the stuff in the system databases, it is more comple
x. Some of below links
> should help you:
> Moving SQL Server Databases
> http://www.support.microsoft.com/?id=224071
> Moving Databases between Servers
> http://www.support.microsoft.com/?id=314546
> Using WITH MOVE in a Restore to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465
> How To Transfer Logins and Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=246133
> Mapping Logins & SIDs after a Restore
> http://www.support.microsoft.com/?id=298897
> Utility to map users to the correct login
> http://www.dbmaint.com/SyncSqlLogins.asp
> How to Resolve Permission Issues When a Database Is Moved Between SQL Serv
ers
> http://www.support.microsoft.com/?id=240872
> User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
> Disaster Recovery Articles for SQL Server
> http://www.support.microsoft.com/?id=307775
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:C3C00883-884D-498A-995B-4CC38495C880@.microsoft.com...
>
our SQL server 2000 running on Windows 2000 server is optimised for 8
queries, how can I increase the number of simultaneous queries?
Thanks
Nicosp_configure 'user connections', 0
go
reconfigure
go
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico|||Seems you are running either MSDE (Desktop Engine) or Personal Editions. The
se are constrained to 8
concurrent queries, since they are basically free software. If you want to g
et rid of the
constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edi
tion.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico|||Thanks for the answer
I'll go check in the help file what it does.
"Adam Machanic" wrote:
> sp_configure 'user connections', 0
> go
> reconfigure
> go
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
>
>|||Maybe I didn't write the right questions, here it is again
I get a message in the event viewer saying that the SQL server was optimized
for 8 queries and that there was 10 queries more.
How can I optimize the server for more queries?
Thanks
"Nico" wrote:
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico|||See my other reply. You need to buy and install "a proper" SQL Server to get
rid of this performance
throttling.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:84290A0D-D078-4892-81F8-CB8F96E8D345@.microsoft.com...[vbcol=seagreen]
> Maybe I didn't write the right questions, here it is again
> I get a message in the event viewer saying that the SQL server was optimiz
ed
> for 8 queries and that there was 10 queries more.
> How can I optimize the server for more queries?
> Thanks
> "Nico" wrote:
>|||ok thanks. You are right, the server is installed with the personnal edition
.
We have the standard edition, I should reinstall it with the standard editio
n.
Is there anything I should do before uninstalling the personnal edition et
reinstalling with the Standard edition?
Thank you
"Tibor Karaszi" wrote:
> Seems you are running either MSDE (Desktop Engine) or Personal Editions. T
hese are constrained to 8
> concurrent queries, since they are basically free software. If you want to
get rid of the
> constraint, buy either Workgroup Edition, Standard Edition or Enterprise E
dition.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
>|||If you don't need to save anything in the system databases, it is easy:
Backup all user databases. Stop SQL Server and also save the database files
(safety measure). Remove
SQL Server. Install SE. Restore the user databases.
If you want to retain the stuff in the system databases, it is more complex.
Some of below links
should help you:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Server
s
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:C3C00883-884D-498A-995B-4CC38495C880@.microsoft.com...[vbcol=seagreen]
> ok thanks. You are right, the server is installed with the personnal editi
on.
> We have the standard edition, I should reinstall it with the standard edit
ion.
> Is there anything I should do before uninstalling the personnal edition et
> reinstalling with the Standard edition?
> Thank you
> "Tibor Karaszi" wrote:
>|||Thank you
"Tibor Karaszi" wrote:
> If you don't need to save anything in the system databases, it is easy:
> Backup all user databases. Stop SQL Server and also save the database file
s (safety measure). Remove
> SQL Server. Install SE. Restore the user databases.
> If you want to retain the stuff in the system databases, it is more comple
x. Some of below links
> should help you:
> Moving SQL Server Databases
> http://www.support.microsoft.com/?id=224071
> Moving Databases between Servers
> http://www.support.microsoft.com/?id=314546
> Using WITH MOVE in a Restore to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465
> How To Transfer Logins and Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=246133
> Mapping Logins & SIDs after a Restore
> http://www.support.microsoft.com/?id=298897
> Utility to map users to the correct login
> http://www.dbmaint.com/SyncSqlLogins.asp
> How to Resolve Permission Issues When a Database Is Moved Between SQL Serv
ers
> http://www.support.microsoft.com/?id=240872
> User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
> Disaster Recovery Articles for SQL Server
> http://www.support.microsoft.com/?id=307775
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:C3C00883-884D-498A-995B-4CC38495C880@.microsoft.com...
>
How to increase the number of allowed queries?
Hi there,
our SQL server 2000 running on Windows 2000 server is optimised for 8
queries, how can I increase the number of simultaneous queries?
Thanks
Nicosp_configure 'user connections', 0
go
reconfigure
go
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico|||Seems you are running either MSDE (Desktop Engine) or Personal Editions. These are constrained to 8
concurrent queries, since they are basically free software. If you want to get rid of the
constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edition.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico|||Thanks for the answer
I'll go check in the help file what it does.
"Adam Machanic" wrote:
> sp_configure 'user connections', 0
> go
> reconfigure
> go
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> > Hi there,
> > our SQL server 2000 running on Windows 2000 server is optimised for 8
> > queries, how can I increase the number of simultaneous queries?
> >
> > Thanks
> > Nico
>
>|||Maybe I didn't write the right questions, here it is again
I get a message in the event viewer saying that the SQL server was optimized
for 8 queries and that there was 10 queries more.
How can I optimize the server for more queries?
Thanks
"Nico" wrote:
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico|||See my other reply. You need to buy and install "a proper" SQL Server to get rid of this performance
throttling.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:84290A0D-D078-4892-81F8-CB8F96E8D345@.microsoft.com...
> Maybe I didn't write the right questions, here it is again
> I get a message in the event viewer saying that the SQL server was optimized
> for 8 queries and that there was 10 queries more.
> How can I optimize the server for more queries?
> Thanks
> "Nico" wrote:
>> Hi there,
>> our SQL server 2000 running on Windows 2000 server is optimised for 8
>> queries, how can I increase the number of simultaneous queries?
>> Thanks
>> Nico|||ok thanks. You are right, the server is installed with the personnal edition.
We have the standard edition, I should reinstall it with the standard edition.
Is there anything I should do before uninstalling the personnal edition et
reinstalling with the Standard edition?
Thank you
"Tibor Karaszi" wrote:
> Seems you are running either MSDE (Desktop Engine) or Personal Editions. These are constrained to 8
> concurrent queries, since they are basically free software. If you want to get rid of the
> constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edition.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> > Hi there,
> > our SQL server 2000 running on Windows 2000 server is optimised for 8
> > queries, how can I increase the number of simultaneous queries?
> >
> > Thanks
> > Nico
>|||If you don't need to save anything in the system databases, it is easy:
Backup all user databases. Stop SQL Server and also save the database files (safety measure). Remove
SQL Server. Install SE. Restore the user databases.
If you want to retain the stuff in the system databases, it is more complex. Some of below links
should help you:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:C3C00883-884D-498A-995B-4CC38495C880@.microsoft.com...
> ok thanks. You are right, the server is installed with the personnal edition.
> We have the standard edition, I should reinstall it with the standard edition.
> Is there anything I should do before uninstalling the personnal edition et
> reinstalling with the Standard edition?
> Thank you
> "Tibor Karaszi" wrote:
>> Seems you are running either MSDE (Desktop Engine) or Personal Editions. These are constrained to
>> 8
>> concurrent queries, since they are basically free software. If you want to get rid of the
>> constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edition.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Nico" <Nico@.discussions.microsoft.com> wrote in message
>> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
>> > Hi there,
>> > our SQL server 2000 running on Windows 2000 server is optimised for 8
>> > queries, how can I increase the number of simultaneous queries?
>> >
>> > Thanks
>> > Nico
>>|||Thank you
"Tibor Karaszi" wrote:
> If you don't need to save anything in the system databases, it is easy:
> Backup all user databases. Stop SQL Server and also save the database files (safety measure). Remove
> SQL Server. Install SE. Restore the user databases.
> If you want to retain the stuff in the system databases, it is more complex. Some of below links
> should help you:
> Moving SQL Server Databases
> http://www.support.microsoft.com/?id=224071
> Moving Databases between Servers
> http://www.support.microsoft.com/?id=314546
> Using WITH MOVE in a Restore to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465
> How To Transfer Logins and Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=246133
> Mapping Logins & SIDs after a Restore
> http://www.support.microsoft.com/?id=298897
> Utility to map users to the correct login
> http://www.dbmaint.com/SyncSqlLogins.asp
> How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
> http://www.support.microsoft.com/?id=240872
> User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
> Disaster Recovery Articles for SQL Server
> http://www.support.microsoft.com/?id=307775
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:C3C00883-884D-498A-995B-4CC38495C880@.microsoft.com...
> > ok thanks. You are right, the server is installed with the personnal edition.
> > We have the standard edition, I should reinstall it with the standard edition.
> >
> > Is there anything I should do before uninstalling the personnal edition et
> > reinstalling with the Standard edition?
> >
> > Thank you
> >
> > "Tibor Karaszi" wrote:
> >
> >> Seems you are running either MSDE (Desktop Engine) or Personal Editions. These are constrained to
> >> 8
> >> concurrent queries, since they are basically free software. If you want to get rid of the
> >> constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edition.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> >> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> >> > Hi there,
> >> > our SQL server 2000 running on Windows 2000 server is optimised for 8
> >> > queries, how can I increase the number of simultaneous queries?
> >> >
> >> > Thanks
> >> > Nico
> >>
> >>
>
our SQL server 2000 running on Windows 2000 server is optimised for 8
queries, how can I increase the number of simultaneous queries?
Thanks
Nicosp_configure 'user connections', 0
go
reconfigure
go
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico|||Seems you are running either MSDE (Desktop Engine) or Personal Editions. These are constrained to 8
concurrent queries, since they are basically free software. If you want to get rid of the
constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edition.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico|||Thanks for the answer
I'll go check in the help file what it does.
"Adam Machanic" wrote:
> sp_configure 'user connections', 0
> go
> reconfigure
> go
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> > Hi there,
> > our SQL server 2000 running on Windows 2000 server is optimised for 8
> > queries, how can I increase the number of simultaneous queries?
> >
> > Thanks
> > Nico
>
>|||Maybe I didn't write the right questions, here it is again
I get a message in the event viewer saying that the SQL server was optimized
for 8 queries and that there was 10 queries more.
How can I optimize the server for more queries?
Thanks
"Nico" wrote:
> Hi there,
> our SQL server 2000 running on Windows 2000 server is optimised for 8
> queries, how can I increase the number of simultaneous queries?
> Thanks
> Nico|||See my other reply. You need to buy and install "a proper" SQL Server to get rid of this performance
throttling.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:84290A0D-D078-4892-81F8-CB8F96E8D345@.microsoft.com...
> Maybe I didn't write the right questions, here it is again
> I get a message in the event viewer saying that the SQL server was optimized
> for 8 queries and that there was 10 queries more.
> How can I optimize the server for more queries?
> Thanks
> "Nico" wrote:
>> Hi there,
>> our SQL server 2000 running on Windows 2000 server is optimised for 8
>> queries, how can I increase the number of simultaneous queries?
>> Thanks
>> Nico|||ok thanks. You are right, the server is installed with the personnal edition.
We have the standard edition, I should reinstall it with the standard edition.
Is there anything I should do before uninstalling the personnal edition et
reinstalling with the Standard edition?
Thank you
"Tibor Karaszi" wrote:
> Seems you are running either MSDE (Desktop Engine) or Personal Editions. These are constrained to 8
> concurrent queries, since they are basically free software. If you want to get rid of the
> constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edition.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> > Hi there,
> > our SQL server 2000 running on Windows 2000 server is optimised for 8
> > queries, how can I increase the number of simultaneous queries?
> >
> > Thanks
> > Nico
>|||If you don't need to save anything in the system databases, it is easy:
Backup all user databases. Stop SQL Server and also save the database files (safety measure). Remove
SQL Server. Install SE. Restore the user databases.
If you want to retain the stuff in the system databases, it is more complex. Some of below links
should help you:
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nico" <Nico@.discussions.microsoft.com> wrote in message
news:C3C00883-884D-498A-995B-4CC38495C880@.microsoft.com...
> ok thanks. You are right, the server is installed with the personnal edition.
> We have the standard edition, I should reinstall it with the standard edition.
> Is there anything I should do before uninstalling the personnal edition et
> reinstalling with the Standard edition?
> Thank you
> "Tibor Karaszi" wrote:
>> Seems you are running either MSDE (Desktop Engine) or Personal Editions. These are constrained to
>> 8
>> concurrent queries, since they are basically free software. If you want to get rid of the
>> constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edition.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Nico" <Nico@.discussions.microsoft.com> wrote in message
>> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
>> > Hi there,
>> > our SQL server 2000 running on Windows 2000 server is optimised for 8
>> > queries, how can I increase the number of simultaneous queries?
>> >
>> > Thanks
>> > Nico
>>|||Thank you
"Tibor Karaszi" wrote:
> If you don't need to save anything in the system databases, it is easy:
> Backup all user databases. Stop SQL Server and also save the database files (safety measure). Remove
> SQL Server. Install SE. Restore the user databases.
> If you want to retain the stuff in the system databases, it is more complex. Some of below links
> should help you:
> Moving SQL Server Databases
> http://www.support.microsoft.com/?id=224071
> Moving Databases between Servers
> http://www.support.microsoft.com/?id=314546
> Using WITH MOVE in a Restore to a New Location with Detach/Attach
> http://support.microsoft.com/?id=221465
> How To Transfer Logins and Passwords Between SQL Servers
> http://www.support.microsoft.com/?id=246133
> Mapping Logins & SIDs after a Restore
> http://www.support.microsoft.com/?id=298897
> Utility to map users to the correct login
> http://www.dbmaint.com/SyncSqlLogins.asp
> How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
> http://www.support.microsoft.com/?id=240872
> User Logon and/or Permission Errors After Restoring Dump
> http://www.support.microsoft.com/?id=168001
> Disaster Recovery Articles for SQL Server
> http://www.support.microsoft.com/?id=307775
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> news:C3C00883-884D-498A-995B-4CC38495C880@.microsoft.com...
> > ok thanks. You are right, the server is installed with the personnal edition.
> > We have the standard edition, I should reinstall it with the standard edition.
> >
> > Is there anything I should do before uninstalling the personnal edition et
> > reinstalling with the Standard edition?
> >
> > Thank you
> >
> > "Tibor Karaszi" wrote:
> >
> >> Seems you are running either MSDE (Desktop Engine) or Personal Editions. These are constrained to
> >> 8
> >> concurrent queries, since they are basically free software. If you want to get rid of the
> >> constraint, buy either Workgroup Edition, Standard Edition or Enterprise Edition.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >>
> >>
> >> "Nico" <Nico@.discussions.microsoft.com> wrote in message
> >> news:BA32307B-D9DD-4FD5-92BB-DEC8DA03BDB1@.microsoft.com...
> >> > Hi there,
> >> > our SQL server 2000 running on Windows 2000 server is optimised for 8
> >> > queries, how can I increase the number of simultaneous queries?
> >> >
> >> > Thanks
> >> > Nico
> >>
> >>
>
How to Increase the Length of Drop Down Menu Parameters
Is there a way to make the drop down parameters longer so more than
5-6 lines show?
Thanks
BobOn Dec 21, 6:00 am, Bob <b...@.ebearings.com> wrote:
> Is there a way to make the drop down parameters longer so more than
> 5-6 lines show?
> Thanks
> Bob|||On Dec 21, 6:00 am, Bob <b...@.ebearings.com> wrote:
> Is there a way to make the drop down parameters longer so more than
> 5-6 lines show?
> Thanks
> Bob
As far as I know, this flexibility does not exist. If a custom ASP.NET
application is an option, you might consider creating one of those and
use one of the drop-down list/etc controls and then use the report
viewer control, the Reporting Services Web Service or URL access to
integrate the actual SSRS report. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
5-6 lines show?
Thanks
BobOn Dec 21, 6:00 am, Bob <b...@.ebearings.com> wrote:
> Is there a way to make the drop down parameters longer so more than
> 5-6 lines show?
> Thanks
> Bob|||On Dec 21, 6:00 am, Bob <b...@.ebearings.com> wrote:
> Is there a way to make the drop down parameters longer so more than
> 5-6 lines show?
> Thanks
> Bob
As far as I know, this flexibility does not exist. If a custom ASP.NET
application is an option, you might consider creating one of those and
use one of the drop-down list/etc controls and then use the report
viewer control, the Reporting Services Web Service or URL access to
integrate the actual SSRS report. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
How to increase the default row size in sql server 2000 only
Hi, Guys.
I am in bit trouble.I am importing the table from mysql to sql server which has having nearly 65000 records.
I starts the import of table by import/export utility.But when the records reaches 65000, the error message came.."THIS TABLE HAVING ROW SIZE 8190 WHICH IS EXCCEDING THE DEFAULT SIZE OF 8060".
So please let me know how to over come this problem..
I am in bit trouble.I am importing the table from mysql to sql server which has having nearly 65000 records.
I starts the import of table by import/export utility.But when the records reaches 65000, the error message came.."THIS TABLE HAVING ROW SIZE 8190 WHICH IS EXCCEDING THE DEFAULT SIZE OF 8060".
So please let me know how to over come this problem..
I CAN'T UPGRADE SQL SERVER SO GIVE SOLUTION FOR SQL SERVER 2000 ONLY...
Thanks in Advance to all of you.
pchadha20For my knowledge it isn't possible to change that limit. You should split your table or in some cases use Ntext-type but that would generate a lot of other troubles.
How to Increase the DB Size
hi,
I have one DB in SQL Server 2005.When I was creating it
takes 7813 MB.Now the databse size almost full.Now I want to extend the
DB Size.At my HDD has more space(near by 160 GB).But I don't know how to
extend the Size.More over I had one doubt.Am executing the
exec sp_helpdb command.It shows the Datafile maxsize is Unlimited.I want to
know when the data is full,whether it automatically takes the size from the
HDD or not.
Please Help me out to this Problem.
When it reaches the maximum capacity, it will be increased automatically. Check whether the Autogrowth enabled or not.sqlHow to increase the data file size?
Hi All,
Is it possible to increase the data file size in SQL Server 2005 Express edition?
If yes then how?
Thanks,
Varun
Hi Varun
If you have MSSQL Management Studio installed then from there select Database's properties > Files
There you can setup initial maximum size for Data and Log file.
Thanks,
how to increase tablespaces in Sql server
Can someone tell me how to increase tablespaces in SQL Server?
Is the syntax the same as Oracle? Is there a wizard in Enterprise Manager?
CheersThere is no concept of tablespaces in sql server...
well ok, if you consider creating separate file structures...then that would be close...
what are you trying to do?|||hiya
Yeh, I figured that (as in oracle you can increase the size of the tables),
The disk is 99% full (DB) and we are installing a new disk. We would like data to be written to the new disk (this is a temporary measurement until we upgrade the server) How do we set Map the data across?
Cheers|||Dump and Restore?|||The data for database files is written in parallel, while for log files sequencially.
Is the syntax the same as Oracle? Is there a wizard in Enterprise Manager?
CheersThere is no concept of tablespaces in sql server...
well ok, if you consider creating separate file structures...then that would be close...
what are you trying to do?|||hiya
Yeh, I figured that (as in oracle you can increase the size of the tables),
The disk is 99% full (DB) and we are installing a new disk. We would like data to be written to the new disk (this is a temporary measurement until we upgrade the server) How do we set Map the data across?
Cheers|||Dump and Restore?|||The data for database files is written in parallel, while for log files sequencially.
How to increase table size
Okay, I am actually having 2 problems. We have LANdesk and it uses SQL serve
r
2000 and the people in our desktop department are getting a message which
says:
The size of FixedDrives.Caption is too small. Increase its size by at
least 7.
How do you increase the size of this table.
Problem #2
This is a very recent implementation and I notice that the maintenance plan
will not backup the transaction log. It appears to backup the database ok.
But the transaction log never backs up and it is set to backup every 3 hours
.P#1 : SOund like a column rather than a table problem.
P#2 Did you choode to backup the TLog ? What does SQL Server Agent say ? Is
there a job for this ?
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
--
"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com>
schrieb im Newsbeitrag
news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
> server
> 2000 and the people in our desktop department are getting a message which
> says:
> The size of FixedDrives.Caption is too small. Increase its size by at
> least 7.
> How do you increase the size of this table.
> Problem #2
> This is a very recent implementation and I notice that the maintenance
> plan
> will not backup the transaction log. It appears to backup the database ok.
> But the transaction log never backs up and it is set to backup every 3
> hours.|||The error you're getting is from LANdesk, not SQL Server. I suggest you
contact their technical support to see what to do. You can't pre-allocate
space for tables in SQL Server, they automatically grow as you insert more
rows into them.
What recovery mode is the database in? If its simple recovery mode, taking a
log backup is a no-op.
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
in message news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
server
> 2000 and the people in our desktop department are getting a message which
> says:
> The size of FixedDrives.Caption is too small. Increase its size by at
> least 7.
> How do you increase the size of this table.
> Problem #2
> This is a very recent implementation and I notice that the maintenance
plan
> will not backup the transaction log. It appears to backup the database ok.
> But the transaction log never backs up and it is set to backup every 3
hours.|||ok, I'm by no means a SQL expert so I'm feeling my way through this and yes
you are rights captions is a column in the fixeddrives table. I right
clicked on the table and chose design table. The captions column data type i
s
char and the length is 60. If I increase it by 7 as the error asks and then
click save, I get a warning during the presave process which goes on to say:
Warning: One or more existing columns have ANSI_PADDING 'off' and will be
re-created with ANSI_PADDING 'on'.
I have no clue what to do from there.
As for the transaction log backup problem, a maintenance plan has been
created to backup the transaction log every 3 hours. It fails everytime. Her
e
are the results:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'SVRWEBG026' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'DB Maintenance Plan2' on 4/18/2005 1:25:00 PM
Backup can not be performed on database 'LDINV'. This sub task is ignored.
End of maintenance plan 'DB Maintenance Plan2' on 4/18/2005 1:25:00 PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
Any help will be greatly appreciated.
"Jens Sü?meyer" wrote:
> P#1 : SOund like a column rather than a table problem.
> P#2 Did you choode to backup the TLog ? What does SQL Server Agent say ? I
s
> there a job for this ?
> HTH, Jens SUessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com>
> schrieb im Newsbeitrag
> news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
>
>|||"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
in message news:32826F49-2FBF-48CE-9582-3EC1382455D9@.microsoft.com...
> ok, I'm by no means a SQL expert so I'm feeling my way through this and
> yes
> you are rights captions is a column in the fixeddrives table. I right
> clicked on the table and chose design table. The captions column data type
> is
> char and the length is 60. If I increase it by 7 as the error asks and
> then
> click save, I get a warning during the presave process which goes on to
> say:
You should contact LANDesk Tech Support. Going in and changing the
structure of a database for an application could break the application, or
at the very least, waste a lot of time and space with no positive results.
If their customers have encountered this problem before, they might have a
thoroughly tested fix or patch for the front-end software as well as the
database.|||So, if the database is in simple recovery mode you can not backup the
transaction logs? What can you do to tell what mode it is in? For that matte
r
what are the modes?
Again I'm not the SQL guy.
"Paul S Randal [MS]" wrote:
> The error you're getting is from LANdesk, not SQL Server. I suggest you
> contact their technical support to see what to do. You can't pre-allocate
> space for tables in SQL Server, they automatically grow as you insert more
> rows into them.
> What recovery mode is the database in? If its simple recovery mode, taking
a
> log backup is a no-op.
> Regards
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrot
e
> in message news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> server
> plan
> hours.
>
>
r
2000 and the people in our desktop department are getting a message which
says:
The size of FixedDrives.Caption is too small. Increase its size by at
least 7.
How do you increase the size of this table.
Problem #2
This is a very recent implementation and I notice that the maintenance plan
will not backup the transaction log. It appears to backup the database ok.
But the transaction log never backs up and it is set to backup every 3 hours
.P#1 : SOund like a column rather than a table problem.
P#2 Did you choode to backup the TLog ? What does SQL Server Agent say ? Is
there a job for this ?
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
--
"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com>
schrieb im Newsbeitrag
news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
> server
> 2000 and the people in our desktop department are getting a message which
> says:
> The size of FixedDrives.Caption is too small. Increase its size by at
> least 7.
> How do you increase the size of this table.
> Problem #2
> This is a very recent implementation and I notice that the maintenance
> plan
> will not backup the transaction log. It appears to backup the database ok.
> But the transaction log never backs up and it is set to backup every 3
> hours.|||The error you're getting is from LANdesk, not SQL Server. I suggest you
contact their technical support to see what to do. You can't pre-allocate
space for tables in SQL Server, they automatically grow as you insert more
rows into them.
What recovery mode is the database in? If its simple recovery mode, taking a
log backup is a no-op.
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
in message news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
server
> 2000 and the people in our desktop department are getting a message which
> says:
> The size of FixedDrives.Caption is too small. Increase its size by at
> least 7.
> How do you increase the size of this table.
> Problem #2
> This is a very recent implementation and I notice that the maintenance
plan
> will not backup the transaction log. It appears to backup the database ok.
> But the transaction log never backs up and it is set to backup every 3
hours.|||ok, I'm by no means a SQL expert so I'm feeling my way through this and yes
you are rights captions is a column in the fixeddrives table. I right
clicked on the table and chose design table. The captions column data type i
s
char and the length is 60. If I increase it by 7 as the error asks and then
click save, I get a warning during the presave process which goes on to say:
Warning: One or more existing columns have ANSI_PADDING 'off' and will be
re-created with ANSI_PADDING 'on'.
I have no clue what to do from there.
As for the transaction log backup problem, a maintenance plan has been
created to backup the transaction log every 3 hours. It fails everytime. Her
e
are the results:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'SVRWEBG026' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'DB Maintenance Plan2' on 4/18/2005 1:25:00 PM
Backup can not be performed on database 'LDINV'. This sub task is ignored.
End of maintenance plan 'DB Maintenance Plan2' on 4/18/2005 1:25:00 PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
Any help will be greatly appreciated.
"Jens Sü?meyer" wrote:
> P#1 : SOund like a column rather than a table problem.
> P#2 Did you choode to backup the TLog ? What does SQL Server Agent say ? I
s
> there a job for this ?
> HTH, Jens SUessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com>
> schrieb im Newsbeitrag
> news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
>
>|||"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
in message news:32826F49-2FBF-48CE-9582-3EC1382455D9@.microsoft.com...
> ok, I'm by no means a SQL expert so I'm feeling my way through this and
> yes
> you are rights captions is a column in the fixeddrives table. I right
> clicked on the table and chose design table. The captions column data type
> is
> char and the length is 60. If I increase it by 7 as the error asks and
> then
> click save, I get a warning during the presave process which goes on to
> say:
You should contact LANDesk Tech Support. Going in and changing the
structure of a database for an application could break the application, or
at the very least, waste a lot of time and space with no positive results.
If their customers have encountered this problem before, they might have a
thoroughly tested fix or patch for the front-end software as well as the
database.|||So, if the database is in simple recovery mode you can not backup the
transaction logs? What can you do to tell what mode it is in? For that matte
r
what are the modes?
Again I'm not the SQL guy.
"Paul S Randal [MS]" wrote:
> The error you're getting is from LANdesk, not SQL Server. I suggest you
> contact their technical support to see what to do. You can't pre-allocate
> space for tables in SQL Server, they automatically grow as you insert more
> rows into them.
> What recovery mode is the database in? If its simple recovery mode, taking
a
> log backup is a no-op.
> Regards
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrot
e
> in message news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> server
> plan
> hours.
>
>
How to increase table size
Okay, I am actually having 2 problems. We have LANdesk and it uses SQL server
2000 and the people in our desktop department are getting a message which
says:
The size of FixedDrives.Caption is too small. Increase its size by at
least 7.
How do you increase the size of this table.
Problem #2
This is a very recent implementation and I notice that the maintenance plan
will not backup the transaction log. It appears to backup the database ok.
But the transaction log never backs up and it is set to backup every 3 hours.P#1 : SOund like a column rather than a table problem.
P#2 Did you choode to backup the TLog ? What does SQL Server Agent say ? Is
there a job for this ?
HTH, Jens SUessmeyer.
--
http://www.sqlserver2005.de
--
"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com>
schrieb im Newsbeitrag
news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
> server
> 2000 and the people in our desktop department are getting a message which
> says:
> The size of FixedDrives.Caption is too small. Increase its size by at
> least 7.
> How do you increase the size of this table.
> Problem #2
> This is a very recent implementation and I notice that the maintenance
> plan
> will not backup the transaction log. It appears to backup the database ok.
> But the transaction log never backs up and it is set to backup every 3
> hours.|||The error you're getting is from LANdesk, not SQL Server. I suggest you
contact their technical support to see what to do. You can't pre-allocate
space for tables in SQL Server, they automatically grow as you insert more
rows into them.
What recovery mode is the database in? If its simple recovery mode, taking a
log backup is a no-op.
Regards
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
in message news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
server
> 2000 and the people in our desktop department are getting a message which
> says:
> The size of FixedDrives.Caption is too small. Increase its size by at
> least 7.
> How do you increase the size of this table.
> Problem #2
> This is a very recent implementation and I notice that the maintenance
plan
> will not backup the transaction log. It appears to backup the database ok.
> But the transaction log never backs up and it is set to backup every 3
hours.|||ok, I'm by no means a SQL expert so I'm feeling my way through this and yes
you are rights captions is a column in the fixeddrives table. I right
clicked on the table and chose design table. The captions column data type is
char and the length is 60. If I increase it by 7 as the error asks and then
click save, I get a warning during the presave process which goes on to say:
Warning: One or more existing columns have ANSI_PADDING 'off' and will be
re-created with ANSI_PADDING 'on'.
I have no clue what to do from there.
As for the transaction log backup problem, a maintenance plan has been
created to backup the transaction log every 3 hours. It fails everytime. Here
are the results:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'SVRWEBG026' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'DB Maintenance Plan2' on 4/18/2005 1:25:00 PM
Backup can not be performed on database 'LDINV'. This sub task is ignored.
End of maintenance plan 'DB Maintenance Plan2' on 4/18/2005 1:25:00 PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
Any help will be greatly appreciated.
"Jens Sü�meyer" wrote:
> P#1 : SOund like a column rather than a table problem.
> P#2 Did you choode to backup the TLog ? What does SQL Server Agent say ? Is
> there a job for this ?
> HTH, Jens SUessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com>
> schrieb im Newsbeitrag
> news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> > Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
> > server
> > 2000 and the people in our desktop department are getting a message which
> > says:
> >
> > The size of FixedDrives.Caption is too small. Increase its size by at
> > least 7.
> >
> > How do you increase the size of this table.
> >
> > Problem #2
> >
> > This is a very recent implementation and I notice that the maintenance
> > plan
> > will not backup the transaction log. It appears to backup the database ok.
> > But the transaction log never backs up and it is set to backup every 3
> > hours.
>
>|||"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
in message news:32826F49-2FBF-48CE-9582-3EC1382455D9@.microsoft.com...
> ok, I'm by no means a SQL expert so I'm feeling my way through this and
> yes
> you are rights captions is a column in the fixeddrives table. I right
> clicked on the table and chose design table. The captions column data type
> is
> char and the length is 60. If I increase it by 7 as the error asks and
> then
> click save, I get a warning during the presave process which goes on to
> say:
You should contact LANDesk Tech Support. Going in and changing the
structure of a database for an application could break the application, or
at the very least, waste a lot of time and space with no positive results.
If their customers have encountered this problem before, they might have a
thoroughly tested fix or patch for the front-end software as well as the
database.|||So, if the database is in simple recovery mode you can not backup the
transaction logs? What can you do to tell what mode it is in? For that matter
what are the modes?
Again I'm not the SQL guy.
"Paul S Randal [MS]" wrote:
> The error you're getting is from LANdesk, not SQL Server. I suggest you
> contact their technical support to see what to do. You can't pre-allocate
> space for tables in SQL Server, they automatically grow as you insert more
> rows into them.
> What recovery mode is the database in? If its simple recovery mode, taking a
> log backup is a no-op.
> Regards
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
> in message news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> > Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
> server
> > 2000 and the people in our desktop department are getting a message which
> > says:
> >
> > The size of FixedDrives.Caption is too small. Increase its size by at
> > least 7.
> >
> > How do you increase the size of this table.
> >
> > Problem #2
> >
> > This is a very recent implementation and I notice that the maintenance
> plan
> > will not backup the transaction log. It appears to backup the database ok.
> > But the transaction log never backs up and it is set to backup every 3
> hours.
>
>
2000 and the people in our desktop department are getting a message which
says:
The size of FixedDrives.Caption is too small. Increase its size by at
least 7.
How do you increase the size of this table.
Problem #2
This is a very recent implementation and I notice that the maintenance plan
will not backup the transaction log. It appears to backup the database ok.
But the transaction log never backs up and it is set to backup every 3 hours.P#1 : SOund like a column rather than a table problem.
P#2 Did you choode to backup the TLog ? What does SQL Server Agent say ? Is
there a job for this ?
HTH, Jens SUessmeyer.
--
http://www.sqlserver2005.de
--
"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com>
schrieb im Newsbeitrag
news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
> server
> 2000 and the people in our desktop department are getting a message which
> says:
> The size of FixedDrives.Caption is too small. Increase its size by at
> least 7.
> How do you increase the size of this table.
> Problem #2
> This is a very recent implementation and I notice that the maintenance
> plan
> will not backup the transaction log. It appears to backup the database ok.
> But the transaction log never backs up and it is set to backup every 3
> hours.|||The error you're getting is from LANdesk, not SQL Server. I suggest you
contact their technical support to see what to do. You can't pre-allocate
space for tables in SQL Server, they automatically grow as you insert more
rows into them.
What recovery mode is the database in? If its simple recovery mode, taking a
log backup is a no-op.
Regards
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
in message news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
server
> 2000 and the people in our desktop department are getting a message which
> says:
> The size of FixedDrives.Caption is too small. Increase its size by at
> least 7.
> How do you increase the size of this table.
> Problem #2
> This is a very recent implementation and I notice that the maintenance
plan
> will not backup the transaction log. It appears to backup the database ok.
> But the transaction log never backs up and it is set to backup every 3
hours.|||ok, I'm by no means a SQL expert so I'm feeling my way through this and yes
you are rights captions is a column in the fixeddrives table. I right
clicked on the table and chose design table. The captions column data type is
char and the length is 60. If I increase it by 7 as the error asks and then
click save, I get a warning during the presave process which goes on to say:
Warning: One or more existing columns have ANSI_PADDING 'off' and will be
re-created with ANSI_PADDING 'on'.
I have no clue what to do from there.
As for the transaction log backup problem, a maintenance plan has been
created to backup the transaction log every 3 hours. It fails everytime. Here
are the results:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'SVRWEBG026' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'DB Maintenance Plan2' on 4/18/2005 1:25:00 PM
Backup can not be performed on database 'LDINV'. This sub task is ignored.
End of maintenance plan 'DB Maintenance Plan2' on 4/18/2005 1:25:00 PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
Any help will be greatly appreciated.
"Jens Sü�meyer" wrote:
> P#1 : SOund like a column rather than a table problem.
> P#2 Did you choode to backup the TLog ? What does SQL Server Agent say ? Is
> there a job for this ?
> HTH, Jens SUessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com>
> schrieb im Newsbeitrag
> news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> > Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
> > server
> > 2000 and the people in our desktop department are getting a message which
> > says:
> >
> > The size of FixedDrives.Caption is too small. Increase its size by at
> > least 7.
> >
> > How do you increase the size of this table.
> >
> > Problem #2
> >
> > This is a very recent implementation and I notice that the maintenance
> > plan
> > will not backup the transaction log. It appears to backup the database ok.
> > But the transaction log never backs up and it is set to backup every 3
> > hours.
>
>|||"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
in message news:32826F49-2FBF-48CE-9582-3EC1382455D9@.microsoft.com...
> ok, I'm by no means a SQL expert so I'm feeling my way through this and
> yes
> you are rights captions is a column in the fixeddrives table. I right
> clicked on the table and chose design table. The captions column data type
> is
> char and the length is 60. If I increase it by 7 as the error asks and
> then
> click save, I get a warning during the presave process which goes on to
> say:
You should contact LANDesk Tech Support. Going in and changing the
structure of a database for an application could break the application, or
at the very least, waste a lot of time and space with no positive results.
If their customers have encountered this problem before, they might have a
thoroughly tested fix or patch for the front-end software as well as the
database.|||So, if the database is in simple recovery mode you can not backup the
transaction logs? What can you do to tell what mode it is in? For that matter
what are the modes?
Again I'm not the SQL guy.
"Paul S Randal [MS]" wrote:
> The error you're getting is from LANdesk, not SQL Server. I suggest you
> contact their technical support to see what to do. You can't pre-allocate
> space for tables in SQL Server, they automatically grow as you insert more
> rows into them.
> What recovery mode is the database in? If its simple recovery mode, taking a
> log backup is a no-op.
> Regards
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
> in message news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> > Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
> server
> > 2000 and the people in our desktop department are getting a message which
> > says:
> >
> > The size of FixedDrives.Caption is too small. Increase its size by at
> > least 7.
> >
> > How do you increase the size of this table.
> >
> > Problem #2
> >
> > This is a very recent implementation and I notice that the maintenance
> plan
> > will not backup the transaction log. It appears to backup the database ok.
> > But the transaction log never backs up and it is set to backup every 3
> hours.
>
>
How to increase table size
Okay, I am actually having 2 problems. We have LANdesk and it uses SQL server
2000 and the people in our desktop department are getting a message which
says:
The size of FixedDrives.Caption is too small. Increase its size by at
least 7.
How do you increase the size of this table.
Problem #2
This is a very recent implementation and I notice that the maintenance plan
will not backup the transaction log. It appears to backup the database ok.
But the transaction log never backs up and it is set to backup every 3 hours.
P#1 : SOund like a column rather than a table problem.
P#2 Did you choode to backup the TLog ? What does SQL Server Agent say ? Is
there a job for this ?
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com>
schrieb im Newsbeitrag
news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
> server
> 2000 and the people in our desktop department are getting a message which
> says:
> The size of FixedDrives.Caption is too small. Increase its size by at
> least 7.
> How do you increase the size of this table.
> Problem #2
> This is a very recent implementation and I notice that the maintenance
> plan
> will not backup the transaction log. It appears to backup the database ok.
> But the transaction log never backs up and it is set to backup every 3
> hours.
|||The error you're getting is from LANdesk, not SQL Server. I suggest you
contact their technical support to see what to do. You can't pre-allocate
space for tables in SQL Server, they automatically grow as you insert more
rows into them.
What recovery mode is the database in? If its simple recovery mode, taking a
log backup is a no-op.
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
in message news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
server
> 2000 and the people in our desktop department are getting a message which
> says:
> The size of FixedDrives.Caption is too small. Increase its size by at
> least 7.
> How do you increase the size of this table.
> Problem #2
> This is a very recent implementation and I notice that the maintenance
plan
> will not backup the transaction log. It appears to backup the database ok.
> But the transaction log never backs up and it is set to backup every 3
hours.
|||ok, I'm by no means a SQL expert so I'm feeling my way through this and yes
you are rights captions is a column in the fixeddrives table. I right
clicked on the table and chose design table. The captions column data type is
char and the length is 60. If I increase it by 7 as the error asks and then
click save, I get a warning during the presave process which goes on to say:
Warning: One or more existing columns have ANSI_PADDING 'off' and will be
re-created with ANSI_PADDING 'on'.
I have no clue what to do from there.
As for the transaction log backup problem, a maintenance plan has been
created to backup the transaction log every 3 hours. It fails everytime. Here
are the results:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'SVRWEBG026' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'DB Maintenance Plan2' on 4/18/2005 1:25:00 PM
Backup can not be performed on database 'LDINV'. This sub task is ignored.
End of maintenance plan 'DB Maintenance Plan2' on 4/18/2005 1:25:00 PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
Any help will be greatly appreciated.
"Jens Sü?meyer" wrote:
> P#1 : SOund like a column rather than a table problem.
> P#2 Did you choode to backup the TLog ? What does SQL Server Agent say ? Is
> there a job for this ?
> HTH, Jens SUessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com>
> schrieb im Newsbeitrag
> news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
>
>
|||"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
in message news:32826F49-2FBF-48CE-9582-3EC1382455D9@.microsoft.com...
> ok, I'm by no means a SQL expert so I'm feeling my way through this and
> yes
> you are rights captions is a column in the fixeddrives table. I right
> clicked on the table and chose design table. The captions column data type
> is
> char and the length is 60. If I increase it by 7 as the error asks and
> then
> click save, I get a warning during the presave process which goes on to
> say:
You should contact LANDesk Tech Support. Going in and changing the
structure of a database for an application could break the application, or
at the very least, waste a lot of time and space with no positive results.
If their customers have encountered this problem before, they might have a
thoroughly tested fix or patch for the front-end software as well as the
database.
|||So, if the database is in simple recovery mode you can not backup the
transaction logs? What can you do to tell what mode it is in? For that matter
what are the modes?
Again I'm not the SQL guy.
"Paul S Randal [MS]" wrote:
> The error you're getting is from LANdesk, not SQL Server. I suggest you
> contact their technical support to see what to do. You can't pre-allocate
> space for tables in SQL Server, they automatically grow as you insert more
> rows into them.
> What recovery mode is the database in? If its simple recovery mode, taking a
> log backup is a no-op.
> Regards
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
> in message news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> server
> plan
> hours.
>
>
sql
2000 and the people in our desktop department are getting a message which
says:
The size of FixedDrives.Caption is too small. Increase its size by at
least 7.
How do you increase the size of this table.
Problem #2
This is a very recent implementation and I notice that the maintenance plan
will not backup the transaction log. It appears to backup the database ok.
But the transaction log never backs up and it is set to backup every 3 hours.
P#1 : SOund like a column rather than a table problem.
P#2 Did you choode to backup the TLog ? What does SQL Server Agent say ? Is
there a job for this ?
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com>
schrieb im Newsbeitrag
news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
> server
> 2000 and the people in our desktop department are getting a message which
> says:
> The size of FixedDrives.Caption is too small. Increase its size by at
> least 7.
> How do you increase the size of this table.
> Problem #2
> This is a very recent implementation and I notice that the maintenance
> plan
> will not backup the transaction log. It appears to backup the database ok.
> But the transaction log never backs up and it is set to backup every 3
> hours.
|||The error you're getting is from LANdesk, not SQL Server. I suggest you
contact their technical support to see what to do. You can't pre-allocate
space for tables in SQL Server, they automatically grow as you insert more
rows into them.
What recovery mode is the database in? If its simple recovery mode, taking a
log backup is a no-op.
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
in message news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> Okay, I am actually having 2 problems. We have LANdesk and it uses SQL
server
> 2000 and the people in our desktop department are getting a message which
> says:
> The size of FixedDrives.Caption is too small. Increase its size by at
> least 7.
> How do you increase the size of this table.
> Problem #2
> This is a very recent implementation and I notice that the maintenance
plan
> will not backup the transaction log. It appears to backup the database ok.
> But the transaction log never backs up and it is set to backup every 3
hours.
|||ok, I'm by no means a SQL expert so I'm feeling my way through this and yes
you are rights captions is a column in the fixeddrives table. I right
clicked on the table and chose design table. The captions column data type is
char and the length is 60. If I increase it by 7 as the error asks and then
click save, I get a warning during the presave process which goes on to say:
Warning: One or more existing columns have ANSI_PADDING 'off' and will be
re-created with ANSI_PADDING 'on'.
I have no clue what to do from there.
As for the transaction log backup problem, a maintenance plan has been
created to backup the transaction log every 3 hours. It fails everytime. Here
are the results:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'SVRWEBG026' as 'NT AUTHORITY\SYSTEM' (trusted)
Starting maintenance plan 'DB Maintenance Plan2' on 4/18/2005 1:25:00 PM
Backup can not be performed on database 'LDINV'. This sub task is ignored.
End of maintenance plan 'DB Maintenance Plan2' on 4/18/2005 1:25:00 PM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
Any help will be greatly appreciated.
"Jens Sü?meyer" wrote:
> P#1 : SOund like a column rather than a table problem.
> P#2 Did you choode to backup the TLog ? What does SQL Server Agent say ? Is
> there a job for this ?
> HTH, Jens SUessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com>
> schrieb im Newsbeitrag
> news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
>
>
|||"simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
in message news:32826F49-2FBF-48CE-9582-3EC1382455D9@.microsoft.com...
> ok, I'm by no means a SQL expert so I'm feeling my way through this and
> yes
> you are rights captions is a column in the fixeddrives table. I right
> clicked on the table and chose design table. The captions column data type
> is
> char and the length is 60. If I increase it by 7 as the error asks and
> then
> click save, I get a warning during the presave process which goes on to
> say:
You should contact LANDesk Tech Support. Going in and changing the
structure of a database for an application could break the application, or
at the very least, waste a lot of time and space with no positive results.
If their customers have encountered this problem before, they might have a
thoroughly tested fix or patch for the front-end software as well as the
database.
|||So, if the database is in simple recovery mode you can not backup the
transaction logs? What can you do to tell what mode it is in? For that matter
what are the modes?
Again I'm not the SQL guy.
"Paul S Randal [MS]" wrote:
> The error you're getting is from LANdesk, not SQL Server. I suggest you
> contact their technical support to see what to do. You can't pre-allocate
> space for tables in SQL Server, they automatically grow as you insert more
> rows into them.
> What recovery mode is the database in? If its simple recovery mode, taking a
> log backup is a no-op.
> Regards
> --
> Paul Randal
> Dev Lead, Microsoft SQL Server Storage Engine
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "simpsoro@.webster.edu" <simpsorowebsteredu@.discussions.microsoft.com> wrote
> in message news:F6473B51-EFE8-4F0D-878A-FEC5404D3E5D@.microsoft.com...
> server
> plan
> hours.
>
>
sql
How to increase SSIS performance
Hello again,
I'll just throw my question: how could I increase SSIS-performance?
I have a really heavy job with thousands of records my base selection, then I perform some lookups (I replaced most of them by sql) and derived columns (again, I replaced as much as possible by sql). Finally, after a slowly changing dimension task, I do update/insert on a given table. Is there a trick to speed up lookups and inserts (something like manipulating the buffer sizes - just asking).
Fact is that I replaced a script task by pure sql-joins and gained 6 of the 12 hours this job took.
Any ideas?
Greets,
Tom
Tom De Cort wrote:
Hello again,
I'll just throw my question: how could I increase SSIS-performance?
I have a really heavy job with thousands of records my base selection, then I perform some lookups (I replaced most of them by sql) and derived columns (again, I replaced as much as possible by sql). Finally, after a slowly changing dimension task, I do update/insert on a given table. Is there a trick to speed up lookups and inserts (something like manipulating the buffer sizes - just asking).
Fact is that I replaced a script task by pure sql-joins and gained 6 of the 12 hours this job took.Any ideas?
Greets,
Tom
Speeding up by replacing the script task doesnt surprise me. If you have a high-performant database engine at your disposal, why not use it!
Some links for you that may help:
Whitepaper on Performance Tuning Techniques
http://blogs.conchango.com/jamiethomson/archive/2006/04/09/3594.aspx
Donald Farmer's Technet webcast (highly recommended)
http://blogs.conchango.com/jamiethomson/archive/2006/06/14/4076.aspx
-Jamie
|||
Hi Jamie,
Great, I've read the whitepaper and discovered a lot!
Greets,
-Tom
How to increase SSIS performance
Hello again,
I'll just throw my question: how could I increase SSIS-performance?
I have a really heavy job with thousands of records my base selection, then I perform some lookups (I replaced most of them by sql) and derived columns (again, I replaced as much as possible by sql). Finally, after a slowly changing dimension task, I do update/insert on a given table. Is there a trick to speed up lookups and inserts (something like manipulating the buffer sizes - just asking).
Fact is that I replaced a script task by pure sql-joins and gained 6 of the 12 hours this job took.
Any ideas?
Greets,
Tom
Hello again,
I'll just throw my question: how could I increase SSIS-performance?
I have a really heavy job with thousands of records my base selection, then I perform some lookups (I replaced most of them by sql) and derived columns (again, I replaced as much as possible by sql). Finally, after a slowly changing dimension task, I do update/insert on a given table. Is there a trick to speed up lookups and inserts (something like manipulating the buffer sizes - just asking).
Fact is that I replaced a script task by pure sql-joins and gained 6 of the 12 hours this job took.Any ideas?
Greets,
Tom
Speeding up by replacing the script task doesnt surprise me. If you have a high-performant database engine at your disposal, why not use it!
Some links for you that may help:
Whitepaper on Performance Tuning Techniques
http://blogs.conchango.com/jamiethomson/archive/2006/04/09/3594.aspx
Donald Farmer's Technet webcast (highly recommended)
http://blogs.conchango.com/jamiethomson/archive/2006/06/14/4076.aspx
-Jamie
|||
Hi Jamie,
Great, I've read the whitepaper and discovered a lot!
Greets,
-Tom
Subscribe to:
Posts (Atom)