There isn't without some sort of reconciliation process. This is one reason Windows groups are preferred. AD will handle the group membership cleanup when the domain user is deleted, meaning...

The benefit is there are times when certain application require a particular username. However, especially on the Windows side, your corporate naming standard doesn't match the name the application wants....

If it's 2005, the easiest way is to use SQL Server Management Studio. You can install just the workstation components if you have the CD/DVD. Otherwise, you could use a...

If you're hitting the /ReportServer virtual directory, expect something that looks like a directory listing. The ReportServer part is the web service. For what is typically /Reports you should get...

WILLIAM MITCHELL (4/9/2008)

---

I voted for SP3 but now I'm having second thoughts.

SQL 2000 had SP3 but then was followed by SP3a.

SQL 2005 had SP2 but then was followed by SP2a.

It...

I really, really, really wish SQL Server would track client by IP. And allow for security which specified access by IP. For instance, is sa login was only permitted to...

roger.plowman (4/9/2008)

---

Look, you're beating a dead horse about SP3. You've said there are no bugs for SP3 to fix, so why should MS go to the effort? Service packs are...

All right, prior to me configuring a Service Broker endpoint, I saw the following messages related to Server Broker in my SQL logs:

The Service Broker protocol transport is disabled or...

I had a long conversation with our VMware SE (he's moved on to bigger and better things within VMware now) who I had a previous working relationship with long before...

In SQL Server 2000 there's not a whole lot you can do with respect to seeing information in the master database. The reason is that all users (except members of...

Are there other MSSQL.N folders? The folders are numbered based on when the services were installed.

Matt Miller (4/12/2008)

---

To follow up on Brian's comment, the bolded part is the "servicename" for the instance:

'Software\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp'

In a named instance that will usually be formatted as MachineName$instance.

So you'd have to...

It doesn't look like the login is failing. Are you running a script that uses SMO?

If you're looking to get the login names and you're trying to filter based on just those names, here's what you need:

SELECT sl.NAME

FROM dbo.sysusers su

JOIN master.dbo.syslogins sl

...

The exact registry key will depend on the version of SQL Server and whether or not it's a named instance. The example given was for a SQL Server 2000 default...