you could have a look at this:

http://www.remote-keys.com

DMO is supported in katmai, but it's the last release. after katmai you'll have to move to SMO.

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1759081&SiteID=17

it should work if you remove the single quotes around master:

:setvar sourceDB master

use $(sourcedb)

reverse the steps for bonus points.

you could do this with triggers. however it would bring the perf of your system to a halt.

it makes it go faster. 😀

exactly. you could just add a step in the job that invokes a .net console app using the CmdExec subsystem in agent. this console app could do anything, for...

ms would never port sql server to unix or any other os.

sql server drives adoption of the windows server platform, just as halo drives adoption of the xbox.

in 2005, you don't need an indexed view to get what amounts to a second clustered index on a table - you can get the same effect with included columns...

seems like a bad idea to me. even apart from the security risks of having to allow unsafe assemblies.

databases tend to be the bottleneck in many tiered architectures I've...

this looks like a mysql script. InnoDB is one of the storage engines you can choose there. Another common one in mysql is MyIASM

nice. wasn't aware of that one. 🙂

for web email, I like fastmail.fm better than either yahoo or gmail. been using them for many years.

it is not easy to diagnose resource leaks in managed code. to do it in managed code used by sql server would be even harder. I've diagnosed plenty...

this is generally not a good idea. if your procs are altering the schema of your database, you are building on a shaky foundation indeed.

create view fails because it...