Viewing 15 posts - 2,416 through 2,430 (of 6,216 total)
Dphilip - great reply!
Is your log reader still running and posting commands? There should be a clean up job that runs, is it? Or do you have subscriptions that aren't...
March 7, 2003 at 5:49 pm
I see the embedded connection string all the time, truly horrible. At least obscure it!
Andy
March 7, 2003 at 5:32 pm
There's a better one for SQL2K:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224071
Basically start with -T3608, detach the db, then either move and reattach, or you can restore (with or without move).
Andy
March 7, 2003 at 5:30 pm
March 7, 2003 at 5:05 pm
You can of course, and that is the right answer. Downside will be (or may be anyway!) blocking.
Andy
March 7, 2003 at 6:34 am
I remain ambivalent on the test prep thing. I study by using a test prep book (if one available), then I go back to the exam requirements until I can...
March 7, 2003 at 6:30 am
Having 4000+ posts doesn't mean I'm always right either? Bummer!
Andy
March 7, 2003 at 6:19 am
I think nextrecordset is a cleaner solution. Maybe it would make sense to build one more proc that duplicates the logic - usp_getallcounts or something like that.
Andy
March 7, 2003 at 6:17 am
Could also put on a separate sub net, configure the router to only have the one route you need.
Andy
March 7, 2003 at 6:15 am
Havent used it either. Think it probably falls in the Access/file based db arena. Are they having problems with their current system that moving to SQL would fix?
Andy
March 6, 2003 at 5:52 pm
Permissions maybe? Havent tested, but maybe even though the account has drop db permission it doesn't have delete permissions on the disk.
Andy
March 6, 2003 at 9:21 am
Seems like it would work. Access works pretty much like sql, date is stored to the left of the decimal, time to the right, formatting has nothing to do with...
March 6, 2003 at 9:20 am
You can query the system tables directly, or use the information schema views, either from Query Analyzer (or use ADO/ADO.Net to run the query will work too).
Andy
March 6, 2003 at 9:01 am
Its bad? I'd run a new backup immediately, safeguard your previous backups, try running dbcc to fix the error. May end up with some data loss, so hopefully your backups...
March 6, 2003 at 8:59 am
It should, assuming you have a chunk of contiguous space to restore into.
Andy
March 6, 2003 at 7:13 am
Viewing 15 posts - 2,416 through 2,430 (of 6,216 total)