This should do it for you.

UPDATE PRODDTA.F0911

SET [GLREG#] = 0

WHERE GLLT = 'AA' AND GLPN = 12

AND GLCTRY = 20 AND GLFY = 5

The reason your update...

Imke

This query returns the data and log size for all databases on the server, right?  But it only provides a snapshot of the sizes at the time the query is...

Do you really need to shrink at all?   It sounds like you have plenty of disk space... are you doing this to free up space for something else?  If not,...

Yes.  That one looks a bit scary.  It should be possible to write it without dynamic SQL, though.  And using joins instead of subqueries, where you can, will make it...

Frances

It's in the last line - did you mean to say @quiz IS NULL or @quiz = ''? 

John

Andy

Surely not if that involves dropping and recreating publications, or hacking system tables?  Backup and restore requires neither of those.

John

Andy

Why not just back up the database and restore it to the new location?  You don't have to touch the system tables then.

John

Yes, you can do that using replication, but I can't think why you would want to.  Perhaps you could explain a bit more about what you (or your boss) are...

You can use bcp or DTS.  There is lots of information about them in Books Online.

John

Please will you give the text of the error since the picture you posted is only visible to you.

Thanks

John

If you have one application and one database then you can't have active-active clustering.  Active-active involves having two instances or more set up, with those instances running on different nodes...

JB

You'll know the reserved words because they appear pink or blue in Query Analyzer.

John

With your sample data, ordering by max or by min will give the same result.  However, if your data looked like this, you would get a different results and then...

Brian

Yes - go as if you're installing SQL Server, but choose Client Tools instead when you're given the choice.

John

Will this work?

select sectionname, count(sectionname)

from sectionnames

group by sectionname

order by max(cont_section_id)

John