Viewing 15 posts - 3,571 through 3,585 (of 6,401 total)
Uou need to capture then 1 second apart then minus the figures, as the counter value is cumulative.
October 4, 2012 at 8:15 am
Are you running the browser as a domain account or as network service?
October 4, 2012 at 8:15 am
Daniel Bowlin (10/4/2012)
opc.three (10/3/2012)
DebatableDisputable
dispicable
October 4, 2012 at 8:08 am
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
Viewing 15 posts - 3,571 through 3,585 (of 6,401 total)