Duplicate post.

Replies here please: http://www.sqlservercentral.com/Forums/FindPost944341.aspx

It does, if each user authenticates with his own credentials on the database.

You could also have different scenarios, with an application that requires windows authentication fo the users but doesn't...

I'm not sure I understand what you mean, but they look like the logical file names, associated with a physical file. You don't have two data files and two log...

ORIGINAL_LOGIN() should be what you're after, but be careful: it could be different from what you expect, depending on how you authenticate the users in your application.

Your sample data and required output is quite hard to read.

Can you make it more readable?

Take a look at the article linked in my signature and find out how.

Echoing again...

I would do it this way:

select

KEY

, SUM( case WHEN col1 IS NULL THEN 1 else 0 end) AS 'nullcnt'

, SUM( case...

Gail, I found the perfect present for your birthday!!!

Sorry for echoing, Gail...

create table #t

(

i int

)

insert into #t(i)

values (null)

SELECT CASE WHEN i IS NULL THEN 'Is Null' -- This will never be returned

...

Download and install process monitor.

Start it and set up a filter on process name = sqlbrowser.exe

Start sql browser: you should see it struggling to start and some kind of...

That's why you need to trace it...

Is it a 64 bit installation on 32?

Have you checked the registry?

You could try to trace the sqlbrowser.exe process with process monitor and see where it stops.

You can't go at trigger level, you'll have to set the permissions at table level.

If this is a x64 machine, I would also check if there's a registry key like this:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer

If you find a key like this, it could be due to...