Viewing 15 posts - 2,656 through 2,670 (of 6,216 total)
If its just backup space that concerns you, you should take a look at both SQLZip and SQL Litespeed, both advertise here on the site. You can really cut the...
January 20, 2003 at 4:55 pm
Generally you want it to auto size (unless you're running with AWE enabled). In worst case if you're out of memory some queries will fail, but they shouldnt get disconnected....
January 20, 2003 at 4:53 pm
January 20, 2003 at 3:10 pm
January 20, 2003 at 1:17 pm
Hard to beat several minutes. Seriously, your options are to restore from backup, detach/copy/attach (which takes the production db down), or snapshot. What you could do is make the initial...
January 20, 2003 at 8:34 am
What library database? One that you're using in production?
Andy
January 20, 2003 at 8:30 am
Something else to keep in mind is that not all errors are errors - some are business logic related. If you know an update should only affect one row and...
January 18, 2003 at 1:16 pm
Or maybe you've granted NT login access to the tables?
Andy
January 18, 2003 at 9:08 am
Primary key is a requirement for transactional. Snapshot is just a bcp copy, so no requirements at all. Merge adds a uniqueidentifier to each table - so even though its...
January 18, 2003 at 9:07 am
Definitely will get put in the newsletter. NetMeeting is interesting, but dont know if we have hardware to support it - depending on many things I suppose. We'll try to...
January 18, 2003 at 9:05 am
Try it like this:
insert employee (empname,date) select empname, '01/17/2003' from department
Andy
January 17, 2003 at 10:56 am
January 17, 2003 at 10:12 am
Please dont cross post - did you get an answer on the other post?
Andy
January 17, 2003 at 10:07 am
Hopefully MS will get to the point of making SQL so that SA's dont necessarily have access to the data as part of administering. Look at NT security, entirely common...
January 17, 2003 at 10:07 am
Cool. We'll try to do something maybe early Feb. MS Messenger, Yahoo, other?
Andy
January 17, 2003 at 9:37 am
Viewing 15 posts - 2,656 through 2,670 (of 6,216 total)