Viewing 15 posts - 3,571 through 3,585 (of 6,397 total)
To help us help you we do need more information than what you have supplied, while we appreciate that you may not be able to provide us with the data...
October 4, 2012 at 7:49 am
Yes that is the problem, NT SERVICE\SQLSERVERAGENT your referencing is not an account is a virtual group, you need to specify an account not a group to run a service.
What...
October 4, 2012 at 7:35 am
Please attach a screen shot of how you are managing to assign nt service\sqlserveragent to run the service within SQL config manager or services.msc as I cannot replicate it.
October 4, 2012 at 5:57 am
They are all high availability or disaster recovery solutions in SQL, they are far to technical to get into in a forum, I would strongly recommend doing a google search...
October 4, 2012 at 4:32 am
If you have enterprise edition, you could look at change data capture (unsure if it captures the user and hostname), otherwise you will need to use things like triggers which...
October 4, 2012 at 3:47 am
Something like the below
SELECT
LTRating,
RHDate
FROM
Accounts
WHERE
LTRating = 'D'
AND
dateadd(dd, datediff(dd, 0, RHDate), 0) = dateadd(year,-1,dateadd(dd, datediff(dd, 0, GETDATE()), 0)) -- Removes the time element from any datetimes, so eg 1900-01-01 00:00:00.000
October 4, 2012 at 3:45 am
Do you have custom auditing in place, which logs who acesses what and where from? If not you cannot find out who modified the data.
October 4, 2012 at 3:35 am
Well with no backup the only way would be to rebuild the master database, so you will need to ensure that you know all passwords for all accounts, all server...
October 4, 2012 at 3:32 am
NT SERVICE\SQLSERVERAGENT is the virtual group which the account running the SQL Agent Service is granted access to so that you dont have to mess with SQL permissions.
From what I...
October 4, 2012 at 3:19 am
Surely what you want is something like logshipping, mirroring etc which automates all this for you, so whatever happens at the primary is sent to the secondary and you dont...
October 4, 2012 at 3:13 am
You need to set the data source to run using a SQL account to make the report access the DB using a SQL login.
Access to the SSRS web page is...
October 4, 2012 at 3:12 am
The only thing really would be to check the steps.
You could query msdb.dbo.sysjobsteps, but that will only tell you the DB which is in the step screen, it wont tell...
October 4, 2012 at 2:07 am
Quickest answer is you cannot, data driven subscriptions are an Enterprise only feature.
October 4, 2012 at 2:03 am
Viewing 15 posts - 3,571 through 3,585 (of 6,397 total)