[MS SQL Server] Sql server logins |
| Posted: 29 Mar 2013 05:31 AM PDT Hi,can somebody help me with How to find out all user's permission, roles for all the databases?Thankstina |
| Version not chaning in Change Tracking in SQL Server 2008 Posted: 29 Mar 2013 06:07 AM PDT Hi,When i Inserted few record in a table where CHange Tracking is enable, has generated all different Version Number for column SYS_CHANGE_VERSION and same for column SYS_CHANGE_CREATION_VERSION(For Insert SQL).Whereas in another table(In another DB), the 4,000,000 records only 50 distinct SYS_CHANGE_VERSION generated. So it was like a group of records have same version number.I was under impression that new version will be created each time if there is change is happening(insert,update,delete) in a table.Please guide..Anupam |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment