I'm trying to convert our application and support additional east asian languages such as chinese simplified, japanese and korean. I know how to make the asp.net side work by support UTF-8 / global resource files / UICulture and whatever. But what do I have to do on the Sql Server side?
I tested a few samples and i'm getting garbage characters after entring some chinese/japanese characters.
Another unrelated question,
I wrote some custom store procedures (dyanmically concatnated strings), I dont' have sql server 2005, so I'm wondering if I deploy it to sql server 2005, will 2005 be backward compatiable with 2000? I don't have any triggers and stuff, so I'm just wondering if you know anything about it.
We have an existing C# application using SQL Server 2000 database. Currently, the app is English-only, however the business now wants to internationalize the app to support multiple languages (French, Spanish, Russian, Polish, etc.). We will have only one database. So, data in multiple languages will be stored in the same database.
My question is about how this affects the ORDER BY clauses in our SQL stored procedures.
I found an article on Microsoft's web site which seemed to imply that we will have to use COLLATE on every single ORDER BY. This seems crazy to me. If this is true, that means we'll have to pass down a collation name to the stored procedures.
Is there any setting to indicate Unicode data to handle, so that no need to exclusively use Unicode data types ( ex nvarchar ). I need to execute both Unicode and non Unicode SQL statements with in one environment. I don't want to create seperate database again. Please let me know if any one had approached on SQL server this way. I am looking the way Oracle provides where you don€™t need to declare the data type of the column as Unicode type in table definition but can indicate when running a query to manipulate that field as Unicode field.
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
UAT environment : SQL Server 2008 R2 SP3 Enterprise Edition
SANDBOX environment : SQL Server 2008 R2 SP3 Standard Edition
I have a database backup (.bak) that was taken from UAT environment that has CDC enabled on some tables. I want to restore that database into my SANDBOX environment which does not support CDC (because of standard edition). The restore process fails due to this incompatibility. Is there any way to restore without CDC (I dont CDC enabled on my SANDBOX; just my data from the backup) ?
How many processors can SQL server 7.0 support? If the sql server box has 2 CPUs, will sql server 7.0 utilize both ? or sql server use one and NT use the other?
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
Hi,Do any versions of SQL Server support the following functions, asthey appear in the Oracle Database:-1) XMLElement2) XMLAttributes3) XMLForestThanks in Advance for your replyByeAmardeep Verma
Hi, Please do inform me about the SQL server database capacity of handing the data.
Well, I€™m a designing Data warehouse database on SQL server 2005 my first time load of data is 9 million records for 30 years of period, and future growth of data would be almost 20 million for the up coming 10 years. Will this database would be able to handle that much of data.
Would someone please make a clarification for me on the mainstream desupport of SQL Server 2000. In the following url it states that the desupport will take place 4/8/2008. http://support.microsoft.com/lifecycle/?LN=en-us&p1=2852&x=12&y=11 Yet, if you read the lifecycle policy it at the following location it states that mainstream support is for 2-5years after the release of the successor product which ever is longer. http://support.microsoft.com/gp/lifepolicy Since SQL Server 2005 was released 4/8/2005 then five years would put it on support until 4/8/2010. Would someone please correct me where I am reading this incorrectly?
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?
How well SQL Server can support 300 million records... Any body is working on big database like this. can anyone give me some input on this. it's going to be 60GB database size.
Hi, This is chirag patel. we are going to develop web application which can disply data (Search Results) in different language. if user selected country Japan, then search results should be in Japanese. if user selected country Chian, then search results should be in Chinese. now i want to store all these read only data in Database. how and where i can store it? do i need to have different Databases? or with single database also i can achive? I means what is advisable approach to achieve this?
if Single Database for all countries then how i can store same data in different languages in single table?
please guide me if anyone know how to achive such kind of scenario in SQL Server?
Hello,I would like to know whether it is possible to execute DTS(Data Transformation Services) packages created from withinthe EM (Enterprise Manager) user interface, from the commandline. That is, is it possible to execute a command at the DOSprompt which will execute, and optionally also reconfigure,the DTS package? This would allow invoking DTS packagesfrom within scripts.Thank you for your replies,Neil
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 want to manage my servers from a central location and have the ability to manage my packges too. Unfortunatley my servers are across domains which means I have to use SQL Server Login, which isn't a bad thing. However for some bizzare reason I can't connect to Integration Services using this method, only windows authentication which is a complete pain in the butt from a management stand point as I have to copy packages to various servers rather than add them from a central point.
Does anyone know if this bug/feature or what ever Microsoft is calling it will be fixed or know of any workarounds.
I've tried to enclose a few database operations in a TransactionScope block but it looks like SQL Server CE RM does ignores ambiental transaction.
Here is the code:
static void TestTxn() { // Command to insert an integer in a table with a single integer column string cmdPassText = "INSERT TESTTABLE (INTFIELD) VALUES(1)"; // Command to force field type mismatch exception string cmdFailText = "INSERT TESTTABLE (INTFIELD) VALUES('Foo')";
using (TransactionScope scope = new TransactionScope()) { using (SqlCeConnection conn = new SqlCeConnection("DataSource = 'Test.sdf'")) { try { conn.Open(); SqlCeCommand cmdPass = new SqlCeCommand(cmdPassText, conn); returnValue = cmdPass.ExecuteNonQuery(); SqlCeCommand cmdFail = new SqlCeCommand(cmdFailText, conn); returnValue = cmdFail.ExecuteNonQuery(); } catch (Exception ex){ Console.WriteLine("Command failed"); Console.WriteLine("Exception Message: {0}", ex.Message); } } scope.Complete(); } }
After first command suceeds and seccond command failes table still has one affected row after transaction.
Am I doing something wrong or System.Transactions.Transaction is not supported with SQL Server CE RM?
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?
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
Hello, I would like to see if Microsoft has issued any announcement on SQL Server 2000 end of support. If anyone is aware of this or seen new posts/articles, please let me know. Thank you!
