resotre the user in the database

Before formatting the server the user took the backup of the database.
After the installation the database was restored but we can find the all the
user in resored database obivously the all user are not in the logins under
the security. Is there anyway to copy the all the user from resoted database
to logins
Thanks in advance
NizhamTake a look at sp_change_users_login system stored procedure in the BOL
"Nizham" <junkmn@.gmail.com> wrote in message
news:%23Ue8kb%23SGHA.792@.TK2MSFTNGP10.phx.gbl...
> Before formatting the server the user took the backup of the database.
> After the installation the database was restored but we can find the all
> the user in resored database obivously the all user are not in the logins
> under the security. Is there anyway to copy the all the user from resoted
> database to logins
> Thanks in advance
> Nizham
>|||There are more than 100 user in the databse any can help me on this
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uQ4l%23e%23SGHA.1236@.TK2MSFTNGP11.phx.gbl...
> Take a look at sp_change_users_login system stored procedure in the BOL
>
>
> "Nizham" <junkmn@.gmail.com> wrote in message
> news:%23Ue8kb%23SGHA.792@.TK2MSFTNGP10.phx.gbl...
>|||There's a GUI over sp_change_users_login available at www.dbmaint.com.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nizham" <mnizham@.gmail.com> wrote in message news:e%236XkwDTGHA.4340@.tk2msftngp13.phx.gbl.
.
> There are more than 100 user in the databse any can help me on this
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uQ4l%23e%23SGHA.1236@.TK2MSFTNGP11.phx.gbl...
>

Resolving duplicates entries in table among 10 databases

Hi

Our product uses MS-SQL Server 2000. One of our customer has 10
installations with each installation stroring data in its own database.
Now the customer wants to consolidate these databases into one and we
already have plan for that by consolidating one DB at a time. But first
they want to find how many unique or duplicate entries they have across
all the 10 databases

Assumptions:
1. All the databases reside on the same server. (This is just an
assumption, not the real environment at customer site)
2. Databases can not be merged before it is found how many unique or
duplicate rows exist.

Table under consideration:
Message
(
HashID PK,
...
)

# of rows in Message table in each of databases: 1 Million

Here is my question: How can I find how many unique or duplicate
entries they have across all the 10 databases. I easily find unique
rows for two databases with a query like this:

SELECT COUNT(A.HasID) FROM db1.dbo.Message A LEFT OUTER JOIN ON
db2.dbo.Message B ON A.HashID = B.HashID WHERE B.HashID IS NULL

How can I do this for 10 databases. This will require factorial of 10
queries to solve this problem.

I will appreciate if someone can provide hint on this.

Regards
AK> Here is my question: How can I find how many unique or duplicate
> entries they have across all the 10 databases.

The following will list the count of unique values (Duplicates = 0) as well
has the non-unique values grouped by the number of duplicates (1-9).

SELECT
Duplicates,
(Duplicates + 1) * COUNT(*) AS TotalHashIDCount
FROM (
SELECT HashID, COUNT(*) - 1 AS Duplicates
FROM (
SELECT HashID FROM db1.dbo.Message
UNION ALL SELECT HashID FROM db2.dbo.Message
UNION ALL SELECT HashID FROM db3.dbo.Message
UNION ALL SELECT HashID FROM db4.dbo.Message
UNION ALL SELECT HashID FROM db5.dbo.Message
UNION ALL SELECT HashID FROM db6.dbo.Message
UNION ALL SELECT HashID FROM db7.dbo.Message
UNION ALL SELECT HashID FROM db8.dbo.Message
UNION ALL SELECT HashID FROM db9.dbo.Message
UNION ALL SELECT HashID FROM db10.dbo.Message
) AS Messages
GROUP BY HashID) AS HashIDCounts
GROUP BY Duplicates
ORDER BY Duplicates

--
Hope this helps.

Dan Guzman
SQL Server MVP

"AK" <ambkh@.yahoo.com> wrote in message
news:1139679057.443925.49210@.g44g2000cwa.googlegro ups.com...
> Hi
> Our product uses MS-SQL Server 2000. One of our customer has 10
> installations with each installation stroring data in its own database.
> Now the customer wants to consolidate these databases into one and we
> already have plan for that by consolidating one DB at a time. But first
> they want to find how many unique or duplicate entries they have across
> all the 10 databases
> Assumptions:
> 1. All the databases reside on the same server. (This is just an
> assumption, not the real environment at customer site)
> 2. Databases can not be merged before it is found how many unique or
> duplicate rows exist.
> Table under consideration:
> Message
> (
> HashID PK,
> ...
> )
> # of rows in Message table in each of databases: 1 Million
> Here is my question: How can I find how many unique or duplicate
> entries they have across all the 10 databases. I easily find unique
> rows for two databases with a query like this:
> SELECT COUNT(A.HasID) FROM db1.dbo.Message A LEFT OUTER JOIN ON
> db2.dbo.Message B ON A.HashID = B.HashID WHERE B.HashID IS NULL
> How can I do this for 10 databases. This will require factorial of 10
> queries to solve this problem.
> I will appreciate if someone can provide hint on this.
> Regards
> AK|||Thank you Dan. This is exactly what I needed (in fact more than what I
needed :)

Regards
AK

Dan Guzman wrote:
> > Here is my question: How can I find how many unique or duplicate
> > entries they have across all the 10 databases.
> The following will list the count of unique values (Duplicates = 0) as well
> has the non-unique values grouped by the number of duplicates (1-9).
> SELECT
> Duplicates,
> (Duplicates + 1) * COUNT(*) AS TotalHashIDCount
> FROM (
> SELECT HashID, COUNT(*) - 1 AS Duplicates
> FROM (
> SELECT HashID FROM db1.dbo.Message
> UNION ALL SELECT HashID FROM db2.dbo.Message
> UNION ALL SELECT HashID FROM db3.dbo.Message
> UNION ALL SELECT HashID FROM db4.dbo.Message
> UNION ALL SELECT HashID FROM db5.dbo.Message
> UNION ALL SELECT HashID FROM db6.dbo.Message
> UNION ALL SELECT HashID FROM db7.dbo.Message
> UNION ALL SELECT HashID FROM db8.dbo.Message
> UNION ALL SELECT HashID FROM db9.dbo.Message
> UNION ALL SELECT HashID FROM db10.dbo.Message
> ) AS Messages
> GROUP BY HashID) AS HashIDCounts
> GROUP BY Duplicates
> ORDER BY Duplicates
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "AK" <ambkh@.yahoo.com> wrote in message
> news:1139679057.443925.49210@.g44g2000cwa.googlegro ups.com...
> > Hi
> > Our product uses MS-SQL Server 2000. One of our customer has 10
> > installations with each installation stroring data in its own database.
> > Now the customer wants to consolidate these databases into one and we
> > already have plan for that by consolidating one DB at a time. But first
> > they want to find how many unique or duplicate entries they have across
> > all the 10 databases
> > Assumptions:
> > 1. All the databases reside on the same server. (This is just an
> > assumption, not the real environment at customer site)
> > 2. Databases can not be merged before it is found how many unique or
> > duplicate rows exist.
> > Table under consideration:
> > Message
> > (
> > HashID PK,
> > ...
> > )
> > # of rows in Message table in each of databases: 1 Million
> > Here is my question: How can I find how many unique or duplicate
> > entries they have across all the 10 databases. I easily find unique
> > rows for two databases with a query like this:
> > SELECT COUNT(A.HasID) FROM db1.dbo.Message A LEFT OUTER JOIN ON
> > db2.dbo.Message B ON A.HashID = B.HashID WHERE B.HashID IS NULL
> > How can I do this for 10 databases. This will require factorial of 10
> > queries to solve this problem.
> > I will appreciate if someone can provide hint on this.
> > Regards
> > AK|||Better too much than too little :-)

--
Hope this helps.

Dan Guzman
SQL Server MVP

"AK" <ambkh@.yahoo.com> wrote in message
news:1139936166.210532.262820@.g43g2000cwa.googlegr oups.com...
> Thank you Dan. This is exactly what I needed (in fact more than what I
> needed :)
> Regards
> AK
> Dan Guzman wrote:
>> > Here is my question: How can I find how many unique or duplicate
>> > entries they have across all the 10 databases.
>>
>> The following will list the count of unique values (Duplicates = 0) as
>> well
>> has the non-unique values grouped by the number of duplicates (1-9).
>>
>> SELECT
>> Duplicates,
>> (Duplicates + 1) * COUNT(*) AS TotalHashIDCount
>> FROM (
>> SELECT HashID, COUNT(*) - 1 AS Duplicates
>> FROM (
>> SELECT HashID FROM db1.dbo.Message
>> UNION ALL SELECT HashID FROM db2.dbo.Message
>> UNION ALL SELECT HashID FROM db3.dbo.Message
>> UNION ALL SELECT HashID FROM db4.dbo.Message
>> UNION ALL SELECT HashID FROM db5.dbo.Message
>> UNION ALL SELECT HashID FROM db6.dbo.Message
>> UNION ALL SELECT HashID FROM db7.dbo.Message
>> UNION ALL SELECT HashID FROM db8.dbo.Message
>> UNION ALL SELECT HashID FROM db9.dbo.Message
>> UNION ALL SELECT HashID FROM db10.dbo.Message
>> ) AS Messages
>> GROUP BY HashID) AS HashIDCounts
>> GROUP BY Duplicates
>> ORDER BY Duplicates
>>
>> --
>> Hope this helps.
>>
>> Dan Guzman
>> SQL Server MVP
>>
>> "AK" <ambkh@.yahoo.com> wrote in message
>> news:1139679057.443925.49210@.g44g2000cwa.googlegro ups.com...
>> > Hi
>>> > Our product uses MS-SQL Server 2000. One of our customer has 10
>> > installations with each installation stroring data in its own database.
>> > Now the customer wants to consolidate these databases into one and we
>> > already have plan for that by consolidating one DB at a time. But first
>> > they want to find how many unique or duplicate entries they have across
>> > all the 10 databases
>>> > Assumptions:
>> > 1. All the databases reside on the same server. (This is just an
>> > assumption, not the real environment at customer site)
>> > 2. Databases can not be merged before it is found how many unique or
>> > duplicate rows exist.
>>> > Table under consideration:
>> > Message
>> > (
>> > HashID PK,
>> > ...
>> > )
>>> > # of rows in Message table in each of databases: 1 Million
>>> > Here is my question: How can I find how many unique or duplicate
>> > entries they have across all the 10 databases. I easily find unique
>> > rows for two databases with a query like this:
>>> > SELECT COUNT(A.HasID) FROM db1.dbo.Message A LEFT OUTER JOIN ON
>> > db2.dbo.Message B ON A.HashID = B.HashID WHERE B.HashID IS NULL
>>> > How can I do this for 10 databases. This will require factorial of 10
>> > queries to solve this problem.
>>> > I will appreciate if someone can provide hint on this.
>>> > Regards
>> > AK
>sql

Required .Net error during installation....

Hello friends, I have been trying to install SQL Server2005 but I can't. I have .Net framwork 2.0 on my computer. At the end of installation at Reporting Services the following error occurs.

Error: The required version of .Net framwork is not installed.

So first I installed .Net framwork SDK, the problem was same. After that I install .Net framwork 3.0 direct from microsoft but all in vain.

Now I need help about which of the .Net framwork must be installed on computer before installing SQL Server2005.

Thaks a lot..

if you want to setup a RS Server you seem to not have the ASP.NET component registered on the server. Change to the C:\Windows\Microsoft.NET\Framework\v2.0.50727 directory and use the aspnet_regiis.exe -i command for registering the asp.Net extensions to your web server.

If this does not work try the following: You will need to have the .NET 2.0 Framework installed on the Server. This is normally done through the prerequisites pages. Open the Setup of SQL Server 2005 after deleting all instances of the .NET Framework which could be found by the installer. then try to install RS Server again.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hey, I have did this aspnet_regiis.exe -i . Its not worked.

But I want to say one thing that I have already installed Visual Studio 2005 Professional Edition, .Net framwork v2.0.50727 and .Net framwork v3.0 on the same machine...

Now I am trying to install SQL Server2005 too. After very first installation of SQL Server its worked every thing, I made data base on the installed server. And after rebooting my system next day Server is not running. I tried to run all the server services manually but its worked. I used Sql server management studio too, all in vain...

What can I do?

Repost: Installation trouble

Removed the previous version and tried installing the new trial - was able
to see reports in visual but not in reportmanager. So now I tried to drop it
all including all iis-catalogues and installed it from scratch again.
No luck...
My goal is just to get it running to see reports - not to get it running
with the right security settings...so in IIS i changed reports and
reportserver to anonymous access and then stopped and started iis and
reportserver service.
But when activating reportmanager it keeps on saying:
unable to finde script library
'/aspnet_client/system_web/1_1_4322/webuivalidation.js - try placing this
file manually or reinstall by running 'aspnet_regiis -c'
tried running to above and tried aspnet_regiis -i - no luck.
Have an xp operating system - is there a platform limitation for the trial
version ?
Is it related to my IIS-settings ? It shouldn't try to get the file above
when using anonymous access. I have had the previous version to function.
--MichaelNo hints ?
When using reportmanager I can do nothing in there - tried to make a
datasource but nothing happens when trying to save it. When switching from
one tab to another the error below pops up...
"Michael Vardinghus" <michaelvardinghus@.notexisting.com> skrev i en
meddelelse news:eJGqdb4kEHA.3984@.TK2MSFTNGP14.phx.gbl...
> Removed the previous version and tried installing the new trial - was able
> to see reports in visual but not in reportmanager. So now I tried to drop
it
> all including all iis-catalogues and installed it from scratch again.
> No luck...
> My goal is just to get it running to see reports - not to get it running
> with the right security settings...so in IIS i changed reports and
> reportserver to anonymous access and then stopped and started iis and
> reportserver service.
> But when activating reportmanager it keeps on saying:
> unable to finde script library
> '/aspnet_client/system_web/1_1_4322/webuivalidation.js - try placing this
> file manually or reinstall by running 'aspnet_regiis -c'
> tried running to above and tried aspnet_regiis -i - no luck.
> Have an xp operating system - is there a platform limitation for the trial
> version ?
> Is it related to my IIS-settings ? It shouldn't try to get the file above
> when using anonymous access. I have had the previous version to function.
> --Michael
>|||Not quite sure what did the trick but now it's working ...
"Michael Vardinghus" <michaelvardinghus@.notexisting.com> skrev i en
meddelelse news:%23lDRJ8OlEHA.3760@.TK2MSFTNGP12.phx.gbl...
> No hints ?
> When using reportmanager I can do nothing in there - tried to make a
> datasource but nothing happens when trying to save it. When switching from
> one tab to another the error below pops up...
> "Michael Vardinghus" <michaelvardinghus@.notexisting.com> skrev i en
> meddelelse news:eJGqdb4kEHA.3984@.TK2MSFTNGP14.phx.gbl...
> > Removed the previous version and tried installing the new trial - was
able
> > to see reports in visual but not in reportmanager. So now I tried to
drop
> it
> > all including all iis-catalogues and installed it from scratch again.
> >
> > No luck...
> >
> > My goal is just to get it running to see reports - not to get it running
> > with the right security settings...so in IIS i changed reports and
> > reportserver to anonymous access and then stopped and started iis and
> > reportserver service.
> >
> > But when activating reportmanager it keeps on saying:
> >
> > unable to finde script library
> > '/aspnet_client/system_web/1_1_4322/webuivalidation.js - try placing
this
> > file manually or reinstall by running 'aspnet_regiis -c'
> >
> > tried running to above and tried aspnet_regiis -i - no luck.
> >
> > Have an xp operating system - is there a platform limitation for the
trial
> > version ?
> >
> > Is it related to my IIS-settings ? It shouldn't try to get the file
above
> > when using anonymous access. I have had the previous version to
function.
> >
> > --Michael
> >
> >
>