2011-06-14 (first published: 2007-12-05)
5,854 reads
Searching through SPs, Tables, Views
Find quickly all stored procedures, tables and views that are somehow related to the search term.
2011-02-09 (first published: 2011-01-28)
2,704 reads
Restore Database from network location
When using GUI tools, it seems the DB cannot be restored from a network path. This is actually possible via the script.
2010-05-11 (first published: 2009-07-11)
2,799 reads
2008-12-17 (first published: 2008-11-10)
2,659 reads
2008-05-27 (first published: 2008-04-10)
1,541 reads
Refreshing Views and Recompiling Stored Procs
When a table is modified by changing the order of fields or changing field type or adjusting field sizes etc, some of the dependent views (or views on views on views :)) may become invalid as they store some metadata in order to run more efficiently. These views would need to be refreshed with new […]
2007-04-20 (first published: 2007-03-20)
1,761 reads
Blogs
Quick 6 month check – how are those learning goals going…?
By HamishWatson
So in January I wrote a blog post on some goals I had this...
“An installation package for the product Microsoft SQL Server 2012 Native Client cannot be found” – during SQL Server 2017 install
By HamishWatson
This blog post is about a situation that initially perplexed me – I was...
Power BI Monthly Digest – July 2019
By Devin-Knight
In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...
Forums
Changing Hardware
Comments posted to this topic are about the item Changing Hardware
Generate Random alphanumeric value based on timestamp
Hi All, Thank you for looking into my question. Does anyone have a script...
Ask SSC