Post Update For SQLServer SP2--is There One For SQLServer Express?
Apr 18, 2007Regarding KB935356, is there a "post" service pack 2 update for SQLServer Express?
Thanks.
ADVERTISEMENT
Problem Unicode Data 0x2300 In SQLServer 2000 SQLServer 2005 Express
Sep 20, 2006Hi experts;
I have a problem with unicode character 0x2300
I created this table
create table testunicode (Bez nchar(128))
Insert Data
insert into testunicode (Bez)values('Œ€„¢')
with 2 Unicode characters
Œ€ = 0x2300
„¢ = 0x2122
Selecting the data
select Bez from testunicode
I see
"?„¢"
„¢ = 0x2122 is ok but instead of 0x2300 there is 0x3f
When I modify the insert statement like that ( 8960 = 0x2300 )
insert into testunicode (Bez)values(NCHAR(8960)+'„¢')
and select again voila i see
"Œ€„¢"
Does anyone have an idea?
Thanks
Trying To 'load' A Copy Of A SQLServer 2000 Database To SQLServer 2005 Express
Apr 18, 2008
I am trying to 'load' a copy of a SQLServer 2000 database to SQLServer 2005 Express (on another host). The copy was provided by someone else - it came to me as a MDF file only, no LDF file.
I have tried to Attach the database and it fails with a failure to load the LDF. Is there any way to bypass this issue without the LDF or do I have to have that?
The provider of the database says I can create a new database and just point to the MDF as the data source but I can't seem to find a way to do that? I am using SQL Server Management Studio Express.
Thanks!!
Replacing Sqlserver 2000 With Sqlserver 2005 Express
Jun 14, 2006I have an app that uses a sqlserver 2000 jdbc driver to connect to a sqlserver 2000.
Is it possible to do a direct replacement of sqlserver 2000 with sqlserver 2005 express just by reconfiguring the app to point to the express? The app would still be using the sqlserver 2000 jdbc driver to try and make the connection.
If that is a possibility, what can be some differences in the configuration? Previously with 2000 the config information I entered is:
server name: "machinename"( or ip). I've also tried "machiname/SQLEXPRESS"
DB name: name of db instance
port: 1433(default)
user and pass.
My attempts so far results in
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket."
and
"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL."
How Do I Post The Currentdatetime (now) Into A DateTime Field In SQLserver Using A Formview?
Feb 27, 2006How do I post the currentdatetime (now) into a DateTime field in SQLserver using a formview? I tried a couple different techniques, but had problems with both:
1. TRY ONE: I created a date time field on the SQL server named entrydate. I can not figure out how to post the current datetime into it, without the user inputting it into a field.
2. Second TRY: I tried to change the datetime field on the sql server to a datetime stamp field, but it puts in a binary value. Then I can't read it correctly, and my delete functions don't work.
Thanks Ed
How To Transfer Data From A SqlServer Database To A SqlServer Express Database
Mar 29, 2006Is there a way to transfer data from a SqlServer db to a SqlServer Express db. I tried to use the backup file of SqlServer, but this file is not valid for SqlServer Express. Or there any alternatives?
thanks,
Henk
Class Method Is Smoking Fast When Executed Outside Of SQLServer, Dog Slow As A CLR Function Is SQLServer - Anyone?
May 10, 2007We have a static class that makes an HTTPWebRequest to get XML data from one of our vendors. We use this as input to a stored proc in SQLServer2005. When I compile this class and call it from a console application in visual studio it executes in milliseconds, everytime. When I compile it, create the assembly and clr function and execute it in SQLServer, it takes around 14 seconds to execute the first time, then on subsequent requests it is again really fast, until I wait for 10 seconds and re-execute, once again it is slow the first time and then fast on subsequent requests. We do not see this behavior when executing outside SQLServer. Makes me think that some sort of authentication is perhaps taking place the first time the function is run in SQLServer? I have no idea how to debug this further. Anyone seen this before or have any ideas?
Here is the class:
Code Snippet
using System;
using System.Collections.Generic;
using System.Text;
using System.Net;
using System.IO;
namespace Predict.Services
{
public static class Foo
{
public static string GetIntradayQuote(string symbol)
{
string returnQuote = "";
HttpWebRequest request = (HttpWebRequest)(WebRequest.Create("http://data.predict.com/predictws/detailed_quote.html?syms=" + symbol + "&fields=1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,28,30"));
request.Timeout = 1000;
HttpWebResponse response = (HttpWebResponse)(request.GetResponse());
StreamReader streamReader = new StreamReader(response.GetResponseStream());
returnQuote = streamReader.ReadToEnd();
streamReader.Close();
response.Close();
return returnQuote;
}
}
}
When I run call it from a console app it is fine.
I compile it into a dll and then create the assembly and function as follows:
Code Snippet
drop function fnTestGetIntradayQuoteXML_SJS
go
drop assembly TestGetIntradayQuoteXML_SJS
go
create ASSEMBLY TestGetIntradayQuoteXML_SJS from 'c:DataBackupsCLRLibrariesTestGetIntradayQuote_SJS.dll' WITH PERMISSION_SET = EXTERNAL_ACCESS
go
CREATE FUNCTION fnTestGetIntradayQuoteXML_SJS(@SymbolList nvarchar(max)) RETURNS nvarchar(max) AS EXTERNAL NAME TestGetIntradayQuoteXML_SJS.[Predict.Services.Foo].GetIntraDayQuote
go
declare @testing nvarchar(max)
set @testing = dbo.fnTestGetIntradayQuoteXML_SJS('goog')
print @testing
When I execute the function as above, again, really slow the first time, then fast on subsequent calls. Could there be something wrong with the code, or some headers that need to be set differently to operate from the CLR in SQLServer?
Regards,
Skipper.
MIcrosft SQLServer Best Practices Document On Securing SQLServer
Jul 29, 2005I'm chasing after a documetn that was available on one of the Microsoftwebsites that was titled somethign like "MS SQL Server Best Practices"and detailed a nyumber of best practices about securing the server.Included in this was revoking public access to the system tableobjects.Can someone post the URL where I can pick this up, or drop me a note oncontacting them for a copy of the document?
View 2 Replies View RelatedUpgrade SQLServer Mobile (.sdf) Database To SQLServer 2005
Feb 9, 2006Hello,
I have an SQLServer Mobile database, and I would like to know if there is a way to upgrade it to SQLServer 2005 (.mdf) database. My database has no records in it, just the structure (tables etc). What I am actually asking is if I can create automatically a new SQLServer 2005 Database with the same structure as my existin SQLSErver Mobile database
Thanks in advance,
TassosTS
SQLSERVER 2005 X64 Linked Server To SQLSERVER 7.0
Jun 20, 2007Hello people.
I am in the process of planning a server upgrade to sql2005 x64.
I created 2 linked servers: one to a SQL2000 sp4 server and one to a SQL7.0 SP3.
I have the following error when I query the linked servers.
OLE DB provider "SQLNCLI" for linked server "IVDM2K" returned message "Unspecified error".
OLE DB provider "SQLNCLI" for linked server "IVDM2K" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "IVDM2K". The provider supports the interface, but returns a failure code when it is used.
I am aware of KB 906954.
http://support.microsoft.com/default.aspx?scid=kb;en-us;906954
I applied the instcat.sql on the SQL2000SP4 server and my linked server issues for that one are gone.
However, I ran the instcat.sql script on the SQL7.0 sp3 server and the linked server is still giving me an issue.
Can someone help me find a solution to this?
How To Import Access To SQLServer With Parameter From SQLServer, Help Pls!
Jul 8, 2006Hello Expert!
I have 2 Database €“ Access & SQLServer(ver 7)
I need to Import Data TblShift from Access to SQLServer €“ using DTS I€™ve done this successfully!
Now I want to use parameter so I only importing record within range (e.g. ShiftDate BETWEEN 05-24-2006 AND 06-23-2006)
In SQLServer, I have created table to store the date range as following:
TblParameter
DateFrom: 04/24/2006
DateTo: 05/23/2006
How do I use the date range from TblParameter(SQLServer) to import record from TblShift(Access) using DTS?
Is this possible or any better solution for this?
TIA
Regards,
Differences Between Sqlserver 2000 And Sqlserver 7.0
Dec 29, 2005Hi Friends,
Can some please let me know the differences between sqlserver 2000 and sqlserver 7.0
Difference In SQLSERVER/sqlExpress And SQLSERVER
Jun 6, 2007Hi,
I am new to SQL Server 2005. I tried connecting to my local machine by using my machine name as Server name and then tried running the following query:
SELECT * FROM SYS.Objects. It gives me following error:
Invalid object name 'sys.objects'.
Whereas, if I connect to my local machine using mahcinenameSQLEXPRESS, then the above mentioned query runs fine.
Why is this difference? What is the difference when I login in these 2 different ways.
Any help would be appreciated.
Thanks in advance.
Any help
C# & SQLserver Express Installtion
Oct 21, 2007Hello All Great Developers,My Brothers...
blease help me
I am a new in this domain, I need to Know if I can make c# porject
with SQL server Express Database,
and I need to make install to this project to work in any PC without install any another tool or sqlserver program,
blease answer me ,blease
Installed SQLServer Express.....now What?
Jan 13, 2007Hi
I've succesfully installed Visual C# and I've made a couple of example projects. I now want to try and create a database and see if I can make a C# application that talks to it.
So I've installed SQL Server Express. I was hoping I could open it up and get started with creating tables etc. Instead, my Start menu shows:
Microsoft SQL Server 2005
>>>Configuration Tools
>>>>>>SQL Server Configuration Manager
>>>>>>SQL Server Error and Usage Reporting
>>>>>>SQL Server Surface Area Configuration
Where do I go now? Is there some configuring to do before I can start making tables and storing data? Or, have I misunderstood what SQL Server is about?
Thanks
Rich
Sqlserver Express And Tablet Pc
Jan 5, 2006I tried to install sqlserver express on a tablet pc compaq T1000 with windows xp sp2, 512 ram.
A warning appears: hardware incompatible and the installation crashed trying to start sqlserver.
Any similar experience ?
Thanks
Limits SQLServer Express
Jul 27, 2006Hi, can someone explain which are the limits o maximum values that SQLServer Express permit?
I dont see anywhere a compare table in which it says, 10 concurrent connections, etc.
Thanks in advance.
SQLserver Express Licensing
Sep 26, 2007
Can anyone tell me if there is a $ price for a license if SQLserver Express is used on a website? I want to replace Mysql.
Thanks
Rich
Installing SQLSERVER Express
May 25, 2007After installing Visual Studio 2005 everything has installed fine EXCEPT SQLSERVER 2005. I remember having had the same problem some moths ago, but can't remember now how to fix it. I deinstalled VS2005 and installed back again, but the result was the same. SQLSERVER failed to install
thanks
Common UPDATE Syntax For SqlServer And Oracle
Jul 20, 2005The UPDATE table FROM syntax is not supported by Oracle.I am looking for a syntax that is understood by both Oracle and SqlServer.Example:Table1:id name city city_id1 john newyork null2 peter london null3 hans newyork nullTable2:id city23 london24 paris25 newyorkUPDATE table1SET city_id = table2.idFROM table1, table2WHERE table1.city = Table2.cityIf possible I do not want to have two different statements for Oracle andSqlServerPlease do not tell me that these tables are not normalized, it's just anexample!Thanks for any hints.Jan van Veldhuizen
View 8 Replies View RelatedHow To Update Or Delete Records With A SqlServer Destination
Jan 11, 2006I'm a novice to SSIS (and we've never used DTS).
Writing a Control flow that inserts records worked fine, using lookups and all, but i can't find somewhere an example on how to update records of even delete records.
Any suggestions ....
Thx
Harry Leboeuf
How To Update Two Copies Of The Same DB By Transfering The Changes Between Each Other Using SqlServer 2005
Oct 26, 2006ok her is my question.
there are two developers in different offices and they have started with the same db and keep modifying the stored procedures. in a point they want to update their copies of the DB with each other. Is there a easy way to do this in MS Sql server 2005.
How To Update Two Copies Of The Same DB By Transfering The Changes Between Each Other Using SqlServer 2005
Oct 26, 2006ok her is my question.
there are two developers in different offices and they have started with the same db and keep modifying the stored procedures. in a point they want to update their copies of the DB with each other. Is there a easy way to do this in MS Sql server 2005.
Web Application Using SqlServer And VWD'05 Express Edition
May 14, 2007Hello,
Fairly new to asp.net developers community. Can't believe I havent took interest in this before!
Please let me know what I need to learn in terms of resources for creating the mentioned functionality on my asp web page.
I already have a sqldatabase and tables created with data. (This database is reading from another system every 15 mins)The problem is not the database, its working fine, I even have a MS Access frontend that I use.
I want to take the query functionality on the web. ( par number look up to display description, price and unit of measure
I need to have a box for the user to enter a number (1-xxx)..Populate 4 columns with xxx rows.In column one enter 'partnbr"...that looks up the "partnbr' in the "partlist_table" and send back "description" "price" "unit of measure"
Once the info remains on the , I can create masterpages to resemble a quote.
Thank you much for your help.
Dev
Connection To SQLServer 2005 Express
Oct 10, 2006Hi to all GURUS,
I am very (almost two days) new to SQL Server Express (in fact SQL Server). In my old applications I am using VB.Net 2005 Express with MS Access database and now I wants to go for SQL Server Express.
One thing I am unable to find till now is : if SQLServer Express is installed on my Server machine (say ServerPC) with attached database (say MyDB.mdf), how I can access it through ADO.Net 2.0 from client machine. (using VB.Net Express)
Thanks and hope you will encourge me to use SQL Server .
So SQLServer 2005 Express Is FREE?
Jun 4, 2007Ok from what I understand, sqlserver 2005 is FREE, and it is not limited by the number of concurrent connections etc etc.
So this means you can put sqlserver 2005 express on a dedicated server, and it can pretty much handle all the load you can throw right? (except if your say running myspace hehe)
Comments?
VS 2005and SQLserver Express Intergration
Dec 13, 2005Hi,
View 1 Replies View RelatedNot Able To Install Sqlserver Express Toolkit.
Nov 9, 2007
All the Componets are grayed out disabled and not available to proceed further while installing.
All of them have a red cross mark on it saying "Unavailable"
I actually wanted to instal Reporting services component and related services in my machine
Note : MY database server(sqlserver 2005) is connected to this report server(above) by LAN.
Could you please let me know where and how I could install Reporting services
Thanking you in anticipation
Srinivas
SQLServer Express 2005 And VS.NET 2003
Apr 6, 2006I would really like to be using SQLServer Express 2005 for some desktop database applications and replace MSDE. However, I am using VS.NET 2003 and so far I have not been able to discover if that combination will work.
Thanks,
Sid.
Where Can I Download SQLServer 2005 Express SP1
Apr 20, 2006I have followed the link to download SP1 of SQLServer 2005 Express Edition, but, on that page nowhere it is mentioned that downloads offered are of SP1, it simply says that SQLServer 2005 Express edition.
What is the correct link and am I really on the correct page of SP1 ?
Importing Data To Sqlserver Express
Jul 25, 2007I would like to import data to a sqlserver express database. The database I am interested in importing was created in MSDE. I tried backing it up and using the restore function in sqlserver express but with no success. I have not been able to find an import function in the Management Studio Express interface. Is it possible to import this information, or should I get busy with my data entry?
View 4 Replies View RelatedCannot Install SQLServer 2005 Express
May 10, 2006When I try to run the install it detects some previous versions
components. The remove all previous beta components fails and I have
removed everything from the Add/Remove Programs.
Any advice would be helpful
Irina
Access SQLServer Express Using ADODB
Mar 31, 2007Hi,
How should I do to access a table in SQLServer Express database using VB.NET and ADODB?
Thanks!