Viewing 15 posts - 61 through 75 (of 222 total)
You have to write your trigger.
you can get SPID and user information by using system variables.
SELECT @@SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User Name'
September 14, 2009 at 7:52 pm
sorry earlier post was to script users and logins. Links below are for user database permissions.
http://www.sqlservercentral.com/scripts/Security/66129/
http://www.sqlservercentral.com/scripts/Miscellaneous/31315/
September 14, 2009 at 7:48 pm
hopefully you'll find some answers on previous similar posts
http://www.sqlservercentral.com/Forums/Topic508244-359-1.aspx
http://www.sqlservercentral.com/Forums/Topic757794-6-1.aspx#bm761173
September 14, 2009 at 7:42 pm
I'll recommend the same as of Edogg to create an active directory distribution group with all the users and add the distribution group's email address to the operator. It is...
September 14, 2009 at 7:39 pm
Even i agree with mortalic, logshipping seems the option here.
By the way why are you thinking about mirroring or replication? Does the client want a solution for high availability...
September 14, 2009 at 7:37 pm
Adding a number at the end of username will solve the purpose of duplicate users but doesn't it looks bad. It feels like a prisonor number added to the name....
September 14, 2009 at 6:54 pm
Mani you have brought up a good point, i haven't thought of this before. It will be interesting to see feedback from other users, meanwhile i'll just start my research....
August 26, 2009 at 7:06 pm
glad to have virtualisation now which drastically reduced hardware requirements. The presentation is is funny and i think in one or the other organisation, some managers must be having this...
August 26, 2009 at 7:00 pm
If you are talking about the processing of a log backup outside of the log shipping process, and not including that log backup being shipped to and processed on...
August 16, 2009 at 11:40 pm
Sorry please ignore this post as it was wrongly posted here instead of other post. sorry
August 16, 2009 at 11:24 pm
ps (8/16/2009)
If changing a compatibility mode isn't logged operation, i dont think you can achieve what you want to without breaking the configuration/re-setting it.
NO
i did a small test and found...
August 16, 2009 at 11:22 pm
ps (8/16/2009)
If changing a compatibility mode isn't logged operation, i dont think you can achieve what you want to without breaking the configuration/re-setting it.
NO
i did a small test and found...
August 16, 2009 at 11:06 pm
Sorry for any confusion. I agree with you on your following points
Full backups and differential backps won't break the t-log backup chain once the logshipping is setup.
YES
The problem that...
August 16, 2009 at 10:52 pm
All user connections are killed just before each restore operation in a standby configuration.
Yes this is the drawback of restoring database with STANDBY option. By the way, logshipping is not...
August 16, 2009 at 10:35 pm
As masters above have mentioned, it wont break the logshipping process until Enable the Explicit Log backups. Any log backup done will have different (next) LSN and the destination server...
August 16, 2009 at 10:11 pm
Viewing 15 posts - 61 through 75 (of 222 total)