Viewing 15 posts - 5,821 through 5,835 (of 6,400 total)
what you asking for is a trigger
take a look at triggers and the before update statement, you can then have an audit table
so for example i have the below table...
February 24, 2012 at 1:28 am
SQLKnowItAll (2/23/2012)
Figured it out...
SELECT *FROM msdb.dbo.sysmail_profile p
JOIN msdb.dbo.sysmail_principalprofile pp
ON p.profile_id = pp.profile_id
WHERE pp.is_default = 1
I have 4 accounts and 4 profiles, they all show in profile and principal profiles but...
February 24, 2012 at 1:13 am
sp_msforeachdb 'USE [?];
select
DatabaseName = DB_NAME() ,
CollectionDate = CONVERT(DATE,GETDATE()),
a.FILEID,
[FILE_SIZE_MB] =
convert(decimal(12,2),round(a.size/128.000,2)),
[SPACE_USED_MB] =
convert(decimal(12,2),round(fileproperty(a.name,''SpaceUsed'')/128.000,2)),
[FREE_SPACE_MB] =
convert(decimal(12,2),round((a.size-fileproperty(a.name,''SpaceUsed''))/128.000,2)) ,
a.NAME,
a.FILENAME
from
dbo.sysfiles a'
February 24, 2012 at 12:51 am
please attach a screenshot of the alert system tab by right clicking on the SQL agent in Ssms so we can see the settings being used to send notifications
February 23, 2012 at 11:58 am
you don't need a default mail profile so maybe that's why nothing is being returned from principal profile.
February 23, 2012 at 10:41 am
SQLKnowItAll (2/23/2012)
Sorry... My point there was that the default has been changed, but SQL Agent probably has not been restarted.
Forgot about that, always catches me out, something so simple
February 23, 2012 at 9:18 am
your not confusing the default mail profile in the actual database mail configuration page for the mail profile sql agent is using are you?
February 23, 2012 at 9:17 am
in excel you can give it a connection which connects to sql and runs a query, this can be saved and refreshed with up to date data as and when...
February 23, 2012 at 9:16 am
there is no best way to fail back as they are both the same in essence
either setup logshipping again and then fail over again, then setup logshipping again
or
backup secondary, restore...
February 23, 2012 at 9:10 am
you need to look further back, find out why the full text catalogs went offline
February 23, 2012 at 9:04 am
you could take a look at ssis, to export data overnight from SQL to excel files, or use excel and embed a query into the spreadsheet so it can be...
February 23, 2012 at 8:50 am
rocky (2/23/2012)
February 23, 2012 at 8:47 am
you would want to bring the DB's online so you will have to issue a command to each DB with the WITH RECOVERY statement and then resolve any issues with...
February 23, 2012 at 8:27 am
are you extracting the data from DB1 to DB2? or just out into a report direct from the base tables?
February 23, 2012 at 8:19 am
Viewing 15 posts - 5,821 through 5,835 (of 6,400 total)