Bar Charts in Reporting Services

Hi,
can any one help me about bar charts.how to create bar charts in
reporting services.
Thanks in advance
Malli"How to add, move, or delete a chart (Report Designer)" in Reporting Services
Books Online would be a good place to start.
"Malli" wrote:
> Hi,
> can any one help me about bar charts.how to create bar charts in
> reporting services.
>
> Thanks in advance
> Malli

Backup...

Is there a way to find out when the data in a table was
last updated?
How does Sql Server keep track of it?
Thank you in advance,
-TinaSQL Server keeps track of updates to the data via the TRANSACTION LOG.
There are a number of third party tools available to read through the
TRANSACTION LOG. One such product is LOG EXPLORER by Lumigent
(http://www.lumigent.com/).
You might also try using the undocumented DBCC LOG command
Here is schetchy documentatrion.
The following undocumented command will do the trick.
DBCC log ( {dbid|dbname}, [, type={0|1|2|3|4}] )
PARAMETERS:
Dbid or dbname - Enter either the dbid or the name of the database
in question.
type - is the type of output:
0 - minimum information (operation, context, transaction id)
1 - more information (plus flags, tags, row length)
2 - very detailed information (plus object name, index name,
page id, slot id)
3 - full information about each operation
4 - full information about each operation plus hexadecimal dump
of the current transaction log''s row.
by default type = 0
Best way to easily identify updated records is of course to design a
LAST_UPDATE_DATE column into your table design, but of course I don't see to
many folks doing this these days.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Tina" <anonymous@.discussions.microsoft.com> wrote in message
news:123cf01c44275$db2cf520$a501280a@.phx.gbl...
> Is there a way to find out when the data in a table was
> last updated?
> How does Sql Server keep track of it?
> Thank you in advance,
> -Tina
>|||Hi Gregory,
Thanks for the reply. I tried the following commands
I get the error "[Microsoft][ODBC SQL Server Driver]
Syntax error or access violation"
DBCC log ({DB1},{3})
DBCC log ({dbname=DB1},{type=3})
DBCC log ( {DB1}, type={3)) where DB1 is the name of my
database.
What am I doing wrong?
I am running it using Query Analyzer.
Thank you,
-Tina
>--Original Message--
>SQL Server keeps track of updates to the data via the
TRANSACTION LOG.
>There are a number of third party tools available to
read through the
>TRANSACTION LOG. One such product is LOG EXPLORER by
Lumigent
>(http://www.lumigent.com/).
>You might also try using the undocumented DBCC LOG
command
>Here is schetchy documentatrion.
>The following undocumented command will do the trick.
>
>DBCC log ( {dbid|dbname}, [, type={0|1|2|3|4}] )
>
>
>
>
>PARAMETERS:
>
> Dbid or dbname - Enter either the dbid or the name of
the database
> in question.
>
> type - is the type of output:
>
> 0 - minimum information (operation, context,
transaction id)
>
> 1 - more information (plus flags, tags, row length)
>
> 2 - very detailed information (plus object name,
index name,
> page id, slot id)
>
> 3 - full information about each operation
>
> 4 - full information about each operation plus
hexadecimal dump
> of the current transaction log''s row.
>
>by default type = 0
>
>
>Best way to easily identify updated records is of course
to design a
>LAST_UPDATE_DATE column into your table design, but of
course I don't see to
>many folks doing this these days.
>--
>----
--
>----
--
>--
>Need SQL Server Examples check out my website at
>http://www.geocities.com/sqlserverexamples
>"Tina" <anonymous@.discussions.microsoft.com> wrote in
message
>news:123cf01c44275$db2cf520$a501280a@.phx.gbl...
>> Is there a way to find out when the data in a table was
>> last updated?
>> How does Sql Server keep track of it?
>> Thank you in advance,
>> -Tina
>
>.
>|||You need to remove the curly braces. Try using:
dbcc log(DB1, 3)
-Sue
On Tue, 25 May 2004 16:10:19 -0700, "Tina"
<anonymous@.discussions.microsoft.com> wrote:
>Hi Gregory,
>Thanks for the reply. I tried the following commands
>I get the error "[Microsoft][ODBC SQL Server Driver]
>Syntax error or access violation"
>DBCC log ({DB1},{3})
>DBCC log ({dbname=DB1},{type=3})
>DBCC log ( {DB1}, type={3)) where DB1 is the name of my
>database.
>What am I doing wrong?
>I am running it using Query Analyzer.
>Thank you,
>-Tina
>
>>--Original Message--
>>SQL Server keeps track of updates to the data via the
>TRANSACTION LOG.
>>There are a number of third party tools available to
>read through the
>>TRANSACTION LOG. One such product is LOG EXPLORER by
>Lumigent
>>(http://www.lumigent.com/).
>>You might also try using the undocumented DBCC LOG
>command
>>Here is schetchy documentatrion.
>>The following undocumented command will do the trick.
>>
>>DBCC log ( {dbid|dbname}, [, type={0|1|2|3|4}] )
>>
>>
>>
>>
>>PARAMETERS:
>>
>> Dbid or dbname - Enter either the dbid or the name of
>the database
>> in question.
>>
>> type - is the type of output:
>>
>> 0 - minimum information (operation, context,
>transaction id)
>>
>> 1 - more information (plus flags, tags, row length)
>>
>> 2 - very detailed information (plus object name,
>index name,
>> page id, slot id)
>>
>> 3 - full information about each operation
>>
>> 4 - full information about each operation plus
>hexadecimal dump
>> of the current transaction log''s row.
>>
>>by default type = 0
>>
>>
>>Best way to easily identify updated records is of course
>to design a
>>LAST_UPDATE_DATE column into your table design, but of
>course I don't see to
>>many folks doing this these days.
>>--
>>----
>--
>>----
>--
>>--
>>Need SQL Server Examples check out my website at
>>http://www.geocities.com/sqlserverexamples
>>"Tina" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:123cf01c44275$db2cf520$a501280a@.phx.gbl...
>> Is there a way to find out when the data in a table was
>> last updated?
>> How does Sql Server keep track of it?
>> Thank you in advance,
>> -Tina
>>
>>.

Backup vs Export data

Please, can anyone sort this out for me?

What is the difference between backup-restore and export-import data?
Thanks in advance :rolleyes:Export-Import uses DTS to transfer data directly between two databases. Backup dumps data to a file on a drive, and restore loads data from files.|||Thanks for anwering my post :)
So, in case of an emergency, If I do not have a backup, but I have exported data in an other database, I can import data again and everything would be ok?|||I would use backups because what the blinddude forgot to mention is that backups perserve the database objects as well (stored procedure, triggers, views, functions etc...) as well. If your environment is like mine, people are making changes all the time to this stuf.

Also, if you structure your disaster recovery correctly, you can achieve point in time recovery and minimize data loss.|||Well, you could import objects from a remote database as well, though transferring logins and permissions would be difficult.

The big reason (or one of them) for using backups is that you can maintain multiple backup files, allowing you to restore your database to any point in time, down to the minute if data corruption occurs. You cannot do this with import/export. DTS was not meant for data archiving or recoverability, and should not be used for such.|||Thanks for answering my post!
I think that I once used the Enterprise Manager and I was able to export Stored Procedures using the export data feature.
Isn t that possible on Management Studio?