Gary,For log shipping, the secondary server should be in read-only mode. There is nothing wrong with it. With you having mentioned that all the copy and restore jobs are successfully, i can't think of anything else. Can you verify that the loginhistory table is in the log shipped database ?
2004-09-22
Hi stacenic, Liked your post and would be grateful if you could post this script or email it to me on andrewkane17@hotmail.com. Regards Akane
2004-03-31
If you are looking to return just the items despatched during the last calendar month, try using something like this:where oh.date_despatched between convert(char, dateadd(mm, -1, dateadd(dd, -(day(getdate()) - 1), getdate())), 112) and convert(char, dateadd(dd, -day(getdate()), getdate()), 112)This calculates the 1st day of the preceeding month and the last day of the preceeding month with no […]
2004-03-23
If your users are connecting through an application server you can put the SQL Server behind a firewall and just allow access through the firewall to the app server IP address, thus denying enyone else access.
2004-03-04
net stop mssqlservernet start mssqlserverand schedule it at windows level (at command).
2004-03-04
No, not me! But I know a friend who knows someone who has heard, that there might be some people... Actually I only thought about why always reinvent the wheel when someone else has done similar before.
2004-03-03
- keep sql-injection in mind ! Check http://qa.sqlservercentral.com/columnists/chedgate/sqlinjection.asp- just define your variables as sp-parameters and handle your statement in your sp. You will soon discover it's best to work with known predicates.- check http://www.sommarskog.se/dynamic_sql.html and http://www.sommarskog.se/dyn-search.html
2004-03-03
Well I'm getting the hang of this. If you set a global variable to space and then use dynamic properties to set the version id to that then it will always run the latest version. However, do you know a way to dynamically set the filename in an execute package task? Julie
2004-02-17
2004-01-21
If you want the name of the table along with the trigger name: select tbl.name as TABLE_NAME, trg.name as TRIGGER_NAME from sysobjects trg inner join syscomments sc on sc.id = trg.id inner join sysobjects tbl on tbl.id = trg.parent_obj where trg.xtype = 'TR' and sc.text like '%[^A-Z0-9_]sales[^A-Z0-9_]%'
2003-08-31
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers