Luis Cazares


Blogs

7 Best Online Advanced SQL Training Courses to Learn in 2024 and Beyond

By

The world runs on data, and SQL is the key to unlocking its secrets....

Manually Updating Redgate Monitor/SQL Monitor Patch Info

By

This post looks at updating the patch information for SQL Monitor/Redgate Monitor without using...

Bringing the Redgate Seminar to Brisbane

By

We’ve been on a Redgate tour this year, running lots of events to interest,...

Read the latest Blogs

Forums

SQL Server Always

By ptotham

  We have a Windows Server 2022 Failover Cluster with 3 nodes SQL Server...

SSMA - SQL Server Migration Assistant for Oracle question.

By Fletch

Hello SQL Server Experts. Apologies if in the wrong place, was not sure which...

When Are Your Breaks?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item When Are Your Breaks?

Visit the forum

Question of the Day

Default Objects in Clones

On SQL Server 2022, I do this:

USE model
GO
CREATE TABLE dbo.DBALog
(logdate DATETIME2(3), logmsg VARCHAR(2000))
GO
I then create a new database:
CREATE DATABASE INVENTORY
GO
I install a new database application in here with multiple tables, views, etc. I do not run any queries. I then decide to run this code:
DBCC CLONEDATABASE(INVENTORY, Inventory_clone);
GO
What happens?

See possible answers