This is only for Test environment

Steve,

I have thought of option 3. I actually noticed some tables in...

That is what the infratructure we have in our school. We get further ediitons after few months. For time being we want to work at DB. Two DBA's in our...

Oh no It's not to reduct to 20 GB, it is to reduce to <10GB and express edition supports only 10GB per DB. I know deleting data is not a...

Well..I just tried and got the result... Thanks for response..

update tablename

set

columnname = 'Username' + substring(convert(varchar(32), ID), 1, 10)

Is it a good Idea to link Production server to Test server?

Thank you.

Thanks Everyone. So, from the responses what I understood is, better to have 5-10% of mdf for ldf files and need to keep monitoring, so depends upon number of transactions...

Hi Eric,

This SP is really good. Thanks for it. But, what I noticed is it works only for...

Can some one provide me the solution..as I am receiving the following error;

Must declare the scalar variable "@DBName" and

Must declare the scalar variable "@SQLCmd".

I am receiving this error during cursor...

Thank you so much.

Hi Jason,

Thank you for your response. I tried with Adventureworks2008R2 DB. Interestingly, when I run the query...

Will try..Thank you

@dev: If we split the data, then we might encounter constraint issues, right?