LAN Based Connection Between Vb.net 2008 and Sql Server 2008
Hi, if you want to know how to connect vb.net into sql server over LAN based, just pm me.
sql server
Invalid object name in Stored Procedure Alter Command
If you are working with stored procedure using SQL Server Management Studio Tools (SSMS), you will encounter a problem (well, not really a problem) “ Invalid object name” on the name of your stored procedure. Please see screenshot below: This error is not made by SQL Server but rather by SSMS. The solution to this problem is to clear the intelliSense cache. Click on Edit menu => IntelliSense =>
Get the ID of Last Inserted Record in SQL Server
Sometimes you need to know the value of your Primary Key when you insert record in your table. This is true if you have a Master/Detail form and you need to know the Primary key value of the parent table so that you can insert rows in the related table.
Consider the following scenario:
Save, Edit, Delete, Search Into Sql Server 2008 Using VB.NET 2008
Hi this is program you can save,Delete, Edit and search to Sql server 2008 using vb.net 2008,, and the textbox is auto complete from datagridView
Backup and Restore SQL using VB.net 2008/2010
Hi this is program make a vb.net 2008 to back up and restore SQL server
Create Dynamic Tables In SQL SERVER
This program lets you include the field names from datagrid and by defining name of table, you can create table in sql of the included fields. maverickosama www.bitsbyta.com
Connect to SQL Server 2008 through TCP / IP Using VB.NET 2008 Project
Hi this is Vb.net connect sql server using TCP/IP before run this program you need to install a vb.net 2008 and sql server 2008 here in example code:
Hi you need to do this
click all program/ ms sql server 2008 / configuration tool then click SQL server configuration manager
select you server name then rigth click properties you need to enable a TCP and IP add then Restart
Solved: Saving changes is not permitted. The changes you have made...
If you are working with SQL Server Management Studio Tools and encounter the following error when modifying one of your tables:
“Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.”
All you have to do is unchecked the “Prevent saving changes that require the table to be re-created” under the tools menu.
Follow the screenshot below to disable it.
MS Access 2010/2007 database to manage SQL Server scripts
This application allows the user to manage SQL Server scripts. It also allows the user to place SQL Server .SQL scripts in a "Run Once" Windows folder or in a general "Run Whenever" Windows folder. The scripts can be prioritized so they run in a specific order, if necessary. The program works with Windows Logon as well as SQL Server Logon.
Weekly Sales Report using Crystal Reports
The following source code will teach you on how to create a “Weekly Sales Report” using Crystal Reports. The most important part of this project is the use of SQL Statement. Here’s the statement that create a weekly sales report. SELECT TOP (100) PERCENT CONVERT(Varchar, DATEADD(WEEK, DATEDIFF(WEEK, CONVERT(DATETIME, '1900-01-01 00:00:00', 102), Date), CONVERT(DATETIME,