Schema Change History Report

Feb 1, 2008

There is a report when you click servername, report and run SCHEMA CHANGE HISTORY
I had my SQL 2005 running for a few weeks and this is many listed from day started is there a way to recycle this and clean it up on a weekly basic

View 5 Replies


ADVERTISEMENT

SQL Server Admin 2014 :: Schema Change History - Identify Who Dropped A Table?

Jun 30, 2015

How can I easily identify who dropped a table?

View 8 Replies View Related

Tracking Change History, By Column...

Jun 17, 2004

This one is giving me quite a bit more difficulty then I ever imagined it would...

Essentially I would like to use one table to store the change history for multiple tables. I would like to use an update trigger to check which fields have changed in each record, and write a single record for each field that changed containing the table name, field name, previous value and new value to a history table.

I can't seem to find a good way to do this.

View 9 Replies View Related

SQL Login Password Change History

Oct 4, 2007

Hello.

Is it possible to find out a complete history of when the passwords for any SQL Server logins were changed and by what/whom in 2005 standard edition?

Thanks.

View 1 Replies View Related

History/Data Change File Approach

Mar 4, 2005

I need to record in a table:
Who, When, What Field and New Value of Fields
When changes occur to an existing record.

The purpose is for users to occassionally view the changes. They'll want to be able to see the history of the record - who changed what and when.

I figured I'd add the needed code to the stored procedure that's doing the update for the record.

When the stored procedure is called to do the update, the PK and parameters are sent.

The SP could first retain the current state of the record from the disk,
then do the update, then "spin" thru the fields comparing the record state prior to the update and after. Differences could be parsed to a "Changes string" and in the end, this string is saved in a history record along with a few other fields:

Name, DateTime, Changes

FK to Changed Record: some int value
Name: Joe Blow
Date: 1/1/05 12:02pm
Changes: Severity: 23 Project: Everest Assigned Lab: 204

How does the above approach sound?

Is there a better way you'd suggest?

Any sample code for a system that spins thru the fields comparing 1 temporary record with another looking for changes?

Thanks,

Peter

View 3 Replies View Related

DB Engine :: Stored Procedure Change History Information?

Jun 5, 2015

one of my SQL Developer member had one observation that, size of the parameter 'Parameter_XYZ' in certain stored procedure had changed from 25 to 255 during some production fixes, however suddenly its looks like that, someone has changed it back to 25 instead of 255.

DECLARE @Parameter_XYZ
varchar(25);

Can we figure out in which sprint/drop the stored procedure was changed and the Parameter_XYZ back to 25. Can any log recovery mechanism will get such details.

Can we get stored procedure text between different alteration.

View 4 Replies View Related

Change Control - Schema...

Apr 27, 2001

Hello,

I need to know if the anyone has had success using any sort of tracking tool to manage schema in SQL 7. I'm responsible for several SQL servers, each with upwards of 10 databases - most still in deelopment phase. We use Erwin to store our models and Visual sourcesafe for stored procs and sql scripts.
But now as a Dba I'm looking either:

(1) create a custom database to keep track of schema changes (as they movefrom development to test to prod). OR

(2) buy a 3rd party tools to keep track of schema changes? Platinum?

It's getting too much for a single Dba to manage a busy devel shop with 20 db's. Schema is comming in too often. Only some of our db's are in Erwin.

thanks,

View 1 Replies View Related

Change A Table Schema To DBO

Dec 9, 2013

I have created a table on SQL Server from SAS. The table gets created fine. However, the table schema has my user ID in it (AD-ENTmyuserid.Table1). How can I change the schema to dbo.(dbo.Table1)? It's fine if I have to make this change in SQL Server Management Studio.

View 4 Replies View Related

Turn Off Transaction Log During Schema Change?

Nov 9, 2006

Is it possible to turn off transaction logging when making a table schema change? For example, when expanding a varchar field from 10 to 40 characters? This is occurring on a hosted site for a table with about 150,000 records. The db size is 200 Mb. If I try this normally with transaction logging enabled, I get the dreaded log file is full message, even if I first truncate it.
I was thinking about doing the following instead:

taking the db offline
creating a backup
disabling logging
change the schema
re-enable logging
put db back online
If a problem occurs during the schema change, I would just restore from the backup. Please let me know the following:

Is it possible to turn of the transaction logging for the schema change?
Do you see any problems with the above.
Alternatives?
One alternative is to look into increasing the db size. A second is to add a new field (named temp) to the table, copy the old field to the new field, delete the old field, add another field (with the original field name) with the new schema, copy the temp field to the new field, and finally delete the temp field. This should require less space in the transaction log. Unfortnately, it could possibly affect some linked Access databases with the new field order.
Thanks in advance.

View 5 Replies View Related

Change The Schema Of A Mirrored Database

Aug 8, 2007



Simple question, I hope. I need to add a column to a table of a database that is mirrored. How do I have to do that? Do I need to stop mirroring? Is it sufficient to simply pause mirroring? If I make the change on the principal db, what do I need to do the make the same change on the mirror?

Thanks,

View 6 Replies View Related

Schema Change - Snapshot Replication

Apr 16, 2007

How can I keep schema changes in the subscriber's database when I replicate the snapshot from the publisher?



I just want to move data from a remote server, but it seems that the tables are being dropped which is not good as we use the subscriber as a development box.



Please advise

View 7 Replies View Related

Report History Permission

Jan 30, 2008



Hi All ,
I have a user in Report Manager as Browser.
I want this user to create report snapshots but when i give this permission to this user with Manage report history permission , this user can also make changes on execution properties and history properties of the report.

Is there a way to let the user only and only create & view report snapshots but not modify the execution and history properties of the report ?

View 1 Replies View Related

Change Schema Name On Tables And Stored Procedures

Sep 12, 2006

Hi,Is there a way I can change schema name on tables and stored procedures? How do I do this?I´m very news to SQL and .netThanks 

View 1 Replies View Related

How To Change The Schema Owner In Sql Server 2005?

Apr 22, 2008

Hi,
While i trying to drop the user,i getting the following error:
(Microsoft SQL Server, Error: 15138)"

Now,i wanna change the owner of that schema,Which is associated with the schema,which i am trying to delete.

How to transfer the owner?

Plz help me.

View 1 Replies View Related

Transact SQL :: DDL Trigger On Table Schema Change

Oct 16, 2015

Is to Possible to Create a Triggers to capture Schema (alter table, Drop table) Changes only for certain tables.I don’t want schema change for entire database.

View 7 Replies View Related

Table Names Are Not Changing With Change In Schema Name

Aug 8, 2007

Hello Everyone,

I am working on a dtsx package wherein i am sending the data from OLE DB Source (SQL Server) to OLE DB Destination (Oracle). For development purpose i use DEVLOPMENT environment on oracle but for unit testing i have to use QA or Some other Schema. when i use DEVELOPMENT Schema in ole db destination, tables are accessed under Schema name eg. "DEVELOPMENT"."EMPLOYEE", but when i m chenging schema name to QA table names are not changing as "QA"."EMPLOYEE". Data Flow Task is pushing the data to DEVELOPMENT environment only.


Can Anyone suggest me any remedy for it ?
Or this is one more BUG in SQL Server 2005.


Advice and suggestions are highly appreciated !

Thanks

View 3 Replies View Related

How Do I Change The Schema Of SQL Server 2005 Database Diagrams

May 23, 2008

Hi all.  I'm mapping FKs in a DataWarehouse and I'm wondering if there is a way to change the schema of a database diagram from dbo.
Thanks,
Charlie

View 2 Replies View Related

How To Force View To Change Automatically When Table Schema Changes?

Jan 16, 2004

I am still having problem with making View automatically updates itself when the underlying table schema changes. Running sp_recompile on the view table doesn't seem to work either, as I am still getting old format from the view (in Design mode the view returns the right info, but not when I open the View by doing Open View) even though the underlying schema has changed. Right now I find that I have to go into the View and change it a bit to force a recompilation.

And even if sp_recompile does, it would require that I manually do it each time I change a table. Any idea?

View 4 Replies View Related

Replication: Any Way To Change Table Schema W/o Reinitializing Subscriptions

Mar 23, 2004

Hi all,

I'm admitedly a bit new to the world of replication, so please bear with me. I've got two SQL Server 2000 servers running in different locations. Server A does transactional replication over a push subscription to server B. If I need to make a minor change to one of the replicated tables (for example, dropping a no longer used column or changing a varchar field's length) do I need to drop the subscription, make the changes and then re-initialize the schemas and data?

For minor changes, I really hate having to knock out the site runnign off server B while the subscription is re-initialized and data is bulk copied back over. If I want to just make the changes manually on both servers will that cause problems down the line?

Any help is greatly appreciated.

tia.

-m

View 2 Replies View Related

Replication :: Merge Rep Schema Change And Processing Order

Jul 14, 2015

Question re Merge rep (pull) and processing order.  We have a group of changes associated with an app upgrade, the scripts run fine on the publisher.   Part of the change includes creation of a new table , followed by altering a view to use new table.Following the change at the publisher, when the sync is kicked off from the subscriber, it fails - the alter of the view throws an'invalid object' error with regard to the new table.  Seems as if the view alter is attempted before the dependant table has been created. 

I have tried to amend the processing order of the view using sp_changearticle, which executes (quickly) with a 0 return code.But it is to no avail , the error still occurs.   is it possible to change the processing order for a view article , which will be applied to schema changes ? Have

View 4 Replies View Related

SQL Security :: Unable To Change Guest Schema Owner

Jul 22, 2015

One of our databases has at some point in its dark past had the owner of the guest schema changed to be a named user, rather than the default guest user. Correcting this feels like it would be easy enough by running the following...

   ALTER AUTHORIZATION ON SCHEMA::guest TO guest
but that results in..
   Msg 15150, Level 16, State 2, Line 3
   Cannot alter the schema 'guest'.

I realise the guest schema is a special one, and cannot be dropped, but I'm not trying to do that. End goal is to export the database to a SQL Azure DB, and this guest schema assignment is blocking that process from completing.

View 4 Replies View Related

Snapshot Replication And Schema Change On Sql Server 2000

Aug 10, 2006

can a sql server 2000 snapshot replication

solution handle a schema change.



as far as i know i can't drop a table involved in replication

View 4 Replies View Related

Programmatically Create A Report History Snapshot

Dec 20, 2006

Hi,

To programmatically invoke a subscription we can use -

exec ReportServer..AddEvent 'TimedSubscription', '575F96C6-A1BD-49FD-9C2F-934FC9658780'

How can we programmatically cause a Manual Report History Snapshot to be created.

I know it can be done using the Webservice. How would we do it using the ReportServer stored procedures. Which SP/SP's can we call. With what parameters.

TIA,

Sam.

View 4 Replies View Related

Create Report History Reporting Services 2005

Aug 14, 2007

Hi,

Will someone please tell me how to create Report history(snapshots) in reporting service 2005.


Thanks and regards
Altaf Nizamuddin

View 1 Replies View Related

Can I Show History In Reports Via Previous Snapshots Of The Same Report?

May 2, 2008

I have a report that runs monthly and they want to see the previous 2 months of data. This data is stored no place other than the snapshot of the same report for the previous 2 months. Is there any way I can display the last 2 snapshots/history withing my report? Thanks.

View 1 Replies View Related

History Of Report Definition File For Published Reports...

Jun 26, 2007

I would like to know if there is a way to maintain the history of changes to the reports that have been published to the report server?

I know that the report definitions get saved onto ReportServer database. But let's say a user makes a change to the published report and then saves it back to the server. And that the latest change was incorrect and I have to revert back to the previous version of the published report. Is there a way to do that? Does the report server maintain a history of previous versions.

There is a history for each report and I think that corresponds to the history of report executions (output data). But I am talking about the history of actual report definition.

Thanks for you help.

View 2 Replies View Related

SQL 2012 :: Copy SSRS Report Snaphot History To Another Folder

Mar 17, 2015

How can I make a copy of an SSRS Report history snaphot to another folder in Report Manager. I have a report that has history snapshots. But want a copy of the report snapshot history in another folder for users to view easier in Report Manager.

View 0 Replies View Related

Reporting Services :: Appending Data To A Previous Report Run To Create History

May 12, 2015

We have a need to report on historical data when none exists in the database.

Create a tabular report rdl that is run on a regular schedule. This report run is saved as an Excel sheet that overwrites the previous run, which has the same name.

Report is designed to use two data sources--the database and and the previously run Excel sheet. The data is "merged" using the Lookup function thereby creating a new report that includes the history needed.

View 2 Replies View Related

Reporting Services :: Losing History When Existing Report Is Redeployed With New Parameter Addition

May 29, 2015

We are using SSRS 2012. Before we were with 2005. Both the versions have the problem. When a change made to parameters (like adding additional parameter to existing report or changing default value of parameter) using visual studio on developers machine and re-deploy to server, additional parameter or changes to parameter is not showing up. So, we are first deleting the report from server and then re-deploying. This works fine. But we realized that we are losing history of the report (like data related to this report run from execution log). We need the history of report. It is very important to top management to see the details.When I searched in forums, users say that it still exist in 2012 and 2014 and every one talks about deleting and re-deploying report. I would like to know if there is any other alternate route to redeploy additional parameter and not lose history.

View 6 Replies View Related

Reporting Services :: How To Change Parameter Visibility When Accessing Report From Report Manager

Apr 16, 2015

I am working on reports in SSRS 2008 (not R2)... There are some reports with parameters that are hidden when the report is accessed through normal URL using ReportViewer.asx..The thing is that these hidden parameters need to be visible when the report is accessed using SSRS Report Manager.

View 3 Replies View Related

Change Page Title From Report Viewer/Manager To The Actual Report Name?

Jan 26, 2007

Can a person change the page title from "Report Viewer/Manager" to the actual report name?

View 3 Replies View Related

How To Generate Schema Report In Sql

May 5, 2008

we are using toad for sql server

View 1 Replies View Related

SQL 2005 Standard Report Schema Changes

Jan 28, 2008

i notice there is a nice little report that is maintaining all schema changes, this is becoming rather large.

Is there a way to tidy up the changes on a weekly basic.

Thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved