While I was migrating my database server from SQL 2000 to SQL Server 2005 I came across this error as the production and development environment were not quite identical. Well the first thing to note in this error is non descriptive, preventing information disclosure to unauthenticated clients. To determine the true reason for the failure, [...]
Posts Tagged ‘SQL Server Tips and Tricks’
Login failed error: (Msg 18456) SQL Server 2005 Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’
Posted in SQL Server 2005, tagged SQL Server 2005, SQL Server 2005 Migration, SQL Server Tips and Tricks on July 22, 2008 | 3 Comments »
Updatable keyset-driven cursors on remote tables require a transaction with the REPEATABLE_READ or SERIALIZABLE isolation level spanning the cursor. Server: Msg 8180, Level 16 ,Server: Msg 102, Level 15, Server: Msg 1018, Level 15
Posted in Blogroll, tagged SQL Server 2005 Migration, SQL Server Tips and Tricks on June 1, 2008 | 1 Comment »
Server: Msg 8180, Level 16 Server: Msg 102, Level 15 Server: Msg 1018, Level 15, State 1, Procedure SendReview, Line 12 Incorrect syntax near ‘FASTFIRSTROW’. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax. Remote tables are [...]
-
-
Blog Stats
- 237,506 hits
Fellow Bloggers
Archives
- November 2010 (3)
- September 2009 (1)
- May 2009 (1)
- April 2009 (1)
- January 2009 (2)
- July 2008 (1)
- June 2008 (3)
- May 2008 (3)
- February 2008 (1)
- December 2007 (3)
- October 2007 (1)
- September 2007 (6)
- August 2007 (1)
- July 2007 (2)
- June 2007 (2)
- May 2007 (2)
- April 2007 (4)
- February 2007 (4)
- January 2007 (11)
- September 2006 (1)
- August 2006 (3)
May 2012 M T W T F S S « Nov 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 26 27 28 29 30 31 -
Spam Blocked
RSS
Joel on Software- ASP .NET Team Members
- MSR News and Headlines
- Podcast: Look, Computer, No Hands!
- Inside Microsoft Research: More Research Contributions to Windows Phone Translation
- Dino Distefano Presented with the BCS Needham Award
- Inside Microsoft Research: Incremental, Iterative Computation for Big Data
- CHI 2012: Microsoft Research Explores the Potential for Emotional Technology
- ASP .NET Team Blog
- ASP.NET AJAX Team Blogs
- An error has occurred; the feed is probably down. Try again later.
-
Flickr Photos
More Photos -
Recent Comments
Shaani Ali on Display My Computer Icon on th… marky on How to get Excel sheet na… Trbr on Display My Computer Icon on th… bipin on Microsoft and Temenos Pedro on Login failed error: (Msg 18456… Tag Cloud
Meta
-
Delicious
-
Top Posts
- Find and Replace Column values in a Table using T-SQL
- Display My Computer Icon on the Desktop in Windows 7
- How to get Excel sheet names
- The project file ' ' has been renamed or is no longer in the solution. Solved
- How to manually extend the evaluation period
- Adding a ToolTip to an Image (asp:image, img)
- Login failed error: (Msg 18456) SQL Server 2005 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
- Turning off Enhanced Security Configurations for Internet Explorer in Windows Server 2008
- Removing All HTML Tags from a String Using Regular Expressions
- Adding reference to Project in Visual Studio 2005
-
Top Clicks
- Wrox: All New Titles
Visual Studio 2008 Tip Of the Day
- http://blogs.msdn.com/saraford/rss_tag_Visual+Studio+2008+Tip+of+the+Day.xml
- An error has occurred; the feed is probably down. Try again later.
