Property DefaultSchema is not available

Is anybody aware if any progress has been made on this issue?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=79418&SiteID=1

https://connect.microsoft.com/feedback/viewfeedback.aspx?FeedbackID=238246&wa=wsignin1.0&siteid=68.

We are already tracking this request under PS #299032. I will close this request as a duplicate.

It might be better to check PS 299032 progress.

Progress Versus SQL Server

Progress is a piece of crap! Sure it runs on Unix. But the time
invested in learning and working with it obscene! With SQL Server I
could easily plan a maintenance backup plan and transaction backup plan
- Progress - well you have to learn about AI files, sizing the BI and
AI files as well as the data files. It's a freakin nightmare. If I
want to see data in a table, can I simply click on a table and open it
- NO! Instead, I have to learn the 4GL language to write a script to
return records (what if I want to resort those records - write another
4GL script and run it again). But hey, why do you want to see the data
in the tables (at least that's what I was told by my company) Progress
GUI - what a joke. This database server might have been popular with
unix but the world today is GUI and Microsoft are the GUI experts.
Even with the GUI tools in Progress, I still can't click on a table,
open it and see the records. Maybe that's not important to others but
as a dba, it sure is a necessity. We're working with different
versions of Progress and none of them integrate with the other. I've
spent 2 months now trying to run some simple database maintenance on
Progress and all I can say is that I hate BI, AI, and D1, D2, D3 files.
Give me SQL Server any day where at least I can manage databases in a
normal logical way without having to deal with a stinkin .ST files and
prostrct this...prostrct that!!! Any Progress responses are welcome
but I'll take you on any day against SQL Server. If you're a
Pro-Progress and anti-SQL Server, you're behind the times - get with
the newest technology and GUI (not a GUI in development.) I have yet
to see a true relational database designed in Progress. Upsizing a
Progress database into a GUI environment - HA!I worked with Progress for several years running mission critical
applications and all I can say is that is an excellent technology as good as
SQL Server or Oracle.
Ben Nevarez, MCDBA, OCP
Database Administrator
"pkohn@.charter.net" wrote:

> Progress is a piece of crap! Sure it runs on Unix. But the time
> invested in learning and working with it obscene! With SQL Server I
> could easily plan a maintenance backup plan and transaction backup plan
> - Progress - well you have to learn about AI files, sizing the BI and
> AI files as well as the data files. It's a freakin nightmare. If I
> want to see data in a table, can I simply click on a table and open it
> - NO! Instead, I have to learn the 4GL language to write a script to
> return records (what if I want to resort those records - write another
> 4GL script and run it again). But hey, why do you want to see the data
> in the tables (at least that's what I was told by my company) Progress
> GUI - what a joke. This database server might have been popular with
> unix but the world today is GUI and Microsoft are the GUI experts.
> Even with the GUI tools in Progress, I still can't click on a table,
> open it and see the records. Maybe that's not important to others but
> as a dba, it sure is a necessity. We're working with different
> versions of Progress and none of them integrate with the other. I've
> spent 2 months now trying to run some simple database maintenance on
> Progress and all I can say is that I hate BI, AI, and D1, D2, D3 files.
> Give me SQL Server any day where at least I can manage databases in a
> normal logical way without having to deal with a stinkin .ST files and
> prostrct this...prostrct that!!! Any Progress responses are welcome
> but I'll take you on any day against SQL Server. If you're a
> Pro-Progress and anti-SQL Server, you're behind the times - get with
> the newest technology and GUI (not a GUI in development.) I have yet
> to see a true relational database designed in Progress. Upsizing a
> Progress database into a GUI environment - HA!
>|||pkohn@.charter.net wrote:
> Progress is a piece of crap! Sure it runs on Unix. But the time
> invested in learning and working with it obscene! With SQL Server I
> could easily plan a maintenance backup plan and transaction backup plan
> - Progress - well you have to learn about AI files, sizing the BI and
> AI files as well as the data files. It's a freakin nightmare. If I
> want to see data in a table, can I simply click on a table and open it
> - NO! Instead, I have to learn the 4GL language to write a script to
> return records (what if I want to resort those records - write another
> 4GL script and run it again). But hey, why do you want to see the data
> in the tables (at least that's what I was told by my company) Progress
> GUI - what a joke. This database server might have been popular with
> unix but the world today is GUI and Microsoft are the GUI experts.
> Even with the GUI tools in Progress, I still can't click on a table,
> open it and see the records. Maybe that's not important to others but
> as a dba, it sure is a necessity. We're working with different
> versions of Progress and none of them integrate with the other. I've
> spent 2 months now trying to run some simple database maintenance on
> Progress and all I can say is that I hate BI, AI, and D1, D2, D3 files.
> Give me SQL Server any day where at least I can manage databases in a
> normal logical way without having to deal with a stinkin .ST files and
> prostrct this...prostrct that!!! Any Progress responses are welcome
> but I'll take you on any day against SQL Server. If you're a
> Pro-Progress and anti-SQL Server, you're behind the times - get with
> the newest technology and GUI (not a GUI in development.) I have yet
> to see a true relational database designed in Progress. Upsizing a
> Progress database into a GUI environment - HA!
>
Tossing in my 2-cents... I'm not a Progress guy, never touched it. I
do however find it interesting that your entire argument seems to be
based on SQL offering a better GUI. I blame that GUI for some of the
basic, everyday questions that cross this newsgroup on a daily basis.
My database has been running for 2 years, and my transaction log is
250GB, why? How can I export a database to a different server? The GUI
that you seem to cherish allows any Access user to think he's a SQL
Server DBA, without forcing him/her to learn the most basic tasks.
Point-and-click through the maintenance plan wizard, without
understanding a thing about what it's actually doing, all is well until
that plan begins to fail. Since they never understood what it was
doing, they have no idea where to start troubleshooting. Oh, look,
there's a "New Database Wizard", I can create a database! What's my
backup strategy? Do I need transactional recovery capabilities, or are
daily full backups enough? Dunno, the wizard didn't ask me those questions.
Personally, the only time I touch Enterprise Manager is when I have to
work with some DTS package that somebody dragged objects onto,
connecting them with workflow lines, because that's the only way they
know how to execute a stored procedure.

Progress v9.1C database connection for SQL Server 2005 ETL-tool

Hello,
I'm evaluation SQL Server 2005 to use it as an ETL-tool. We need to connect
to a Progress v9.1C database as datasource. SQL Server 2005 operates on the
.NET platform, I'm not aible to connect to progress from the datasource tab
in the ETL-tool part of SQL Server 2005 (there is no ADO.NET or OLE-DB
connection availble). Could you please help me to solve this problem?
Greetings,
Paul Siteur
Vriendelijke groet,
Paulus
Paul Siteur
IBN-groep
ICT Applicatiebeheerder / Cognos ontwerper
Hockeyweg 5
5405 NC Uden
tel. 0413-33 44 37
e-mail psiteur@.ibn-groep.nl
www.ibn-groep.nlIf Progress has an ODBC client, install it on the machine you'll run
Integration services from (that's your development machine and the
deployment server) and use the OLEDB connection for ODBC as your data
source.
"plupos" <plupos@.discussions.microsoft.com> wrote in message
news:5E8E76FF-9DDA-477C-91C7-24FA782C07B4@.microsoft.com...
> Hello,
> I'm evaluation SQL Server 2005 to use it as an ETL-tool. We need to
> connect
> to a Progress v9.1C database as datasource. SQL Server 2005 operates on
> the
> .NET platform, I'm not aible to connect to progress from the datasource
> tab
> in the ETL-tool part of SQL Server 2005 (there is no ADO.NET or OLE-DB
> connection availble). Could you please help me to solve this problem?
> Greetings,
> Paul Siteur
>
> Vriendelijke groet,
> Paulus
> Paul Siteur
> IBN-groep
> ICT Applicatiebeheerder / Cognos ontwerper
> Hockeyweg 5
> 5405 NC Uden
> tel. 0413-33 44 37
> e-mail psiteur@.ibn-groep.nl
> www.ibn-groep.nl

Progress Reporting in an external application

I have a custom external application that executes some packages. I would like to display the execution progress as it would appear in the Progress tab of the SSIS designer. How would I do that? Any help is appreciated.Implement IDTSEvents interface (the simplest way is inherit from DefaultEvents class, and override the methods you need), then call package.Execute(,,IDTSEvents,) method passing your object. Process the events from package and show the progress in the way you want.

Progress on runaway log files issue?

Can anyone tell me the status of the hotfix to resolve the runaway log file
issue? I've been trying to keep an eye on this group as it had been
mentioned in previous posts that an announcement would be posted here when
the fix is available, but I haven't seen it yet. Didn't know if I had
missed it or if it's still being worked on.
Thanks,
ShawnGo to support.microsoft.com and search for article 885286
Jeff
"Shawn Hansen" <shansen@.lrs.com> wrote in message
news:ecK18ZHsEHA.3712@.TK2MSFTNGP15.phx.gbl...
> Can anyone tell me the status of the hotfix to resolve the runaway log
file
> issue? I've been trying to keep an eye on this group as it had been
> mentioned in previous posts that an announcement would be posted here when
> the fix is available, but I haven't seen it yet. Didn't know if I had
> missed it or if it's still being worked on.
> Thanks,
> Shawn
>

Progress Indicator for Table Reindex

I am reindex a 100 Gig Table with 30 million rows. It is currently running 14
hours.
Is there any way for me to find out approx when this will end (ie percent
complete)
No. There is no progress reporting for index ops in SQL Server 2000 or 2005.
Do you know how long the index took to reindex last time? That would be the
basis for a rough first-order approximation of the run-time this time. Other
factors that make determining this very difficult are concurrent cpu and I/O
load and distribution of free space in the database (basically you need to
have another 120 Gb of free space to be able to rebuild a 100 Gb clustered
index - if you don't the files will grow during the operation).
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Gozick" <MarkGozick@.discussions.microsoft.com> wrote in message
news:666E1A4F-D8AF-440C-8D56-84A5DF1DE0EC@.microsoft.com...
> I am reindex a 100 Gig Table with 30 million rows. It is currently running
14
> hours.
> Is there any way for me to find out approx when this will end (ie percent
> complete)
>
|||100GB "TABLE" ?
how big is the DB ?
Greg Jackson
PDX, Oregon
|||the DB is 400 Gig. The 100 Gig table is the General Ledger Detail table which
is quite large. We can only keep 2 years on-line.
"pdxJaxon" wrote:

> 100GB "TABLE" ?
> how big is the DB ?
>
> Greg Jackson
> PDX, Oregon
>
>
|||Mark Gozick wrote:
> the DB is 400 Gig. The 100 Gig table is the General Ledger Detail
> table which is quite large. We can only keep 2 years on-line.
Did you just say "only"? ...
robert
|||That's not that big any more...
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Klemme" <bob.news@.gmx.net> wrote in message
news:u4COG9HYFHA.3356@.TK2MSFTNGP15.phx.gbl...
> Mark Gozick wrote:
> Did you just say "only"? ...
> robert
>

Progress Indicator for Table Reindex

I am reindex a 100 Gig Table with 30 million rows. It is currently running 14
hours.
Is there any way for me to find out approx when this will end (ie percent
complete)No. There is no progress reporting for index ops in SQL Server 2000 or 2005.
Do you know how long the index took to reindex last time? That would be the
basis for a rough first-order approximation of the run-time this time. Other
factors that make determining this very difficult are concurrent cpu and I/O
load and distribution of free space in the database (basically you need to
have another 120 Gb of free space to be able to rebuild a 100 Gb clustered
index - if you don't the files will grow during the operation).
Regards
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Gozick" <MarkGozick@.discussions.microsoft.com> wrote in message
news:666E1A4F-D8AF-440C-8D56-84A5DF1DE0EC@.microsoft.com...
> I am reindex a 100 Gig Table with 30 million rows. It is currently running
14
> hours.
> Is there any way for me to find out approx when this will end (ie percent
> complete)
>|||100GB "TABLE" ?
how big is the DB ?
Greg Jackson
PDX, Oregon|||the DB is 400 Gig. The 100 Gig table is the General Ledger Detail table which
is quite large. We can only keep 2 years on-line.
"pdxJaxon" wrote:
> 100GB "TABLE" ?
> how big is the DB ?
>
> Greg Jackson
> PDX, Oregon
>
>|||Mark Gozick wrote:
> the DB is 400 Gig. The 100 Gig table is the General Ledger Detail
> table which is quite large. We can only keep 2 years on-line.
Did you just say "only"? ...
robert|||That's not that big any more...
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Klemme" <bob.news@.gmx.net> wrote in message
news:u4COG9HYFHA.3356@.TK2MSFTNGP15.phx.gbl...
> Mark Gozick wrote:
> > the DB is 400 Gig. The 100 Gig table is the General Ledger Detail
> > table which is quite large. We can only keep 2 years on-line.
> Did you just say "only"? ...
> robert
>

Progress Indicator for Table Reindex

I am reindex a 100 Gig Table with 30 million rows. It is currently running 1
4
hours.
Is there any way for me to find out approx when this will end (ie percent
complete)No. There is no progress reporting for index ops in SQL Server 2000 or 2005.
Do you know how long the index took to reindex last time? That would be the
basis for a rough first-order approximation of the run-time this time. Other
factors that make determining this very difficult are concurrent cpu and I/O
load and distribution of free space in the database (basically you need to
have another 120 Gb of free space to be able to rebuild a 100 Gb clustered
index - if you don't the files will grow during the operation).
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Gozick" <MarkGozick@.discussions.microsoft.com> wrote in message
news:666E1A4F-D8AF-440C-8D56-84A5DF1DE0EC@.microsoft.com...
> I am reindex a 100 Gig Table with 30 million rows. It is currently running
14
> hours.
> Is there any way for me to find out approx when this will end (ie percent
> complete)
>|||100GB "TABLE" ?
how big is the DB ?
Greg Jackson
PDX, Oregon|||the DB is 400 Gig. The 100 Gig table is the General Ledger Detail table whic
h
is quite large. We can only keep 2 years on-line.
"pdxJaxon" wrote:

> 100GB "TABLE" ?
> how big is the DB ?
>
> Greg Jackson
> PDX, Oregon
>
>|||Mark Gozick wrote:
> the DB is 400 Gig. The 100 Gig table is the General Ledger Detail
> table which is quite large. We can only keep 2 years on-line.
Did you just say "only"? ...
robert|||That's not that big any more...
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Klemme" <bob.news@.gmx.net> wrote in message
news:u4COG9HYFHA.3356@.TK2MSFTNGP15.phx.gbl...
> Mark Gozick wrote:
> Did you just say "only"? ...
> robert
>

Progress indicator for Neural Network training...

I am in the process of training a Neural Networks, which could take significant iterations in the process of getting trained. While using other tools like I can visually see the convergence (in terms of error for the model). Is there a way to see any progress while training while using Analysis Server - Neural Network training? It would be useful to see the accuracy, interation number and timeout while in the process of training etc...

Thanks

Rajeev Gupta

Hello

The progress notifications for Neural Networks will be somewhat improved for the next Service Pack of SQL Server 2005. However, there is still no simple way to display the information you requested. We consider this as an improvement for the next version.

Meanwhile, there is a way to filter the notifications and obtain at least part of the information:

The "Tracing Mining Model Processing Using AMO" article at http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3615.aspx contains information (and a code sample) on how to trace the notifications emitted during the processing of a mining model. Among the "Reading cases..." notifications there are some looking like "Training the subnet. Holdout error = ...".

The sample application can be slightly modified to filter out events that do not look like "Training the subnet....". One such notification is emitted after each iteration and the holdout error is included in the notification.

Hope this helps

Progress Indicator

How do I know the percentage done or left when command like DBCC REINDEX or
ALTER TABLE on a huge table?
Thanks in advance.In general, you don't.
However, in SQL Server 2005, you can query the sys.dm_exec_requests view. It
gives you progress
report for *some* operations (documented in Books Online).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonathan Chong" <jonathan@.smartie.com> wrote in message
news:%238q1PLZeGHA.5016@.TK2MSFTNGP04.phx.gbl...
> How do I know the percentage done or left when command like DBCC REINDEX o
r
> ALTER TABLE on a huge table?
> Thanks in advance.
>

progress indication from ssis app in VB

Hi

am calling an ssis app from my vb programme. It takes about 5 minutes to run. What is the best way to provide progress feedback to my vb user.

Cheers

Ants

I

Ants Hurdley wrote:

Hi

am calling an ssis app from my vb programme. It takes about 5 minutes to run. What is the best way to provide progress feedback to my vb user.

Cheers

Ants

I

Package.Execute() has an overloaded constructor that allows you to pass in a IDTSEvents object. As far as I'm aware this allows you to get events out of the executing package - after which you can surface them to your VB app.

Take a look here for more info:

DtsContainer.Execute Method
(http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtscontainer.execute.aspx)

-Jamie

|||There is also a sample event listener code at
http://msdn2.microsoft.com/en-us/library/ms136090.aspx|||

Hi

Thanks for this - I am not sure if I am understanding this correctly as I am new to this but I want to show the progress as the package is executed. I.e. my Package has 15 steps, so I would like to show a progress bar or something to let the user know that things are happening. Not just show a success or failire.

Cheers

|||

The sampel only demonstrates overriding the OnError event, but you can override any of the other events, such as OnPreExecute and OnPostExecute, which will give you begin and end notices for each container. See here for more information on the DefaultEvents class-

DefaultEvents Members (Microsoft.SqlServer.Dts.Runtime)
(http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.defaultevents_members.aspx)

|||

Ants Hurdley wrote:

Hi

Thanks for this - I am not sure if I am understanding this correctly as I am new to this but I want to show the progress as the package is executed. I.e. my Package has 15 steps, so I would like to show a progress bar or something to let the user know that things are happening. Not just show a success or failire.

Cheers

Well that's not really a SSIS question. SSIS can tell you its progress and its up to you how you display that information in your app. A progress bar is an option I guess.

Note that BIDS uses the same mechanism to populate the "Package Execution" tab when you debug a package .

-Jamie

PROGRESS import of field freezes SQL Server

hi,
I've got a SQL 2005 with an odbc connection to a PROGRESS database. We can
transfer data from the progress to the sql but there is 1 field we can not
transfer. This field, proclaimed by the PROGRESS administration, is a field
wich can contain an empty string or up to 8 characters.
But when we try to do a 'select problemfield, goodfield1,goodfield2 from
pub.table' in the import and export wizard and try to preview this select,
SQL Server freezes for a loooooong time resulting in an error "defined by
component".
We have tried to put the problem field into the select clause, with the
where clause without the where clause... always the same result. The datatyp
e
that we use is a varchar(8) or more but it always freezes.
Does anyone have an idea?
Note: when progress exports to a flat file and we import that flat file,
this works without any problems. So instead of using the odbc connection to
transfer the data overnight, we would like to use flat files and import them
with Integration S. Good solution or not?Ok,
We managed to get the import; but via a flatfile source not with the odbc
connector. Wat went wrong I cant say, it wasn't possible to import the field
s
via a ODBC connection, the flatfime however imported like nothing (although
it where millions of rows)
We have to do a lot of cleansing, the progress software sets a ? in fields
that are not filled in. In this case, implicit conversions to smalldatatime
fails. Now that we have everything in nvarchar, I'm sure SSIS will bring us
where we want.
Thx,
"Philippe" wrote:

> hi,
> I've got a SQL 2005 with an odbc connection to a PROGRESS database. We can
> transfer data from the progress to the sql but there is 1 field we can not
> transfer. This field, proclaimed by the PROGRESS administration, is a fiel
d
> wich can contain an empty string or up to 8 characters.
> But when we try to do a 'select problemfield, goodfield1,goodfield2 from
> pub.table' in the import and export wizard and try to preview this select,
> SQL Server freezes for a loooooong time resulting in an error "defined by
> component".
> We have tried to put the problem field into the select clause, with the
> where clause without the where clause... always the same result. The datat
ype
> that we use is a varchar(8) or more but it always freezes.
> Does anyone have an idea?
> Note: when progress exports to a flat file and we import that flat file,
> this works without any problems. So instead of using the odbc connection t
o
> transfer the data overnight, we would like to use flat files and import th
em
> with Integration S. Good solution or not?

Progress from DBCC SHRINKFILE

Hello,
how can I see the progress of DBCC SHRINKFILE?
If you are using SQL Server 2005, you may be able to get percent_complete
from sys.dm_exec_requests. This is often 0 for most operations, but it is
roughly accurate for some (including backup database). Not sure if it
covers DBCC.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Matze" <Matze@.discussions.microsoft.com> wrote in message
news:AF8ACF95-6C40-4C60-B9F0-42EA6B28661D@.microsoft.com...
> Hello,
> how can I see the progress of DBCC SHRINKFILE?
>
|||Thank you Aaron,
for your reply.
"Aaron Bertrand [SQL Server MVP]" wrote:

> If you are using SQL Server 2005, you may be able to get percent_complete
> from sys.dm_exec_requests. This is often 0 for most operations, but it is
> roughly accurate for some (including backup database). Not sure if it
> covers DBCC.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "Matze" <Matze@.discussions.microsoft.com> wrote in message
> news:AF8ACF95-6C40-4C60-B9F0-42EA6B28661D@.microsoft.com...
>
>
|||Yes, it covers DBCC SHRINKFILE and DBCC SHRINKDATABASE in SQL 2005.
Paul Randal
Principal Lead Program Manager
Microsoft SQL Server Core Storage Engine,
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
"Matze" <Matze@.discussions.microsoft.com> wrote in message
news:C3C5DA45-BE31-4E70-A2EA-82CA767FECA5@.microsoft.com...[vbcol=seagreen]
> Thank you Aaron,
> for your reply.
> "Aaron Bertrand [SQL Server MVP]" wrote:

Progress from DBCC SHRINKFILE

Hello,
how can I see the progress of DBCC SHRINKFILE?If you are using SQL Server 2005, you may be able to get percent_complete
from sys.dm_exec_requests. This is often 0 for most operations, but it is
roughly accurate for some (including backup database). Not sure if it
covers DBCC.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Matze" <Matze@.discussions.microsoft.com> wrote in message
news:AF8ACF95-6C40-4C60-B9F0-42EA6B28661D@.microsoft.com...
> Hello,
> how can I see the progress of DBCC SHRINKFILE?
>|||Thank you Aaron,
for your reply.
"Aaron Bertrand [SQL Server MVP]" wrote:

> If you are using SQL Server 2005, you may be able to get percent_complete
> from sys.dm_exec_requests. This is often 0 for most operations, but it is
> roughly accurate for some (including backup database). Not sure if it
> covers DBCC.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "Matze" <Matze@.discussions.microsoft.com> wrote in message
> news:AF8ACF95-6C40-4C60-B9F0-42EA6B28661D@.microsoft.com...
>
>|||Yes, it covers DBCC SHRINKFILE and DBCC SHRINKDATABASE in SQL 2005.
Paul Randal
Principal Lead Program Manager
Microsoft SQL Server Core Storage Engine,
http://blogs.msdn.com/sqlserverstor...ne/default.aspx
"Matze" <Matze@.discussions.microsoft.com> wrote in message
news:C3C5DA45-BE31-4E70-A2EA-82CA767FECA5@.microsoft.com...[vbcol=seagreen]
> Thank you Aaron,
> for your reply.
> "Aaron Bertrand [SQL Server MVP]" wrote:
>

Progress from DBCC SHRINKFILE

Hello,
how can I see the progress of DBCC SHRINKFILE?If you are using SQL Server 2005, you may be able to get percent_complete
from sys.dm_exec_requests. This is often 0 for most operations, but it is
roughly accurate for some (including backup database). Not sure if it
covers DBCC.
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Matze" <Matze@.discussions.microsoft.com> wrote in message
news:AF8ACF95-6C40-4C60-B9F0-42EA6B28661D@.microsoft.com...
> Hello,
> how can I see the progress of DBCC SHRINKFILE?
>|||Thank you Aaron,
for your reply.
"Aaron Bertrand [SQL Server MVP]" wrote:
> If you are using SQL Server 2005, you may be able to get percent_complete
> from sys.dm_exec_requests. This is often 0 for most operations, but it is
> roughly accurate for some (including backup database). Not sure if it
> covers DBCC.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "Matze" <Matze@.discussions.microsoft.com> wrote in message
> news:AF8ACF95-6C40-4C60-B9F0-42EA6B28661D@.microsoft.com...
> > Hello,
> >
> > how can I see the progress of DBCC SHRINKFILE?
> >
>
>|||Yes, it covers DBCC SHRINKFILE and DBCC SHRINKDATABASE in SQL 2005.
--
Paul Randal
Principal Lead Program Manager
Microsoft SQL Server Core Storage Engine,
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
"Matze" <Matze@.discussions.microsoft.com> wrote in message
news:C3C5DA45-BE31-4E70-A2EA-82CA767FECA5@.microsoft.com...
> Thank you Aaron,
> for your reply.
> "Aaron Bertrand [SQL Server MVP]" wrote:
>> If you are using SQL Server 2005, you may be able to get percent_complete
>> from sys.dm_exec_requests. This is often 0 for most operations, but it
>> is
>> roughly accurate for some (including backup database). Not sure if it
>> covers DBCC.
>> --
>> Aaron Bertrand
>> SQL Server MVP
>> http://www.sqlblog.com/
>> http://www.aspfaq.com/5006
>>
>>
>> "Matze" <Matze@.discussions.microsoft.com> wrote in message
>> news:AF8ACF95-6C40-4C60-B9F0-42EA6B28661D@.microsoft.com...
>> > Hello,
>> >
>> > how can I see the progress of DBCC SHRINKFILE?
>> >
>>

Progress Database ODBC Source

Hello,

I need to pull in data from a progress database into a table in SQL server 2005. I have an ODBC conncetion on the server where I am working.

I am new to SSIS but have used DTS. I need to succsefully pull the data into a table in SQL server 2005 from this progress database.

I have setup my ODBC connection but I cannot pull the data using this connection. The connection test succeeded for the connection manager. When I attempt to use the datasource reader and point to the ODBC Connection Manager entry I recieve Cannot acquire a managed connection from the run time connection manager

Any help is appreciated.

Thanks,

Tony

Hi Tony,

you need to configure your connection as ADO.NET for ODBC. DataReader source can only work with ADO.NET connections.

|||Try to create connection using .NET Provider\ODBC Data Provider I have tried it at my end it's working fine.

Progress Bar in Table Cell

I'm creating a report with several columns. One of which is a percentage
value. The business people have asked that that column show a progress bar of
sorts to give a visual indicator of the percentage complete, in addition to
the textual %. I have tried to figure out how to do this in a table cell but
to no avail. It appears that you can't use an Expression to set the sizing of
an image, rectangle, etc. Anyone have an idea on how this might be done?
Thanks!you could try a chart (one of the bar graphs that are horizontal based).Then
maybe format the chart to remove the legend, scale, title etc
"rSmoke" wrote:
> I'm creating a report with several columns. One of which is a percentage
> value. The business people have asked that that column show a progress bar of
> sorts to give a visual indicator of the percentage complete, in addition to
> the textual %. I have tried to figure out how to do this in a table cell but
> to no avail. It appears that you can't use an Expression to set the sizing of
> an image, rectangle, etc. Anyone have an idea on how this might be done?
> Thanks!|||I had tried that, except you can't put a chart in a table cell. However, your
post led me to try a subreport with a chart in it. That works great. I had
tried a subreport before but hadn't thought to try a chart in it. Thanks for
the help.
"NH" wrote:
> you could try a chart (one of the bar graphs that are horizontal based).Then
> maybe format the chart to remove the legend, scale, title etc
> "rSmoke" wrote:
> > I'm creating a report with several columns. One of which is a percentage
> > value. The business people have asked that that column show a progress bar of
> > sorts to give a visual indicator of the percentage complete, in addition to
> > the textual %. I have tried to figure out how to do this in a table cell but
> > to no avail. It appears that you can't use an Expression to set the sizing of
> > an image, rectangle, etc. Anyone have an idea on how this might be done?
> > Thanks!|||Note: you can put a chart inside a table group header or group footer. In
that case, the chart would be based of all data rows of that particular
group instance (which is what you typically want). The subreport approach
works but is usually not as efficient as table groups.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"rSmoke" <rSmoke@.discussions.microsoft.com> wrote in message
news:7CC6307F-077B-45A8-9BBD-18C451815AD4@.microsoft.com...
>I had tried that, except you can't put a chart in a table cell. However,
>your
> post led me to try a subreport with a chart in it. That works great. I had
> tried a subreport before but hadn't thought to try a chart in it. Thanks
> for
> the help.
> "NH" wrote:
>> you could try a chart (one of the bar graphs that are horizontal
>> based).Then
>> maybe format the chart to remove the legend, scale, title etc
>> "rSmoke" wrote:
>> > I'm creating a report with several columns. One of which is a
>> > percentage
>> > value. The business people have asked that that column show a progress
>> > bar of
>> > sorts to give a visual indicator of the percentage complete, in
>> > addition to
>> > the textual %. I have tried to figure out how to do this in a table
>> > cell but
>> > to no avail. It appears that you can't use an Expression to set the
>> > sizing of
>> > an image, rectangle, etc. Anyone have an idea on how this might be
>> > done?
>> > Thanks!

Progress bar for backup operation

Hi,
I am creating a simple form that user will backup his database using that. I
need to show a progress bar when the backup is in progress. How can I read a
value which indicates that? I saw that BACKUP statement has a STATS option,
but I don't know how to capture its value from the server and bring it to
client.
Any help would be greatly appreciated.
Thanks in advance,
Amin
Amin,
Use the Complete event of the Backup object in SQL-DMO.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that. I
> need to show a progress bar when the backup is in progress. How can I read a
> value which indicates that? I saw that BACKUP statement has a STATS option,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>
|||Amin,
Oops, I meant use the PercentComplete event of the Backup object. Ignore
my other post in this thread.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that. I
> need to show a progress bar when the backup is in progress. How can I read a
> value which indicates that? I saw that BACKUP statement has a STATS option,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>
|||Thanks Mark! That was great tip :-)
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OZDT9GabEHA.4092@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Amin,
> Oops, I meant use the PercentComplete event of the Backup object. Ignore
> my other post in this thread.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Amin Sobati wrote:
that. I[vbcol=seagreen]
read a[vbcol=seagreen]
option,[vbcol=seagreen]
to[vbcol=seagreen]

Progress bar for backup operation

Hi,
I am creating a simple form that user will backup his database using that. I
need to show a progress bar when the backup is in progress. How can I read a
value which indicates that? I saw that BACKUP statement has a STATS option,
but I don't know how to capture its value from the server and bring it to
client.
Any help would be greatly appreciated.
Thanks in advance,
AminAmin,
Use the Complete event of the Backup object in SQL-DMO.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that.
I
> need to show a progress bar when the backup is in progress. How can I read
a
> value which indicates that? I saw that BACKUP statement has a STATS option
,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>|||Amin,
Oops, I meant use the PercentComplete event of the Backup object. Ignore
my other post in this thread.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that.
I
> need to show a progress bar when the backup is in progress. How can I read
a
> value which indicates that? I saw that BACKUP statement has a STATS option
,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>|||Thanks Mark! That was great tip :-)
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OZDT9GabEHA.4092@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Amin,
> Oops, I meant use the PercentComplete event of the Backup object. Ignore
> my other post in this thread.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Amin Sobati wrote:
that. I[vbcol=seagreen]
read a[vbcol=seagreen]
option,[vbcol=seagreen]
to[vbcol=seagreen]

Progress bar for backup operation

Hi,
I am creating a simple form that user will backup his database using that. I
need to show a progress bar when the backup is in progress. How can I read a
value which indicates that? I saw that BACKUP statement has a STATS option,
but I don't know how to capture its value from the server and bring it to
client.
Any help would be greatly appreciated.
Thanks in advance,
AminAmin,
Use the Complete event of the Backup object in SQL-DMO.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that. I
> need to show a progress bar when the backup is in progress. How can I read a
> value which indicates that? I saw that BACKUP statement has a STATS option,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>|||Amin,
Oops, I meant use the PercentComplete event of the Backup object. Ignore
my other post in this thread.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Amin Sobati wrote:
> Hi,
> I am creating a simple form that user will backup his database using that. I
> need to show a progress bar when the backup is in progress. How can I read a
> value which indicates that? I saw that BACKUP statement has a STATS option,
> but I don't know how to capture its value from the server and bring it to
> client.
> Any help would be greatly appreciated.
> Thanks in advance,
> Amin
>
>|||Thanks Mark! That was great tip :-)
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:OZDT9GabEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Amin,
> Oops, I meant use the PercentComplete event of the Backup object. Ignore
> my other post in this thread.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Amin Sobati wrote:
> > Hi,
> > I am creating a simple form that user will backup his database using
that. I
> > need to show a progress bar when the backup is in progress. How can I
read a
> > value which indicates that? I saw that BACKUP statement has a STATS
option,
> > but I don't know how to capture its value from the server and bring it
to
> > client.
> > Any help would be greatly appreciated.
> > Thanks in advance,
> > Amin
> >
> >
> >