Viewing 15 posts - 241 through 255 (of 289 total)
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...
September 6, 2001 at 7:45 pm
quote:
I need to be able to do this both ways in SQL 7 which I have now and SQL 2000 which will...
September 6, 2001 at 4:52 pm
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...
September 6, 2001 at 4:50 pm
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. ...
September 6, 2001 at 4:44 pm
ARe you running SQL 2K or 7.0?
Brian Knight
September 6, 2001 at 5:25 am
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...
September 6, 2001 at 5:24 am
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...
September 6, 2001 at 5:22 am
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...
September 5, 2001 at 5:09 am
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...
September 5, 2001 at 4:52 am
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,...
September 4, 2001 at 8:12 pm
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...
September 4, 2001 at 7:55 pm
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
September 4, 2001 at 7:50 pm
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...
September 4, 2001 at 7:48 pm
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. ...
September 4, 2001 at 7:46 pm
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
September 4, 2001 at 7:28 pm
Viewing 15 posts - 241 through 255 (of 289 total)