Viewing 4 posts - 1 through 4 (of 4 total)
I had success in the sample I created joining three tables from the Adventure Works DB. Employee, EmployeeAddress, and EmployeePayRate and successfully updated the data in the view.
BTW -...
May 3, 2007 at 10:47 pm
While in the view designer, open the properties window and change the update specification to yes. Once you save your view, you should be able to open it and directly...
May 3, 2007 at 9:18 pm
Editing data directly to the table using the SSMS has always been frowned upon from most of the DBAs I know. Being able to control the transaction commit or rollback...
May 3, 2007 at 11:55 am
In a named instance.
Leaving the TCPPort = 0 will cause it to become dynamic
[DlgServerNetwork-0]
NetworkLibs=255
TCPPort=0
TCPPrxy=Default
NMPPipeName=\\.\pipe\MSSQL$PRD01\sql\query
Result=1
April 21, 2006 at 1:21 pm
Viewing 4 posts - 1 through 4 (of 4 total)