Saturday, 20 August 2016

Skype HTML Call Link

So, you found this page because like me you want to add a link to your website so people can call you via Skype.  Well it's real easy to do, Skype themselves have a page where you can generate some buttons.  But maybe you want a easy text link with no fuss.

Just create a hyper link to :-

skype:********?call

Replace the *'s with the username you want to call, it's that easy.

I have used this myself and it opens Skype and makes the call on a PC or mobile phone. 

Friday, 27 May 2016

SQL Error - The EXECUTE permission was denied on the object

SQL Error - The EXECUTE permission was denied on the object…….

SQL Server has a number of fixed database roles such as db_datareader and db_datawriter, which grants the user read and write access to the tables in the database. There is no role to grant a user permission to execute stored procedures, but this is easily resolved by creating a new role within SQL Server.



The following will work on SQL Server 2005 and above.

1.     Create the following SQL query on the database that is giving the error ( this is usually displayed within the error message )

-- Create a db_executor role
CREATE ROLE db_executor

-- Grant execute rights to the new role
GRANT EXECUTE TO db_executor

2.    1.  Select “Security” and then “Users” on the database.  Locate the user, rick click and select “Properties”
3.    2.  Select the “Membership” tab. 
4.    3.  You will now see the “db_executor” box you can tick this and this should resolve the issue.
jj



Wednesday, 23 March 2016

Enable Voicemail On A Samsung S6 on EE

Here is how to enable voicemail on a Samsung S6 on EE, by default mine did not work, so had to figure this out. 

Enable Voicemail On Samsung S6 On EE

Step 1 – Enable Voicemail

Press “Phone”
Hold down “1” this will dial voicemail.
Press “2” for greetings and enable default or create custom one.

Step 2 – Enable Voicemail On Phone

Press “Phone” to enter phone settings (where you dial from)
Click “More”
Click “Settings”
Under “Call Settings” click “More Settings”
Click “Call forwarding”
Click “Voice Call”

Here you can select options, for example I have “Forward when unanswered” and “Forward when unreachable” set.

Enter +447953222222 as the number (this is EE voicemail) 

Monday, 4 January 2016

Offer Remote Assistance In Windows 10

A quick Windows 10 support tip for you.

Like me you maybe having issues finding the “Offer Remote Assistance” tool in Windows 10.  Well fear not it is there, you will just have to create a shortcut to :-


C:\Windows\System32\msra.exe /offerra


Translate