Sigerson (9/6/2012)

---

I don't see good outcomes in the future for our privacy concerns. The use of the web is so financially compelling for corporations that they *must* use it...

One game at a time. Ten times in a short span.

Sorry, perhaps I was not clear.

Install SQL Server as a single node cluster. This allows you to easily add another node to it later, and there is no downside. If...

You are welcome, and it's not well documented from what I can see.

Ditto. I try to ignore those, especially when I think it might be a 2nd or 3rd language for someone. I can't imagine...

Use ALTER SCHEMA, with the type::schema.object

http://msdn.microsoft.com/en-us/library/ms173423.aspx

CREATE SCHEMA OldSchema

;

GO

CREATE SCHEMA NewSchema

;

GO

CREATE TYPE OldSchema.MyTable AS TABLE

( IDCode INT

, Location VARCHAR(200)

)

;

CREATE PROCEDURE OldSchema.MyProc AS SELECT * FROM dbo.MyLogger

;

ALTER SCHEMA NewSchema TRANSFER OldSchema.MyProc

;

ALTER SCHEMA...

Double check your teams. The season kicks off soon.

You can remove the diff, but that won't necessarily change the time, depending on logs. You'll have more logs to restore.

Best way: copy the full to an external HDD and...

I'm sure there's more than one, but this slightly worries me. Someone that can't pipe things to a file and can't install SQL Server is likely not someone I want...

The scheduler is essentially the same in 2012.

I'm not sure what you want as "more flexible". An exception item to the schedule? Perhaps, but I think this is an extremely...

OK, not my day. Not sure how to break the news here that this person is in way, way, over their head.

http://www.sqlservercentral.com/Forums/Topic1353224-2799-2.aspx#bm1354093

"outlined in Microsoft" doesn't tell us anything. Outlined where? What specific procedure...

I'd do what Sean suggested, with a simple IF .. THEN statement for execution of the item.

I thought that Windows Update would flag this, if it's allowed from your machine.

Eric M Russell (9/4/2012)

---

At TechEd, they pass out coffee on the convention floor, not beer and mixed drinks. I can't imagine sitting through a two hour seminar on query...