Viewing 15 posts - 16 through 30 (of 112 total)
Can you provide the schema for the audit table?
By the looks of it you are trying to insert the JOB_POSTING_NUM column into the audit table and I imagine...
April 17, 2013 at 11:48 am
How are you creating your profiles and accounts, using the GUI or scripts?
If you are using scripts can you post them please?
Cheers
Chris
July 27, 2012 at 9:08 am
Some additional info;
I also noticed that the subscriber server had a collation of SQL_LATIN1_GENERAL_CP1_CI_AS whereas the publisher is LATIN1_GENERAL_CI_AS I changed the subscriber database to LATIN1_GENERAL_CI_AS but still get...
January 12, 2012 at 2:03 am
You can use the below link to help with DBCC MEMORYSTATUS
http://support.microsoft.com/kb/907877
You could also look at any of the below quieries and modify them to suit.
-- Listing System memory...
October 14, 2011 at 5:14 am
Using them as a "cobbled together" audit process would surely invalidate the license terms?
Thansk
Chris
October 12, 2011 at 9:46 am
Are thier resources avaiable on both source and destination servers?
October 12, 2011 at 7:09 am
Sounds like something might be delaying log truncation. Search Transaction Log Truncation in BOL.
Thanks
Chris
October 12, 2011 at 7:07 am
I disagree, this shoulds like you would be in breach of the licensing terms. I would try to seek an answer from Microsoft just in case.
Thanks
Chris
October 12, 2011 at 6:55 am
There are many way's of becoming a DBA as there are many different types of DBA (development, production,accidental, architect etc etc). Have a look at the below link.
October 12, 2011 at 6:53 am
Build your scripts dynamically by querying system catalog views etc. That way you are not executing scripts for a pre-defined list of databases and you can make them re-runnable.
Thanks
Chris
October 12, 2011 at 6:51 am
You could use DBCC MEMORYSTATUS.
Thanks
Chris
October 12, 2011 at 6:48 am
Can you provide some more information please?
Package configuration / properties?
Thanks
Chris
October 12, 2011 at 6:47 am
Looks like the restore of the full backup is being done WITH RECOVERY. In order to restore your transaction logs the full backup needs to be restored WITH NORECOVERY....
October 12, 2011 at 6:45 am
Viewing 15 posts - 16 through 30 (of 112 total)