Marketing Assistant (part time summer placement): http://www.graduateadvantage.co.uk/placement/396
Software Developer (part time summer placement): http://www.graduateadvantage.co.uk/placement/397
Business Development Manager (full time 12 month placement): http://www.graduateadvantage.co.uk/placement/398
Graduate Advantage (funded by Advantage West Midlands) help students and graduates find and apply for paid full-time and part-time work placements, summer internships, graduate placements, and free employability training. They offer placements in all sectors of industry and business across the West Midlands.
Hilltops IT is working with Graduate Advantage in order to find suitable candidates to fill the above positions. "The Graduate Advantage scheme works for us on so many levels." says Hilltops IT CEO, Stephen Siggs "Not only is it an opportunity to work with local colleges to give the students there the chance to work with a commercial enterprise, but also from a business perspective we can get temporary contract staff to work on a couple of projects we simply haven't had time to complete ourselves. What Graduate Advantage in terms of their screening and grant funding also make this a very cost-effective solution which will contribute to the local community."
Our existing graduate employees say that they would have loved to work for a commercial business during their summer breaks. Unfortunately (according to Graduate Advantage) it is not uncommon for students educated in the West Midland to move outside the area in order to get work. There is a focused effort from government and local projects to retain these skilled individuals in the West Midlands. You never know - maybe Hilltops IT will be giving the next Bill Gates, Sir Alan Sugar or Max Clifford their first opportunity in business!
Friday, May 8, 2009
BLOG: Trainer Certification from Glasgow CC
For our Business Computing and Website / E-Commerce training services provided to businesses throughout the UK and to recognise the work which we have done with business in Glasgow specifically through their Business Training Grants Programme, Glasgow City Council has awarded Hilltops IT a Trainer Certificate. Well done to Vivienne Watts, Stephen Siggs and Steven Porter for their work in delivering exemplary training courses for our clients.
For more information on our ACT! and QuoteWerks training, plus website services please phone now on +44(0) 1782 564252 or +44(0)844 357 7360 or email info@hilltopsit.co.uk
For businesses in Glasgow and any other region, we can also help with practical advice on getting training grants for your business, plus we have all the paperwork to hand in order to move smoothly through the grant application procedures.
We look forward to hearing from you!
For more information on our ACT! and QuoteWerks training, plus website services please phone now on +44(0) 1782 564252 or +44(0)844 357 7360 or email info@hilltopsit.co.uk
For businesses in Glasgow and any other region, we can also help with practical advice on getting training grants for your business, plus we have all the paperwork to hand in order to move smoothly through the grant application procedures.
We look forward to hearing from you!
DEVELOPMENT: Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server
Running a query from SQL Server 2008 over a linked server connection to a SQL Server 2000 server causes the following error:
OLE DB provider "SQLNCLI10" for linked server "mylinkedserver" returned message "Unspecified error".
OLE DB provider "SQLNCLI10" for linked server "mylinkedserver" returned message "The stored procedure required to complete this operation could notbe found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider interface, but returns a failure code when it is used.
Or
The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "". The provider supports the interface, but returns a failure code when it is used.
Firstly, SQL Server 2000 SP4 (service pack 4) must be installed.
Then the system stored procedures must be manually upgraded.
Note that when manually upgrading the system stored procedures, we used SQL Server Authentication mode which requires the syntax:
osql -U [adminlogin]-P [adminpassword]-S [linkedservername]-i [location]\instcat.sql
We first entered the line as:
osql -U sa -P myPassword -S myServer -i C:\Program Files\Microsoft SQL Server\MSSQL\Install\instcat.sql
But this just bought up the osql help /? list of parameters. To avoid this, make sure that the -i path is in speech marks!
osql -U sa -P myPassword -S myServer -i "C:\Program Files\Microsoft SQL Server\MSSQL\Install\instcat.sql"
Note that the manual upgrade takes a couple of minutes to run and there are a whole bunch of message and numbers displayed in the command window as it executes. If the process is successful, then the last but one line will read "instcat.sql completed successfully".
In our experience, the SQL Service did not need to be restarted, the fix worked immediately and we were able to query the SQL Server 2000 server from SQL Server 2008 over the link immediately:
SELECT COUNT(*)
FROM myLinkedServer.myDatabase.dbo.myTable
We hope that this tip helps others new to SQL Server 2008 development!
Please see our website for more information on our software development services and software development resources.
OLE DB provider "SQLNCLI10" for linked server "mylinkedserver" returned message "Unspecified error".
OLE DB provider "SQLNCLI10" for linked server "mylinkedserver" returned message "The stored procedure required to complete this operation could notbe found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider interface, but returns a failure code when it is used.
Or
The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "
Firstly, SQL Server 2000 SP4 (service pack 4) must be installed.
Then the system stored procedures must be manually upgraded.
Note that when manually upgrading the system stored procedures, we used SQL Server Authentication mode which requires the syntax:
osql -U [adminlogin]-P [adminpassword]-S [linkedservername]-i [location]\instcat.sql
We first entered the line as:
osql -U sa -P myPassword -S myServer -i C:\Program Files\Microsoft SQL Server\MSSQL\Install\instcat.sql
But this just bought up the osql help /? list of parameters. To avoid this, make sure that the -i path is in speech marks!
osql -U sa -P myPassword -S myServer -i "C:\Program Files\Microsoft SQL Server\MSSQL\Install\instcat.sql"
Note that the manual upgrade takes a couple of minutes to run and there are a whole bunch of message and numbers displayed in the command window as it executes. If the process is successful, then the last but one line will read "instcat.sql completed successfully".
In our experience, the SQL Service did not need to be restarted, the fix worked immediately and we were able to query the SQL Server 2000 server from SQL Server 2008 over the link immediately:
SELECT COUNT(*)
FROM myLinkedServer.myDatabase.dbo.myTable
We hope that this tip helps others new to SQL Server 2008 development!
Please see our website for more information on our software development services and software development resources.
Thursday, May 7, 2009
DEVELOPMENT: rsReportServerDatabaseUnavailable on Reporting Services 2008
Trying to connect to the SQL Server Reporting Services reports server for the first time using http://MyServerName/Reportserver, we got the following error:
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help. SQL Server does not exist or access denied.
Using http://localhost/Reportserver opened a login dialog, but the administrator username and password didn't work.
Discussing this with the company who supplied the server, it came to light that the server name had been changed after SQL Server Reporting Services had been installed.
We resolved this by using the rsconfig utility:
Opening a Command Prompt and executing a line like this:
rsconfig -c -sMyServerName -dReportServer -aWindows -uDomain\Account -pMyPassword
Followed by resetting IIS (Internet Information Services)
iisreset
We hope this helps!
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help. SQL Server does not exist or access denied.
Using http://localhost/Reportserver opened a login dialog, but the administrator username and password didn't work.
Discussing this with the company who supplied the server, it came to light that the server name had been changed after SQL Server Reporting Services had been installed.
We resolved this by using the rsconfig utility:
Opening a Command Prompt and executing a line like this:
rsconfig -c -sMyServerName -dReportServer -aWindows -uDomain\Account -pMyPassword
Followed by resetting IIS (Internet Information Services)
iisreset
We hope this helps!
Wednesday, May 6, 2009
DEVELOPMENT: SQL Server 2008 - saving changes is not permitted
After installing SQL Server 2008 we were unable to save updates to any of the existing database tables. Every time we tried to save a change to the table, we got the following error:
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.
To resolve this, click the SQL Server Management Studio Tools Options Designers option and untick the "Prevent saving changes that require table re-creation" checkbox.
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.
To resolve this, click the SQL Server Management Studio Tools Options Designers option and untick the "Prevent saving changes that require table re-creation" checkbox.
We hope this helps anyone else that's new to SQL Server 2008 development!
Tuesday, May 5, 2009
CONNECTIT: ConnectIT-Sage v1.10.0 released
The new release of ConnectIT-Sage QuoteWerks to Sage link adds support for Sage Instant 2009 Accounts and Accounts Plus.
Sage Instant Accounts is easy-to-use accounting software designed to make managing your money, including VAT, end of year accounts and invoicing, as quick and easy as possible. You’ll have all the information you need to manage your business at your fingertips.
Sage Instant Accounts is a simple bookkeeping package that gives you all the tools you need to successfully manage your finances, accounts, customers and suppliers.
Now Sage Instant Accounts users can take advantage of ConnectIT's time saving capabilities, allowing users to create Product Sales Order, Product Invoice, Product Credit, Service Invoice and Service Credit document types in Sage from the information in their QuoteWerks document.
For more information, please your QuoteWerks reseller or contact us on +44(0) 1782 564 252 or email info@hilltopsit.co.uk
Sage Instant Accounts is easy-to-use accounting software designed to make managing your money, including VAT, end of year accounts and invoicing, as quick and easy as possible. You’ll have all the information you need to manage your business at your fingertips.
Sage Instant Accounts is a simple bookkeeping package that gives you all the tools you need to successfully manage your finances, accounts, customers and suppliers.
Now Sage Instant Accounts users can take advantage of ConnectIT's time saving capabilities, allowing users to create Product Sales Order, Product Invoice, Product Credit, Service Invoice and Service Credit document types in Sage from the information in their QuoteWerks document.
For more information, please your QuoteWerks reseller or contact us on +44(0) 1782 564 252 or email info@hilltopsit.co.uk
Friday, May 1, 2009
Business Development Manager wanted (Stoke-on-Trent)
A new full time position is available for a sales person selling computer software products and services. This is an excellent opportunity to join a small, ambitious, highly motivated and positive team of individuals in a growing business and offers excellent career prospects for the successful candidate.
The role will be predominantly working from the office managing and developing a portfolio of prospective and existing customers locally, nationally and internationally. The successful candidate must be well organised, an excellent communicator over the phone, motivated, confident, highly professional, excellent at building lasting relationships, be able to demonstrate excellent computer skills and have an understanding of the software industry. You will report to the Managing Director and be expected to deliver the agreed levels of revenue and profit, whilst adopting a solution lead, consultative sales approach to ensure that customer requirements are met.
Ideally, you will have experience of dealing with small and medium sized businesses. Experience of contact management, quoting and accounts packages, website and software development processes will also be an advantage.
To start as soon as possible. Candidate must have their own car. Package negotiable, commission based (uncapped).
Please apply in writing to Hilltops IT, Lymedale Business Centre, Lymedale Business Park, Newcastle-under-Lyme, Staffordshire, ST5 9QF or by email enquiries@hilltopsit.co.uk. Please include your up-to-date CV and covering letter.
Strictly no agencies.
Subscribe to:
Posts (Atom)
