Schema changes to SQL Server - Microsoft SQL Server

System Audit

I am working with an old version of SQL Server (6.5), but the same
mechanism may exist in later versions.

If there were any changes made to the database schema, would this be
recorded somewhere within the database?

Would there be some way of determining if there had been any schema
changes within the past year?

I am presuming all schema changes would be mediated by the SQL command:
"ALTER TABLE"

Thanks!

Nov 9 '06 #1

Subscribe Reply

1665

Erland Sommarskog

System Audit (pa************ *@gmail.com) writes:

I am working with an old version of SQL Server (6.5), but the same
mechanism may exist in later versions.

If there were any changes made to the database schema, would this be
recorded somewhere within the database?

Would there be some way of determining if there had been any schema
changes within the past year?

I am presuming all schema changes would be mediated by the SQL command:
"ALTER TABLE"

No, they are not recorded anywhere. Not in SQL 6.5, nor in SQL 2005, the
latest version of SQL Server. In 6.5 up to SQL 2000 there is a column
schema_ver in sysobjects which is incremented by 16 when you perform a
change to a table, but that is not much.

Of course, they are in the transaction log, together with everything else
that has hapened to the database.

By the way, it's not much you can do with ALTER TABLE i 6.5...

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Nov 9 '06 #2

Similar topics

2786

Installing, creating database, updating schema?

by: Robin Tucker | last post by:

Hi there, I have a database on my test machine that will need to be installed on users machines. I would like to create the database with the given schema on the users machine and also with some suitable default values in the tables. I note that although I can script the schema so that re-creating the structure of the database is simple on the users machine, I cannot script the contents of the tables also (automatically). What I would...

Microsoft SQL Server

43227

What does schema mean?

by: wackyphill | last post by:

I know in SQL Server the terms Database and Catalog are used interchangably. But a table is also assigned a schema. As seen in the INFORMATION_SCHEMA.Tables View. I don't get what this schema qualifier is all about. Like if a table has a schema of dbo. Can someone explain the relationship the schema has and what it is? Thanks.

Microsoft SQL Server

2371

Does anyone use SSIS for database schema maintenance?

by: Ben | last post by:

We currently use SSIS to build DTS packages in which we store changes to our database schema, as well as scripts that need to be run upon each release. This works well for small sets of changes that never need to be updated or for architectures with only one database. We store each of the changes included in the package in separate files, which are tracked using version control. It is growing time consuming to maintain parity between...

Microsoft SQL Server

2585

how to set my path to connect ms access on web server

by: PALLAVI SHARMA | last post by:

Sir, i have configure the ms access file on webserver. MS. Access file is showing in .../db/mohan.mdb on web server. could you tell me what path should in write in my language to update the database.. Can i repalce the the database on webserver whild drectly copy and paste method... will it work kindly help me

ASP.NET

9562

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10542

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10289

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10068

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9119

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6840

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5625

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4274

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2968

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General