What is the default schema for the user "abc"?

Hmm,

I always thought that more than 3 nodes was introduced with SQL 2005, but on the other hand I think that was related to Windows 2000 which came out...

If you mean setting up a Profiler Trace, there is a slight performance impact but usually it's acceptable. It also depends on how you run it, do you log to...

SQL 2000 Enterprise Edition only supports 2 cluster nodes.

So what you try to do is not possible.

Sorry but I have no idea what you want. Could you give us more details?

Christian Buettner (4/16/2009)

---

Carlo Romagnano (4/16/2009)

---

Correct answer is 1-25:

exec sp_helptext sp_addmessage

in the output search for @severity and you'll find this piece of code that is the law.

...

I don't think it's related to SP3, at least I don't have such issues on my servers.

Could it be that the login for the group is disabled?

Another possibility is...

So you're looking for the schema and the table name.

To get these simply JOIN sys.objects to sys.schemas

You have to use the INSTALLSQLDATADIR parameter. Problem is that this will only accept one directory for data and log files.

In case you want to have separate loctions for...

This should work:

SELECT ds.Name,

OBJECT_NAME(i.object_id) AS [TableName]

FROM sys.indexes i JOIN

sys.data_spaces ds

ON i.data_space_id = ds.data_space_id

WHERE index_id 0

In case you have partitioned tables you must also join the sys.partition_schemes view.

You can use the 2005 dashboard, but there are a few problems.

I had a couple of times that a report gave an error the first time I used it,...

Ok, I had it wrong.

No big deal but of course I investigated this issue a little more. I'm using SQL 2008 Build 1600, so no SP1.

Obviously what's in BOL is...

What's the errormessage? Are you using Databasemail or SQLmail ?

We need more details if you want help.

Wow, you're still using SQL 7.0.

In SQL 2000 or later UPDATETEXT will be logged if your database is in FULL recovery. But I assume an upgrade is not the solution...

I would think that the answer to your question will be very different depending on who you ask.

My personally view is that as a best pratice you shouldn't use...