Archive | April, 2013

TSQL Scripting a Full Text Catalog & Index

One thing that really annoys me in sql server management studio is that when I try to script out a full text catalog, it doesn’t include the full text index within it. The scripting out of sql server objects is an amazing feature, and maybe this is a little oversight, but it is frustrating nonetheless. […]

Continue Reading 0

TSQL Restore Database Backup Nugget

Sometimes its the simple things thats really help – restoring a sql database using transact sql:

Also, to find the logical names from the backup file:

Thanks to Pinal Dave: http://blog.sqlauthority.com/2007/02/25/sql-server-restore-database-backup-using-sql-script-t-sql/

Continue Reading 0