Does anyone know how to copy a Database Diagram from one database to another
in SQL 2000 SP4?
I create a good number of diagrams in the databases of our Development
server.  Every now and then I need to refresh our development databases from

ERROR: Unable to open registry key: HRESULT = 0x80070005, Key =
SYSTEM\CurrentControlSet\Control\WMI\Security
The value returned is -2147024891
<EndFunc Name='Do_UpdateETWMOFWithGUID' Return='1603' GetLastError='0'>

Looking for some suggestions...  About a year ago, my employer
acquired another company.  We're a SQL Server shop, but this other
company uses a mix of SQL Server and Oracle.  As part of the DBA team,
I'm required to start learning Oracle (admin, performance tuning,

HI i have  query where i want to select max of a colum
suppose below is the query
select A ,Max(B), C ,ID
FROM TALBEX

We have completed the first part of converting images stored as an image
columns to be kept outside the database. This process is complete and working
great. We now are going through and setting that image column to 0x00 (we are
not altering the table to remove it for some legacy ...

What are the common database maintenance tasks that I have to carry out on
huge 100 Gb database?
Thanks!

I have BizTalk 2006 installed and used SQL2005 on my development server,
today I noticed that the box is so slow and one process use most of resource
is SQLServr.exe, there were several logs reported and error logs as well too.
I include them into this post, let me know if you ...

Hi, Is there a  way to restrict user access to a column in a table? I have a
table that users can update data but there is one column that I want to
restrict which users can update. Any ideas?

I need to move a database from one server cluster to a second cluster.
I can copy the MDF and LDF from one machine to another, but how do i bring
the login name and password over to the new cluster??
I do not want to ask the customer to change thier passwords.

I am currently evaluating an application package that uses a small Access
database (8 tables). It has the functionality needed, however my IT
organization will only support packages that use SQL Server 2005. Is there a
way to run against SQL Server tables instead of Access 2003 ...

I need to convert the following vba code (front end) to a backend stored
procedure. The front end code is as follows:
if ((dbo_PWOPayback!AnnualVolumePer1000) *
(dbo_PWOPayback!FirstyearRevenuePerThousand) -

I have written a stored procedure. This one is giving error while trying to
compile.
CODE:
create  proc sp_update_dbo_PWO_Status_6

I have read numerous posts on here regarding nested sets and the c-word when
working with hierarchies (yes, I know about 'Trees & Hierarchies') and,
typically, the samples and scenarios provided solve some very basic
hierarchical situations. (i.e. auto-assigned unique IDs for keys ...

How do you full text index a view?
Since you need an Key to do a table, how would you do a View?  My views
don't show up in the wizards' list of tables and views.
Thanks,

Folks,
SQL Server 2005 SP2
We are just now embarking on our upgrade from SQL 2K to 2K5. In development
I have come across this issue.