The EXECUTE permission was denied on the object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’.
Issue : Today I have read one issue over one forum, One user is having below 3 DB roles on MSDB...
2013-01-09
10,710 reads
Issue : Today I have read one issue over one forum, One user is having below 3 DB roles on MSDB...
2013-01-09
10,710 reads
Reblogged from MSSQLFUN:
Issue : Today I have read one issue over one forum, One user is having below 3 DB roles...
2013-01-09
5,361 reads
CMD code to upload file direct into root of FTP site of server
@ echo off
REM ******** this batch file is to...
2013-01-07
1,660 reads
We all know that SQL Server can have 1 default instance & many named instance.
But I want to check, How SQL...
2013-01-04
1,198 reads
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.
Here’s an excerpt:
600 people reached the top of...
2013-01-03
706 reads
2012-12-31
1,225 reads
2012-12-25
904 reads
The 8th cumulative update release for SQL Server 2008 Service Pack 3 is now available for download at the Microsoft...
2012-11-22
929 reads
The 1st cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft...
2012-11-22
1,983 reads
Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 is to restore a full database backup...
2012-11-19
2,612 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have a table. Structure in script below. I have to compare and see...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers