I have a Dual Quad Core Xeon processor server running SQL 2005 Standard. When installed, one processor license was given, even though two OTS boxes are present. When looking at SQL Sever Properties>Processor, it shows 0-7 available CPU's. When running a large table insert and looking into TaskManager, it appears only 1 cpu out of 8 viewed are being hit and hard. The total CPU usage is like 13%. And SQL Server seems slow. Any idea what gives? Why would it show only 1 CPU being hit (maxed out) and the rest doing nothing? Is there a way to tell if SQL Sees all processors (licensing issue?) other than in the SQL Sever Properties>Processor? Thanks.
I have the following configuration: - Server with 8 AMD Opteron Processors - 24 GB Memory - Windows Server 2003 64 bit - SQL 2005 64 bit - EMC Storage
The main instance is defined to use 7 Processors and has about 10 databases.
The problem is: When I run a "simple" Query (DISTINCT or GROUP BY) on a Table with something like 1 million rows, SQL 2005 is very very slow !!! The same query is on a SQL 2000 about 1000times faster ...
Does anybody has some ideas how to configure the system to make it more useful ... ??
Has anyone seen a problem where a SQL Server Application works on a server with a single Processor, However when placed on a box with multi-processors it fails. You do not receive any errors but the data set that is returned is not correct. When reviewing this problem on a test machine that only is a single processor we can not duplicate it. The Production Box is Multi Processor 2 pentium pro 200's with SQL Server 7.0 and no Service Packs. My Question is has any one ever seen this problem, and would installing the SP correct it, I plan on installing the SP's but I wonder if this could be the cause of the problem.
I am using MS SQL Server 2005 n Visual Studio dot net 2005, When starting the managment studio i connect using windows authentication but the problem arises when i need to open an oledbconnection via ado.net with the syntax: oconn=new oledbconnection(provider=;data source=,user id=,password equal) since windows doesnt include any password i cant use the user id and password fields which causes errors althugh i created a password for my windows account the same stuff again is there any problem to change the connection method from windows authentication to sql server authentication and how can i create a login id and password. thank you
<I posted this message in comp.databases Group and then realized thisis a more MS SQL Svr centric group . ... so re-posting it here.>Gentlemen, any workarounds for DTS in Expression version?My goal is to populate a new DB I created with CSV files ... afterreading through dozens of posts it was apparent that DTS is the way togo and then only to find SS-05 Express doesnot support it.Thanks in advance.George
Reader Community I've just started hosting my newly created Microsoft Visual Web Developer 2005 Express Edition web site. Unfortunately the Login group membership functions will not function correctly. Having contacted the web service hosting provider, They replied: "We do not support SQL express2005. The only way to use the extra functions of ASP.NET2 such as group membership is if it is using an SQL 2000 database to connect to. " Is it possible to design web sites with Microsoft Visual Web Developer 2005 Express Edition that store membership details on an SQL 2000 database? I've just paid £88 approx. $140 for a years subscription, have I chosen the wrong web service hosting provider? Should I have designed the web site with a better web site design software tool that also makes designing membership login functionality easy, just as Microsoft Visual Web developer 2005 express edition? Look forward to all comments? Regards
For some reason, when I try to access a database diagram on our new 2005 SQL Server, I get the following error msg: "Database diagram support objects cannot be installed because this database does not have a valid owner" It then goes on to instruct me to either use Properties > Files or ALTER AUTHORIZATION to change the database owner. Well, I've done that - and it clearly shows that there is an owner of the database, but even if I log in as that owner, the error msg continues to come up everytime I try to access Diagrams. I found a post to run the following stored procedure which will set the sql server compatability level: EXEC sp_dbcmptlevel database_name, 90 After running that in the query window of Management Stduio, I get the following msg below on the Messages tab: "DBCC execution completed. If DBCC printed error messages, contact your system administrator." I then try to create a new diagram again, and I get the same initial error (at the top of this post). What do I need to do in order to create a DB diagram?
Hi,does anyone kown if the final release or one of the next Betas ofSQL-Server 2005 will support XQuery-Statemets including the LET-Feature.Thanks,Tobias
I'm a little confused over the maximum CPU count supported by SQL 2005 Standard Edition (this particular edition supports four CPUs).
Does the figure refer to four physical CPUs regardless of whether they are dual-cored or hyperthreaded, or does the figure refer to the number of logical CPUs available to the OS?
Let me cut to the chase - if I purchase a server containing four dual-core CPUs and install SQL Server 2005 Standard, will SQL Server see the eight CPUs and utilise a maximum of four of these, or will it be able to use all eight (because there are actually only four physical CPUs)?
IS visual studio 2005 (not visual studio express 2005 ) support SQL SERVER EXPRESS 2005?
and also , after install SQL serer express 2005 should be set it for each computer(like as SQL server that should be set with name of computer to use database)
I'm a little confused over the maximum CPU count supported by SQL 2005 Standard Edition (this particular edition supports four CPUs).
Does the figure refer to four physical CPUs regardless of whether they are dual-cored or hyperthreaded, or does the figure refer to the number of logical CPUs available to the OS?
Let me cut to the chase - if I purchase a server containing four dual-core CPUs and install SQL Server 2005 Standard, will SQL Server see the eight CPUs and utilise a maximum of four of these, or will it be able to use all eight (because there are actually only four physical CPUs)?
I am working on Visual Studio 2005 and XP embedded. I have developed an application on Visual Studio 2005 platform but that fails to run on my embedded OS.
Is there any way so that I can run my application on my embedded OS.
Does FeaturePack 2007 Release version supports this? If yes, what are the components that needs to be added.
I am currently using SQL Server 2000 server. I have run some BCP command to import data to SQL from CSV and Text files with the help of FORMAT files through Windows Scheduler.
My doubt is, if I swich to SQL Server 2005, whether the same BCP commands will supported? If no, What are the things I need to do to run the BCP commands in 2005 as in 2000?
I heard that the BCP utility is no longer support in 2005 and this can be done thru SSIS utility. Is it right...? Is SQL Server 2005 support to use the BCP commands without going to SSIS utility?
Been fiddling with SQL 2008 Nov CTP but now looking to deploy a 3.5 .sdf project using Merge replication. The 3.1 install sets up a web endpoint with sqlcesa30.dll and I have been running subscriptions just fine with that. But now I want to be able to create and manage my 3.5 publicatoin/subscriptions under SQL 2005 management console. I don't see how to create 3.5 sql ce databases there or to use 'configure web synchronization' to get a 3.5 web endpoint for syncing.
Am I missing something simple like registering the SQL CE 3.5 dlls to work with SQL management studio? I want to install to this a production server with the smallest possible footprint and I do NOT want to inject SQL 2008 Nov CTP bits into that production server at all! So, how to deploy SQL CE 3.5 to production and set up 3.5 merge replication under SQL 2005?
I'm trying to ensure that the access to my symmetric key is validated every use via the use of (X.509 Certifcate) Online Certificate Status Protocol (OCSP).
Question: When a Certificate encrypted Symmetric Key is opened in SQL Server 2005, does SQL Server support OCSP revocation checking?
If it does support OCSP: Can the Certificate Revocation List Distribution Point of the certificate only contain an OCSP distribution point (instead of also including HTTP, LDAP, etc)?
This is really important as I do not want any cached CRL to authorise the access to this highly sensitive data...
Platform: - SQL Server 2005 on Windows Server 2003 R2 - Certificate Services on Windows Server 2003 R2
Refer to: USE AdventureWorks; OPEN SYMMETRIC KEY SymKeyMarketing3 DECRYPTION BY CERTIFICATE MarketingCert9; GO http://msdn2.microsoft.com/en-us/library/ms190499.aspx
I hope this is the right forum to post my question in.
Does anyone know if or when Microsoft will discontinue support for 2000 DTS Legacy packages within SQL Server 2005? We€™re in the process of migrating from 2000 to 2005 and have a lot of packages to migrate to Integration Services. We€™re having problems migrating the packages because quite a few of them are complex and won€™t run after migrating to IS without a major rewrite. Right now it seems that those packages will run just fine under the Legacy folder on the 2005 instance with the data connections pointed to 2005 databases. We€™d just like to plan appropriately if we absolutely have to migrate those packages to IS at some point soon. We realize that we'll need to create new packages using IS, though.
So I€™d appreciate it if anyone has heard anything to please let me know. I apologize if this has been asked before, but I couldn€™t seem to find any posts on it. Thanks!
Hi,I have 2 stored procedure 1st insert the data in parent tables and return the Id. and second insert child table data using that parent table id as paramenter. I have foreign key relationship between these two tables also.my data layer methods somewhat looks likepublic void Save(order value){using (TransactionScope transactionScope = new TransactionScope(TransactionScopeOption.Required)) { int orderId = SaveOrderMaster(value); value.OrderId = orderid; int childId = SaveOrderDetails(value); //complete the transaction transactionScope.Complete(); }}here 1. SaveOrderMaster() calls an stored procedure InserOrderData which insert a new record in order table and return the orderId which is identity column in Order table.2. SaveOrderDetails() call another sotored procedure which insert order details in to table "orderdetail" using the foreign key "orderid".My Problem:Some time the above method works correctly but when i call it repeatledly (in a loop) with data, some time it gives me foreign key error which state that orderid is not existsin table Order. This will happen only randomly. I am not able to figureout the reason. does some one face the same problem. if yes, what could be the reason and/or solution.
I created a table in SQL server 2005 english version and one of the column stored the chinese characters using nvarchar(X). There is no problem to store the Chinese characters in that column. The question is how I can retrieve the data based on that column data. For example:
select * from ChinsesCharaterColumn = 'ChinsesCharacter'
I am unclear on Microsofts policy regarding support for DTS and packages that have been imported (but not migrated) to SQL 2005.
The upgrade advisor states SQL Server 2000 Data Transformation Services Advisory SQL Server 2000 Data Transformation Services is deprecated You must completely migrate existing SQL Server 2000 Data Transformation Services (DTS) packages to SQL Server 2005 Integration Services packages before support is withdrawn.
Source Type: MSDB Package
What does this really mean? What will happen to the importing of legacy packages and this whole area within Management Studio? Will these 2005 features no longer be supported? What will happen to the Execute 2000 task? If I upgrade a SQL 2000 instance post 08/04/08 does this mean that I won't receive support from Microsoft even though the package post installation is in SQL 2005. Will the new dts designer in the feature pack be taken away/withdrawn?
To say DTS packages will no longer be supported is a very dramatic statement with far reaching consequences. How is this going to be effectively implemented? Is there really going to be no backward compatibility support in Katmai?
Does Microsoft officially support installing SQL 2005 Express on a server where SQL 2000 Enterprise Edition is already running (a has to keep running).
In case they do, where do i find this official info / note.
Have they released white papers on this matter?
I know it is possible to install the two together and that they can coexist, but I am worried about how the two SQL installations wil behave when being updated with patches, security updates, service packs etc. do you run the possibility of them corrupting each other? Therefor it is vital to know if Microsoft supports the two running on the same system.
I get a general question about the feacture "Database Mirroring". Is it support by SQL Server Standard. Edition without SP1?? Of i still need to upgrade the server from SQL Server 2005 to SQL Server 2005 with SP1?
Another question: are there any problem if the one machine(server) has installed SQL server 2005 Standard edition and the other with "Developer Editon".
I hope some one can answer my question. Thanks anyway!
SQL Server 2000 is pretty well documented with the limit of 256 (see http://msdn2.microsoft.com/en-us/library/aa214780(SQL.80).aspx) but I can find no documentation anywhere that discusses the limit on SQL Server 2005.
1) first i installed Sql Server 2005 Enterprise Edition, everything was working fine except i was not able to create managed objects from BI, like stored procedures, triggers, UDT, etc etc.
2) so i installed VS.net 2005 complete + Sql Server 2005 Express Edition
now i was able to create stored procedures, triggers, etc etc, i'm talking about the CLR objects, ok, i.e. the managed code, but........ i was only able to do this from Sql Server 2005 Express Edition.
whenever i try to create managed objects CLR like stored procedures and stuff from the Sql Server 2005 Enterprise edition it gives me the following error :
"The Sql Server supplied by these connection properties, does not support managed code, please choose a different server"
please help meeeee.. please please, tell me what's the problem ?
I believe I have made a complete install of Sql Server 2005 on my dev. machine, including all client tools, and can run SSIS packages from the dev. environment.
However DtExec refuses to run any package and always throws the "insufficient version" error (as does the "RunPackage" component, probably for the same reason).
I have repeatedly attempted to find something more to install from the Sql Server 2005 eval release that will allow DTExec to run without the "insufficient version" error, but can find nothing else to install from the eval. The install wizard (and the "change" wizard) indicates everything is installed and will not build a list of any additional components to install.
Are we sure that DtExec will install and run from a sql server 2005 eval distribution?
Licenses are in the pipeline (not that pipleine) but we need to start testing our SSIS solution in the meantime.
p.s. Kudos to the dev. team, it really is an excellent tool!
I've heard that the Standard version supports the use of CommandNotification and that the Express version does not. What about the Workgroup edition? The reason I'm asking is because there is a substantial monthly difference in cost between the two versions if I were to have my site hosted. I've been developing with MS SQL 2005 Express so obviously I have not tested this caching feature. Are command notifications reliable? On paper, it sounds impressive and extremely efficient especially if a site is to have heavy traffic and you can't afford the overhead of heavy database processing that is useless if the data is unchanged. Does the Workgroup edition support automatic change notifications? Have automatic notifications been proven reliable and vastly more efficient than crude polling methods? Thanks in advance.
