Database names not listed except system databases.

What is wrong on the activity monitor ?

if you execute exec sp_who yu will see the old way but we would like to know...

When i create database by using installation program made by

Redgate's schema generation in .Net

on my local server Dtproperties table is created. But some other servers we have i see...

I lltry to answer all your questions.

fist i have redgate software. It is really powerfull but only when two database are identical on schema. and readgate software fails on data...

thank you very much for your explanations

These informations really help to find dependencies.

But my problem is how to find that total hierarchy from these lists

may be one should iterate many...

Security on top level

from that level you dont see it is connected

in users level when you select your database you can see that user alreadey has these priviligies.

I am almost sure that your schema had that logical order which caused

that all ID came to the last column. You must have correct schema

on logical design. if you run...

Discussion here is

Changing of Field order in a database schema

and nor storedprocedures please pay attention!

thnks

Thank you all try to find some of the problems.

As i see First problem is Bad programmers using SELECT * statement

I think one should get big problem when using BULK...

Thnk you very much for your helps

I think i should think opposite way. Namely call views from procedures. Problem is here to call a tabel name dynamiccally.

So i ll try...

what was the solution or wrong ?

i think readers would like to know

with my regards

atik

An other way to test dublicate after you remove primary key condition.

When you have dublicated data if it is not many just remove these dubleicated dta from the main table...

Try first on an emty table if your data transfer still giving dublicate error if does then i had same problem in sqlserver 7 on replication and it was pure

replication...