ms sql server (ru)

ms sql server (ru)

  • Transaction log truncating in MS SQL Server 2005/2008/R2 In Microsoft SQL Server 2005/2008/R2 truncation of transaction log is different than in SQL Server 2000.
  • Searching the string in MS SQL Server database Sometimes, in troubleshooting and/or learning new software you need to find specific string or value in SQL database.

    Here is the script to run in Query Editor over the base to find some string. In "set @search_string = 'what.you.are.searching.for';" in quotes you must type in what you search.

    The script is compatible at least with SQL Server 2005/2008... hopefully with later versions also.