Hi,

1. Are you hosting the database? If no, then customisable databases, but do it this way default schema for base application client schema for client based customisations. . If...

Hi,

Remember SEAT for testing.

Table A

(

Column1 varchar(4),

Column2 int

)

Setup

Select a row of data to be updated.

eg

Select Column1, Column2 from A where Column1 Is Null

Evaluate

Run the test/code

Insert into A_Changes

Select Column1, Column2...

Just backup the database and the encryption key.

Don't lose the encryption key.

There is a scripting tool available if you want to script everything from one server to another. Look on...

http://www.sqlservercentral.com/scripts/source+control/66285/

That's sort of what I was aiming at.

You can populate as many tables as you want with data and just use cartesian joins to give the bulk.

I have reused last...

On other projects that I have worked on, the dev data has occasionally been scrubbed so that names and phone numbers and other account details are gibberish.

Eg John Smith 0406...

Thanks for the feedback Jeff. I appologise to the community for not checking my work more thoroughly.

My next arrticle will be of better quality.

Cheers

Jamie

If you just want the difference between the dates in the two columns

datediff(mm,col1,col2) + 1 to include the first month

eg select datediff(mm,'6/27/13','8/11/13') +1

Cheers

Jamie

😎

I agree we have to view the problem from the clients perspective. Its a skill I pride myself on.

Can I just whinge about the link to the updateable snapshot?

What's wrong...

The semicolon character is a statement terminator. It is a part of the ANSI SQL-92 standard, but was never used within Transact-SQL.

Jamie Ingram

Hi Gail,

Can partial restores be done with the Dev Version?

Cheers

Jamie

Take a look at extending the security model. There is sample code on MSDN.

http://msdn.microsoft.com/en-us/library/aa237550(v=sql.80).aspx

In particular:

IAuthenticationExtension Represents an authentication extension that can be used to authenticate users in Reporting Services.

and

IAuthorizationExtension...

If you just want to run the packages on the new server:

Export your DTS packages using DTSBackup.

Save them to a network location

Create an SSIS job that calls the DTS packages.

Jamie

I dont have access to SQL Server at the moment, so consider this pseudo code. It is untested.

create table #Temp

(

GroupID int;

Col1 varchar2(25),

Col2 varchar2(25)

);

Declare

@Group int,

@Col1...

Fremantle, Western Australia 😎