Fixing SQL Server Management Studio’s Tab Text[/url] by Brent Ozar

Can you specify the view definition you used for the 2 Fact tables? I'm trying to follow along and also have the 32 bit version installed.

Thanks!

Andy DBA (6/14/2011)

Many organizations...

RE: Common SQL Error 3 - You're Using the Wrong Database

The way I get around this is to fully qualify all my table names with dbname.schema/owner.tablename

That way I can be...

Here is an example of a real world use of impersonation:

http://nickgrattan.wordpress.com/2007/07/24/bringing-impersonation-to-sql-server-2005/

For what you want to do it sounds like you'll need to grant 'permanent' (not impersonate) permission to...

How are you connecting to SQL Server from your website? I think when copying a to a new virtual directory, the anonymous user password is cleared (as a security...

Was it one of these articles:

http://www.sqlservercentral.com/Tags/T-SQL/delete/

I think you could do what you're trying to do with some dynamic sql:

declare @sometable nvarchar(255)

declare @sql nvarchar(4000)

DECLARE @ParmDefinition nvarchar(500)

set @ParmDefinition = '@sometable varchar(255)'

set @sometable =...

Impersonate is useful when you want to give another user the same permissions for a period of time. For example, you could allow another user to impersonate your...