Datatype

I am using Visual Studio .NET 2003 with SQL Server 2000. I am trying to
insert the date and time into a SQL database by using hour(now). I am
having a hard time trying to figure out which datatype to use in SQL to
store this value. I have tried using datetime, char, nchar, text and
nothing seems to work. Anyone have any ideas? Thanks!

Regards, :)

Christopher BowenDo you mean that you want to store a time without a date? This isn't
possible in MSSQL, since there is only a single datetime data type.

http://www.aspfaq.com/show.asp?id=2206
http://www.karaszi.com/sqlserver/info_datetime.asp

Simon|||Use a DATETIME or SMALLDATETIME column.

INSERT INTO YourTable (dt_col) VALUES (CURRENT_TIMESTAMP)

--
David Portas
SQL Server MVP
--|||Christopher,

the function call Hour(Now) will return the current hour, which is an
integer. I would expect this information to be of little use. However,
if you want to store this in an SQL-Server database, then a column of
type tinyint would suffice.

HTH,
Gert-Jan

c_bowen@.earthlink.net wrote:
> I am using Visual Studio .NET 2003 with SQL Server 2000. I am trying to
> insert the date and time into a SQL database by using hour(now). I am
> having a hard time trying to figure out which datatype to use in SQL to
> store this value. I have tried using datetime, char, nchar, text and
> nothing seems to work. Anyone have any ideas? Thanks!
> Regards, :)
> Christopher Bowen|||It would probably be helpful to see your code and it's not 100% clear what
you're trying to do. I'm guessing hour(now) is a .NET function? Does it
simply return the number of the current hour? That would be some sort of
INT, which would be a datatype mismatch with the datatypes you say you've
tried. Your note mentioned "insert the date and time", which wouldn't
simply be the current hour, anyway.

When I want to insert the date and time, I usually use SQL Server's
getdate() function to supply the value. A T-SQL example would be:

create table foo (col1 char(10),col2 datetime)
go
insert foo values ('abc',getdate())
go
select * from foo
go

[results]
(1 row(s) affected)

col1 col2
---- ----------------
abc 2005-02-25 15:16:38.367

(1 row(s) affected)

Use the datetime datatype if you can. In my experience, using character or
numeric types for storing dates and times usually ends up in grief.

By the way, I usually set things up so that SQL Server is responsible for
supplying the time, rather than the application. That way, if the various
workstation's or web server's clocks are a little bit off, the time values
of rows inserted/updated will still be synchronized across your
applications.

<c_bowen@.earthlink.net> wrote in message
news:1109141117.808195.36560@.l41g2000cwc.googlegro ups.com...
> I am using Visual Studio .NET 2003 with SQL Server 2000. I am trying to
> insert the date and time into a SQL database by using hour(now). I am
> having a hard time trying to figure out which datatype to use in SQL to
> store this value. I have tried using datetime, char, nchar, text and
> nothing seems to work. Anyone have any ideas? Thanks!
> Regards, :)
> Christopher Bowensql

Datasource

I have several hundred reports that I need to change the Datasource to point
to another server. Without going one report property at a time and changing
the datasource, is there a way to run an update statement on ReportServer
database to use the new target server for the said reports? If running an
update is not advisable then how do I make global change to the reports data
sources?
Thanks in advance for the assistance.
--
Lito DWhy don't you just change the connection string of the current Data Source
instead of creating a new one and changing all of the reports?
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Datasource
> thread-index: AcgQYLyNYww3Wxw0QxS8ZfpBNLID8A==> X-WBNR-Posting-Host: 207.46.19.168
> From: =?Utf-8?B?TElUTw==?= <anynomous@.msn.com>
> Subject: Datasource
> Date: Tue, 16 Oct 2007 18:55:04 -0700
> I have several hundred reports that I need to change the Datasource to
point
> to another server. Without going one report property at a time and
changing
> the datasource, is there a way to run an update statement on ReportServer
> database to use the new target server for the said reports? If running an
> update is not advisable then how do I make global change to the reports
data
> sources?
> Thanks in advance for the assistance.
> --
> Lito D
>|||The problem is that some reports must stay on the live server whereas the
rest should go to another server having previous day old data. I assume
there is a utility ( not too familiar with rs.exec) that I can issue via
command line to change the datasource from one to another then manually
change the few reports that must stay on the live server.
Lito D
"Chris Alton [MSFT]" wrote:
> Why don't you just change the connection string of the current Data Source
> instead of creating a new one and changing all of the reports?
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Datasource
> > thread-index: AcgQYLyNYww3Wxw0QxS8ZfpBNLID8A==> > X-WBNR-Posting-Host: 207.46.19.168
> > From: =?Utf-8?B?TElUTw==?= <anynomous@.msn.com>
> > Subject: Datasource
> > Date: Tue, 16 Oct 2007 18:55:04 -0700
> >
> > I have several hundred reports that I need to change the Datasource to
> point
> > to another server. Without going one report property at a time and
> changing
> > the datasource, is there a way to run an update statement on ReportServer
> > database to use the new target server for the said reports? If running an
> > update is not advisable then how do I make global change to the reports
> data
> > sources?
> >
> > Thanks in advance for the assistance.
> >
> > --
> > Lito D
> >
>|||If you are using a Shared DataSource for your reports then you are going to
have to create a new Data Source anyway. So if all you have are a few
reports to change that stay on the live server then just change the
existing Shared Data Source to point to the new server and then create a
second Data Source that points to the old server. Then manually change the
few reports to the new Shared Data Source. If you are using embedded Data
Sources in your reports then you've got a tedious job ahead of you. The
following tool might help you out but its a 3rd party tool and I haven't
really used it extensively.
http://www.sqldbatips.com/showarticle.asp?ID=62
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Datasource
> thread-index: AcgRFlfiLyP20tutQlCHtUWElaYfEw==> X-WBNR-Posting-Host: 207.46.19.197
> From: =?Utf-8?B?TElUTw==?= <anynomous@.msn.com>
> References: <A60B2818-F70D-4150-BBA9-41BEC7FCDC93@.microsoft.com>
<4c7dqiMEIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: Datasource
> Date: Wed, 17 Oct 2007 16:35:04 -0700
> The problem is that some reports must stay on the live server whereas the
> rest should go to another server having previous day old data. I assume
> there is a utility ( not too familiar with rs.exec) that I can issue via
> command line to change the datasource from one to another then manually
> change the few reports that must stay on the live server.
>
> --
> Lito D
>
> "Chris Alton [MSFT]" wrote:
> > Why don't you just change the connection string of the current Data
Source
> > instead of creating a new one and changing all of the reports?
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Datasource
> > > thread-index: AcgQYLyNYww3Wxw0QxS8ZfpBNLID8A==> > > X-WBNR-Posting-Host: 207.46.19.168
> > > From: =?Utf-8?B?TElUTw==?= <anynomous@.msn.com>
> > > Subject: Datasource
> > > Date: Tue, 16 Oct 2007 18:55:04 -0700
> > >
> > > I have several hundred reports that I need to change the Datasource
to
> > point
> > > to another server. Without going one report property at a time and
> > changing
> > > the datasource, is there a way to run an update statement on
ReportServer
> > > database to use the new target server for the said reports? If
running an
> > > update is not advisable then how do I make global change to the
reports
> > data
> > > sources?
> > >
> > > Thanks in advance for the assistance.
> > >
> > > --
> > > Lito D
> > >
> >
> >
>sql

Dataset.Clear() doesn't mark rows as deleted

Ok, I've spent a good amount on time on debugging an unupdating scenario in my application. Finally I knew the reason which is very annoying. Either I'm missing something really obvious (I hope so,) or this is a bug.

to reproduce what I'm talking about:
1- create a new win forms application using VS2005 sp1
2- add some SQL Compact Edition data file that have some records from the data menu, you'll get the designer to generate the dataset and everything..
3- drag a table from the data sources window, you'll get the data grid and the navigator on the form
4- add a button and have this in the click event handler:
datasetname.Clear();
TableAdapterName.Update(datasetname);

launch the program, click the button, you'll see the grid get wiped out as it supposed to do. close the program and relaunch. the data is there again (this has nothing to do with the copy always, copy if newer infamous stupidity)

now:
5- edit the click event handler and change it so something like this:
foreach (datasetname.TableRow row in datasetname.Table)
{
row.Delete();
}
TableAdapterName.Update(datasetname);

Launch the program, hit the button, grid wiped out. exit and relaunch. You'll see no data (i.e. the update on table adapter worked alright)

You can also try the GetChanges method on the dataset rightafter you use the clear method and you'd get no deleted records at all.

So, in 100,000+ records dataset, if i need to wipe the thing out and add some new records do i have to loop over every record and call delete (which will take LOTS of time).
I do hope that I'm missing something obvious.

Any help would be highly appreciated.

Thanks.

Yes, that's because Clear() is not supposed to mark rows as deleted, it suppose to clear tables of all row regardless of the row states.

Besides there’s no magic way to mark all rows as deleted except by looping through them, so should Clear() actually do that it would take a while anyway.

If you need to delete all the rows and then add some here’s how to do that efficiently:

1. Execute SQL query(ies) to delete rows strait from the database.

2. Create new empty DataSet with the same schema and use it instead of existing one (which would be collected).

3. Add rows you need.

4. Execute update using new DataSet.

DataSet Bug?

Hi,
###Problem 1###
I've encountered serveral times on this problem Every time when I used store
procedure to create a datatset. In the store procedure, it cannot have more
then 2 select statement even though the first select state is only shown when
a flag is turned on. For example :
...
set @.debug=0
if @.debug=1
select * from ABC
Select X, Y, Z from WWW
...
The dataset will shows the 1st select statement instead of the 2nd. I've to
deleted the those unwanted lines before my dataset is correct. Is this a bug?
###Problem 2###
Currently, I'm facing another problem with DataSet ...:(
This time when i wrote a intensive coding in the store procedure with
consists of quite a number of insert Temp tables. When I run the store
procedure using the Query Analyzer, my dataset is correct. However when I
used Reporting Services, I'm unable to get the correct dataset. Why is this
so?
Any help is definitely appreciated... ThanksPls ignore the 2nd problem. I've found the root cause. my Applogies...;P
But the 1st problem, i've encountered several times.
"Samie" wrote:
> Hi,
> ###Problem 1###
> I've encountered serveral times on this problem Every time when I used store
> procedure to create a datatset. In the store procedure, it cannot have more
> then 2 select statement even though the first select state is only shown when
> a flag is turned on. For example :
> ...
> set @.debug=0
> if @.debug=1
> select * from ABC
> Select X, Y, Z from WWW
> ...
> The dataset will shows the 1st select statement instead of the 2nd. I've to
> deleted the those unwanted lines before my dataset is correct. Is this a bug?
>
> ###Problem 2###
> Currently, I'm facing another problem with DataSet ...:(
> This time when i wrote a intensive coding in the store procedure with
> consists of quite a number of insert Temp tables. When I run the store
> procedure using the Query Analyzer, my dataset is correct. However when I
> used Reporting Services, I'm unable to get the correct dataset. Why is this
> so?
> Any help is definitely appreciated... Thanks

Data-Driven Subscriptions

Each time I run a data-driven subscription, I recieve the following
information ... "Processing: 0 processed of 1 total; 0 errors" ... The report
runs fine manually and via a subscription, but not a data-driven
subscription. I'm at a lost, where do I start to find this problem?
--
~Jack~Start by looking the reportserverservice<data>.log file. See if it says
anything about picking up the items. What is the subscriptions result?
Have you checked if the subscriptions has succeeded but is just not
reporting it correctly?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
> Each time I run a data-driven subscription, I recieve the following
> information ... "Processing: 0 processed of 1 total; 0 errors" ... The
> report
> runs fine manually and via a subscription, but not a data-driven
> subscription. I'm at a lost, where do I start to find this problem?
> --
> ~Jack~|||Daniel,
Thanks for the reply. The data-driven subscription is designed to save the
file as an excel file to a shared folder. Late yesterday I had changed the
User name to my own credentials to see if this would help. Now I recieve the
message "Processing: 1 processed of 1 total; 0 errors"; but no file is
delivered/created to the shared folder. This is at least a step better since
before I had changed the credentials, the message was "Processing: 0
processed of 1 total; 0 errors" . I did look through the log files and found
no errors (wish I had, it would make it simpler to track down the issue)
"Daniel Reib [MSFT]" wrote:
> Start by looking the reportserverservice<data>.log file. See if it says
> anything about picking up the items. What is the subscriptions result?
> Have you checked if the subscriptions has succeeded but is just not
> reporting it correctly?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
> > Each time I run a data-driven subscription, I recieve the following
> > information ... "Processing: 0 processed of 1 total; 0 errors" ... The
> > report
> > runs fine manually and via a subscription, but not a data-driven
> > subscription. I'm at a lost, where do I start to find this problem?
> > --
> > ~Jack~
>
>|||Can you post a portion of the log file that contains the info for when the
subscription fired?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
news:E9BEDE9D-EEEA-4570-8D1D-B648986F46F4@.microsoft.com...
> Daniel,
> Thanks for the reply. The data-driven subscription is designed to save
> the
> file as an excel file to a shared folder. Late yesterday I had changed
> the
> User name to my own credentials to see if this would help. Now I recieve
> the
> message "Processing: 1 processed of 1 total; 0 errors"; but no file is
> delivered/created to the shared folder. This is at least a step better
> since
> before I had changed the credentials, the message was "Processing: 0
> processed of 1 total; 0 errors" . I did look through the log files and
> found
> no errors (wish I had, it would make it simpler to track down the issue)
> "Daniel Reib [MSFT]" wrote:
>> Start by looking the reportserverservice<data>.log file. See if it says
>> anything about picking up the items. What is the subscriptions result?
>> Have you checked if the subscriptions has succeeded but is just not
>> reporting it correctly?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
>> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
>> > Each time I run a data-driven subscription, I recieve the following
>> > information ... "Processing: 0 processed of 1 total; 0 errors" ... The
>> > report
>> > runs fine manually and via a subscription, but not a data-driven
>> > subscription. I'm at a lost, where do I start to find this problem?
>> > --
>> > ~Jack~
>>|||Daniel, Here is the last log entries for the data-driven subscription
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
processing item 09a38510-e45a-4050-a89d-856230aa4859
ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
08:23:02.
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
finished processing item 09a38510-e45a-4050-a89d-856230aa4859
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
ReportingServicesService!schedule!1cf4!12/16/2004-08:23:02:: Creating Time
based subscription notification for subscription:
f914a139-fae6-4192-b98a-7d6ab51ec6e0
ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
08:23:02.
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
finished processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
processing item c7dffde0-062e-494b-b66e-e502b8eb714d
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
finished processing item c7dffde0-062e-494b-b66e-e502b8eb714d
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
NotificationPolling processing item ab5e7c97-88d8-44af-83df-cff2ef6e7047
ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:03::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: e ERROR:
DBUnProtectData failed: System.FormatException: Invalid length for a Base-64
char array.
at System.Convert.FromBase64String(String s)
at
Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
data)
ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: i INFO: Current
user: NT AUTHORITY\SYSTEM
ReportingServicesService!notification!1cf4!12/16/2004-08:23:03:: e ERROR:
Error occured processing notification. Invalid length for a Base-64 char
array.
ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Data Driven
Notification for activation id 9845a8ff-e063-4a16-b6e1-ee8b59ba22ef was saved.
ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Status: Invalid
length for a Base-64 char array.
ReportingServicesService!notification!1cf4!12/16/2004-08:23:03::
Notification ab5e7c97-88d8-44af-83df-cff2ef6e7047 completed. Success: True,
Status: Invalid length for a Base-64 char array., DeliveryExtension: Report
Server FileShare, Report: Monthly Sales, Attempt 0
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
NotificationPolling finished processing item
ab5e7c97-88d8-44af-83df-cff2ef6e7047
ReportingServicesService!library!1cf4!12/16/2004-08:25:30:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
chunks, 0 running jobs
"Daniel Reib [MSFT]" wrote:
> Can you post a portion of the log file that contains the info for when the
> subscription fired?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> news:E9BEDE9D-EEEA-4570-8D1D-B648986F46F4@.microsoft.com...
> > Daniel,
> >
> > Thanks for the reply. The data-driven subscription is designed to save
> > the
> > file as an excel file to a shared folder. Late yesterday I had changed
> > the
> > User name to my own credentials to see if this would help. Now I recieve
> > the
> > message "Processing: 1 processed of 1 total; 0 errors"; but no file is
> > delivered/created to the shared folder. This is at least a step better
> > since
> > before I had changed the credentials, the message was "Processing: 0
> > processed of 1 total; 0 errors" . I did look through the log files and
> > found
> > no errors (wish I had, it would make it simpler to track down the issue)
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Start by looking the reportserverservice<data>.log file. See if it says
> >> anything about picking up the items. What is the subscriptions result?
> >> Have you checked if the subscriptions has succeeded but is just not
> >> reporting it correctly?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> >> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
> >> > Each time I run a data-driven subscription, I recieve the following
> >> > information ... "Processing: 0 processed of 1 total; 0 errors" ... The
> >> > report
> >> > runs fine manually and via a subscription, but not a data-driven
> >> > subscription. I'm at a lost, where do I start to find this problem?
> >> > --
> >> > ~Jack~
> >>
> >>
> >>
>
>|||Are you using Fileshare delivery? If so there is a known issue where you
can not use dynamic values for the user name and password. From the log,
this looks like the issue.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
news:BD5AF19E-5055-41B8-9E1B-83648CD11037@.microsoft.com...
> Daniel, Here is the last log entries for the data-driven subscription
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> processing item 09a38510-e45a-4050-a89d-856230aa4859
> ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
> 08:23:02.
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> finished processing item 09a38510-e45a-4050-a89d-856230aa4859
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
> ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
> ReportingServicesService!schedule!1cf4!12/16/2004-08:23:02:: Creating Time
> based subscription notification for subscription:
> f914a139-fae6-4192-b98a-7d6ab51ec6e0
> ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
> 08:23:02.
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> finished processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
> ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> processing item c7dffde0-062e-494b-b66e-e502b8eb714d
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> finished processing item c7dffde0-062e-494b-b66e-e502b8eb714d
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
> NotificationPolling processing item ab5e7c97-88d8-44af-83df-cff2ef6e7047
> ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:03::
> NotificationPolling processing 1 more items. 1 Total items in internal
> queue.
> ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: e ERROR:
> DBUnProtectData failed: System.FormatException: Invalid length for a
> Base-64
> char array.
> at System.Convert.FromBase64String(String s)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
> data)
> ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: i INFO: Current
> user: NT AUTHORITY\SYSTEM
> ReportingServicesService!notification!1cf4!12/16/2004-08:23:03:: e ERROR:
> Error occured processing notification. Invalid length for a Base-64 char
> array.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Data Driven
> Notification for activation id 9845a8ff-e063-4a16-b6e1-ee8b59ba22ef was
> saved.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Status:
> Invalid
> length for a Base-64 char array.
> ReportingServicesService!notification!1cf4!12/16/2004-08:23:03::
> Notification ab5e7c97-88d8-44af-83df-cff2ef6e7047 completed. Success:
> True,
> Status: Invalid length for a Base-64 char array., DeliveryExtension:
> Report
> Server FileShare, Report: Monthly Sales, Attempt 0
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
> NotificationPolling finished processing item
> ab5e7c97-88d8-44af-83df-cff2ef6e7047
> ReportingServicesService!library!1cf4!12/16/2004-08:25:30:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
> chunks, 0 running jobs
>
> "Daniel Reib [MSFT]" wrote:
>> Can you post a portion of the log file that contains the info for when
>> the
>> subscription fired?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
>> news:E9BEDE9D-EEEA-4570-8D1D-B648986F46F4@.microsoft.com...
>> > Daniel,
>> >
>> > Thanks for the reply. The data-driven subscription is designed to save
>> > the
>> > file as an excel file to a shared folder. Late yesterday I had changed
>> > the
>> > User name to my own credentials to see if this would help. Now I
>> > recieve
>> > the
>> > message "Processing: 1 processed of 1 total; 0 errors"; but no file is
>> > delivered/created to the shared folder. This is at least a step better
>> > since
>> > before I had changed the credentials, the message was "Processing: 0
>> > processed of 1 total; 0 errors" . I did look through the log files and
>> > found
>> > no errors (wish I had, it would make it simpler to track down the
>> > issue)
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> Start by looking the reportserverservice<data>.log file. See if it
>> >> says
>> >> anything about picking up the items. What is the subscriptions
>> >> result?
>> >> Have you checked if the subscriptions has succeeded but is just not
>> >> reporting it correctly?
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
>> >> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
>> >> > Each time I run a data-driven subscription, I recieve the following
>> >> > information ... "Processing: 0 processed of 1 total; 0 errors" ...
>> >> > The
>> >> > report
>> >> > runs fine manually and via a subscription, but not a data-driven
>> >> > subscription. I'm at a lost, where do I start to find this problem?
>> >> > --
>> >> > ~Jack~
>> >>
>> >>
>> >>
>>|||Yes I'm using file share and yes I am dynamically storing the user name and
password. Manually entered the user name and passwor as you suggest. Work
like charm. Thanks for all the help!!!
"Daniel Reib [MSFT]" wrote:
> Are you using Fileshare delivery? If so there is a known issue where you
> can not use dynamic values for the user name and password. From the log,
> this looks like the issue.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> news:BD5AF19E-5055-41B8-9E1B-83648CD11037@.microsoft.com...
> > Daniel, Here is the last log entries for the data-driven subscription
> >
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > processing item 09a38510-e45a-4050-a89d-856230aa4859
> > ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> > processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> > f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> > f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
> > 08:23:02.
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > finished processing item 09a38510-e45a-4050-a89d-856230aa4859
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
> > ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> > processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> > f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
> > ReportingServicesService!schedule!1cf4!12/16/2004-08:23:02:: Creating Time
> > based subscription notification for subscription:
> > f914a139-fae6-4192-b98a-7d6ab51ec6e0
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> > f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
> > 08:23:02.
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > finished processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
> > ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> > processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > processing item c7dffde0-062e-494b-b66e-e502b8eb714d
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > finished processing item c7dffde0-062e-494b-b66e-e502b8eb714d
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
> > NotificationPolling processing item ab5e7c97-88d8-44af-83df-cff2ef6e7047
> > ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:03::
> > NotificationPolling processing 1 more items. 1 Total items in internal
> > queue.
> > ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: e ERROR:
> > DBUnProtectData failed: System.FormatException: Invalid length for a
> > Base-64
> > char array.
> > at System.Convert.FromBase64String(String s)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
> > data)
> > ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: i INFO: Current
> > user: NT AUTHORITY\SYSTEM
> > ReportingServicesService!notification!1cf4!12/16/2004-08:23:03:: e ERROR:
> > Error occured processing notification. Invalid length for a Base-64 char
> > array.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Data Driven
> > Notification for activation id 9845a8ff-e063-4a16-b6e1-ee8b59ba22ef was
> > saved.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Status:
> > Invalid
> > length for a Base-64 char array.
> > ReportingServicesService!notification!1cf4!12/16/2004-08:23:03::
> > Notification ab5e7c97-88d8-44af-83df-cff2ef6e7047 completed. Success:
> > True,
> > Status: Invalid length for a Base-64 char array., DeliveryExtension:
> > Report
> > Server FileShare, Report: Monthly Sales, Attempt 0
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
> > NotificationPolling finished processing item
> > ab5e7c97-88d8-44af-83df-cff2ef6e7047
> > ReportingServicesService!library!1cf4!12/16/2004-08:25:30:: i INFO:
> > Cleaned
> > 0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
> > chunks, 0 running jobs
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Can you post a portion of the log file that contains the info for when
> >> the
> >> subscription fired?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> >> news:E9BEDE9D-EEEA-4570-8D1D-B648986F46F4@.microsoft.com...
> >> > Daniel,
> >> >
> >> > Thanks for the reply. The data-driven subscription is designed to save
> >> > the
> >> > file as an excel file to a shared folder. Late yesterday I had changed
> >> > the
> >> > User name to my own credentials to see if this would help. Now I
> >> > recieve
> >> > the
> >> > message "Processing: 1 processed of 1 total; 0 errors"; but no file is
> >> > delivered/created to the shared folder. This is at least a step better
> >> > since
> >> > before I had changed the credentials, the message was "Processing: 0
> >> > processed of 1 total; 0 errors" . I did look through the log files and
> >> > found
> >> > no errors (wish I had, it would make it simpler to track down the
> >> > issue)
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> Start by looking the reportserverservice<data>.log file. See if it
> >> >> says
> >> >> anything about picking up the items. What is the subscriptions
> >> >> result?
> >> >> Have you checked if the subscriptions has succeeded but is just not
> >> >> reporting it correctly?
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> >> >> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
> >> >> > Each time I run a data-driven subscription, I recieve the following
> >> >> > information ... "Processing: 0 processed of 1 total; 0 errors" ...
> >> >> > The
> >> >> > report
> >> >> > runs fine manually and via a subscription, but not a data-driven
> >> >> > subscription. I'm at a lost, where do I start to find this problem?
> >> >> > --
> >> >> > ~Jack~
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

Database/Application Documentation

Just general thoughts...
It seems to me that there is a lack of compile time binding between a .NET
application and the a SQL server database.
Can someone suggest the best way to do things like
-identify stored procedures that are no longer being used by an application
-genrerate a call tree of .NET classes and modules which flows all the way
to database SPs.
Is using strongly typed classes, something i am not very familiar with,
helpful?
I've looked at Project Anayzer by Avisio and the output is confusing.
Does Rational have something to help document an application that spans
tiers by analyzing the code?
Is the output quality or quantity?You could run a trace on the server and analyze the output for missing
procedures
http://sqlservercode.blogspot.com/
"Chad" wrote:

> Just general thoughts...
> It seems to me that there is a lack of compile time binding between a .NET
> application and the a SQL server database.
> Can someone suggest the best way to do things like
> -identify stored procedures that are no longer being used by an applicatio
n
> -genrerate a call tree of .NET classes and modules which flows all the way
> to database SPs.
> Is using strongly typed classes, something i am not very familiar with,
> helpful?
> I've looked at Project Anayzer by Avisio and the output is confusing.
> Does Rational have something to help document an application that spans
> tiers by analyzing the code?
> Is the output quality or quantity?
>
>
>|||That is correct. When you compile a .NET application, it only compiles
the managed code. SQL Server objects are considered to be external
resources, and are not compiled or checked in any way. Only the
provider syntax is checked, embedded strings, parameters and SQL
statements are not. There are other Microsoft partners who provide
third-party tools, which you may like better than the one you tried. I
used FMS analyzer a long time ago, which I liked at the time, but I've
not kept up with the available tools. See
http://www.microsoft.com/sql/partners/dbtools.asp for a complete list.
--Mary
On Fri, 30 Sep 2005 23:47:54 -0400, "Chad"
<chad.dokmanovich@.unisys.com> wrote:

>Just general thoughts...
>It seems to me that there is a lack of compile time binding between a .NET
>application and the a SQL server database.
>Can someone suggest the best way to do things like
>-identify stored procedures that are no longer being used by an application
>-genrerate a call tree of .NET classes and modules which flows all the way
>to database SPs.
>Is using strongly typed classes, something i am not very familiar with,
>helpful?
>I've looked at Project Anayzer by Avisio and the output is confusing.
>Does Rational have something to help document an application that spans
>tiers by analyzing the code?
>Is the output quality or quantity?
>
>

Database Version

Hello

if we generate a database file on a particular version of ms sql express and in time to come if there are a few more versions of ms sql express out there with the users - if we continue to package with our app a database file from an older version of sql express will that be a problem with users running a newer version of sql express ?

Also what about the converse scenario - where we ship a database file from a newer version of sql while the customer is still running on an older version.

Thanks,

Avinash

Hi,

normally you speak out only the support where you are sure that it works. It you are a userfriendly vendorf :-) you would check the database version and give a message box that the software can′t be installed or will be installed at their own risks because this version isn′t supported by you. Othwise, if you have a fire-and-forget attitude (like some software vendors) you only write the prerequisites on your box or readme.txt stating that the users *should* read that carefully or otherwise won′t get any support.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Many thanks for your response.

What I wanted to actually know is; since being able to do an auto attach on a database file and because applications in general and smart clients in particular have the ability to bring with them their own database file; surely in time to come there may be several versions of sql express out there with the users.

From your earlier email, I undertand that you are suggesting we perform some kind of a defensive check before we use the database file

But I was curious to hear of any features - upgrade/migration features that express has within it. For example there should be no problem opening a word 97 document in word 2000 but the otherway round may not be possible. But it may not be fully dysfunctional aswell. For example - may be the limitation is that (hypothetically) x, y and z features may not be rendered/rendered corectly. But the document itself should be rendered minus support for the newer features.

Although it may quite a while before the next version of express comes along, I wanted to get an understanding of what potential situations we will need to prepare for with our customers and also what measures we can take now to hopefully ease support to our customers later.

I'm not sure if I've been able to explain what I was unsure about or require clarifications on. Pl let me know if I need to clarify any of my questions.

Thanks and Regards,

Avinash

PS: It will be great if you can point me to some documentation that talks about the issues that I'm not certain about.

|||

Hi,

don′t get me wrong, in th most cases you are sure right. There is an automatical upgrade path with attaching databases, even if their service pack level differs, but I wouldn′t rely on that. Although this is a nice cool feature, we would have to go the like the one I mentiond above in Germany due to law restrictions / warranty.

As the version of SQL Server Express and 2000 / 7.0 are upgrade compatible , there sure will be an automated way to upgrade the SQL Server Express version among each other. But due to database changes on the main successor version of SQl Server they are not (AFAIK and my experience is) downgrade compatible.

What can you do ? -Testing testing testing prior to sending out your database version. Thats a way to document that you did your best to eliminate errors. What of a customers calls you and tells "Hey, I did upgrade my database from Version 9.0.2043 to your new version and this didn′t work and my database is crashed."

What about you telling then that you don′t know if that particular version is not compatible for upgrading ? So you would have to go the test afterwards, inform all customers to whom you shipped the upgrade product and extinguish the burning house at the customer site.

But on the other side, what about telling the customers that all version were tested for upgrading and had gone though a quality test at your center and this is a customer specific problem ?

I guess the latter one is more relaxing for the vendors, becasue they can proof that they took care to this scenarios.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Many thanks Jens Suessmeyer. I think I understand what you are saying.

Thanks and Regards,

Avinash

database updation log

how could I see which user run what query on the datbase
(sql 2000) at what time. pl help
regards, shahidYou need to have a trace running at that point-in-time, to see what the
users were running at that time. Do you have one?
Or you need to have some sort of logging in your application or stored
procedures.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"shahid" <anonymous@.discussions.microsoft.com> wrote in message
news:2b13201c467fb$a8013480$a401280a@.phx
.gbl...
how could I see which user run what query on the datbase
(sql 2000) at what time. pl help
regards, shahid|||Hi,
SQL Server will not log any Select statements. Only way to look into that is
activate Profiler. You can save the profiler output to a Table for analysis.
FYI, You can see the information only from the point you activate the
profier.
For doing this you could use the GUI interface Profiler or look into the
books online for the procedure "sp_trace_create".
Thanks
Hari
MCDBA
"shahid" <anonymous@.discussions.microsoft.com> wrote in message
news:2b13201c467fb$a8013480$a401280a@.phx
.gbl...
> how could I see which user run what query on the datbase
> (sql 2000) at what time. pl help
> regards, shahid

database update problem

hey guys. My database doesnt update until my application is exited. I need it to update at run time. Could anybody tell me how to fix this problem?

Your application IS using the server in 'run-time'.

Sounds like you may have an issue with how the application is holding data remotely, and then flushing its data changes to the server upon exit or close. That is a application design issue and not a SQL Server issue.

Perhaps I'm not understanding your plight. Care to go into more detail?

|||it updates when I run it from visual, just not the published version

DataBase Trigger

Hi All,
I want to create a comon insert trigger which should be applicable to all the tables in a database
i.e,
the trigger should be fired every time when we try to insert a record in any one of the tables in that database
i don't to achieve this using Stored Procedures
Thanks and Best Regards
Jothi Magesh
> I want to create a comon insert trigger which should be applicable to all
> the tables in a database
There is no such thing in current versions of SQL Server. There are tools
that can help you though.
http://www.aspfaq.com/search.asp?q=lumigent