Technical Article

Dynamically Alter all your Tables.....

This script allows you to dynamically alter all the tables in your database.  In the script i am building up an alter statement that adds a 'TimeStamp' column a table.If anyone knows a better way to do this kind of thing, feel free to drop me a mail (jamie.moffat@infographics.co.uk)

You rated this post out of 5. Change rating

2002-07-04

739 reads

Blogs

What Does Redgate Test Data Manager Do?

By

At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...

Extracting PostgreSQL database metadata for presentation in Excel format

By

(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...

Change Notebook Spark Session Time-Out in Microsoft Fabric

By

You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...

Read the latest Blogs

Forums

some questions related to Ola hallengren maintenance scripts

By vsamantha35

Hi All, I have couple questions related to Ola Hallengren's maintenance script. If anyone...

How to Alert When SQL Queries Exceed a Time Limit During Execution?

By IT researcher

I've been exploring various methods to monitor and alert for long-running queries in SQL...

3rd Friday of the Month

By water490

Hi everyone I need to find the last business of the week.  In most...

Visit the forum

Question of the Day

SQL Express Agent

How can I run SQL Agent with SQL Server Express 2022?

See possible answers