There have been many suggestions to get this working. I will give you three that worked for me in the order they should be tried.
- Restart your computer. Some of the projects files run in the background. Stop them if you know what they are. Restarting is not necessary just end their tasks) and then try again.
- Go to Solution Explorer, right-click your project go to properties, click Debug, at the bottom there is a check box, click the check box to ‘Enable SQL Server Debugging’.
- Go to Solution Explorer, right-click your project go to properties, click Debug, at the bottom there is a check box, un-check the check box that states ‘Enable the Visual Studio hosting process’.
You can suppress elements that you don’t want to include in a CSV export by doing the following:
- Click an element.
- In the properties windows, Choose “NoOutput” in the DataElement Output property.
Add missing protocol mail handler in chrome settings manually in order to for a gmail compose window to appear when clicking a mailto:firstname.lastname@example.org link on a web site.
1) Click Settings
2) Scroll to the bottom and click Advanced Settings.
3) Under Privacy, click Content Settings.
4) Scroll down and click Manage Handlers.
5) If the mailto handler is missing, do the following.
a) Bring up your gmail in a Chrome Tab.
b) Paste the following into the URL of that tab:
Choose the ‘Allow’ radio button and click done.
c) Go back to your Manage Handlers and the mailto handler should now be there pointing to mail.google.com.
Wrap your head around this one!
Here is an example of an order by in a SQL Statement that shows how specific you can get when ordering your data.
order by location_3,
when location_3 ='c' then
when location_4 = '1' then location_5
when location_4 in('2','3') then name_last
when location_3 ='d' then name_last
when location_3 ='e' then
when location_4 = '1' then location_5
when location_4 in('2','3','4','5') then name_last
when location_3 ='f' then
when location_4 in('1','2','3') then name_last
when location_4 in('4','5') then location_5
when location_3 ='g' then
when location_4 in('1','2','4','5') then name_last
when location_4 = '3' then location_5
In SQL Server Management Studio, you can run the following commands against your MDF database files to get metadata information.
--SQL Server DBCC CHECKPRIMARYFILE with Option = 0
--First, we will use it with zero to check if it is the primary file if so it will return 1 otherwise 0.
DBCC CHECKPRIMARYFILE('C:\Users\jrmoo\Downloads\MDF\Homeschool_Database.mdf',0) WITH NO_INFOMSGS
--Determine version of mdf file
DBCC CHECKPRIMARYFILE('C:\Users\jrmoo\Downloads\MDF\Homeschool_Database.mdf',2) WITH NO_INFOMSGS
--To check logical name, size, maxsize, status and physical name of all files
DBCC CHECKPRIMARYFILE('C:\Users\jrmoo\Downloads\MDF\Homeschool_Database.mdf',1) WITH NO_INFOMSGS
--Checks the logical name, status and path of all files
DBCC CHECKPRIMARYFILE('C:\Users\jrmoo\Downloads\MDF\Homeschool_Database.mdf',3) WITH NO_INFOMSGS
Here are the output results:
1) Open the PDF in Google Chrome.
2) Select Print.
3) Click the Change button in Destination and choose Choose ‘Save as PDF’.
4) Click the radio button to choose your print range.
5) Click ‘Save’.
6) Follow the ‘Save As’ dialog box prompts.
I find this very useful when I have to do a quick reboot in the middle of the day and have multiple explorer windows open that I don’t want to have to drill down and bring up again.
You can see your Trash from Google Calendar on your computer. In Trash, you can:
See deleted events for 30 days
Restore deleted events
Delete events forever
Click the drop-down to the right of the calendar you want to work with.
Select ‘View Trash’.
To restore an event, click the checkbox to the left of the event and click the ‘Restore selected events’ button.
To delete an event(s) permanently, click the checkbox(es) to the left of the event(s) and click the ‘Delete forever’ button.