2011-06-14 (first published: 2007-12-05)
5,864 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,714 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,873 reads
2008-12-17 (first published: 2008-11-10)
2,667 reads
2008-05-27 (first published: 2008-04-10)
1,579 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,799 reads
Blogs
VMware & SQL Server 823-824 alerts
By kleegeek
We’ve been tracking a weird state with SQL Server virtual machines on VMware and...
Daily Coping 18 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Storage Field Day 23 – SIOS
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
Forums
Search not working???
Hi, We have a user that is not an administrator that says when they...
sql server enterprise edition or standard
Hello, I was looking over the Edition specifications, and Standard is capped at 128...
Quick Question on 2019 to older version?
A client of ours is upgrading their database to SQL Server 2019. The edition...
Ask SSC