SQL Server Performance Forum – Threads Archive

Ad-Hoc queries (SQL Server Express Edition)

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
SELECT *
FROM OPENROWSET(‘Microsoft.Jet.OLEDB.4.0’, ‘Excel 8.0;Database=D: esting.xls;HDR=YES’, ‘SELECT * FROM [SheetName$]’) AS derivedtbl_1 but it is showing error that unable to run AD-Hoc queries.
I tried to switch it on by configuration manager. bUt I am not getting any way for this.
Please let me know. Thanking You
Anshu

Your OPENROWSET looks strange.
Will this work?
OPENROWSET
(
‘Microsoft.Jet.OLEDB.4.0’,
‘Excel 8.0;Database=D: esting.xls;HDR=YES’
,SheetName$
) —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

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 Evaluation version.
I tried to switch it on from configuration manager but I couldnot find any method to switch it on.
Please suggest me on this topic.
Thanking YOu
Anshu

http://blogs.msdn.com/sqlexpress/ about using SQLExpress etc. HTH
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi Guys,
SQL EXpress server supports Ad-Hoc Queries. Pplease go to configuration manager and put the server instance then enable AD-Hoc Queries. Thanking You
Anshu

Sorry, probably you should ask your question here:http://forums.microsoft.com/msdn/default.aspx?ForumGroupID=19 —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

]]>