Resources feed from DotNetFunda.Com (C) DotNetFunda.com2012. All rights reserved. http://www.dotnetfunda.com webmaster@dotnetfunda.com en-us DotnetfundaResourceshttp://feedburner.google.com http://feedproxy.google.com/~r/DotnetfundaResources/~3/uqioKtCgn68/3rd56788-using-visual-basic-11-to-connect-to-localdb.aspx We are trying to use Visual Basic 11 to connect to a test.mdf database file that was created by SQL Server Management Studio 2012 using the Server Name (localdb)\v11.0. The database and its tables loo ... <p><a href="http://feedads.g.doubleclick.net/~a/UgQET7xBOtxNTNC4m-RxrwQudJc/0/da"><img src="http://feedads.g.doubleclick.net/~a/UgQET7xBOtxNTNC4m-RxrwQudJc/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/UgQET7xBOtxNTNC4m-RxrwQudJc/1/da"><img src="http://feedads.g.doubleclick.net/~a/UgQET7xBOtxNTNC4m-RxrwQudJc/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/DotnetfundaResources/~4/uqioKtCgn68" height="1" width="1"/> Thu, 17 May 2012 12:00:00 AM GMT http://www.dotnetfunda.com/misc/articles/3rd56788-using-visual-basic-11-to-connect-to-localdb.aspx http://feedproxy.google.com/~r/DotnetfundaResources/~3/bqrYPs33VAk/3rd56787-not-able-to-connect-sqlserver-2008.aspx TITLE: Connect to Server ------------------------------ Cannot connect to @DELL@\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific er ... <p><a href="http://feedads.g.doubleclick.net/~a/PDHAxIihEJYYR5xdIUAc9ZuSgO0/0/da"><img src="http://feedads.g.doubleclick.net/~a/PDHAxIihEJYYR5xdIUAc9ZuSgO0/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/PDHAxIihEJYYR5xdIUAc9ZuSgO0/1/da"><img src="http://feedads.g.doubleclick.net/~a/PDHAxIihEJYYR5xdIUAc9ZuSgO0/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/DotnetfundaResources/~4/bqrYPs33VAk" height="1" width="1"/> Thu, 17 May 2012 12:00:00 AM GMT http://www.dotnetfunda.com/misc/articles/3rd56787-not-able-to-connect-sqlserver-2008.aspx http://feedproxy.google.com/~r/DotnetfundaResources/~3/IhIkiwTTrG4/3rd56786-remote-connection-string-question.aspx Hi, Re: Connection Strings (new to SQL Server) When connecting to the database locally, it appear that it's possible to use Integrated Security=SSPI instead of User Id and Password. My question is ... <p><a href="http://feedads.g.doubleclick.net/~a/dUd4iqPb5dLealdqJpCU_L7Uyns/0/da"><img src="http://feedads.g.doubleclick.net/~a/dUd4iqPb5dLealdqJpCU_L7Uyns/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/dUd4iqPb5dLealdqJpCU_L7Uyns/1/da"><img src="http://feedads.g.doubleclick.net/~a/dUd4iqPb5dLealdqJpCU_L7Uyns/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/DotnetfundaResources/~4/IhIkiwTTrG4" height="1" width="1"/> Sat, 19 May 2012 12:00:00 PM GMT http://www.dotnetfunda.com/misc/articles/3rd56786-remote-connection-string-question.aspx http://feedproxy.google.com/~r/DotnetfundaResources/~3/spKFf4wbDcI/3rd56785-i-am-working-aspnet-web-application-with-db2-provider-with-c.aspx I need this as an example only in DB2 select orderdate from Orders where month(orderdate) = month(getdate())-1 If anyone knows please help me</s ... ... <p><a href="http://feedads.g.doubleclick.net/~a/cIfhLe6KbKAIuOH_45RuAjHBxJQ/0/da"><img src="http://feedads.g.doubleclick.net/~a/cIfhLe6KbKAIuOH_45RuAjHBxJQ/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/cIfhLe6KbKAIuOH_45RuAjHBxJQ/1/da"><img src="http://feedads.g.doubleclick.net/~a/cIfhLe6KbKAIuOH_45RuAjHBxJQ/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/DotnetfundaResources/~4/spKFf4wbDcI" height="1" width="1"/> Thu, 17 May 2012 12:00:00 PM GMT http://www.dotnetfunda.com/misc/articles/3rd56785-i-am-working-aspnet-web-application-with-db2-provider-with-c.aspx http://feedproxy.google.com/~r/DotnetfundaResources/~3/gXeGbeep7y4/3rd56784-software-installation-problems.aspx Hi I m using Windows 7 OS. I need to install a software 'Mini link Service Manager' by Ericsson. When I try to install it I get following error message: &quot;Setup has detected that MSDE 1.0 is ... <p><a href="http://feedads.g.doubleclick.net/~a/M9AHYJM5vaiaI7ziyjjZ_xeSxdY/0/da"><img src="http://feedads.g.doubleclick.net/~a/M9AHYJM5vaiaI7ziyjjZ_xeSxdY/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/M9AHYJM5vaiaI7ziyjjZ_xeSxdY/1/da"><img src="http://feedads.g.doubleclick.net/~a/M9AHYJM5vaiaI7ziyjjZ_xeSxdY/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/DotnetfundaResources/~4/gXeGbeep7y4" height="1" width="1"/> Sat, 19 May 2012 12:00:00 AM GMT http://www.dotnetfunda.com/misc/articles/3rd56784-software-installation-problems.aspx http://feedproxy.google.com/~r/DotnetfundaResources/~3/LN7Mbo6bGPY/3rd56783-missing-index-it-causes-table-scan.aspx Hello all, There is a table 'RBOTRANSACTIONSALESTRANS' with 500,000records, maximum row size 912, and minimum row sieze 708. The cluster index is like: /****** Object:&nbsp; Index [I_20163TRANSA ... <p><a href="http://feedads.g.doubleclick.net/~a/LghHUhI114magYNuuVv396ySi1I/0/da"><img src="http://feedads.g.doubleclick.net/~a/LghHUhI114magYNuuVv396ySi1I/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/LghHUhI114magYNuuVv396ySi1I/1/da"><img src="http://feedads.g.doubleclick.net/~a/LghHUhI114magYNuuVv396ySi1I/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/DotnetfundaResources/~4/LN7Mbo6bGPY" height="1" width="1"/> Sun, 20 May 2012 12:00:00 PM GMT http://www.dotnetfunda.com/misc/articles/3rd56783-missing-index-it-causes-table-scan.aspx http://feedproxy.google.com/~r/DotnetfundaResources/~3/BKVTDu9Zh1k/3rd56782-pubs-northwind-databases.aspx Hello... Where can I download the northwind and pubs databases mdf format? or scripts to rebuild them? thanks ... ... <p><a href="http://feedads.g.doubleclick.net/~a/uxhBzkSaX0CXo8GVai2iGKgT7sE/0/da"><img src="http://feedads.g.doubleclick.net/~a/uxhBzkSaX0CXo8GVai2iGKgT7sE/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/uxhBzkSaX0CXo8GVai2iGKgT7sE/1/da"><img src="http://feedads.g.doubleclick.net/~a/uxhBzkSaX0CXo8GVai2iGKgT7sE/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/DotnetfundaResources/~4/BKVTDu9Zh1k" height="1" width="1"/> Fri, 18 May 2012 12:00:00 AM GMT http://www.dotnetfunda.com/misc/articles/3rd56782-pubs-northwind-databases.aspx http://feedproxy.google.com/~r/DotnetfundaResources/~3/y8wCNKD9GnM/3rd56781-roll-back-in-sql.aspx Hi guys, I deleted a row in SQL, now i am trying to perform Rollback operation but it shows me this error &quot;The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.&quot;. Below ... <p><a href="http://feedads.g.doubleclick.net/~a/xSs8963enADzVXTv-uXP-odzeZ8/0/da"><img src="http://feedads.g.doubleclick.net/~a/xSs8963enADzVXTv-uXP-odzeZ8/0/di" border="0" ismap="true"></img></a><br/> <a href="http://feedads.g.doubleclick.net/~a/xSs8963enADzVXTv-uXP-odzeZ8/1/da"><img src="http://feedads.g.doubleclick.net/~a/xSs8963enADzVXTv-uXP-odzeZ8/1/di" border="0" ismap="true"></img></a></p><img src="http://feeds.feedburner.com/~r/DotnetfundaResources/~4/y8wCNKD9GnM" height="1" width="1"/> Mon, 21 May 2012 12:00:00 AM GMT http://www.dotnetfunda.com/misc/articles/3rd56781-roll-back-in-sql.aspx