Viewing 6 posts - 1 through 6 (of 6 total)
The only way that worked for me was to extract files from standalone installer (7zip) and run Setup.exe as administrator.
May 31, 2010 at 9:22 am
I tested every proposed solution. Here's the results:
1. EXEC('SET NOEXEC ON ' + @sqlstring)
2. EXEC('SET PARSEONLY ON ' + @sqlstring)
3. EXEC('SET FMTONLY ON ' + @sqlstring)
-> All 3 returned syntaxical...
April 13, 2007 at 3:41 am
The PARSEONLY option checks the SQL syntaxt but not the objets existance.
SELECT * FROM NonExistingTable -> parsing says OK !
How can I verify the querie's objects existance?
April 12, 2007 at 4:04 am
It is that! Just one thing: you cannot use SET PARSEONLY ON and SET PARSEONLY OFF in the same statement because the query would be executed and not parsed! So...
April 12, 2007 at 2:02 am
Here you have a topic on locking issues after SP4 installation: http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic1883.aspx
June 22, 2006 at 2:47 am
November 14, 2005 at 10:41 am
Viewing 6 posts - 1 through 6 (of 6 total)