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...

SQL browser settings are stored under this registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\SQL Browser

You could disable the SSRP listener setting the key to a value of 0, but this would prevent the...

Thanks for giving us feedback on your issue.

I hope this helps others experiencing the same.

90 stands for SQLServer 2005.

How many instances are running on that machine?

Try running this from a command prompt and post here the results.

sc query | findstr /I "SQL"

It doesn't look like SQLServer2008 installation path.

Are you sure?

Don't start it as service.

Stop the service, open a command prompt and run sqlbrowser.exe -c.

sp_msforeachdb uses the ? placeholder for the current database being processed.

This should do the trick.

exec master..sp_msforeachdb 'select max(len(name)) from [?].sys.tables'

Have you tried running it with the -c command line switch?

Does it return any errors?

Congratulations!

dave1982 (6/25/2010)

---

For example in a recent deployment of SharePoint I was

The Bussiness Analyst

The System Architecht

The DBA

The Developer

The Trainer

The Support!!

Now I have an argument that these should all be seperate rolls...

They don't know what they're missing! 😛

Paul White NZ (6/25/2010)

---

It's not common knowledge, no. A number of articles have been written on the subject, so I'm not at all sure *why* more people don't know...

I didn't know that. Thank you for pointing it out.

I think I'll be adding schemabinding to LOTS of UDF soon. 😉

Great code, Paul, as usual!!

Just one question: what does schemabinding mean here? The return value depends only on the input parameter, so I miss the point on enabling shemabinding.

I think you will find and answer here:

http://www.sqlservercentral.com/Forums/FindPost941588.aspx