Viewing 15 posts - 2,341 through 2,355 (of 6,216 total)
Seems like a good idea. Think we may have to rework a little to get there, will have to see how we handle scripts internally. We're still catching up on...
April 2, 2003 at 1:13 pm
I agree its mgmt that makes the difference. Right now I wear two hats, DBA and developer, so it's become easier to make sure I do things I agree with!
Andy
April 2, 2003 at 8:38 am
Access pretty good at some things, nothing wrong with using it. Format/layout - in other words you want to write a query to bring back the data you need as...
April 2, 2003 at 7:58 am
How big are the reports? Handling concurrent users is not as hard with a SQL backend, you can use locking hints to make it even better if you don't care...
April 2, 2003 at 5:46 am
Of course. Though if you had varchar parms, you'd have to used fixed length strings for your params, or do length checking inside the sub. It's a fair point. As...
April 2, 2003 at 5:43 am
If you build up a string to do the change, it's dynamic sql, which means you have to use either exec(@sql) or sp_executesql(@sql) to run it, and when you do,...
April 2, 2003 at 5:37 am
Havent tried it, doesn't sound fun. Seems like you could shortcut it, what you need to know is the SID for the new account. If you have that, you could...
April 2, 2003 at 5:35 am
I agree that it's better to format and reinstall when you upgrade. The data in SQL, including packages, is pretty easy - I just stop the service, copy all the...
April 1, 2003 at 11:19 am
You can do log backups of MSDB, you just have to change the recovery mode. Then every time SQL starts you have to reset it, MS apparently prefers it to...
April 1, 2003 at 5:25 am
Most common way is as Chris indicates, put what you need done in table (queue), then run a job periodically or have an insert/update to the table run sp_start_job. Which...
April 1, 2003 at 5:23 am
April 1, 2003 at 5:21 am
We have a dev server where they have sysadmin access, some leverage it more than others, but it does keep me from being the bottleneck. Once code is ready, they...
April 1, 2003 at 5:20 am
Agree with that - a web service is just about ideal for this type of thing, would let you keep the authentication off site.
Andy
March 31, 2003 at 5:47 pm
One way would be to script out everything each night using DMO. Bill Wunder has posted a freeware utility that does just that and checks into VSS. Lately I've been...
March 31, 2003 at 5:02 pm
Viewing 15 posts - 2,341 through 2,355 (of 6,216 total)