Data File in a Different machine on the network.

Hi All,

I have a requirement to create the database with data and log files in
a different machine on the network.

Googling, I got a link which said Mapped drives do not work but UNC paths
work. However in my case, both are failing.

Any advices or links on net will be highly useful.

Thanks and Regards,
Chandra MohanDon't do this. It's not supported by Microsoft, you will lose all the
benefits of a client-server database and you risk corrupting your data.

Read this article:

http://www.mssqlserver.com/faq/gene...tworkdrives.asp

--
David Portas
----
Please reply only to the newsgroup
--|||bschandramohan@.yahoo.com (Chandra Mohan) wrote in message news:<bb0ef6.0309282105.59f0d698@.posting.google.com>...
> Hi All,
> I have a requirement to create the database with data and log files in
> a different machine on the network.
> Googling, I got a link which said Mapped drives do not work but UNC paths
> work. However in my case, both are failing.
> Any advices or links on net will be highly useful.
> Thanks and Regards,
> Chandra Mohan

Check this KB article:

http://support.microsoft.com/defaul...1&Product=sql2k

You can put database files on network drives by setting trace flag
1807, but it is not supported unless the files are on a NAS which is
specifically certified for SQL Server. Often, the NAS will make the
network drive appear like a local one, so you won't need to set the
trace flag on anyway.

Putting a database on a normal UNC share is a very bad idea - you
won't be able to guarantee data integrity and performance will suffer.

Simon|||David Portas (REMOVE_BEFORE_REPLYING_dportas@.acm.org) writes:
> Don't do this. It's not supported by Microsoft, you will lose all the
> benefits of a client-server database and you risk corrupting your data.

I agree that putting a database on a network drive is an extremely bad
idea, but I don't see where the client-server issue comes in. You can
still connect a lots of clients to that database, as if the database
had been a drive local to the database server. (Well, lots and lots.
If there are lots, corruption might appear within the hour.)

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||What I had in mind was that you lose the performance advantage (compared to
a desktop database running on a network) of server-based processing. And you
sacrifice much of the resilience of transaction management and logging.

--
David Portas
----
Please reply only to the newsgroup
--

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns9405EBB63563DYazorman@.127.0.0.1...
> David Portas (REMOVE_BEFORE_REPLYING_dportas@.acm.org) writes:
> > Don't do this. It's not supported by Microsoft, you will lose all the
> > benefits of a client-server database and you risk corrupting your data.
> I agree that putting a database on a network drive is an extremely bad
> idea, but I don't see where the client-server issue comes in. You can
> still connect a lots of clients to that database, as if the database
> had been a drive local to the database server. (Well, lots and lots.
> If there are lots, corruption might appear within the hour.)
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||David Portas (REMOVE_BEFORE_REPLYING_dportas@.acm.org) writes:
> What I had in mind was that you lose the performance advantage (compared
> to a desktop database running on a network) of server-based processing.
> And you sacrifice much of the resilience of transaction management and
> logging.

You mean that rather running client on machine A and server on machine B,
we're running both server and client on A, and only have the database files
on B.

Yes, this is killing the client-server concept. (Ever heard of Visual
SourceSafe? That's an example of this architecture.)

I don't know why people want to put databases on network devices, but
my assumption is that the most common reason is simply space constraint
on the server, so they try to rent space somewhere else in the network.
In this case, I guess clients still connect from somewhere else.

But rather than renting the space, it's better to rent the entire disk
and move into cabinet. Or see your local hardware dealer...

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Data Extract then create new table

Please help in SQL2000

I have a table called dbo.DataFile which has 31 fields...I need to extract data from this table then create a new table under two conditions:

1. I only need to extract the data if the data from DF_SC_Case_Nbr field doesn't start with '0000%'

2. I need to merge [DF_SC_Case_Nbr] & [DF_SC_Def_Nbr] then call it DF_Combo_SC_Nbr (and keep the rest of the columns in tact), so the new table will now have 32 columns

Can somebody please help with the codes?..thanks. :confused:I don't speak SQL2000 :rolleyes: , but the general idea would be something like this:

CREATE TABLE new_table AS
SELECT column1, column2, ... column 31,
DF_SC_Case_Nbr || DF_SC_Def_Nbr DF_Combo_SC_Nbr
FROM dbo.DataFile
WHERE DF_SC_Case_Nbr NOT LIKE '0000%';


Merging two columns can be done using concatenation operator (in Oracle SQL represented by "||").|||Yeah that sounds right...but is there anybody out there who can translate this so sql can understand it?... :confused:|||Yes, but this sounds like homework. If you understand the basic idea and at least something about SQL Server 2000, then I think you should be able to type the answer as fast as I can.

If you are missing something, please explain. If you are trying to get someone to do your homework, sorry, that isn't my style.

-PatP|||Hi All,
I am using the sqlldr to load data with direct=true and parellel=true.
now my question is i have some column with unique indexes and primary keys also. if at all any record is duplicate then index becomes unusable. so what is the solution to delete those records which are violating unique indexes.

2) can any one provide me the query which making use of hints which does not make use of the index which is in un usable state and delete the records.|||You could create a temporary table which looks exactly like your original table, but without any indexes / unique / primary keys.
Load data into the temporary table.
Insert data into original table, eliminating duplicate rows.

I'd say you'll finish it much faster that way than trying to make Loader do a job itself.sql

Data Extract - Partitioning

Hello,

I have a table containing 3 columns Department Name, RiskScenario and Cost. I am trying to create a data extract that contains the top 3 Risk Scenarios (sorted by Cost) per Department.

I tried using this sql statement in MSQuery but it doesn't work. Any ideas where I'm going wrong or if there is a simpler way to do this?

Select * from (
Select DepartmentName, `Risk Scenario`, Cost, row_number() OVER (PARTITION BY DepartmentName order by Cost) rn
FROM 'Departmental Risks`) where rn <=3

Please help. Just can't figure this out!

Meera

Meera:

Exactly what kind of error(s) are you experiencing? It appears to me that you have spurious "quotes" in your query.

Dave

|||

Meera:

I mocked the data with this table:

create table [Departmental Risks]
( DepartmentName varchar(30),
[Risk Scenario] varchar(30),
cost numeric (9,2)
)
go
insert into [Departmental Risks] values ('Dept A', 'Scene 1', 45.32)
insert into [Departmental Risks] values ('Dept A', 'Scene 2', 29.95)
insert into [Departmental Risks] values ('Dept A', 'Scene 3', 71.45)
insert into [Departmental Risks] values ('Dept A', 'Scene 4', 54.34)
insert into [Departmental Risks] values ('Dept B', 'Scene A', 21.45)

I then ran tried this query and obtained the result that follows:

select DepartmentName,
[Risk Scenario],
cost
from ( select DepartmentName,
row_number () over
( partition by DepartmentName
order by cost desc, [Risk Scenario]
) as Seq,
[Risk Scenario],
cost
from [Departmental Risks]
) a
where seq <= 3
order by DepartmentName,
cost desc,
[Risk Scenario]

-- -- Output: --

-- DepartmentName Risk Scenario cost
-- -
-- Dept A Scene 3 71.45
-- Dept A Scene 4 54.34
-- Dept A Scene 1 45.32
-- Dept B Scene A 21.45

See if this is in the direction you are aiming.

Dave

|||

Hi Dave,

I tried that in both MSQuery and MsAccess. In MS query the message i get say could not add the table '('. In Access I get a syntax error in query expresion 'row_number()...

Am at a loss!

Here is whatI used:

select [RA07 - Departmental Risks].DepartmentName,
[RA07 - Departmental Risks].[Risk Scenario],
[RA07 - Departmental Risks].annualriskcost
from ( select [RA07 - Departmental Risks].DepartmentName,
row_number () over
( partition by [RA07 - Departmental Risks].DepartmentName
order by [RA07 - Departmental Risks].annualriskcost desc, [RA07 - Departmental Risks].[Risk Scenario]
) as Seq,
[RA07 - Departmental Risks].[Risk Scenario],
[RA07 - Departmental Risks].annualriskcost
from [RA07 - Departmental Risks]
) a
where seq <= 3
order by [RA07 - Departmental Risks].DepartmentName,
[RA07 - Departmental Risks].annualriskcost desc,
[RA07 - Departmental Risks].[Risk Scenario];

|||

Is your target database an Access database or a SQL Server 2000 database? The errors you are getting indicates that the target database is not SQL Server 2005.

Dave

|||

Dave,

Its an Access Database

Data eplorer DBxtra

Just found a very nice tool for data exploring, filtering and report creation.
Connects to almost any database.
Can create very fast and complete reports.
You even can schedule reports.Yeah, it's called reporting services...|||Even if you could get DBxtra to work, it is quite lame compared to Reporting Services. DBxtra seems more like a sub-set of the more commonly used features from Crystal Reports.

-PatP|||Pat & Brett, I haven't had a chance to play around with reporting services. Do both of you recommend it?|||There's no majik bullet for reporting, but Reporting Services is very, very good. If you have only Windoze hosted (or at least ODBC accessible) tools to report from, Reporting Services is probably as good as you'll find.

-PatP|||Pat & Brett, I haven't had a chance to play around with reporting services. Do both of you recommend it?

Getting server support (that's their gig) to get anything done, that a vp is not smashing them over the head, is not on their radar...I'm still waiting..

BUT...if it's like everything else...you can build it better and more customiozable...think about it...take dynamic to the nth level...

That's all the f'n wizards do...|||Thanks, I'll check it out and see what it's all about.

Data Driven Subscriptions-Expressions in Parameters

I'm trying to create a report that, when generated, puts in a start
date of last Sunday to last Saturday. To be more specific, take this
week which begins on Sunday, Feb 10 and ends Saturday, Feb 16. When
this report gets generated anytime this week, the start date should be
Sunday Feb 3 and the end date should be Saturday Feb 9. When the
report is run next week, the start date/end date for that report
should be Feb 10/Feb 16.
I figured out the date expression for the start and end dates and set
them as the default for this report in Visual Studio. However, when I
upload them to my Report Server and set the data driven subscription
(DDS) to use the default for those date parameters, it won't let me.
So my question is, in the DDS itself, can I use an expression for the
date paramenters? If the answer is no, then I'm obviously not getting
the syntax correctly.
Any help would be greatly appreicated.On Feb 12, 4:49=A0pm, lsantos13 <lsanto...@.gmail.com> wrote:
> I'm trying to create a report that, when generated, puts in a start
> date of last Sunday to last Saturday. =A0To be more specific, take this
> week which begins on Sunday, Feb 10 and ends Saturday, Feb 16. =A0When
> this report gets generated anytime this week, the start date should be
> Sunday Feb 3 and the end date should be Saturday Feb 9. =A0When the
> report is run next week, the start date/end date for that report
> should be Feb 10/Feb 16.
> I figured out the date expression for the start and end dates and set
> them as the default for this report in Visual Studio. =A0However, when I
> upload them to my Report Server and set the data driven subscription
> (DDS) to use the default for those date parameters, it won't let me.
> So my question is, in the DDS itself, can I use an expression for the
> date paramenters? =A0If the answer is no, then I'm obviously not getting
> the syntax correctly.
> Any help would be greatly appreicated.
Correction on the last sentence - I meant to say "If the answer is
YES,..."|||Did you ever get a fix on this, as I am having the same problem. In my report
definition in VS I have a multi-select YEAR parameter that is dynamically
generating values using the query (a google query :).
***********
SELECT (YEAR(GETDATE()) -5) + 5*5*(a-1)+5*(b-1) + c AS [YEAR] FROM
(SELECT 1 a UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION
ALL SELECT 5) x
CROSS JOIN
(SELECT 1 b UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION
ALL SELECT 5) y
CROSS JOIN
(SELECT 1 c UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION
ALL SELECT 5) z
WHERE 5*5*(a-1)+5*(b-1) + c <= (YEAR(GETDATE())+1-(YEAR(GETDATE()) -5))
ORDER BY 1
*************
and default values for current year and last year using Year(Now) and
Year(Now)-1. This is causing an error in data-driven subscription
rsReportParameterValueNotSet. The odd thing is that this only occurs if other
parameters are set to "Query Results Field". If all parameters are set to
"Static Selection" and "Use Default" is checked everything works fine.

Data Driven Subscriptions

Hi !!
I want to create a scheduled delivery, with email & file share used together
with a single execution on a report. This means that i will sent the report
attachment thru an email to the recipient, and the same time copy that report
using the file share in a folder. Is this possible to implement?
This is because, I can only execute the report only once due to an updation
being done to the database.
Thanks - PeteSubscriptions only support sending through 1 delivery extension. Have you
looked into setting up the report to run on an Execution snapshot? This
would allow you to control when the report will run and all renderings of
the report will come off the snapshot and not the data. You could then
create two subscriptions running off either a shared schedule of when the
report execution snapshot is updated.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pete" <Pete@.discussions.microsoft.com> wrote in message
news:36D77E8B-1768-44AA-955E-D459516C7D41@.microsoft.com...
> Hi !!
> I want to create a scheduled delivery, with email & file share used
together
> with a single execution on a report. This means that i will sent the
report
> attachment thru an email to the recipient, and the same time copy that
report
> using the file share in a folder. Is this possible to implement?
> This is because, I can only execute the report only once due to an
updation
> being done to the database.
> Thanks - Pete

data driven subscription when data changes

Is it possible to create a data driven subscription only when new data is added to the table. Say in the morning there are 10 records and added later are another 20-- I already have a report for the inital 10 and I want another to send out the new 20

thanks in advance

km

Hi,

data driven subscription is to dynamically create a list of recipients.

event driven subscription should not be confused with it.

There are different ways to do event driven subscriptions, from hard core programming to leverage of tools on hands. Try harder to search this forum, you will find plenty of articles about this subject.

Philippe

Data Driven Subscription Not Available

I am trying to create a data driven subscription. However, on the
Subscriptions tab for the reports the New Data-Driven Subscription selection
is not present. Only the New Subscription selection is present. I can
create regular subscriptions but need to create a data driven subscription.
Is there something in the config file that needs changed to enable data
driven subscriptions?Do you have Standard or Enterprise. Data driven subscriptions is a
Enterprise feature.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blaine" <Blaine@.discussions.microsoft.com> wrote in message
news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
>I am trying to create a data driven subscription. However, on the
> Subscriptions tab for the reports the New Data-Driven Subscription
> selection
> is not present. Only the New Subscription selection is present. I can
> create regular subscriptions but need to create a data driven
> subscription.
> Is there something in the config file that needs changed to enable data
> driven subscriptions?|||Data driven subscriptions are only available with SQL Server Enterprise
Edition.
Are you running Standard?
"Blaine" <Blaine@.discussions.microsoft.com> wrote in message
news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
>I am trying to create a data driven subscription. However, on the
> Subscriptions tab for the reports the New Data-Driven Subscription
> selection
> is not present. Only the New Subscription selection is present. I can
> create regular subscriptions but need to create a data driven
> subscription.
> Is there something in the config file that needs changed to enable data
> driven subscriptions?|||I thought I was running Enterprise everywhere but on this server it is only
the Standard edition. We are planning on upgrading to SQL Server 2005 1Q06 -
what version of it will I need to have?
Thanks for your help.
Blaine
"Bruce L-C [MVP]" wrote:
> Do you have Standard or Enterprise. Data driven subscriptions is a
> Enterprise feature.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Blaine" <Blaine@.discussions.microsoft.com> wrote in message
> news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
> >I am trying to create a data driven subscription. However, on the
> > Subscriptions tab for the reports the New Data-Driven Subscription
> > selection
> > is not present. Only the New Subscription selection is present. I can
> > create regular subscriptions but need to create a data driven
> > subscription.
> > Is there something in the config file that needs changed to enable data
> > driven subscriptions?
>
>|||Data driven subscriptions is still an enterprise feature in RS 2005.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Blaine" <Blaine@.discussions.microsoft.com> wrote in message
news:3C1F63FF-EFBB-469D-9A1E-F27AE5A48165@.microsoft.com...
>I thought I was running Enterprise everywhere but on this server it is only
> the Standard edition. We are planning on upgrading to SQL Server 2005
> 1Q06 -
> what version of it will I need to have?
> Thanks for your help.
> Blaine
> "Bruce L-C [MVP]" wrote:
>> Do you have Standard or Enterprise. Data driven subscriptions is a
>> Enterprise feature.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Blaine" <Blaine@.discussions.microsoft.com> wrote in message
>> news:D1F3D1AB-E50E-42E3-BDC2-B7F52AED421D@.microsoft.com...
>> >I am trying to create a data driven subscription. However, on the
>> > Subscriptions tab for the reports the New Data-Driven Subscription
>> > selection
>> > is not present. Only the New Subscription selection is present. I can
>> > create regular subscriptions but need to create a data driven
>> > subscription.
>> > Is there something in the config file that needs changed to enable data
>> > driven subscriptions?
>>

data driven subscription not available

Hi,
I am trying to create a data driven subscription. I have stored the
credentials and custom data source in the report. My account has site
administrator and content manager permissions, yet the "New Data Driven
Subscription" button is not available. I have multiple reports like this.
Any ideas?
MarcusAre you on Enterprise Edition of Reporting Services, it's an EE only
feature.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Marcus K" <MarcusK@.discussions.microsoft.com> wrote in message
news:86A68FE4-6761-44D0-89A1-8EADE9855583@.microsoft.com...
> Hi,
> I am trying to create a data driven subscription. I have stored the
> credentials and custom data source in the report. My account has site
> administrator and content manager permissions, yet the "New Data Driven
> Subscription" button is not available. I have multiple reports like this.
> Any ideas?
> Marcus|||That explains it... Thanks!!
"Jasper Smith" wrote:
> Are you on Enterprise Edition of Reporting Services, it's an EE only
> feature.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Marcus K" <MarcusK@.discussions.microsoft.com> wrote in message
> news:86A68FE4-6761-44D0-89A1-8EADE9855583@.microsoft.com...
> > Hi,
> >
> > I am trying to create a data driven subscription. I have stored the
> > credentials and custom data source in the report. My account has site
> > administrator and content manager permissions, yet the "New Data Driven
> > Subscription" button is not available. I have multiple reports like this.
> >
> > Any ideas?
> >
> > Marcus
>
>|||That might explain my problem...where does it state that it's an EE only
option? The developer edition supports it as well (obviously I suppose) but I
hadn't realised it wouldn't work in production!!
"Jasper Smith" wrote:
> Are you on Enterprise Edition of Reporting Services, it's an EE only
> feature.
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Marcus K" <MarcusK@.discussions.microsoft.com> wrote in message
> news:86A68FE4-6761-44D0-89A1-8EADE9855583@.microsoft.com...
> > Hi,
> >
> > I am trying to create a data driven subscription. I have stored the
> > credentials and custom data source in the report. My account has site
> > administrator and content manager permissions, yet the "New Data Driven
> > Subscription" button is not available. I have multiple reports like this.
> >
> > Any ideas?
> >
> > Marcus
>
>|||If you go to the SQL Server site then navigate to the reporting services page
and then find the feature compairison it is listed there.
For us the only thing we need EE for is the data driven subscriptions and I
can't get the boss to come off the hip with 10x the money for that one
feature.
I am going to try and write some code to run reports from the reporting
server using .net and sql statements.
"Paul Hasell" wrote:
> That might explain my problem...where does it state that it's an EE only
> option? The developer edition supports it as well (obviously I suppose) but I
> hadn't realised it wouldn't work in production!!
> "Jasper Smith" wrote:
> > Are you on Enterprise Edition of Reporting Services, it's an EE only
> > feature.
> >
> > --
> > HTH
> >
> > Jasper Smith (SQL Server MVP)
> > http://www.sqldbatips.com
> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org
> >
> > "Marcus K" <MarcusK@.discussions.microsoft.com> wrote in message
> > news:86A68FE4-6761-44D0-89A1-8EADE9855583@.microsoft.com...
> > > Hi,
> > >
> > > I am trying to create a data driven subscription. I have stored the
> > > credentials and custom data source in the report. My account has site
> > > administrator and content manager permissions, yet the "New Data Driven
> > > Subscription" button is not available. I have multiple reports like this.
> > >
> > > Any ideas?
> > >
> > > Marcus
> >
> >
> >

Data Driven Subscription - rsLogonFailed Problem

Hi
I am working my way through a series of tutorials in RS2005 and am
having a problem when trying to create a data driven subscription
When I try to validate my query against a subscriber database I get :
Logon failed. (rsLogonFailed) Get Online Help - Value does not fall
within the expected range.
The connection I am using is:
data source=(local);initial catalog=AdventureWorks; persist security
info=false;Application Name=SalesPeopleSub;password=sp_password
I have then entered some user credentials and checked 'Use as Windows
credentials when connecting to the data source'.
This connection method is exactly the same as I used when I created a
custom data source for another report earlier in the tutorial and this
works fine.
The query I am using is:
SELECT
FILENAME, FILEEXTN, PATH, RENDER_FORMAT, USERNAME, PASSWORD, WRITEMODE
FROM DataDrivenFileShareExample
As far as I can tell I have given my user enough rights to read from
this table. I have even used the runas.exe app to launch the SQL
Management Studio using the users credentials and can successfully run
that query from the Query analyser.
if anyone can point me in the rightv direction it would be appreciated
Cheers
MarkI have since found that if I create exactly the same data source as a
shared data source, I can select it and successfully use it in the data
driven subscription.
So it appears to be a problem with setting a individual data source for
a data driven subscription only. Can anyone could shed any light on why
if fails?
Cheers

Data driven subscription

I have create a data driven subscription that should email to to different people. It is sent to one but not the other. if I set up a normal subscription to the email it works. I can not see anywhere in the log the problem. Any Ideas on how to find out what is causing it.

What is a subscription status in a Report Manager after it's executed?

If it's like ‘Done: {1} processed of {1} total;’ then everything worked fine. Your data driven (DD) query returned just one user to send email to.

If it's like ‘Done: {1} processed of {3} total; {2} errors’ then yes, two subscriptions failed. In that case you can find error details in the logfile. Subscription processing error details are logged into files like ReportServerService__<datetime>.log located at <Program Files>\Microsoft SQL Server\MSSQL.#\Reporting Services\LogFiles.

|||

Edit

Send e-mail to PorterS

TimedSubscription

12/21/2006 8:40 AM

Mail sent to PorterS

Edit

Upcoming

TimedSubscription

12/21/2006 10:45 AM

Done: 1 processed of 1 total; 1 errors.

|||Also as you can see a subsscription ran at 10:45 But i do not see any log after 8:37 am this morning could loggin be turned off?|||

Second subscription at 10:45 (data driven) had one user to send e-mail to and it's processing failed. Please find error details in the RS windows service logfile.

|||What is the log filename?|||ReportServerService__12_21_2006_00_08_25.log|||

Any chance there is another file ReportServerService__12_21_2006_hh_mm_ss.log created later that contains records for 10:45 subscription? Or any chance that there is another RS instance sharing same database, and that instance procesed 10:45 subscription? Logging is turned OFF by either removing ReportingServicesService.exe.config from Reporting Services\ReportServer\Bin directory or by setting DefaultTraceSwitch value to 0 in this config file. If none of options above explains why you don't see logging for 10:45 subscription then I don't have an explanation.

|||Thank's I will take a look.sql

Data Driven

Hi,
I understand I can create a stored procedure to return all the parameters
for data driven. The last statement of the Stored Procedure is Select *
DataDrivenTableName. However, after I put Exec SPName, and when i go to the
next page to fill out all the To, CC, Subject..., there is nothing in each
drop down box and I can't continue to finish the setup.
Any idea what's wrong.
Thanks
EdAFAIK RS uses first resultset to get data, not last.
Stjepan
"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:2F0D6FE4-2FA8-49EB-A965-D0A57D47362C@.microsoft.com...
> Hi,
> I understand I can create a stored procedure to return all the parameters
> for data driven. The last statement of the Stored Procedure is Select *
> DataDrivenTableName. However, after I put Exec SPName, and when i go to
> the
> next page to fill out all the To, CC, Subject..., there is nothing in each
> drop down box and I can't continue to finish the setup.
> Any idea what's wrong.
> Thanks
> Ed

Data does not fit....

I am doing a simple update statement but am getting an error.

Cannot create a row of size 10675 which is greater than the allowable maximum of 8060.
The statement has been terminated.

I am inserting data that is as big as 7500 characters into a varchar(7500) field. I have made sure that my column is 7500 in length. the only way it fits is if I cut it down to 4950 characters...

Any Ideas?

William,

Total columns length for row is max 8060 (not a single column). Maybe you would want to put your new concatenated string into a text/ntext column.

PS: BTW check another thread about concatenating text fields earlier today.

|||

In SQL Server 2000, the entire row's data must be <= 8060 bytes, not just a single column. (this allows it to fit on a single page)

In SQL Server 2005, you can put > 8060 bytes on a row, but it is not advisable in most cases. Any rows that are larger than that spill over into a different page.

|||

I know about the limitation and I implement restrictors to make sure my working tables do not go over the given length that I need.

My data has a max length of 7500 because I populated the field with another process that only allows the data to be 7500 in length. So I do not know how the data is growing...

I am just setting a column (varchar 7500) to the value of another column (varchar 7500) and that is what does not make sense to me.

|||Can you post the script of the table?|||

this table gets populated by a process that limits the data to 7500

CREATE TABLE [dbo].[Search_hold] (
[id] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[credits] [varchar] (7500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

When I do a simple update to this table is where I get the error... I am only posting the column that is effected because the table is 30+ columns wide....

CREATE TABLE [dbo].[Search] (
[prod_id] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[credits] [varchar] (7500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[srch_field] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[dateadded] [smalldatetime] NULL ,
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

The first table is to get the data and the main table is the second one. Alot more data is in the table that these columns...

Data Directory In Network location?

Is it possible to set DATADIR=\\<company_network_somedirectory>\? When I
try it, set-up seems to fail.
Also, if I were to create a new database on a default instance of MSDE, I am
not able to pick mapped network directories.
Appreciate any insight.
Thanks,
Sha.
hi Sha,
"Sha S." <shajihans@.ttnus.com> ha scritto nel messaggio
news:OajGz8D7EHA.3836@.tk2msftngp13.phx.gbl
> Is it possible to set DATADIR=\\<company_network_somedirectory>\?
> When I try it, set-up seems to fail.
>
it is possible, using a trace flag, but strongly not suggested... SQL Server
requires a strong, reliant and trusted, verified path (and enough permission
must be granted to the Windows account running it's services) in order
perform (possibly as fast as possible) disk IO operations...
as Network share usually are not that secure and robust, nor fast, it is
strongly advised only to use "local" storag subsystem and not remote...
as regard the setup.exe parameter, I actually do not know if it's possible
to specify remote paths...
please keep you data on your local disk(s) :D

> Also, if I were to create a new database on a default instance of
> MSDE, I am not able to pick mapped network directories.
>
again, enough permission(s) [on the network shares] must be granted to the
Windows account running MSDE SQL Server and SQL Server Agent services..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you, Andrea, for your reply. I shall follow it.
Andrea Montanari wrote:
> hi Sha,
> "Sha S." <shajihans@.ttnus.com> ha scritto nel messaggio
> news:OajGz8D7EHA.3836@.tk2msftngp13.phx.gbl
>
> it is possible, using a trace flag, but strongly not suggested... SQL Server
> requires a strong, reliant and trusted, verified path (and enough permission
> must be granted to the Windows account running it's services) in order
> perform (possibly as fast as possible) disk IO operations...
> as Network share usually are not that secure and robust, nor fast, it is
> strongly advised only to use "local" storag subsystem and not remote...
> as regard the setup.exe parameter, I actually do not know if it's possible
> to specify remote paths...
> please keep you data on your local disk(s) :D
>
>
> again, enough permission(s) [on the network shares] must be granted to the
> Windows account running MSDE SQL Server and SQL Server Agent services..
>
|||hi Sha,
"Sha S." <pilgrim216@.gmail.com> ha scritto nel messaggio
news:e8MrtIP7EHA.3616@.TK2MSFTNGP11.phx.gbl
> Thank you, Andrea, for your reply. I shall follow it.
>
:D
just a consideratio I had after posting... for sure it's not possible to
specify remote folders for <DATA_DIR> parameter as you can not install MSDE
specifying the trace flag required for that kind of feature
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Data Dictionary for Dimensions

Is there any easy way to create a dictionary or lookup function based on
Dimensions in a cube? We only have 4 cubes so far but the big one has some
50 dimensions and sometimes finding the attribute you want to report on is
consuming.
Would like to for example to search somewhere for where the attribute
"model" is, from example below and have it return the cube and dimension
it's in:
Something like:
Cube XYZ
Dimension: Autos
Attributes:
Make
Model
Year Released
..Hello Joe,
I am not sure what version of Analysis services you are using so I am
going to assume that you are using AS 2005.
With AS 2005 you have the ability to create perspectives. These can be
used to group dimensions and measures into common areas for reporting.
Perspectives can be defined to the attribute and measure level. You can
also create a linked cube that can maintain the perspectives across all
your cubes.
You could also consider using report builder as a front end. It
provides a good ad hoc query interface, but is not a replacement for
pivot tables in Excel. Report Builder creates a semantic layer on top
of the cube that allows users to search for attributes and entities
when creating a query.
To use this you will need Reporting services 2005 installed. Check out
my blog post on creating a report model against AS 2005 cubes.
http://bi-on-sql-server.blogspot.co...er-and-udm.html
Hope this helps,
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/|||underprocessable|||Hello Joe,
I have seen this error before. It was caused by the SQL server being
renamed Check the following:
1. Use the full server name instead of local alias
2. Check that the server has not been renamed
3. Try to connect to the RS server through Management Studio
Are you only getting this error in BIDS. Have you tried accessing
Reports in Report Manager?
Myles|||I got it working well on my local box - so it must be related to the server
I'm deploying too...maybe security issues...
<Myles.Matheson@.gmail.com> wrote in message
news:1156928164.274497.324030@.i42g2000cwa.googlegroups.com...
> Hello Joe,
> I have seen this error before. It was caused by the SQL server being
> renamed Check the following:
> 1. Use the full server name instead of local alias
> 2. Check that the server has not been renamed
> 3. Try to connect to the RS server through Management Studio
> Are you only getting this error in BIDS. Have you tried accessing
> Reports in Report Manager?
> Myles
>

Data Dictionary

Is there any software available (preferably freeware but commercial an
option) to help me create a data dictionary for my database to help document
it?
Thanks
Keith,
I'm not aware of any free ones, but I like Embarcadero's ER/Studio to do
this work. However, it is quite expensive, but worth the money in my opinion
if you do a lot of database design work.
www.embarcadero.com
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Keith" <@..> wrote in message news:OanwEQpLEHA.340@.TK2MSFTNGP11.phx.gbl...
> Is there any software available (preferably freeware but commercial an
> option) to help me create a data dictionary for my database to help
document
> it?
> Thanks
>

Data Dictionary

Is there any software available (preferably freeware but commercial an
option) to help me create a data dictionary for my database to help document
it?
ThanksKeith,
I'm not aware of any free ones, but I like Embarcadero's ER/Studio to do
this work. However, it is quite expensive, but worth the money in my opinion
if you do a lot of database design work.
www.embarcadero.com
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Keith" <@..> wrote in message news:OanwEQpLEHA.340@.TK2MSFTNGP11.phx.gbl...
> Is there any software available (preferably freeware but commercial an
> option) to help me create a data dictionary for my database to help
document
> it?
> Thanks
>

Data Dictionary

What tool can I use to create a data dictionary for a MS SQL database?Hi,
APEXSQL has got a very good tool for creating a data dictionary.
http://www.apexsql.com/sql_tools_doc.asp
Thanks
Hari
SQL Server MVP
"docsql" <docsql@.noemail.nospam> wrote in message
news:uCpn8gYgFHA.460@.TK2MSFTNGP09.phx.gbl...
> What tool can I use to create a data dictionary for a MS SQL database?
>|||Anything that comes with SQL Server installation?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23buKSpZgFHA.3776@.TK2MSFTNGP10.phx.gbl...
> Hi,
>
> APEXSQL has got a very good tool for creating a data dictionary.
> http://www.apexsql.com/sql_tools_doc.asp
> Thanks
> Hari
> SQL Server MVP
> "docsql" <docsql@.noemail.nospam> wrote in message
> news:uCpn8gYgFHA.460@.TK2MSFTNGP09.phx.gbl...
>|||Hello,
Unfortunately there isn't pre-packaged, off-the-shelf tools for creating
and maintaining data dictionaries at present. You might want to see if the
"extended properties" concept is useful for you. For more information refer
to the following article:
Extended Properties in SQL Server 2000
http://msdn.microsoft.com/library/d...-us/dnsqlpro02/
html/sql02a10.asp
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
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.

Data Dictionary

What tool can I use to create a data dictionary for a MS SQL database?
Hi,
APEXSQL has got a very good tool for creating a data dictionary.
http://www.apexsql.com/sql_tools_doc.asp
Thanks
Hari
SQL Server MVP
"docsql" <docsql@.noemail.nospam> wrote in message
news:uCpn8gYgFHA.460@.TK2MSFTNGP09.phx.gbl...
> What tool can I use to create a data dictionary for a MS SQL database?
>
|||Anything that comes with SQL Server installation?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23buKSpZgFHA.3776@.TK2MSFTNGP10.phx.gbl...
> Hi,
>
> APEXSQL has got a very good tool for creating a data dictionary.
> http://www.apexsql.com/sql_tools_doc.asp
> Thanks
> Hari
> SQL Server MVP
> "docsql" <docsql@.noemail.nospam> wrote in message
> news:uCpn8gYgFHA.460@.TK2MSFTNGP09.phx.gbl...
>
|||Hello,
Unfortunately there isn't pre-packaged, off-the-shelf tools for creating
and maintaining data dictionaries at present. You might want to see if the
"extended properties" concept is useful for you. For more information refer
to the following article:
Extended Properties in SQL Server 2000
http://msdn.microsoft.com/library/de...us/dnsqlpro02/
html/sql02a10.asp
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
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.

Data Dictionary

What tool can I use to create a data dictionary for a MS SQL database?Hi,
APEXSQL has got a very good tool for creating a data dictionary.
http://www.apexsql.com/sql_tools_doc.asp
Thanks
Hari
SQL Server MVP
"docsql" <docsql@.noemail.nospam> wrote in message
news:uCpn8gYgFHA.460@.TK2MSFTNGP09.phx.gbl...
> What tool can I use to create a data dictionary for a MS SQL database?
>|||Anything that comes with SQL Server installation?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23buKSpZgFHA.3776@.TK2MSFTNGP10.phx.gbl...
> Hi,
>
> APEXSQL has got a very good tool for creating a data dictionary.
> http://www.apexsql.com/sql_tools_doc.asp
> Thanks
> Hari
> SQL Server MVP
> "docsql" <docsql@.noemail.nospam> wrote in message
> news:uCpn8gYgFHA.460@.TK2MSFTNGP09.phx.gbl...
>> What tool can I use to create a data dictionary for a MS SQL database?
>|||Hello,
Unfortunately there isn't pre-packaged, off-the-shelf tools for creating
and maintaining data dictionaries at present. You might want to see if the
"extended properties" concept is useful for you. For more information refer
to the following article:
Extended Properties in SQL Server 2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro02/
html/sql02a10.asp
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================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.