Viewing 15 posts - 35,101 through 35,115 (of 39,723 total)
You should be able to do this, but keep in mind MSDE dies at around 5 users, which is easy to use unless you are talking very small scale web...
March 15, 2004 at 2:33 pm
If it's full, then backup transaction with no_log should help. Be sure you then take a full backup as you won't be able to point in time restore.
Check the sQL...
March 15, 2004 at 2:31 pm
March 15, 2004 at 2:29 pm
I manage 10 DBAs in a multi-platform, enterprise shop that supports a 12,000 person company. Here the production DBAs have access to production and development. Development DBAs have access to...
March 15, 2004 at 11:18 am
If the table and filegroup are consistent within themselves and there are no changes to other tables that affect then, then consistency shouldn't be an issue.
Other than for performance, filegroups...
March 14, 2004 at 9:50 am
Haven't really looked at this. It seems boot camps are good for preparing you for the test, but not for learning. That's a gross statement, but what I've seen.
March 12, 2004 at 1:53 pm
User sends email to you.
You create view.
![]()
March 12, 2004 at 1:50 pm
This is correct. There was a vendor at PASS 2003 that had a windows auth driver for Java, but that's the only one I've seen. I believe it isn't allowed...
March 12, 2004 at 1:49 pm
I echo most of what's above. Stability and Security need to be to notch before this is released. I wouldn't mind some interim release stuff, but more I'd like more...
March 12, 2004 at 10:27 am
select @myvar = @@rowcount
March 10, 2004 at 9:42 am
Interesting idea and thanks. If I get some time, I'll try to look into the tempdb thing.
March 10, 2004 at 9:36 am
I didn't think of it, but a restore makes sense. Be sure that your integrity has not suffered before you go any further.
March 10, 2004 at 9:35 am
You can set the retention for the jobs in the history tables.
March 9, 2004 at 3:20 pm
The with INIT should overwrite the previous backup. Not sure why it doesn't work here. I take a different approach. I make a new filename everyday, so I have the...
March 9, 2004 at 11:40 am
Viewing 15 posts - 35,101 through 35,115 (of 39,723 total)