This works in SSMS

-- Change execution context to the desired login

EXECUTE AS LOGIN = 'Domain\LoginName';

GO

--Check the execution context

SELECT SUSER_NAME();

GO

-- Do stuff

--Revert to me

REVERT;

GO

The Dixie Flatline said county boundaries, not country boundaries.

I've successfully used the steps in the first post here:

http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx

I just tested changing my OPENROWSET code from Excel 5.0 (originally wrote it for '97) to Excel 8.0, which you use and it behaves in the way you described -...

You can format the column in Excel before doing the import. In the cell immediately below the column name right click, select format cell and select number. Choose...

The above code relies on the first day of the week being a Sunday, the US default. Your first day may be different (mine is), which will give an...

You can just add that component, no need to reinstall.

It's an optional component of the Database Engine. You need to rerun setup and select it.

msdn: Collations specify the rules for how strings of character data are sorted and compared, based on the norms of particular languages and locales. For example, in an ORDER BY...

I'm using SQL Server 2008 SP2 (not R2) and the option Jeffrey mentioned, File > Open > File with New Connection is there in SSMS. It allows you to...

I'm sorry, I think I may have misread your original post. When you say 'the database is not changing language ... it's still showing in English' are you expecting...

Right click over the server\instance name in SSMS Object Explorer and select Activity Monitor.

Don't know if this will help, but SQL Server recognises domain logins by their Windows SIDs. When the domain user account was recreated it would have been created with...

The change in database collation will only affect objects created after the change. As per BOL:

You can change the collation of any new objects that are created in a...

The SQL Server Agent is installed as a Windows service on the SQL Server and runs scheduled jobs. The client tools are available on the SQL Server installation...