Viewing 7 posts - 1 through 7 (of 7 total)
Hi Jeff, thank you for response.
I tried OPENDATASOURCE instead of OPENROWSET.
SELECT * FROM OPENDATASOURCE ('Microsoft.ACE.OLEDB.12.0', 'Data Source=\\server\share\filename.xls;Extended Properties="Excel 12.0;IMEX=1;HDR=NO;"')...['2014$']
It's running ok again when sql server is connected in...
March 2, 2015 at 10:25 am
Thanks, but it doesn't work for me. A member of SQLAgentOperatorRole can create/modify/delete the owned jobs only, as an article says and as I tested.
In my environment, developer1 should...
July 25, 2012 at 1:45 pm
Many thanks, after settings MSDTC on SQL2008 it's working now
October 27, 2011 at 7:18 am
Sure it has - it's added manually into jobs generated by DB Maintenance plan, not within DB Maintenance plan itself.
August 5, 2004 at 11:55 am
Mail settings are all right, I've checked it.
I use MS Outlook.
A mail works in all cases except the manually added notification in the jobs created by sql server - db...
August 3, 2004 at 11:56 am
Books Online:
"With Windows Authentication mode, the user account that runs SQL Profiler must be granted permission to connect to an instance of SQL Server. The login account also must...
July 30, 2004 at 1:05 pm
IMHO it is something wrong with data and log files of tempDB. You can try to put the files tempDB.mdf and templog.log into this server's DATA folder. You can copy...
July 30, 2004 at 12:56 pm
Viewing 7 posts - 1 through 7 (of 7 total)