2011-06-14 (first published: 2007-12-05)
5,862 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,710 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,839 reads
2008-12-17 (first published: 2008-11-10)
2,666 reads
2008-05-27 (first published: 2008-04-10)
1,575 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,791 reads
Blogs
A New Form of Address: Mx
By Steve Jones
When I was presenting at the dataMinds Connect conference, I called on someone in...
Group By Starting Characters
By Kevin3NF
I was chatting with Jeff (b|t) on my team yesterday and the context escapes...
Daily Coping 22 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Maybe It Is DNS
Comments posted to this topic are about the item Maybe It Is DNS
Finding all logins that can alter DDL
Hello experts, Is there a ready-made query out there that I could run on...
Insert records with a where
I want to insert record job allocations only for selected jobs I know the...
Ask SSC