Numbers Table

Reference parent datacontext binding.

Rebuild indexes

Wrong threads crash

Put the following in the viewmodelBase

Example call

Adding a foreign key

Adds foreign key in tblDisplay for lnkclientID which exists in tblClient as IDClient

 

Adding weak Link

Adds a weak link (lnkAddressID) between tbl_SUB_SubscriptionContract and tbl_SUB_Address. Conditions accepted:

- ID has to exist in tblAddress

- 0 values accepted

 

DateAdd

The DateAdd() Functions adds/subtracts a specific interval to a specified date

 

Example:

Using the DateAdd function in a loop to add 1 month to each date

Data Execution Prevention workaround

If you ever get those applications that wont allow you to run more than one instance, try the following:

- Right click on “Computer” or “My Computer”
- Select “Advanced” or “Advanced System settings”
- Under Performance heading; select “Settings”
- Select “Data Execution Prevention”
- Select “Turn on DEP for all programs and services except those I select.
- Select “Add” and add the required programs to the list.
- Hit Ok

Hope that helps!! :)

Configure Windows Firewall for SQL Server

After a fresh install of an SQL instance, you may find you cannot connect to it from another machine on the network. It might be that the firewall is blocking it. Try the following on the server:

- Open Windows Firewall:
– Allow programs to connect
– Add sqlbrowser and sqlserver found in
C:\Program Files\Microsoft SQL Server\MSSQL10_50.[INSTANCENAME]\MSSQL\Binn\sqlservr.exe
C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe