architecture

where is the actual physical location of views, sp's and dts packages?
The same place as was mention when you asked this question 4 times ago. :-)
"mat" wrote:

> where is the actual physical location of views, sp's and dts packages?

architecture

where is the actual physical location of views, sp's and dts packages?
Views and stored procs are objects within a database. Their definitions are
stored in sysobjects, syscomments, and others system tables within their
database. Physical storage is in the data files.
DTS package definitions are stored in msdb. Look for system tables named
like 'sysdts%'. Physical storage will be in the msdb data file.
DTS packages
"mat" wrote:

> where is the actual physical location of views, sp's and dts packages?
sql

architecture

where is the actual physical location of views, sp's and dts packages?
as far as I know, views and sps are part of your database file (.mdf) stored
as objects with the system tables. Typically a view is thought of as a
virtual table, or a stored query. The results of using a view are not
permanently stored in the database. The data accessed through a view is
actually constructed using standard T-SQL select command and can come from
one to many different base tables or even other views.
I hope this helps...
"mat" wrote:

> where is the actual physical location of views, sp's and dts packages?

architecture

Where are views, dts packages stored..
ie where would the actual pysical location of vies and dts packages be
Views and stored procedures are in the syscomments table. DTS packages are
in the MSDB database.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"mat" <mat@.discussions.microsoft.com> wrote in message
news:37BD3C41-73C3-4F81-AAFA-3E823244BBF4@.microsoft.com...
> Where are views, dts packages stored..
> ie where would the actual pysical location of vies and dts packages be

architecture

Where are views, dts packages stored..
ie where would the actual pysical location of vies and dts packages beViews and stored procedures are in the syscomments table. DTS packages are
in the MSDB database.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"mat" <mat@.discussions.microsoft.com> wrote in message
news:37BD3C41-73C3-4F81-AAFA-3E823244BBF4@.microsoft.com...
> Where are views, dts packages stored..
> ie where would the actual pysical location of vies and dts packages be

architecture

where is the actual physical location of views, sp's and dts packages?Views and stored procs are objects within a database. Their definitions are
stored in sysobjects, syscomments, and others system tables within their
database. Physical storage is in the data files.
DTS package definitions are stored in msdb. Look for system tables named
like 'sysdts%'. Physical storage will be in the msdb data file.
DTS packages
"mat" wrote:

> where is the actual physical location of views, sp's and dts packages?

architecture

Where are views, dts packages stored..
ie where would the actual pysical location of vies and dts packages beViews and stored procedures are in the syscomments table. DTS packages are
in the MSDB database.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"mat" <mat@.discussions.microsoft.com> wrote in message
news:37BD3C41-73C3-4F81-AAFA-3E823244BBF4@.microsoft.com...
> Where are views, dts packages stored..
> ie where would the actual pysical location of vies and dts packages besql

architecture

where is the actual physical location of views, sp's and dts packages?Views and stored procs are objects within a database. Their definitions are
stored in sysobjects, syscomments, and others system tables within their
database. Physical storage is in the data files.
DTS package definitions are stored in msdb. Look for system tables named
like 'sysdts%'. Physical storage will be in the msdb data file.
DTS packages
"mat" wrote:
> where is the actual physical location of views, sp's and dts packages?

architecture

where is the actual physical location of views, sp's and dts packages?as far as I know, views and sps are part of your database file (.mdf) stored
as objects with the system tables. Typically a view is thought of as a
virtual table, or a stored query. The results of using a view are not
permanently stored in the database. The data accessed through a view is
actually constructed using standard T-SQL select command and can come from
one to many different base tables or even other views.
I hope this helps...
"mat" wrote:
> where is the actual physical location of views, sp's and dts packages?

architecture

where is the actual physical location of views, sp's and dts packages?The same place as was mention when you asked this question 4 times ago. :-)
"mat" wrote:
> where is the actual physical location of views, sp's and dts packages?

Applying CSS to SRS Reports

Hi , I hava a quick question about can we apply Css to actual repots in the
SRS ?
Since i figured out there is one property comes with SP1 i.e.,
rc:Stylesheet=Mystylename (without css extension) but this solution can only
resolve my half problem i.e., it applies only to parameter section and
toolbar section of the report but i wanted to apply for complete report
display while rendering it or displaying with the use of ReportViewer control.
Any Help is appreciated.
Thanks in advance.
APatelWe have the same want, we ended up using a near identity xsl to transorm the
unstyled report into 3 styles that we use as a subreport. The outer report
uses the style as a parameter, then we show/hide the subreports based on the
style...Yes it's very clunky, I'm looking for suggestions on a better way.
Here's my xsl file:
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="2.0"
xmlns:msrs="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:fn="http://www.w3.org/2005/02/xpath-functions"
exclude-result-prefixes="msrs xs fn">
<xsl:output encoding="iso-8859-1" method="xml" omit-xml-declaration ="yes"
indent="yes"/>
<xsl:template match="//msrs:FontFamily">
<msrs:FontFamily>Tahoma</msrs:FontFamily>
</xsl:template>
<xsl:template
match="//msrs:Textbox/msrs:Style[msrs:BackgroundColor='#fbee83']/msrs:BackgroundColor">
<msrs:BackgroundColor>#4e0000</msrs:BackgroundColor>
<msrs:Color>White</msrs:Color>
</xsl:template>
<xsl:template
match="//msrs:Textbox/msrs:Style[msrs:BackgroundColor='SandyBrown']/msrs:BackgroundColor">
<msrs:BackgroundColor>Maroon</msrs:BackgroundColor>
<msrs:Color>White</msrs:Color>
</xsl:template>
<xsl:template match="//msrs:Textbox/msrs:Style[contains(., 'Mod 2,
"White", "Wheat"')]/msrs:BackgroundColor">
<msrs:BackgroundColor>= iif(RowNumber(Nothing) Mod 2, "White",
"LightGrey")</msrs:BackgroundColor>
</xsl:template>
<xsl:template match="@.* | node()" priority="-2">
<xsl:copy>
<xsl:apply-templates select="@.* | node()"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
"APatel" <APatel@.discussions.microsoft.com> wrote in message
news:B6D65976-EF0D-4BD0-A8A0-798CD71678A5@.microsoft.com...
> Hi , I hava a quick question about can we apply Css to actual repots in
> the
> SRS ?
> Since i figured out there is one property comes with SP1 i.e.,
> rc:Stylesheet=Mystylename (without css extension) but this solution can
> only
> resolve my half problem i.e., it applies only to parameter section and
> toolbar section of the report but i wanted to apply for complete report
> display while rendering it or displaying with the use of ReportViewer
> control.
> Any Help is appreciated.
> Thanks in advance.
> APatel