How to make setup of report

Hello all
I made some reports at my machine. Now i installed Sql Server Reporting
Services on other machine which is production machine. I want to make
an installable or setup or any package to install created reports. Can
anyone help me how to do this?
I gone through Publish sample reports, i tried to publish my one
report, but it shows some error. In the script i dont know what to put
infront of parentFolder. can any one help me.
Thanks & Regards
RajThe server should be something like
http://yourservername/ReportServer
If you want the report in my reports...use
My Reports/Yourfoldername
and for data sources
My Reports/Data Sources
replace My Reports with whatever directory under RS you wish your reports to
be deployed ( and that you have permission to do.)
Hope this helps...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Raj" wrote:
> Hello all
> I made some reports at my machine. Now i installed Sql Server Reporting
> Services on other machine which is production machine. I want to make
> an installable or setup or any package to install created reports. Can
> anyone help me how to do this?
> I gone through Publish sample reports, i tried to publish my one
> report, but it shows some error. In the script i dont know what to put
> infront of parentFolder. can any one help me.
>
> Thanks & Regards
> Raj
>

How to make a database in Sql2005 Express

I have installed the Sql2005 Express.
But there are not any tools like Enterprise Manager in it.
How can I establish a database in it?
You can use Microsoft SQL Server 2005 Express Manager as a database
management tool for SQL Server Express 2005.
http://www.microsoft.com/downloads/d...displaylang=en
- Peter Ward
WARDY IT Solutions
"ad" wrote:

> I have installed the Sql2005 Express.
> But there are not any tools like Enterprise Manager in it.
> How can I establish a database in it?
>
>

How to make a database in Sql2005 Express

I have installed the Sql2005 Express.
But there are not any tools like Enterprise Manager in it.
How can I establish a database in it?You can use Microsoft SQL Server 2005 Express Manager as a database
management tool for SQL Server Express 2005.
http://www.microsoft.com/downloads/details.aspx?familyid=8f92556a-6c3b-47d2-9929-ecdc5a4d25ae&displaylang=en
- Peter Ward
WARDY IT Solutions
"ad" wrote:
> I have installed the Sql2005 Express.
> But there are not any tools like Enterprise Manager in it.
> How can I establish a database in it?
>
>

How to make a database in Sql2005 Express

I have installed the Sql2005 Express.
But there are not any tools like Enterprise Manager in it.
How can I establish a database in it?You can use Microsoft SQL Server 2005 Express Manager as a database
management tool for SQL Server Express 2005.
http://www.microsoft.com/downloads/...&displaylang=en
- Peter Ward
WARDY IT Solutions
"ad" wrote:

> I have installed the Sql2005 Express.
> But there are not any tools like Enterprise Manager in it.
> How can I establish a database in it?
>
>

How to login to SQL Server Web Data Administrator?

I have installed Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) and the SQL Server Web Data Administrator. After I run the SQL Server Web Data Administrator it
is asking me for login and password. How can I determine my login and password? Thank you.Try using "sa" for login (without the quotes) and a blank password. After you login, make sure you change the password to something non-blank!

How to list all installed MS SQL Server Name by Delphi or other program language

How to list all installed MS SQL Server Name by Delphi or other program language?You can use SQL-DMO to achieve this. Here is some VB code:

Private Function GetAllSqlServerCollection(colSqlServers As Collection)
As
Boolean
Dim intIndex As Integer
Dim oApplication As SQLDMO.Application
Dim oNameList As SQLDMO.NameList

Set oApplication = New Application
With oApplication
Set oNameList = .ListAvailableSQLServers
With oNameList
For intIndex = 1 To .Count
colSqlServers.Add (oNameList.Item(intIndex))
Next
End With
End With
Set oApplication = Nothing
GetAllSqlServerCollection = True
End Function

macka.|||uh whats a delphi

haha|||It is a program language product by Borland (or it may be seen as visual pascal)|||Thank you!
Now, I can solve my problem.

how to know which sql server 2000 version is installed

how to know which sql server 2000 is installed: standart or professional?
thanks
http://www.aspfaq.com/2160
HTH, Jens Suessmeyer.

how to know which sql server 2000 version is installed

how to know which sql server 2000 is installed: standart or professional?
thankshttp://www.aspfaq.com/2160
HTH, Jens Suessmeyer.

how to know which sql server 2000 version is installed

how to know which sql server 2000 is installed: standart or professional?
thankshttp://www.aspfaq.com/2160
HTH, Jens Suessmeyer.

How to know what sql version is installed.

Hi, we are verifying the licenses of sql server that we have installed
on al the company. But we dont know how to know with type of
installation a machine has.
For example, if i execute the select @.@.version statement in QA it
returns all the information But we need a way to know this information
at a file level.
Do you know how can i get this information without using sql sentences.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Maria,
I just this week wrote this kixTart script that checks for the product
version of a local SQL client tools installation. We will be running it
through Scriptlogic which is the script running tool that we use
(recommended). Scriptlogic is a kixtart environment, but the script could
easily be made into vbscript.
The @.@.version command checks to see what is installed on the server that
hosts the database regardless of where you run it from.
$LogFile = "\\Acsb\Common\Administration\Shared\DB\inv\Cver.t xt"
$SQLFile = "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe"
$AnaLiveFile = "C:\Anasazi\Live\AS\APP\ATRAIN.ICO"
$AnaExist = "No Value"
If Exist ("$AnaLiveFile")
$AnaExist = "Y"
Else
$AnaExist = "N"
EndIf
If Exist ("$SQLFile")
$Cver = GetFileVersion("$SQLFile", "ProductVersion")
Else
$Cver = "No SQl File"
EndIf
$ReturnCode = RedirectOutput("$LogFile","0")
If $ReturnCode = 0
? @.WKSTA + "," + $Cver + "," + $AnaExist + "," + @.USERID + "," +
@.PRODUCTTYPE + "," + @.FULLNAME + "," + @.IPADDRESS0 + "," + @.DATE + "," + @.CSD
EndIf
The product version of osql.exe will be 800.760 if Service pack 3 is
installed, 800.194 if not. I hope that helps.
"MariaGuzman" wrote:

> Hi, we are verifying the licenses of sql server that we have installed
> on al the company. But we don4t know how to know with type of
> installation a machine has.
> For example, if i execute the select @.@.version statement in QA it
> returns all the information But we need a way to know this information
> at a file level.
> Do you know how can i get this information without using sql sentences.
> Thanks a lot for your help.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>

How to know what sql version is installed.

Hi, we are verifying the licenses of sql server that we have installed
on al the company. But we dont know how to know with type of
installation a machine has.
For example, if i execute the select @.@.version statement in QA it
returns all the information But we need a way to know this information
at a file level.
Do you know how can i get this information without using sql sentences.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!Maria,
I just this week wrote this kixTart script that checks for the product
version of a local SQL client tools installation. We will be running it
through Scriptlogic which is the script running tool that we use
(recommended). Scriptlogic is a kixtart environment, but the script could
easily be made into vbscript.
The @.@.version command checks to see what is installed on the server that
hosts the database regardless of where you run it from.
$LogFile = " \\Acsb\Common\Administration\Shared\DB\i
nv\Cver.txt"
$SQLFile = "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe"
$AnaLiveFile = "C:\Anasazi\Live\AS\APP\ATRAIN.ICO"
$AnaExist = "No Value"
If Exist ("$AnaLiveFile")
$AnaExist = "Y"
Else
$AnaExist = "N"
EndIf
If Exist ("$SQLFile")
$Cver = GetFileVersion("$SQLFile", "ProductVersion")
Else
$Cver = "No SQl File"
EndIf
$ReturnCode = RedirectOutput("$LogFile","0")
If $ReturnCode = 0
? @.WKSTA + "," + $Cver + "," + $AnaExist + "," + @.USERID + "," +
@.PRODUCTTYPE + "," + @.FULLNAME + "," + @.IPADDRESS0 + "," + @.DATE + "," + @.CS
D
EndIf
The product version of osql.exe will be 800.760 if Service pack 3 is
installed, 800.194 if not. I hope that helps.
"MariaGuzman" wrote:

> Hi, we are verifying the licenses of sql server that we have installed
> on al the company. But we don4t know how to know with type of
> installation a machine has.
> For example, if i execute the select @.@.version statement in QA it
> returns all the information But we need a way to know this information
> at a file level.
> Do you know how can i get this information without using sql sentences.
> Thanks a lot for your help.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>

How to know what sql version is installed.

Hi, we are verifying the licenses of sql server that we have installed
on al the company. But we don´t know how to know with type of
installation a machine has.
For example, if i execute the select @.@.version statement in QA it
returns all the information But we need a way to know this information
at a file level.
Do you know how can i get this information without using sql sentences.
Thanks a lot for your help.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Maria,
I just this week wrote this kixTart script that checks for the product
version of a local SQL client tools installation. We will be running it
through Scriptlogic which is the script running tool that we use
(recommended). Scriptlogic is a kixtart environment, but the script could
easily be made into vbscript.
The @.@.version command checks to see what is installed on the server that
hosts the database regardless of where you run it from.
$LogFile = "\\Acsb\Common\Administration\Shared\DB\inv\Cver.txt"
$SQLFile = "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe"
$AnaLiveFile = "C:\Anasazi\Live\AS\APP\ATRAIN.ICO"
$AnaExist = "No Value"
If Exist ("$AnaLiveFile")
$AnaExist = "Y"
Else
$AnaExist = "N"
EndIf
If Exist ("$SQLFile")
$Cver = GetFileVersion("$SQLFile", "ProductVersion")
Else
$Cver = "No SQl File"
EndIf
$ReturnCode = RedirectOutput("$LogFile","0")
If $ReturnCode = 0
? @.WKSTA + "," + $Cver + "," + $AnaExist + "," + @.USERID + "," +
@.PRODUCTTYPE + "," + @.FULLNAME + "," + @.IPADDRESS0 + "," + @.DATE + "," + @.CSD
EndIf
The product version of osql.exe will be 800.760 if Service pack 3 is
installed, 800.194 if not. I hope that helps.
"MariaGuzman" wrote:
> Hi, we are verifying the licenses of sql server that we have installed
> on al the company. But we don4t know how to know with type of
> installation a machine has.
> For example, if i execute the select @.@.version statement in QA it
> returns all the information But we need a way to know this information
> at a file level.
> Do you know how can i get this information without using sql sentences.
> Thanks a lot for your help.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>