Thanks for the question. Since we mostly work with SQL Server 2000 and use dbo only, we have never used the REFERENCES permission so far. This might change in the...

As always excellent question with very good explanation.

I am just wondering why you get a different DATALENGTH than I do (I get 486)

Thanks!

Just luck 😉

The bulk-logged recovery model will not help at all btw. There is nothing like a bulk-logged delete.

I would have gone with the new table approach as well, with copying the...

whatispunk (7/18/2008)

---

What happens to nvarchar variables when different concatenations are performed. (This is for a dynamic sql call).

Given the following code:

DECLARE @sql nvarchar(MAX)

DECLARE @where nvarchar(MAX)

SET @where = ' WHERE Name...

Jeff Moden (7/18/2008)

---

Again, I wouldn't use a correlated subquery for this. But that's not the big problem here... what does this query do to the @Tab table? Nothing......

Viswanath S. Dhara (7/18/2008)

---

Hi Adam,

Your query works, but that is not what I am tring to do!

I am trying...

Hello Roi,

you actually can add constraints to table variables.

Example:

DECLARE @MyTabVar TABLE(

PKCol int NOT NULL PRIMARY KEY CLUSTERED

,UniqueCol int NOT NULL UNIQUE

)

Depending on what you are trying to achieve you can also use LIKE '_%'.

This will exclude NULLs an empty strings '' (but not the single space strings ' ').

I think you are looking for this:

SELECT SERVERPROPERTY('ErrorLogFileName')

(If you mean the server logs and not the database logs)

Hi umailedit,

can you please elaborate a little more on why you...

Hi Danny,

Sorry for the late reply. I had almost no time today to troubleshoot this, but I might be able to check again tomorrow.

Although my confidence to find a solution...

Hi Danny,

in one of the post above, you wrote that adding the space in the editor works.

Is the issue solved by this or does it only work in the editor...

Thanks for the feedback!

I found this information really helpful:

A not-so-very technical discussion of Multi Version Concurrency Control

http://www.ibphoenix.com/main.nfs?page=ibp_mvcc_roman