Download/Install SQL RS 2005 Alone--not the whole chunk of SQL2005

Hey all,
Is there anywhere that I could download trial version of SQL 2005 Reporting
services alone...not the whole junk of SQL Server 2005. I need just the
Reporting services. another question is I have SQL 2005 Developer Edition
CTP(community tchnology preview) DVD and I am looking at a way to upgrade
only reporting services from 2000 to 2005.But the set up wont let me do just
that. It insists that I upgrade the server also. Please let me know!!!Hi,
You can only download the complete package of SQL Server 2005 and I believe
it will be by its release. Reporting Service 2005 is a part of SQL Server
2005. Compare it to the Analysis Server part: you can't download it seperate
from the SQL Server part.
For your upgrading problem: Maybe it is a 'feature' of the CTP install,
haven't tried it this way. But you could try to install the SQL Server 2005
at a new instance and make SRS to install/upgrade at the instance of the 2000
version.
Hope this would help you.
Jan Pieter Posthuma
"Balaji" wrote:
> Hey all,
> Is there anywhere that I could download trial version of SQL 2005 Reporting
> services alone...not the whole junk of SQL Server 2005. I need just the
> Reporting services. another question is I have SQL 2005 Developer Edition
> CTP(community tchnology preview) DVD and I am looking at a way to upgrade
> only reporting services from 2000 to 2005.But the set up wont let me do just
> that. It insists that I upgrade the server also. Please let me know!!!
>

download sql2005 sp2

which one i should download for my sql2005 server(win2003 server).
SQLServer2005SP2-KB921896-IA64-ENU.exe
SQLServer2005SP2-KB921896-x64-ENU.exe
SQLServer2005SP2-KB921896-x86-ENU.exe
The answer depends on your hardware platform.
IA64 is for Itanium
x64 is for the AMD and Intel 64-bit non-itanium platform.
x86 is the 32-bit version.
Select @.@.version will tell you what architecture you are running
For Example:
Microsoft SQL Server 2005 - 9.00.2047.00 (X64)
Apr 14 2006 01:11:53
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
That is an x64 system.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mecn" <mecn2002@.yahoo.com> wrote in message
news:O4icgVEtHHA.412@.TK2MSFTNGP04.phx.gbl...
> which one i should download for my sql2005 server(win2003 server).
> SQLServer2005SP2-KB921896-IA64-ENU.exe
> SQLServer2005SP2-KB921896-x64-ENU.exe
> SQLServer2005SP2-KB921896-x86-ENU.exe
>
|||How do I find out the machine is 32-bit or 64 version?
Thanks
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:utQ8reEtHHA.4800@.TK2MSFTNGP05.phx.gbl...
> The answer depends on your hardware platform.
> IA64 is for Itanium
> x64 is for the AMD and Intel 64-bit non-itanium platform.
> x86 is the 32-bit version.
> Select @.@.version will tell you what architecture you are running
> For Example:
> --
> Microsoft SQL Server 2005 - 9.00.2047.00 (X64)
> Apr 14 2006 01:11:53
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
> --
> That is an x64 system.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:O4icgVEtHHA.412@.TK2MSFTNGP04.phx.gbl...
>

download sql2005 sp2

which one i should download for my sql2005 server(win2003 server).
SQLServer2005SP2-KB921896-IA64-ENU.exe
SQLServer2005SP2-KB921896-x64-ENU.exe
SQLServer2005SP2-KB921896-x86-ENU.exeThe answer depends on your hardware platform.
IA64 is for Itanium
x64 is for the AMD and Intel 64-bit non-itanium platform.
x86 is the 32-bit version.
Select @.@.version will tell you what architecture you are running
For Example:
--
Microsoft SQL Server 2005 - 9.00.2047.00 (X64)
Apr 14 2006 01:11:53
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
--
That is an x64 system.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mecn" <mecn2002@.yahoo.com> wrote in message
news:O4icgVEtHHA.412@.TK2MSFTNGP04.phx.gbl...
> which one i should download for my sql2005 server(win2003 server).
> SQLServer2005SP2-KB921896-IA64-ENU.exe
> SQLServer2005SP2-KB921896-x64-ENU.exe
> SQLServer2005SP2-KB921896-x86-ENU.exe
>|||How do I find out the machine is 32-bit or 64 version?
Thanks
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:utQ8reEtHHA.4800@.TK2MSFTNGP05.phx.gbl...
> The answer depends on your hardware platform.
> IA64 is for Itanium
> x64 is for the AMD and Intel 64-bit non-itanium platform.
> x86 is the 32-bit version.
> Select @.@.version will tell you what architecture you are running
> For Example:
> --
> Microsoft SQL Server 2005 - 9.00.2047.00 (X64)
> Apr 14 2006 01:11:53
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
> --
> That is an x64 system.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:O4icgVEtHHA.412@.TK2MSFTNGP04.phx.gbl...
>

download sql2005 sp2

which one i should download for my sql2005 server(win2003 server).
SQLServer2005SP2-KB921896-IA64-ENU.exe
SQLServer2005SP2-KB921896-x64-ENU.exe
SQLServer2005SP2-KB921896-x86-ENU.exeThe answer depends on your hardware platform.
IA64 is for Itanium
x64 is for the AMD and Intel 64-bit non-itanium platform.
x86 is the 32-bit version.
Select @.@.version will tell you what architecture you are running
For Example:
--
Microsoft SQL Server 2005 - 9.00.2047.00 (X64)
Apr 14 2006 01:11:53
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
--
That is an x64 system.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"mecn" <mecn2002@.yahoo.com> wrote in message
news:O4icgVEtHHA.412@.TK2MSFTNGP04.phx.gbl...
> which one i should download for my sql2005 server(win2003 server).
> SQLServer2005SP2-KB921896-IA64-ENU.exe
> SQLServer2005SP2-KB921896-x64-ENU.exe
> SQLServer2005SP2-KB921896-x86-ENU.exe
>|||How do I find out the machine is 32-bit or 64 version?
Thanks
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:utQ8reEtHHA.4800@.TK2MSFTNGP05.phx.gbl...
> The answer depends on your hardware platform.
> IA64 is for Itanium
> x64 is for the AMD and Intel 64-bit non-itanium platform.
> x86 is the 32-bit version.
> Select @.@.version will tell you what architecture you are running
> For Example:
> --
> Microsoft SQL Server 2005 - 9.00.2047.00 (X64)
> Apr 14 2006 01:11:53
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
> --
> That is an x64 system.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:O4icgVEtHHA.412@.TK2MSFTNGP04.phx.gbl...
>> which one i should download for my sql2005 server(win2003 server).
>> SQLServer2005SP2-KB921896-IA64-ENU.exe
>> SQLServer2005SP2-KB921896-x64-ENU.exe
>> SQLServer2005SP2-KB921896-x86-ENU.exe
>>
>sql

downgrade SQL2005 to SQL2k - Unicode ANSI issue

Hello,

I created a script with database publishing wizard to convert a SS2005
db into a SS2k db. The script has schema and data and looks very good.
When I try to start the created script in SS2k-Query analyzer, I get an
error like (in german)

Server: Nachr.-Nr. 105, Schweregrad 15, Status 1, Zeile 2
?ffnendes Anführungszeichen vor der Zeichenfolge '????
'.
It meens - translated from german- 'opening quote before string
<blabla>'

In the sript it stops at this line:
EXEC dbo.sp_addextendedproperty @.name=N'GUID', @.value=N'????

In the script many lines before I have many other GUIDs which QA
doesn't complain, so it's an Unicode/ANSI-issue I guess. What to do
now?

thanks
candide_sh(candide_sh@.yahoo.de) writes:

Quote:

Originally Posted by

I created a script with database publishing wizard to convert a SS2005
db into a SS2k db. The script has schema and data and looks very good.
When I try to start the created script in SS2k-Query analyzer, I get an
error like (in german)
>
Server: Nachr.-Nr. 105, Schweregrad 15, Status 1, Zeile 2
ffnendes Anfhrungszeichen vor der Zeichenfolge '??
'.
It meens - translated from german- 'opening quote before string
><blabla>'
>
In the sript it stops at this line:
EXEC dbo.sp_addextendedproperty @.name=N'GUID', @.value=N'??
>
In the script many lines before I have many other GUIDs which QA
doesn't complain, so it's an Unicode/ANSI-issue I guess. What to do
now?

"Database publishing wizard" I will have to admit that this tool is unknown
to me. Do you mean the scripting wizard in Management Studio, or do you mean
a third-party tool?

In any case, the Open File dialog in QA has a File Format combo where you
can specify Unicode format. Normally QA (as many other Windows) tools
determines whether a file is Unicode or not by looking for a byte-order
mark in the beginning of the file. But some tools do not generate a byte-
order mark.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||DB Pub Wizard comes from SS2005, from Microsoft SQLServer2005 website
(search for feature pack)
I guess it creates a script file (myscript.sql) but doesn't create this
file in UNICODE. I searched and played around in SS2005, but I think I
can't influence the behaviour of DB Pub Wizard (writing only ANSI) from
SS2005.

Remember I open QA in SS2000 to start this script. Thanks for your
hint, I found the dialog box in QA and changed the file format to
Unicode, but no success.

--
candide_sh

On 26 Jan., 14:36, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

(candide...@.yahoo.de) writes:

Quote:

Originally Posted by

I created a script with database publishing wizard to convert a SS2005
db into a SS2k db. The script has schema and data and looks very good.
When I try to start the created script in SS2k-Query analyzer, I get an
error like (in german)

>

Quote:

Originally Posted by

Server: Nachr.-Nr. 105, Schweregrad 15, Status 1, Zeile 2
ffnendes Anfhrungszeichen vor der Zeichenfolge '??
'.
It meens - translated from german- 'opening quote before string
<blabla>'

>

Quote:

Originally Posted by

In the sript it stops at this line:
EXEC dbo.sp_addextendedproperty @.name=N'GUID', @.value=N'??

>

Quote:

Originally Posted by

In the script many lines before I have many other GUIDs which QA
doesn't complain, so it's an Unicode/ANSI-issue I guess. What to do
now?"Database publishing wizard" I will have to admit that this tool isunknown

to me. Do you mean the scripting wizard in Management Studio, or do you mean
a third-party tool?
>
In any case, the Open File dialog in QA has a File Format combo where you
can specify Unicode format. Normally QA (as many other Windows) tools
determines whether a file is Unicode or not by looking for a byte-order
mark in the beginning of the file. But some tools do not generate a byte-
order mark.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Zitierten Text ausblenden -- Zitierten Text anzeigen -

|||(candide_sh@.yahoo.de) writes:

Quote:

Originally Posted by

DB Pub Wizard comes from SS2005, from Microsoft SQLServer2005 website
(search for feature pack)
I guess it creates a script file (myscript.sql) but doesn't create this
file in UNICODE. I searched and played around in SS2005, but I think I
can't influence the behaviour of DB Pub Wizard (writing only ANSI) from
SS2005.
>
Remember I open QA in SS2000 to start this script. Thanks for your
hint, I found the dialog box in QA and changed the file format to
Unicode, but no success.

I downloaded the DB Publish Wizard, and it does indeed generate a Unicode
file. I had created this table on SQL 2005:

CREATE TABLE utlndsk(a nvarchar(234) NOT NULL)
go
INSERT utlndsk(a) VALUES (nchar(8080) + nchar(324))

and I was able to insert that data successfully on SQL 2000 through
Query Analyzer.

Maybe there is some special catch with extended properties. (I never
use them myself, so I did not play with one.)

What is in that extended property on SQL 2005?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||hello Erland

the GUID-value was created by the upsizing wizard of MS-Access2003 and
I really don't know what for it is. But the conservative way is to not
touch the values created by this wizard. As the script generated by DB
Pub wizard crashed at only this one GUID-value (others worked fine) I
commented this line out and manually copy/pasted this value. Well
done...

On 26 Jan., 23:42, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

(candide...@.yahoo.de) writes:

Quote:

Originally Posted by

DB Pub Wizard comes from SS2005, from Microsoft SQLServer2005 website
(search for feature pack)
I guess it creates a script file (myscript.sql) but doesn't create this
file in UNICODE. I searched and played around in SS2005, but I think I
can't influence the behaviour of DB Pub Wizard (writing only ANSI) from
SS2005.

>

Quote:

Originally Posted by

Remember I open QA in SS2000 to start this script. Thanks for your
hint, I found the dialog box in QA and changed the file format to
Unicode, but no success.I downloaded the DB Publish Wizard, and it doesindeed generate a Unicode

file. I had created this table on SQL 2005:
>
CREATE TABLE utlndsk(a nvarchar(234) NOT NULL)
go
INSERT utlndsk(a) VALUES (nchar(8080) + nchar(324))
>
and I was able to insert that data successfully on SQL 2000 through
Query Analyzer.
>
Maybe there is some special catch with extended properties. (I never
use them myself, so I did not play with one.)
>
What is in that extended property on SQL 2005?
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

'downgrade' sql server 2005

I developed my application using SQL2005 Developer edition. but my clients
wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
Edition to Express?
As long as your DB is less than 4gb .Backup and restore.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Patrick Yong" <patrickyong@.newsgroups.nospam> wrote in message
news:eTmqj1gQGHA.4900@.TK2MSFTNGP09.phx.gbl...
> I developed my application using SQL2005 Developer edition. but my clients
> wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
> Edition to Express?
>

'downgrade' sql server 2005

I developed my application using SQL2005 Developer edition. but my clients
wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
Edition to Express?As long as your DB is less than 4gb .Backup and restore.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Patrick Yong" <patrickyong@.newsgroups.nospam> wrote in message
news:eTmqj1gQGHA.4900@.TK2MSFTNGP09.phx.gbl...
> I developed my application using SQL2005 Developer edition. but my clients
> wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
> Edition to Express?
>

'downgrade' sql server 2005

I developed my application using SQL2005 Developer edition. but my clients
wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
Edition to Express?As long as your DB is less than 4gb .Backup and restore.
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Patrick Yong" <patrickyong@.newsgroups.nospam> wrote in message
news:eTmqj1gQGHA.4900@.TK2MSFTNGP09.phx.gbl...
> I developed my application using SQL2005 Developer edition. but my clients
> wants it free with SQL2005 Express. How exactly to migrate my DB in Dev
> Edition to Express?
>

Domain Group Members and Database Roles

Greetings...
I have a SQL2005 Express database where I have created 3 user defined
database roles, granted those db roles all the required permissions on the
required db objects, and made a few (Domain\Group) groups login members of
those database roles. The 3 roles are for high, medium, and low rights.
When a user logins with Windows NT authority, I can determine their identity
with
SUSER_SNAME(), but how can I easily determine what role or roles the user,
not the group, belongs to? The user would not have a principal_id, but the
group does. There's got to be a way to know what role the USER is in, isn't
there?
DaveHi
Try
sys.database_role_members catalog view
"DGardner" <DGardner@.discussions.microsoft.com> wrote in message
news:2BE1DB54-0A86-4CF8-A916-0666AD0790AF@.microsoft.com...
> Greetings...
> I have a SQL2005 Express database where I have created 3 user defined
> database roles, granted those db roles all the required permissions on the
> required db objects, and made a few (Domain\Group) groups login members of
> those database roles. The 3 roles are for high, medium, and low rights.
> When a user logins with Windows NT authority, I can determine their
> identity
> with
> SUSER_SNAME(), but how can I easily determine what role or roles the user,
> not the group, belongs to? The user would not have a principal_id, but the
> group does. There's got to be a way to know what role the USER is in,
> isn't
> there?
> Dave|||Uri,
that view is not too informative... I finally got this query to work for
what I want:
Select name as Roles
From sys.database_principals
Where type='R' And is_fixed_role=0 And principal_id<>0
But I wouldn't call this 'easy' or intuitive...
Dave
"Uri Dimant" wrote:

> Hi
> Try
> sys.database_role_members catalog view
>
> "DGardner" <DGardner@.discussions.microsoft.com> wrote in message
> news:2BE1DB54-0A86-4CF8-A916-0666AD0790AF@.microsoft.com...
>
>|||Hi Dave.
Try with the IS_MEMBER function
Regards
Antonio Soto
Solid Quality Learning
http://www.sqlu.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"DGardner" <DGardner@.discussions.microsoft.com> escribi en el mensaje
news:2BE1DB54-0A86-4CF8-A916-0666AD0790AF@.microsoft.com...
> Greetings...
> I have a SQL2005 Express database where I have created 3 user defined
> database roles, granted those db roles all the required permissions on the
> required db objects, and made a few (Domain\Group) groups login members of
> those database roles. The 3 roles are for high, medium, and low rights.
> When a user logins with Windows NT authority, I can determine their
> identity
> with
> SUSER_SNAME(), but how can I easily determine what role or roles the user,
> not the group, belongs to? The user would not have a principal_id, but the
> group does. There's got to be a way to know what role the USER is in,
> isn't
> there?
> Dave|||Antonio,
Sorry... IS_MEMBER() doesn't work either. Although the group is assigned to
the role, the individual user who is a member of the group is not, and so
IS_MEMBER() returns 0 every time. It looks like the query I constructed is
the only way to get the info I want.
Dave
"Antonio Soto" wrote:

> Hi Dave.
> Try with the IS_MEMBER function
> Regards
> --
> Antonio Soto
> Solid Quality Learning
> http://www.sqlu.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
> "DGardner" <DGardner@.discussions.microsoft.com> escribió en el mensaje
> news:2BE1DB54-0A86-4CF8-A916-0666AD0790AF@.microsoft.com...
>
>