Hi Madhivanan, I tried this query for last 2 days but couldn't transfer. Now I have given it up. Please tell me can I transfer database from SQL...
Hi, DTS services are not included in SQL Server Express. So please let me know how to transfer data from excel sheet to SQL Server Express. Thanking...
Oh, Sorry Satya, I will remember this. Thankx Anshu
Hi, I am using SQL Server Express evaluation version. And I want to tranfer database file from an EXCEL sheet to SQL Server Express. I couldn't find...
Hi Madhivanan, Thanking you for your reply. I am executing query like this INSERT INTO city (cityName) SELECT * FROM OPENROWSET(...
Hi Madhivanan, I am just running this query INSERT INTO city (cityName) // Where cityName is the name of the column in the city table//...
Hi Guys, SQL EXpress server supports Ad-Hoc Queries. Pplease go to configuration manager and put the server instance then enable AD-Hoc Queries....
Hi MAdhivanan, Thanking you, SQL Express is running AD-Hoc Queries. I also have one more novice question. In the query you provided, where to put the...
Hi Frank, Guten Tag, Thank you for your advice. I also have some problem. Actually I am unable to run AD-Hoc query (OPENROWSET) on my MSSQL Express...
Hi, Does anybody knows how to allow AD-Hoc queries in MSSQL server express edition evaluation version. I am trying to run query INSERT INTO city...
Hi Madhivanan, Thanking you for providing your suggestions. But I am sorry to say that I am unable to find to run any method for Ad-Hoc queries. I...
Hi Madhivanan, I just tried by the way you suggested. But I am sorry to say that it is showing an error that AD-Hoc Qyery should be on. I tried to...
Hi Guys,<br />Only the selected cities I am cosidering...<img src='/community/emoticons/emotion-1.gif' alt=':)' />)<br /><br />Anshu
Yes, I am trying, I will just let you know in couple of moments. Thanking You Anshu
Hi, I am sorry to say, I couldnot find DTS wizard in SQL Server Express edition. Also I couldn't find DTS Wizard in Visual Studio 2005 evaluation...
Thanking you very much. I apologise for asking this question in the wrong forum. Anshu
Hi, I am preparing a database in MSSQL for all cities list of the world. I have a list of all cities in MS-Excel file. is there any way to enter...
Hi, I am using Visual Studio 2005. I create a list box on a webpage. and when I try to run it the content of list boxes opening on the upper side...
Thanking you very much. I gotta clue... and now ready to get it run.
Hi, When I was installing the MSSQL SERVER Express Edition then I gave dafault server instance. I also checked with computer managemnet services and...
Separate names with a comma.
