Viewing 15 posts - 4,231 through 4,245 (of 9,712 total)
Douglas Osborne-229812 (7/5/2012)
Brandie,Do you have a short example?
Not knowing which of my three suggestions you want an example for, I'll give you the trigger:
--Table is the user table you're logging....
July 6, 2012 at 4:22 am
Giving a W.A.G. because it's been a long time since I learned my AD security... SQL Server is acting with your user credentials in SSMS rather than the service account...
July 5, 2012 at 12:34 pm
bcsims 90437 (7/5/2012)
SQLRNNR (7/5/2012)
crookj (7/5/2012)
Ray K (7/5/2012)
(For the benefit of those outside the USA, that was...
July 5, 2012 at 12:10 pm
Can you add the account via the SSMS GUI? Or does it error out when you hit "OK"?
July 5, 2012 at 11:40 am
Please post CREATE TABLE statements for your tables in the query. Please post INSERT statements with multiple rows of sample data for us to run the query against.
July 5, 2012 at 11:39 am
It would help us to help you if you could post some DDL and sample data in the form of INSERT scripts. Then post an expected result and a copy...
July 5, 2012 at 10:44 am
Have tried loading your entire query into a variable first and doing EXEC(@MyVar)?
Can you run the create login statement by itself without the variable & dynamic SQL?
July 5, 2012 at 10:42 am
You could try logging this with a DDL trigger or coding your own version of an audit by using the undocumented deleted table.
Or you could simply set up some operational...
July 5, 2012 at 10:39 am
SQLRNNR (7/5/2012)
Thanks Brandie. I even like that you posted the script using dbcc timewarp. Notice the publish date is July 24, 2012.:-D
Shhhhh. You're not supposed to tell anyone....
July 5, 2012 at 10:17 am
That tells me Log Shipping isn't set up (or isn't set up properly) on your secondary server.
You'll need to start over from scratch.
July 5, 2012 at 9:10 am
thomasrichardson2000 (7/5/2012)
primary_idprimary_databasebackup_directorybackup_sharebackup_retention_periodbackup_compressionbackup_job_idmonitor_servermonitor_server_security_modebackup_thresholdthreshold_alertthreshold_alert_enabledlast_backup_filelast_backup_datelast_backup_date_utchistory_retention_period
C2BEA283-0F09-49C6-9B2A-1CEE4C626182mydatabase\\rentway1\BACKUP_RENTWAY\\rentway1\BACKUP_RENTWAY4320235497C9B-6E5D-4A1F-A0C2-3FB166FF7FD5NULLNULL60144201\\rentway1\BACKUP_RENTWAY\mydatabase_20120705133000.trn2012-07-05 14:30:05.3472012-07-05 13:30:05.3435760
cheers
Where's the second one? For the Secondary Database?
July 5, 2012 at 8:38 am
Michael Valentine Jones (7/5/2012)
Then you can...
July 5, 2012 at 7:00 am
Oh good grief. Nevermind.
We're getting a new type of file that hasn't been accounted for. DOH.
July 5, 2012 at 6:50 am
rodjkidd (7/5/2012)
Brandie Tarvin (7/5/2012)
http://lasrsff.blogspot.com/2012/07/legend-of-beemen-by-brandie-tarvin.html
Excuse me while I...
July 5, 2012 at 5:24 am
Can you paste the actual command into the thread? Feel free to change the sensitive information. We just need to see the entire command.
July 5, 2012 at 5:13 am
Viewing 15 posts - 4,231 through 4,245 (of 9,712 total)