Tuesday, November 28, 2006 - Posts

CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user
The new RSS feed is here

If you encounter this

Could not obtain information about Windows NT group/user <MyDomain>/<MyName>, error code 0x5.

When you try and CREATE an ASSEMBLY, you might think well I'm not connected as that user. The user it sqawks about is the database owner.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user

posted Tuesday, November 28, 2006 11:18 AM by SimonSabin with 0 Comments

dmvs and CROSS APPLY

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/dmvs and CROSS APPLY
The new RSS feed is here

In SQL 2005 there is a new feature by which you can extend a result set with the results of another resultset. You might think thats nothing new because thats exactly what a join is, and with the combination of derived tables you have full control, and you can use table valued functions.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/dmvs and CROSS APPLY

posted Tuesday, November 28, 2006 10:26 AM by SimonSabin with 0 Comments