OK, you should find the .Net setup log in %temp%\dd_net_framework35_MSI*.txt.

I take it you're running the setup as a local administrator and specifically running the executable in Administrative mode (right...

It's irrelevant whether you're using the Professional, Ultimate or Enterprise version of Windows 7 - all work fine despite not being officially supported versions.

You just need to do some investigation...

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

It might not be in the list of supported platforms, but I've definitely installed the 180 day Evaluation version on Windows 7 Pro before.

There's a install log somewhere that should...

You could replicate the functionality I guess with something like:

WHERE (Col1=X OR Col2=Y) AND NOT (Col1=X AND Col2=Y).

Does GPG store the encryption keys in the registry for each user? If so, then are you testing it using the same account that is running the SQL Server service?

Also,...

I think having multiple input parameters was a new function of SQL Server 2008 and 2005 is limited to a single parameter.

SQL Server 2005 CREATE AGGREGATE (BOL)

@param_name

Is a parameter in...

I think this was cross-posted.

Please see the below with a large discussion:

http://www.sqlservercentral.com/Forums/Topic912735-391-1.aspx

I think that the DB and log size's were not as described, especially as transaction logs have a 2TB...

No problem. Glad I could help 🙂

An Active/Active Cluster means that you have two sets of clustered instances, one running on the first server, the other on the second.

When one server/instance fails, that instance starts on...

I voted "No", but only because it doesn't have a lot of new features I'm excited about and there are licensing implications.

I'm not worried about it being buggy in the...

Go is not a T-SQL command, it's syntax used in Management Studio to signal the end of a batch. If you're submitting it from a .Net application, you have to...

Assuming you're talking about an OLTP application, I would always tend towards separating the data rather than just NULLing columns that are not relevant to the type.

It just makes...

The problem with this type of approach is that the subquery in the SELECT will be processed last and therefore will be executed once for each row in your CTE,...

You absolutely must use a non-standard port if publishing a SQL Server to the internet and SQL Browser should always be disabled. I've no idea why you'd allow UDP access...