Log Shipping Support 2005 SP1
Apr 20, 2007Whats new for SQL Server 2005 SP2 states:-
"The sqllogship application is now supported."
Can anybody confirm that log shipping is not supported in SQL Server 2005 SP1?
Thanks
ADVERTISEMENT
SQL Server 2005 Support
Oct 18, 2005I 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
SQL Svr 2005 Express Does NOT Support DTS
Apr 9, 2006<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
View 4 Replies View RelatedSQL 2005 MultiProcessor Support
Sep 24, 2007I 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.
View 5 Replies View RelatedSql Server 2005 Sp2 Support
Jul 13, 2007Is sql server 2005 SP2 supported on windows server 2003 SP2?
View 5 Replies View RelatedSupport For SQL Express2005 My Host Provider Does Not Provide Support?
Dec 5, 2005Reader 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
Philip
SQL 2005 Log Shipping
Aug 9, 2007I have a SQL 2k5 log shipping setup and all copy jobs as well as restore jobs are running properly but the LS_Alert job that the wizard auto creates fails every two minutes has anyone experienced this before. After going through the wizard it creates a LS_Alert job and schedules it every two minutes and it fails constantly.
Thanks!
kdubb
SQL 2005 Log Shipping
Aug 9, 2007I have a SQL 2k5 log shipping setup and all copy jobs as well as restore jobs are running properly but the LS_Alert job that the wizard auto creates fails every two minutes has anyone experienced this before. After going through the wizard it creates a LS_Alert job and schedules it every two minutes and it fails constantly.
Thanks!
kdubb
Sql Server 2005 Diagram Support
Mar 30, 2006For 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?
Xquery Support In SQL-Server 2005
Jul 23, 2005Hi,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
View 1 Replies View RelatedMemory Support For Sql 2005 STD 64BIT
Jan 2, 2008
Hi,
I'm about to install Windows 2003 STD 64BIT and SQL 2005 STD 64BIT with 12GB MEM.
my question is about the switch in the BOOT.INI - do i need to enable any switch with this server configuration?
and do i need to enable the AWE on the SQL?
THX
Confusion Over SQL 2005 Standard CPU Support
Feb 6, 2007I'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)?
Thanks, Chris.
Support Visual Studio 2005 Sql...
May 24, 2006IS 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)
Confusion Over SQL 2005 Standard CPU Support
Feb 7, 2007I'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)?
Thanks, Chris.
XPE + Visual Studio 2005 Support
Mar 28, 2007Hello All,
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.
Regards
Michells
BCP Support In SQL Server 2005 - Doubts
Sep 4, 2007Hi friends,
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?
Please help. Thanks in advance.
Regards,
Sethu.
Support For 3.5 Merge Replication Under SQL 2005
Dec 3, 2007Been 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?
OCSP Support In SQL Server 2005?
Oct 2, 2007Hi All,
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
Regards
Andrew R.
Is DTS Support In 2005 Going Away Permanently At Some Point?
Mar 6, 2007I 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!
SQL 2005 Log Shipping Setup
Aug 9, 2007I have a SQL 2k5 log shipping setup and all copy jobs as well as restore jobs are running properly but the LS_Alert job that the wizard auto creates fails every two minutes has anyone experienced this before. After going through the wizard it creates a LS_Alert job and schedules it every two minutes and it fails constantly.
Thanks!
kdubb
Truncating T-Log's In SQL 2005 Log Shipping
Jan 31, 2008
Hi everyone,
How/when should transaction logs be truncated without breaking Log Shipping?. I'm trying to deal with the scenario of my tlogs increasing their size as I configure log shipping to 5 min. -frequency backups.
Many thanks
MS SQL 2005 Log Shipping And Altering A DB
Feb 26, 2008Question: I have Log Shipping setup and i am wanting to verify it will do what we need. That is when a table is changed in our production enviroment that change is replicated into our other server. IE I rename a field in a table or create a new table... You know change the structure... How do I replicate that stuff to my other servers?
View 6 Replies View RelatedLog Shipping Between SQL 2005 And SQL 2000
Aug 15, 2006We have an environment where 3 SQL 2000 servers exist; one production servers and two standby servers that receive logs via log shipping. Everything works fine and it is stable. My client wants to get a new 64 bit server and run SQL 2005 64 bit version for the production box. Can we still do log shipping with the two remaining SQL 2000 boxes or do they all have to be on the same version and bit version?
Thanks
Bill
How Many Concurrent Connections Support SQL Server 2005?
Jun 16, 2006Hi folks,
That is the question: how many concurrent connections support Microsoft SQL Server 2005?
Thanks in advance,
Javier.
Help Needed For Transaction Support In SQL Server 2005
Jun 21, 2006Hi,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.
View 5 Replies View RelatedLauguage Support In SQL Server 2005 English Ver
Feb 25, 2008I 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'
Please help!
Alan
Support For SQL DTS Packages Post Upgrade To SQL 2005
Feb 15, 2007Hi,
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?
Cheers, James
SQL 2005 SP1 Not Support Process Update Option?
Jun 16, 2006as title.
Thanks.,
Kelvin Jor
SQL 2005 Express Together With SQL 2000 Ent.edt. Microsoft Support
Mar 27, 2007Does 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.
Does Sql Server 2005 Compact 3.5 Support Views?
Feb 29, 2008I think I read somewhere that sql server 2005 Compact Edition (3.1) does not support views. Does anyone know if views were added to 3.5?
View 3 Replies View RelatedDatabase Mirroring Support Also By SQL Server 2005 Without SP1
Sep 27, 2006Hi All,
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!
Regards,
Pat
Restored Database/Diagrams Support/SQL-Server 2005
Oct 18, 2005Hello,
View 10 Replies View RelatedDo SQL Server 2005/CLR Triggers Support .config Files?
Jun 5, 2006Does anyone know if it's possible to use the standard .config file within a CLR Trigger to read properties via the System.Configuration namespace
I guess it's not possible because the CLR Trigger needs to be compiled as an assembly which is hosted by SQL Server
Thanks
Jason