Copy a database between servers with one command
This tool is a helper for your daily work to copy easily databases between Servers/instances and do all the necessary stuff for you.
2015-12-04 (first published: 2014-09-23)
30,570 reads
Copy Database Script
Script move of DB files from one location to another
Generates Scripts to move DB files from one location to another SQL and powershell scripts
2016-04-11 (first published: 2014-03-19)
3,616 reads
Custom Event ID
Does anyone know how to write a custom Event ID to the Event log from SQL ? I see xp_logevent and a couple of other similiar tools, but nothing thta allows me to write a custom and unique number to the event log. Does anyone have any suggestions? Thanks in advance CleaVersion: SQL Server 2000 (clustered) latest […]
2004-05-13
10 reads
RE: Foreign Key Name
here ya go Steve,ALTER TABLE user_detail ADD CONSTRAINT FK__user_header__user_detail FOREIGN KEY(user_id) REFERENCES user_header (user_id) NOT FOR REPLICATIONsorry 'bout the formatting. the smirking face is an open paren.
2004-05-13
RE: SQL Server 2000 backup on network device
Try using the UNC path instead as the F mapped drive will not be visible to SQL Agent only the logged in user at the time the map is created.'\\server\drive$\path\filename.bak'
2004-03-24
2004-03-22
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers