Tag Info

Hot answers tagged

3

The logical built in place to put this kind of metadata about columns might be in the description box when the column is selected in the table designer. Behind the scenes this gets saved as an extended property with MS_Description as the property name. It would be extremely pushing it to claim that this is "standard" or common practice though.


3

If I understand what you are asking then like this. WHERE DateModified BETWEEN @BeginDate AND @EndDate AND (@Troop IS NULL OR d.CreatorLEA = @Troop)


2

SSIS code behind is actually a XML value and all components of package will be represented as XML node values within it.This XML can be parsed to identify if it has a reference for our searched table or column. Finding SSIS Packages having References to a Table or Column will help you.


1

Finally found the a solution online which lead me to the actual solution of the problem. Apparently it is an issue with SQL Server 2008 and installing the Service Pack is the answer to this. How can we install a service pack while installing the application: See this article Slipstream Service Packs and Cumulative Updates on a SQL Server 2008 ...


1

Know this is an old question but we've just been working with this, Last month we had to move our distribution server to a brand new machine, (Setup is two machines in AG stand alone distributor and a reporting server) The only real way we found to move distributor server is to completely tear down and rebuild replication, this can be done with right ...


1

No. Committed transactions modify the contents of the database tables first in the transaction log, then in the data files. Unless triggers or other techniques are explicitly set up upfront, there is no way to recover the values stored in the database before the transaction was committed. In order to do that, you have to restore a copy of the database ...


1

sorry to hear that. Well if u havent trimmed transaction log you can do it. Nice articles how to achieve it: http://www.mssqltips.com/sqlservertip/3160/recover-deleted-sql-server-data-and-tables-with-the-help-of-transaction-log-and-lsns/ How do I rollback a dropped table using log?



Only top voted, non community-wiki answers of a minimum length are eligible