Query accross servers

Hi,
Please could someone provide me with a best example of how to query records
from different tables in different databases, where the databases are
located on different servers on the same network.
Your assistance is much appreciated.If you want to use different servers you have to build up some linked
servers (look in the BOL). There you can go with the four-point name to
query them.
Select * from [Servername].[Databasename].[owner].[Objectname]
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"11Oppidan" <11Oppidan@.community.nospam> schrieb im Newsbeitrag
news:us3gSr6WFHA.3092@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Please could someone provide me with a best example of how to query
> records from different tables in different databases, where the databases
> are located on different servers on the same network.
> Your assistance is much appreciated.
>|||You may also want to check out OPENQUERY in BOL. Sometimes it yields
better performance than four-part names.
Here's an excerpt from BOL:
This example creates a linked server named OracleSvr against an Oracle
database using the Microsoft OLE DB Provider for Oracle. Then this
example uses a pass-through query against this linked server.
Note This example assumes that an Oracle database alias called ORCLDB
has been created.
EXEC sp_addlinkedserver 'OracleSvr',
'Oracle 7.3',
'MSDAORA',
'ORCLDB'
GO
SELECT *
FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM joe.titles')
GO
HTH...
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Wed, 18 May 2005 15:13:15 +0200, "Jens Smeyer"
<Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote:

>If you want to use different servers you have to build up some linked
>servers (look in the BOL). There you can go with the four-point name to
>query them.
>Select * from [Servername].[Databasename].[owner].[Objectname]|||Thanks guys!
"Joe Webb" <joew@.webbtechsolutions.com> wrote in message
news:67gm815emd4m6g2vb7dr70tsn01vsciaon@.
4ax.com...
> You may also want to check out OPENQUERY in BOL. Sometimes it yields
> better performance than four-part names.
> Here's an excerpt from BOL:
> This example creates a linked server named OracleSvr against an Oracle
> database using the Microsoft OLE DB Provider for Oracle. Then this
> example uses a pass-through query against this linked server.
> Note This example assumes that an Oracle database alias called ORCLDB
> has been created.
>
> EXEC sp_addlinkedserver 'OracleSvr',
> 'Oracle 7.3',
> 'MSDAORA',
> 'ORCLDB'
> GO
> SELECT *
> FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM joe.titles')
> GO
>
> HTH...
> --
> Joe Webb
> SQL Server MVP
>
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/t...il/-/0972688811
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
>
> On Wed, 18 May 2005 15:13:15 +0200, "Jens Smeyer"
> <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote:
>
>

query 2 server at the same time

can some one please tell me with an example,how to query data from two db server in the same tsql query.

Thanks in advace

You have to setup a linked server and then use full 4 parts to query the linked server.

SELECT *
FROM linkserver.dbname.schema.tablename
JOIN tablename

query - specify multiple items

Hi,
I am trying to develop a report where the user is able to specify the
information to be pulled from one specific field.
For example... the table has 2 fields... Company ID, Company Name
I only want to see information where Company ID = ABC and XYZ
but I want the user to be able to specify multiple Company ID's in the
report parameter
Thanks,
JenI've got part of the query figured out:
SELECT Company ID, Company Name
FROM Company Profile
WHERE (Company ID (@.CompanyID))
But this only lets me query one company id at a time. how can I alter the
query to allow users to query multiple company id's?
thanks
jen
"Jennifer Mar" <jmar@.cityharvest.org> wrote in message
news:O6rTcrxZHHA.1300@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I am trying to develop a report where the user is able to specify the
> information to be pulled from one specific field.
> For example... the table has 2 fields... Company ID, Company Name
> I only want to see information where Company ID = ABC and XYZ
> but I want the user to be able to specify multiple Company ID's in the
> report parameter
> Thanks,
> Jen
>|||Hello Jennifer,
If you are using the SQL Server 2005, you could use the Multi-value
Parameter.
When you enable the Multi-value for the parameter, you could get a dropdown
list in the report.
Then you need to use the IN statement to query the data.
You could refer this article:
Adding a Multivalue Parameter
http://msdn2.microsoft.com/en-us/aa337396.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||We're currently running sql server 2000. i am using visual studio .net to
build the reports.
The way the query is build now, it allows the user to enter the parameters
in a seperate text box for each company id they query. how can i build the
query so that they can just enter a string of unlimited company id's?
thanks!
jen
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:OO42Wm4ZHHA.1784@.TK2MSFTNGHUB02.phx.gbl...
> Hello Jennifer,
> If you are using the SQL Server 2005, you could use the Multi-value
> Parameter.
> When you enable the Multi-value for the parameter, you could get a
dropdown
> list in the report.
> Then you need to use the IN statement to query the data.
> You could refer this article:
> Adding a Multivalue Parameter
> http://msdn2.microsoft.com/en-us/aa337396.aspx
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
>
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Jen,
You could use the parameter as the String and use the comma mark to
seperate each company id.
And in the query, you could use the parameter like this:
Select * from tbl_companies where companyid in (@.Parameters)
Hope this will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||hi wei,
thanks so much for checking in. everything worked out great :)
jen
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:5JytuQ7aHHA.1028@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>|||Hello Jen,
My pleasure!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Query

Hi All

Thnks

I have a Datatable in which the rows have a unique id no appended to it

Example ColumnName : Manufacturer

Rows: Item1{6319c77a-b2c6-4b26-9528-99685de50d41}

Item2{e919c77a-b2c6-4b26-9528-99685de50d41}

Item3{ab19c77a-b2c6-4b26-9528-99685de50d41}

I need to insert into database only the unique id of the rows

6319c77a-b2c6-4b26-9528-99685de50d41 ie the num within {} brakets

How do I do this ?

Cheers

use this sample,

Code Snippet

Create Table #data (

[Value] Varchar(100)

);

Insert Into #data Values('Item1{6319c77a-b2c6-4b26-9528-99685de50d41}');

Insert Into #data Values('Item2{e919c77a-b2c6-4b26-9528-99685de50d41}');

Insert Into #data Values('Item3{ab19c77a-b2c6-4b26-9528-99685de50d41}');

Create Table #Targetdata (

[Value] UniqueIdentifier

);

insert into #Targetdata

Select Substring(Value,Charindex('{',Value)+1,CharIndex('}',Value)-1) From #Data

|||

Perhaps this will give you the direction you seek.

Code Snippet

SET NOCOUNT ON

DECLARE @.Manufacturer table
( [Rows] varchar(100) )

INSERT INTO @.Manufacturer VALUES ( 'Item1{6319c77a-b2c6-4b26-9528-99685de50d41}' )
INSERT INTO @.Manufacturer VALUES ( 'Item2{e919c77a-b2c6-4b26-9528-99685de50d41}' )
INSERT INTO @.Manufacturer VALUES ( 'Item3{ab19c77a-b2c6-4b26-9528-99685de50d41}' )

SELECT [ID] = substring( [Rows], 7, 36 )
FROM @.Manufacturer

ID
6319c77a-b2c6-4b26-9528-99685de50d41
e919c77a-b2c6-4b26-9528-99685de50d41
ab19c77a-b2c6-4b26-9528-99685de50d41

|||

Thanks a lot this works just fine .

|||

Thanks a lot this works just fine .

query

Hi, I have a query to build a returned record as and order by Name:
ID, Name
5 A
1 B
3 C '?
4 D
2 E
Now, I want to add a parameter (for example ID=3) to the query (or somehow),
so the returned record only return:
ID, Name
4 D
2 E
How to do that? Thanks.Please post the text of your query, then I will have my worker bees make the
changes you request.|||Try,
select [id], [name]
from t1
where [id] > 3
order by [name]
AMB
"js" wrote:

> Hi, I have a query to build a returned record as and order by Name:
> ID, Name
> 5 A
> 1 B
> 3 C '?
> 4 D
> 2 E
>
> Now, I want to add a parameter (for example ID=3) to the query (or somehow
),
> so the returned record only return:
> ID, Name
> 4 D
> 2 E
>
> How to do that? Thanks.
>
>|||Add a WHERE clause to your query. It is possible to create a stored
procedure which accepts a parameter. The stored procedure would return data
just as your query does.
Keith
"js" <js@.someone@.hotmail.com> wrote in message
news:e1O1SpATFHA.3056@.TK2MSFTNGP14.phx.gbl...
> Hi, I have a query to build a returned record as and order by Name:
> ID, Name
> 5 A
> 1 B
> 3 C '?
> 4 D
> 2 E
>
> Now, I want to add a parameter (for example ID=3) to the query (or
> somehow), so the returned record only return:
> ID, Name
> 4 D
> 2 E
>
> How to do that? Thanks.
>
>|||Thanks...
Add a WHERE clause(where [id] > 3) to query will filter out (2, E)?
select [id], [name]
from t1
where [id] > 3
order by [name]
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:O1uUovATFHA.2996@.TK2MSFTNGP15.phx.gbl...
> Add a WHERE clause to your query. It is possible to create a stored
> procedure which accepts a parameter. The stored procedure would return
> data just as your query does.
> --
> Keith
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:e1O1SpATFHA.3056@.TK2MSFTNGP14.phx.gbl...
>|||One solution would be:
Select T.Id, T.Name
From Table As T
Where Ascii(T.Name) > Ascii('C')
Another would be
Select T.Id, T.Name
From Table As T
Where Cast(T.Name As Binary(1)) > Cast('C' As Binary(1))
Of course, by doing it this way, you'll likely get an index or table scan.
Thomas
"js" <js@.someone@.hotmail.com> wrote in message
news:e1O1SpATFHA.3056@.TK2MSFTNGP14.phx.gbl...
> Hi, I have a query to build a returned record as and order by Name:
> ID, Name
> 5 A
> 1 B
> 3 C '?
> 4 D
> 2 E
>
> Now, I want to add a parameter (for example ID=3) to the query (or somehow
),
> so the returned record only return:
> ID, Name
> 4 D
> 2 E
>
> How to do that? Thanks.
>
>|||Actually, SQL as I just discovered, SQL is smart enough to do this sort of
analysis on strings for you. So you should be able to do this:
Select T.Id, T.Name
From Table As T
Where T.Name > 'C'
Thomas
"Thomas Coleman" <replyingroup@.anywhere.com> wrote in message
news:%23CLAj9ATFHA.3036@.TK2MSFTNGP10.phx.gbl...
> One solution would be:
> Select T.Id, T.Name
> From Table As T
> Where Ascii(T.Name) > Ascii('C')
> Another would be
> Select T.Id, T.Name
> From Table As T
> Where Cast(T.Name As Binary(1)) > Cast('C' As Binary(1))
> Of course, by doing it this way, you'll likely get an index or table scan.
>
> Thomas
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:e1O1SpATFHA.3056@.TK2MSFTNGP14.phx.gbl...
>|||Thanks Thomas,
I don't know 'C' but only "ID=3"

Query:
select [id], [name] from tb1
union
select [id], [name] from tb2
union
select [id], [name] from tb3
ORDER BY [name]
Output:
How to return this base the previous query:
Can I use a cursor in sql:
dim rs
sql0= "DECLARE TBs_Cursor CURSOR FOR "
sql1 = "select [id], [name] from tb1 union select [id], [name] from tb2
union select [id], [name] from tb3 ORDER BY [name]"
sql2 = sql0 + sql1 + 'OPEN Cursor, Loop if ID < 3, then delete, and return
the records'
rs.open sql2,...
"Thomas Coleman" <replyingroup@.anywhere.com> wrote in message
news:%23CLAj9ATFHA.3036@.TK2MSFTNGP10.phx.gbl...
> One solution would be:
> Select T.Id, T.Name
> From Table As T
> Where Ascii(T.Name) > Ascii('C')
> Another would be
> Select T.Id, T.Name
> From Table As T
> Where Cast(T.Name As Binary(1)) > Cast('C' As Binary(1))
> Of course, by doing it this way, you'll likely get an index or table scan.
>
> Thomas
>
> "js" <js@.someone@.hotmail.com> wrote in message
> news:e1O1SpATFHA.3056@.TK2MSFTNGP14.phx.gbl...
>|||On Thu, 28 Apr 2005 11:52:44 -0400, "js" <js@.someone@.hotmail.com> wrote:

>Hi, I have a query to build a returned record as and order by Name:
>ID, Name
>5 A
>1 B
>3 C '?
>4 D
>2 E
>
>Now, I want to add a parameter (for example ID=3) to the query (or somehow)
,
>so the returned record only return:
>ID, Name
>4 D
>2 E
>
>How to do that? Thanks.
>
Hi js,
Try if this does what you want:
SELECT ID, Name
FROM MyTable
WHERE Name > (SELECT Name
FROM MyTable
WHERE Id = 3)
ORDER BY Name
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||> I don't know 'C' but only "ID=3"
Not sure what you mean here.
Thomas

Query

Hi
Is there any T-SQL script/query to find out is full text search service
precent or not?
For example if i have SQL 2005 Express then no and yes if i have SQL 2005
Express Advanced?
Best regards
Mex
SELECT fulltextserviceproperty('IsFulltextInstalled')
returns 1 if it is installed 0 if it is not.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Meels Lilbok" <meelis.lilbok@.deltmar.ee> wrote in message
news:2514C014-0348-4B92-AA77-07A8B20F0BFD@.microsoft.com...
> Hi
> Is there any T-SQL script/query to find out is full text search service
> precent or not?
> For example if i have SQL 2005 Express then no and yes if i have SQL 2005
> Express Advanced?
>
> Best regards
> Mex
>

Quality Control

Does RS2005 have any quality control mechanisms. Can a report be edited once
its rendered and posted to the report server? For example, my report could
have a paragraph describing some aspect of the report. Could this paragraph
be manually edited?
Thank You - mcOnce the report is published it will continue to be rendered with regards to
the published RDL. However, you can always update the rdl and republish it
on top of the old RDL changing what users see.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mc" <mc@.discussions.microsoft.com> wrote in message
news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> Does RS2005 have any quality control mechanisms. Can a report be edited
> once
> its rendered and posted to the report server? For example, my report
> could
> have a paragraph describing some aspect of the report. Could this
> paragraph
> be manually edited?
> Thank You - mc|||Hi Daniel, thank you for the response. Could you also answer the following?
What if the user was responsible for editing the report? For example, a
user logs in to review the report and wants to make a change? Can the rdl
be updated while viewing the report or would this require a custom
application to make changes?
This leads to another question. Does "re-publishing" track versions or
would it simply be like running another report?
Thanks - mc
"Daniel Reib [MSFT]" wrote:
> Once the report is published it will continue to be rendered with regards to
> the published RDL. However, you can always update the rdl and republish it
> on top of the old RDL changing what users see.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> > Does RS2005 have any quality control mechanisms. Can a report be edited
> > once
> > its rendered and posted to the report server? For example, my report
> > could
> > have a paragraph describing some aspect of the report. Could this
> > paragraph
> > be manually edited?
> >
> > Thank You - mc
>
>|||No the user would not be able to edit the reports while viewing them. If
the user has the correct permission they could download the rdl from Report
Manager and edit the report in Report Designer, but I don't imagine this is
what you want.
Republishing does not track versions. You can create history snapshots of
the report which can be saved and viewed later. You can't trigger them on
publish but can on some other events.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mc" <mc@.discussions.microsoft.com> wrote in message
news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
> Hi Daniel, thank you for the response. Could you also answer the
> following?
> What if the user was responsible for editing the report? For example, a
> user logs in to review the report and wants to make a change? Can the
> rdl
> be updated while viewing the report or would this require a custom
> application to make changes?
> This leads to another question. Does "re-publishing" track versions or
> would it simply be like running another report?
> Thanks - mc
>
>
> "Daniel Reib [MSFT]" wrote:
>> Once the report is published it will continue to be rendered with regards
>> to
>> the published RDL. However, you can always update the rdl and republish
>> it
>> on top of the old RDL changing what users see.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
>> > Does RS2005 have any quality control mechanisms. Can a report be
>> > edited
>> > once
>> > its rendered and posted to the report server? For example, my report
>> > could
>> > have a paragraph describing some aspect of the report. Could this
>> > paragraph
>> > be manually edited?
>> >
>> > Thank You - mc
>>|||No, it would not be feasible for the user to edit the rdl. I would have to
come up with a way to allow the users to make changes or flag the report for
a custom system to allow changes. Any suggestions?
"Daniel Reib [MSFT]" wrote:
> No the user would not be able to edit the reports while viewing them. If
> the user has the correct permission they could download the rdl from Report
> Manager and edit the report in Report Designer, but I don't imagine this is
> what you want.
> Republishing does not track versions. You can create history snapshots of
> the report which can be saved and viewed later. You can't trigger them on
> publish but can on some other events.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
> > Hi Daniel, thank you for the response. Could you also answer the
> > following?
> >
> > What if the user was responsible for editing the report? For example, a
> > user logs in to review the report and wants to make a change? Can the
> > rdl
> > be updated while viewing the report or would this require a custom
> > application to make changes?
> >
> > This leads to another question. Does "re-publishing" track versions or
> > would it simply be like running another report?
> >
> > Thanks - mc
> >
> >
> >
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Once the report is published it will continue to be rendered with regards
> >> to
> >> the published RDL. However, you can always update the rdl and republish
> >> it
> >> on top of the old RDL changing what users see.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> >> > Does RS2005 have any quality control mechanisms. Can a report be
> >> > edited
> >> > once
> >> > its rendered and posted to the report server? For example, my report
> >> > could
> >> > have a paragraph describing some aspect of the report. Could this
> >> > paragraph
> >> > be manually edited?
> >> >
> >> > Thank You - mc
> >>
> >>
> >>
>
>|||It really depends on how complex the changes are that users can make. If
they are trivial text changes you could write an app using the ReportViewer
control to display the report. You could then have an edit button and build
a simple designer that allows them to change only elements you wish.
If you just want to flag the report then all RS catalog items have a generic
property bag associated with them. You could have the users set some
property to flag that the report needs updating.
I hope that helps.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mc" <mc@.discussions.microsoft.com> wrote in message
news:4084F46B-8D7A-474F-A68E-08A5CFC7AC1D@.microsoft.com...
> No, it would not be feasible for the user to edit the rdl. I would have
> to
> come up with a way to allow the users to make changes or flag the report
> for
> a custom system to allow changes. Any suggestions?
>
> "Daniel Reib [MSFT]" wrote:
>> No the user would not be able to edit the reports while viewing them. If
>> the user has the correct permission they could download the rdl from
>> Report
>> Manager and edit the report in Report Designer, but I don't imagine this
>> is
>> what you want.
>> Republishing does not track versions. You can create history snapshots
>> of
>> the report which can be saved and viewed later. You can't trigger them
>> on
>> publish but can on some other events.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
>> > Hi Daniel, thank you for the response. Could you also answer the
>> > following?
>> >
>> > What if the user was responsible for editing the report? For example,
>> > a
>> > user logs in to review the report and wants to make a change? Can the
>> > rdl
>> > be updated while viewing the report or would this require a custom
>> > application to make changes?
>> >
>> > This leads to another question. Does "re-publishing" track versions or
>> > would it simply be like running another report?
>> >
>> > Thanks - mc
>> >
>> >
>> >
>> >
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> Once the report is published it will continue to be rendered with
>> >> regards
>> >> to
>> >> the published RDL. However, you can always update the rdl and
>> >> republish
>> >> it
>> >> on top of the old RDL changing what users see.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "mc" <mc@.discussions.microsoft.com> wrote in message
>> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
>> >> > Does RS2005 have any quality control mechanisms. Can a report be
>> >> > edited
>> >> > once
>> >> > its rendered and posted to the report server? For example, my
>> >> > report
>> >> > could
>> >> > have a paragraph describing some aspect of the report. Could this
>> >> > paragraph
>> >> > be manually edited?
>> >> >
>> >> > Thank You - mc
>> >>
>> >>
>> >>
>>|||Yes your explanation helped, Thank You!
On a side note, would you have any input into the following
1) Is it possible to create a report template containing text that would
be evaluated at runtime by a sql query? For example, the text in my
reports need to cater to various languages. Can I configure a textbox to
look up a value when the report is run?
2) How flexible are the graphing capabilities? Can you a third party
package be used to create graphs as long as the rdl file is constructed
properly?
3) Does RS provide a good audit mechanism for logging and tracking reports?
Thanks again - mc
"Daniel Reib [MSFT]" wrote:
> It really depends on how complex the changes are that users can make. If
> they are trivial text changes you could write an app using the ReportViewer
> control to display the report. You could then have an edit button and build
> a simple designer that allows them to change only elements you wish.
> If you just want to flag the report then all RS catalog items have a generic
> property bag associated with them. You could have the users set some
> property to flag that the report needs updating.
> I hope that helps.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:4084F46B-8D7A-474F-A68E-08A5CFC7AC1D@.microsoft.com...
> > No, it would not be feasible for the user to edit the rdl. I would have
> > to
> > come up with a way to allow the users to make changes or flag the report
> > for
> > a custom system to allow changes. Any suggestions?
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> No the user would not be able to edit the reports while viewing them. If
> >> the user has the correct permission they could download the rdl from
> >> Report
> >> Manager and edit the report in Report Designer, but I don't imagine this
> >> is
> >> what you want.
> >>
> >> Republishing does not track versions. You can create history snapshots
> >> of
> >> the report which can be saved and viewed later. You can't trigger them
> >> on
> >> publish but can on some other events.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
> >> > Hi Daniel, thank you for the response. Could you also answer the
> >> > following?
> >> >
> >> > What if the user was responsible for editing the report? For example,
> >> > a
> >> > user logs in to review the report and wants to make a change? Can the
> >> > rdl
> >> > be updated while viewing the report or would this require a custom
> >> > application to make changes?
> >> >
> >> > This leads to another question. Does "re-publishing" track versions or
> >> > would it simply be like running another report?
> >> >
> >> > Thanks - mc
> >> >
> >> >
> >> >
> >> >
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> Once the report is published it will continue to be rendered with
> >> >> regards
> >> >> to
> >> >> the published RDL. However, you can always update the rdl and
> >> >> republish
> >> >> it
> >> >> on top of the old RDL changing what users see.
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> >> >> > Does RS2005 have any quality control mechanisms. Can a report be
> >> >> > edited
> >> >> > once
> >> >> > its rendered and posted to the report server? For example, my
> >> >> > report
> >> >> > could
> >> >> > have a paragraph describing some aspect of the report. Could this
> >> >> > paragraph
> >> >> > be manually edited?
> >> >> >
> >> >> > Thank You - mc
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I can answer the question 3 for you. RS writes every report execution in
the ExecutionLog Table. This table is purged every 30 days. We have
provided some DTS packages for extracting the data to another DB for long
term storage that you would want to take advantage of.
Here is a link describing the process:
http://msdn2.microsoft.com/library/ms159110.aspx
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"mc" <mc@.discussions.microsoft.com> wrote in message
news:C1756736-E8F2-469C-B524-4C934AF8F9CE@.microsoft.com...
> Yes your explanation helped, Thank You!
> On a side note, would you have any input into the following
> 1) Is it possible to create a report template containing text that would
> be evaluated at runtime by a sql query? For example, the text in my
> reports need to cater to various languages. Can I configure a textbox to
> look up a value when the report is run?
> 2) How flexible are the graphing capabilities? Can you a third party
> package be used to create graphs as long as the rdl file is constructed
> properly?
>
> 3) Does RS provide a good audit mechanism for logging and tracking
> reports?
>
> Thanks again - mc
> "Daniel Reib [MSFT]" wrote:
>> It really depends on how complex the changes are that users can make. If
>> they are trivial text changes you could write an app using the
>> ReportViewer
>> control to display the report. You could then have an edit button and
>> build
>> a simple designer that allows them to change only elements you wish.
>> If you just want to flag the report then all RS catalog items have a
>> generic
>> property bag associated with them. You could have the users set some
>> property to flag that the report needs updating.
>> I hope that helps.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "mc" <mc@.discussions.microsoft.com> wrote in message
>> news:4084F46B-8D7A-474F-A68E-08A5CFC7AC1D@.microsoft.com...
>> > No, it would not be feasible for the user to edit the rdl. I would
>> > have
>> > to
>> > come up with a way to allow the users to make changes or flag the
>> > report
>> > for
>> > a custom system to allow changes. Any suggestions?
>> >
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> No the user would not be able to edit the reports while viewing them.
>> >> If
>> >> the user has the correct permission they could download the rdl from
>> >> Report
>> >> Manager and edit the report in Report Designer, but I don't imagine
>> >> this
>> >> is
>> >> what you want.
>> >>
>> >> Republishing does not track versions. You can create history
>> >> snapshots
>> >> of
>> >> the report which can be saved and viewed later. You can't trigger
>> >> them
>> >> on
>> >> publish but can on some other events.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "mc" <mc@.discussions.microsoft.com> wrote in message
>> >> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
>> >> > Hi Daniel, thank you for the response. Could you also answer the
>> >> > following?
>> >> >
>> >> > What if the user was responsible for editing the report? For
>> >> > example,
>> >> > a
>> >> > user logs in to review the report and wants to make a change? Can
>> >> > the
>> >> > rdl
>> >> > be updated while viewing the report or would this require a custom
>> >> > application to make changes?
>> >> >
>> >> > This leads to another question. Does "re-publishing" track versions
>> >> > or
>> >> > would it simply be like running another report?
>> >> >
>> >> > Thanks - mc
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >> > "Daniel Reib [MSFT]" wrote:
>> >> >
>> >> >> Once the report is published it will continue to be rendered with
>> >> >> regards
>> >> >> to
>> >> >> the published RDL. However, you can always update the rdl and
>> >> >> republish
>> >> >> it
>> >> >> on top of the old RDL changing what users see.
>> >> >>
>> >> >> --
>> >> >> -Daniel
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "mc" <mc@.discussions.microsoft.com> wrote in message
>> >> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
>> >> >> > Does RS2005 have any quality control mechanisms. Can a report be
>> >> >> > edited
>> >> >> > once
>> >> >> > its rendered and posted to the report server? For example, my
>> >> >> > report
>> >> >> > could
>> >> >> > have a paragraph describing some aspect of the report. Could
>> >> >> > this
>> >> >> > paragraph
>> >> >> > be manually edited?
>> >> >> >
>> >> >> > Thank You - mc
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks again for your help!!
"Daniel Reib [MSFT]" wrote:
> I can answer the question 3 for you. RS writes every report execution in
> the ExecutionLog Table. This table is purged every 30 days. We have
> provided some DTS packages for extracting the data to another DB for long
> term storage that you would want to take advantage of.
> Here is a link describing the process:
> http://msdn2.microsoft.com/library/ms159110.aspx
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "mc" <mc@.discussions.microsoft.com> wrote in message
> news:C1756736-E8F2-469C-B524-4C934AF8F9CE@.microsoft.com...
> > Yes your explanation helped, Thank You!
> >
> > On a side note, would you have any input into the following
> >
> > 1) Is it possible to create a report template containing text that would
> > be evaluated at runtime by a sql query? For example, the text in my
> > reports need to cater to various languages. Can I configure a textbox to
> > look up a value when the report is run?
> >
> > 2) How flexible are the graphing capabilities? Can you a third party
> > package be used to create graphs as long as the rdl file is constructed
> > properly?
> >
> >
> > 3) Does RS provide a good audit mechanism for logging and tracking
> > reports?
> >
> >
> > Thanks again - mc
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> It really depends on how complex the changes are that users can make. If
> >> they are trivial text changes you could write an app using the
> >> ReportViewer
> >> control to display the report. You could then have an edit button and
> >> build
> >> a simple designer that allows them to change only elements you wish.
> >>
> >> If you just want to flag the report then all RS catalog items have a
> >> generic
> >> property bag associated with them. You could have the users set some
> >> property to flag that the report needs updating.
> >>
> >> I hope that helps.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> news:4084F46B-8D7A-474F-A68E-08A5CFC7AC1D@.microsoft.com...
> >> > No, it would not be feasible for the user to edit the rdl. I would
> >> > have
> >> > to
> >> > come up with a way to allow the users to make changes or flag the
> >> > report
> >> > for
> >> > a custom system to allow changes. Any suggestions?
> >> >
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> No the user would not be able to edit the reports while viewing them.
> >> >> If
> >> >> the user has the correct permission they could download the rdl from
> >> >> Report
> >> >> Manager and edit the report in Report Designer, but I don't imagine
> >> >> this
> >> >> is
> >> >> what you want.
> >> >>
> >> >> Republishing does not track versions. You can create history
> >> >> snapshots
> >> >> of
> >> >> the report which can be saved and viewed later. You can't trigger
> >> >> them
> >> >> on
> >> >> publish but can on some other events.
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> >> news:238696BA-1FFD-4E62-AF5C-91ACF1E9EA6A@.microsoft.com...
> >> >> > Hi Daniel, thank you for the response. Could you also answer the
> >> >> > following?
> >> >> >
> >> >> > What if the user was responsible for editing the report? For
> >> >> > example,
> >> >> > a
> >> >> > user logs in to review the report and wants to make a change? Can
> >> >> > the
> >> >> > rdl
> >> >> > be updated while viewing the report or would this require a custom
> >> >> > application to make changes?
> >> >> >
> >> >> > This leads to another question. Does "re-publishing" track versions
> >> >> > or
> >> >> > would it simply be like running another report?
> >> >> >
> >> >> > Thanks - mc
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> > "Daniel Reib [MSFT]" wrote:
> >> >> >
> >> >> >> Once the report is published it will continue to be rendered with
> >> >> >> regards
> >> >> >> to
> >> >> >> the published RDL. However, you can always update the rdl and
> >> >> >> republish
> >> >> >> it
> >> >> >> on top of the old RDL changing what users see.
> >> >> >>
> >> >> >> --
> >> >> >> -Daniel
> >> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> >> rights.
> >> >> >>
> >> >> >>
> >> >> >> "mc" <mc@.discussions.microsoft.com> wrote in message
> >> >> >> news:51B0E325-43ED-4BAE-9B77-5A4DA9D311A3@.microsoft.com...
> >> >> >> > Does RS2005 have any quality control mechanisms. Can a report be
> >> >> >> > edited
> >> >> >> > once
> >> >> >> > its rendered and posted to the report server? For example, my
> >> >> >> > report
> >> >> >> > could
> >> >> >> > have a paragraph describing some aspect of the report. Could
> >> >> >> > this
> >> >> >> > paragraph
> >> >> >> > be manually edited?
> >> >> >> >
> >> >> >> > Thank You - mc
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

qualifying Stored Procedure with owner. Why is it important/

I've been reading some posts that indicate that it is best to invoke a
Stored Procedure with the owner name. Example
exec dbo.MyStoredProc
instead of
exec MyStoredProc
I never really understood why this makes a difference.
I would appreciate it if someone could shed some light on this
Thanks in advanceWell, what about if some user 'user1' have created a procedure which is
owned by 'user1'
If you do "Exec UserProc" you will get an error, you need to use "Exec
user1.UserProc" generally it is advisable to qualify owner name before
database objects.
Things are changed in SQL 2005 where you have to qualify schema name
instead of user name for database objects
chirag shah|||in my database all objects are owned by dbo. I have read that there is a
performance impact by not qualifying the owner of the SP (even in a case
like mine where all objects are owned by dbo)
"c_shah" <shah.chirag@.netzero.net> wrote in message
news:1142951587.510508.143150@.g10g2000cwb.googlegroups.com...
> Well, what about if some user 'user1' have created a procedure which is
> owned by 'user1'
> If you do "Exec UserProc" you will get an error, you need to use "Exec
> user1.UserProc" generally it is advisable to qualify owner name before
> database objects.
> Things are changed in SQL 2005 where you have to qualify schema name
> instead of user name for database objects
> chirag shah
>|||"TJT" <TJT@.nospam.com> wrote in message
news:u0kJDZPTGHA.4864@.TK2MSFTNGP12.phx.gbl...
> in my database all objects are owned by dbo. I have read that there is a
> performance impact by not qualifying the owner of the SP (even in a case
> like mine where all objects are owned by dbo)
>
http://support.microsoft.com/default.aspx?scid=kb;en-us;263889
David|||see
http://www.sqlservercentral.com/columnists/chedgate/worstpracticenotqualifyingobjectswiththeowner.asp
for a discussion of why objects should always be qualified.
"TJT" wrote:
> in my database all objects are owned by dbo. I have read that there is a
> performance impact by not qualifying the owner of the SP (even in a case
> like mine where all objects are owned by dbo)
>
> "c_shah" <shah.chirag@.netzero.net> wrote in message
> news:1142951587.510508.143150@.g10g2000cwb.googlegroups.com...
> > Well, what about if some user 'user1' have created a procedure which is
> > owned by 'user1'
> > If you do "Exec UserProc" you will get an error, you need to use "Exec
> > user1.UserProc" generally it is advisable to qualify owner name before
> > database objects.
> >
> > Things are changed in SQL 2005 where you have to qualify schema name
> > instead of user name for database objects
> >
> > chirag shah
> >
>
>