SQL 2005 Restore Script Generator
This script will generate a restore statement with supporting MOVE operations to a new directory structure.
2011-12-13 (first published: 2008-05-29)
3,867 reads
- Interests: Anything with two wheels and a motor.
Delete files older than n-days via T-SQL
Delete files on a fileshare leaving behind files not older than n-days.
2011-09-13 (first published: 2008-04-02)
8,581 reads
Powershell/SMO: Unload table schema, dri, perms & data.
PSH script to unload table schema, dri, permissions and data to file(s).
2008-06-10 (first published: 2008-05-07)
1,063 reads
Blogs
Daily Coping 8 Dec 2022
By Steve Jones
Today’s coping tip is to be curious. Learn about a new topic or an...
#PowershellBasics: Warnings and how to hide them.
One of my favorite parts of having a new job is that I learn...
Daily Coping 7 Dec 2022
By Steve Jones
Today’s coping tip is to stop for a minute when you walk outside and...
Forums
Problem Importing NULLs in varchar field
hello, This is something I'm really struggling with and haven't found much when I...
SQL Server 2022 is RTM
You can get your hands on SQL Server 2022 right now and this forum,...
Blocking
We were getting constant blocking on the db server. However, after stopping the process...
Ask SSC