sql change automation

Article

Phil Factor describes how custom pre- and post-deployment scripts work, when doing state-based database deployments with SQL Compare or SQL Change Automation, and how you might use them to, for example, add a version number to the target database, specify its database settings, or stuff data into some tables.

2019-11-18

Automating Builds from Source Control for the WideWorldImporters Database

by Additional Articles

Redgate

Automate

Article

Kendra Little shows how to get the WideWorldImporters database into version control, using SQL Source Control, and then set up an automated database build process, using Azure DevOps with SQL Change Automation.

2019-04-17 (first published: 2019-04-03)

Table rowcount

by ishaan99

Redgate

Topic

Does any one have a script handy that gives you the rowcount of all user tables on a database. I have one but it gets the result from sysindexes which sometimes is notuptodate. Also I wont prefer anything witha cursor as that might slow down the server. any scripts other than these two.Thanks

2005-05-27

CSV Rendering

by Prasad-Bhogadi

Redgate

Topic

I have a report which takes lot of time to render, rather the stored procedure returning the data to the report consumes good amount of time because of the number of records and conditions in the stored procedure, So what I need to implement is when the report is invoked I am displaying different rendering […]

2005-05-18

2 reads

UPDATE a table using results of a UNION query

by Keith-Walter-210080

Redgate

Topic

Hi, I am having trouble figuring out how to do this, I am a bit green so there may be a better way than my approach. I have a series of queries (2) in an Access Front-End that are quite slow. The first is a UNION that joins 2 views, the second is an update […]

2005-05-18

2 reads

RE: Permissions

by Paula-196779

Redgate

Thanks, that makes sense.

2005-05-18

RE: Permissions

by Steven-2

Redgate

Public access gives the user what ever permissions are assigned to the public role.You can have one database owner, but many people in the dbo group. dbo's have full access to the database in question.

2005-05-18

RE: urgent please

by Ninja's_RGR'us

Redgate

insert into record0 select * from record001 where left(FirstCol, 2) = '00' AND ( agency is null or trans_id is null or ISNUMERIC(trans_id)=0 or isnumeric(accounts_trans)=0 or isnumeric(baccounts)=0 or isnumeric(daccounts)=0 or isnumeric(osa)=0 )

2005-04-29