Viewing 15 posts - 28,441 through 28,455 (of 39,810 total)
You can nominate someone at http://www.exceptionaldba.com/
Nigel was not renewed in April 2008 as his work commitments prevented him from contributing substantially to the community in 2007. However he is well...
May 29, 2008 at 8:08 am
Haven't seen that. The task should call some sys.databases, so if the account can see the databases in that view, they should come through.
Not sure why you wouldn't see them....
May 28, 2008 at 8:05 pm
Can't do it. Need to take the db offline to move the log file.
May 28, 2008 at 8:02 pm
Does your machine authenticate with a domain when you VPN in?
May 28, 2008 at 8:01 pm
I agree with Matt as well, and also ask that if someone hasn't made any attempt to solve something or figure it out, ask them to. We don't want to...
May 28, 2008 at 2:12 pm
you need to do some math to get the results.
You can divide by 1000 to get seconds, then you'd have to divide by 60 to get minutes, and subtract...
May 28, 2008 at 2:11 pm
You have good points on efficiency, and those items do matter when you compare cars. That's one good thing about the Xprize. They "charge" for electricity so that there's a...
May 28, 2008 at 2:10 pm
Use SSIS, there's a data import wizard in SSMS that will help you.
May 28, 2008 at 2:05 pm
This seems like homework, please ask the OP to make an attempt before you give the answer here.
May 28, 2008 at 2:04 pm
One last thought, perhaps you are backing up to the same file (appending) as well. Are you using INIT in the backups?
May 28, 2008 at 2:03 pm
Matt is correct, this doesn't necessarily work from remote computers by default.
May 28, 2008 at 2:02 pm
there have been quite a few debates on the "green-ness" of hybrids. I think the jury's still out on whether they are better or worse for the environment overall.
May 28, 2008 at 11:50 am
Nothing on the OS is affected. The server stops and SQL does not respond to clients, but the OS isn't changed.
There should be more resources available for the OS and...
May 28, 2008 at 11:44 am
Litespeed coes with an extractor that will extract the compressed backup back to native SQL Server format and then you can perform a restore on any server.
May 28, 2008 at 11:43 am
On separate WANs, you might have networking rules preventing the port from being used.
May 28, 2008 at 11:04 am
Viewing 15 posts - 28,441 through 28,455 (of 39,810 total)