I would think Andy it's all a matter of resources and corporate culture. My company has an old school mainframe culture where everything has its checks. It also...

quote:

---

I need to be able to do this both ways in SQL 7 which I have now and SQL 2000 which will...

We have a similar QA process. The problem comes in where you have enough money at stake to where QA is rushed through with executive overrides. Then when...

I used the Transcender and found it to be an excellent investment. If you can pass one of their tests, you're almost guaranteed to pass the real thing. ...

ARe you running SQL 2K or 7.0?

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

Sure. In your Execute SQL task, use syntax like this:

SET @LOCALVARIABLE = ?

Then in SS 2K, click Parameters to specify which global variable the ? represents. In SQL...

What is your identity column set to right now? Is it over 2 billion? You may have to reseed that or the system table that logs the intervals.

Brian...

If you're trying to restore a database from a different sort order onto a 7.0 box, you may want to install a SQL 7 box in parallel with that sort...

This will apply to each and every database in 7.0. The only way to change it after installation is to rebuild the master. Another problem is you can't...

The main problem I'm experiencing is that the development manager will call me and demand that something be done in production ASAP. I'm used to defined processes in production,...

I'm not too proud. Maintenance Wizard is the way to go. If you use it though, NEVER check the Repair Minor Problems checkbox. In every build of...

I'm a little *old school* and use Source Safe after scripting out the database. RedGate's SQL Compare is an excellent investment though and they're cheap (under $100).

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight

It must be some type of scheduled task that did this. Index rebuilds would easily do this on a large database. You may want to invest in LogExplorer...

I'm afraid there's not really an easy way to do this. Check out Les Smith's java encryption article on this. The encrypt function has no decrypt counterpart. ...

If you're running SQL 2K, make sure you have SP1 installed when doing this. I had some issues where my GO statements were bugging out.

Brian Knight

bknight@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bknight