Stephane

Your syntax doesn't look quite right.  I don't see how your update statement can work.  How about this (not tested, obviously):

update r

set countryId = c.countryId

from #regions r join...

Nita

Make the user a member of the db_datareader and db_denydatawriter fixed server roles in the database.  If you are asking how to do this for all databases, you can generate...

When a new row is inserted, it will be put on a page according to its place in the clustered index.  If there is no room on the required page,...

Mike, Robert

Thanks for doing the BOL/KB searching for me.  I suppose the real point of my post was to have a little moan that, in this QoD (and quite a...

Yes.  Whether it's a DELETE FROM, DROP or TRUNCATE, it's not going to work if the table is referenced by a foreign key constraint.

Come to think of it, writing a...

I'm working on reinventing the wheel on this one... but using sysreferences instead of sysdepends.  Will post the script when I get it finished.

By the way, jmcgarvey's script will also...

The explanation doesn't explain the answer: it merely restates it.  Would the setter of the question care to go into a little more depth, please?

John

Raj

I think you said earlier that you'd tried with an index on that column and there was no improvement.  Please will you post an execution plan for when you have...

Manish

AWE is only needed for memory above 4GB.  I'm not sure what's causing SQL Server to get stuck at 2GB.  Do you have any other applications running on the server? ...

Ryan

Assuming the taskid column doesn't allow nulls, something like this:

SELECT e.empid,

e.name,

COUNT(t.taskID) as tcount,

COUNT(t.taskID) - COUNT(t.resolution) as NullRes

FROM tasks t

RIGHT JOIN employee...

Ah - it's an AS400 database?  I don't know anything about AS400, I'm afraid.  However, if it's ANSI compliant, you should be able to run SELECT TABLE_SCHEMA, TABLE_NAME...

Manish

Are you using the Standard or Enterprise Edition of SQL Server 2000?

John

Nelson

The only thing I can think of is that you may have two tables called BZRCRP, one owned by dbo (with 5 records) and one owned by EBSTSTNEW (with 1...

David

No, it's because LIKE doesn't work with text data types.  The performance of this isn't going to be good, because none of the searches will be able to use indexes. ...

Dave

Glad you got it working.  Just one more thing.  If you use my method, and any of your tables have text columns, you will need to add the following:

December 21, 2006 at 6:39 am