In SQL 2000, I could simply connect to a local host server (which I made in installation) and connect to a server on a local host. In SQL 2005, things are obviously different. Does someone know how to make a local server in SQL 2005 and make a database (or transfer a 2000 database) and simple work offline? This is for school so thats why it is offline.
I still would not turn my printers off, the energy on standby is minimal, i like them ready to be used. I can kind of understand your reason for disabling the spooler, never done it myself, seems like a waste of time, anyway I use a Mac for most things these days. The one thing I must get in the habit of doing is turning the scanner off from the mains, i have a smart plug that I will stick on it, the scanner have a external PSU and still pull a fair bit of energy, even when not in use and I don't use it that often.
I can understand turning the printers off, maybe, but the energy they use while on standby is very small, my Brother LED printer, uses less than a watt in deep sleep, the same as the Epson printer. So compared to other stuff they use nothing. I don't use the printers as much as i used to, I want to use the Epson more, which is an ink-jet, that is why I got it to do photos and crafting stuff.
Turning a laser off is fine, mine will go to a off state, it then uses even less energy. The Brother while it is a LED printer, it works the same way as a Laser printer, but with LEDs instead of a laser.
as i said, i don;t use the printers as much asi used to, but I like the idea that they are there when I need them.
Question
alfaaqua
Hey
In SQL 2000, I could simply connect to a local host server (which I made in installation) and connect to a server on a local host. In SQL 2005, things are obviously different. Does someone know how to make a local server in SQL 2005 and make a database (or transfer a 2000 database) and simple work offline? This is for school so thats why it is offline.
Link to comment
https://www.neowin.net/forum/topic/900604-i-want-to-make-a-local-sql-server-2005/Share on other sites
8 answers to this question
Recommended Posts