FIX:Invoke or BeginInvoke cannot be called on a control until the window handle has been created Error
When I am installing the sql server 2008 on my windows 7 ultimate , I am getting the below error
I googled this error and got this issue the issue with sql server 2008 product when installed on windows 7
Temporary fix for this:
After this error got on the window pop up like above, click on ok and then install the sql server 2008 service pack1
This service pack is available for free down load in the msdn site
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=20302
and this service pack installation fixed this issue.
Please try and let us know if you are still facing the issues.
Thanks for viewing.
Regards,
Chaitanya
Visit site: https://mssqlbuzz.wordpress.com
Send an Email : mssqlbuzz
Get the jobs details in sql server and their status
Hi All,
Please use the below script in the Sql server management studio to see the status of Jobs running on Sql server instance
Use msdb
go
select distinct j.Name as "Job Name", j.description as "Job Description", h.run_date as LastStatusDate,
case h.run_status
when 0 then ‘Failed’
when 1 then ‘Successful’
when 3 then ‘Cancelled’
when 4 then ‘In Progress’
end as JobStatus
from sysJobHistory h, sysJobs j
where j.job_id = h.job_id and h.run_date =
(select max(hi.run_date) from sysJobHistory hi where h.job_id = hi.job_id)
order by 1
Please let us know if you have other options
Thanks for viewing.
Regards,
Chaitanya
SQL Server Management Studio Shortcuts
Hi Folks,
Below are the SQL Server Management Studio Shortcuts
Basic Editing Shortcuts
File Shortcuts
View Shortcuts
Query Shortcuts
Window Shortcuts
|
Advanced Editing Shortcuts
Bookmarks Shortcuts
Function Keys
Intellisense Shortcuts
|
Please check and let us know if you have any concerns
SQL BLOGGING 