Welcome to SQL
Try doing the following at a time when the database has
few or no users.
Right Click on the Database and select Properties
Select Options Tab
Under Recovery - Model if its not set to simple change it
to simple.
Press OK
Right Click the database and select All Tasks -> Shrink
Database
Select the check box 'Move Pages to beginning...'
Press ok
Go make yourself a drink whilst your waiting ;)
And after if finishes change your 'Recovery - Model' back
to what it was prior to your change.
Peter
>--Original Message--
>Please excues my ignorance, but I am in no way a SQL guy;
so here goes:
>I have an accounting package that uses SQL 2000. SQL is
creating a backup
>file that is getting HUGE (about 2 GB)
>The actual data is around a few hundred MB.
>Is there a way to reduce the size of the backup file by:
>Compacting?
>Performaing a backup (that SQL knows about)?
>Is there a way to move that file?
>Can any of this be done on-line?
>Thanks for any help.
>Regards;
>PB
>
>.
>
Please forgive my ignorance, but:
Where is the database? It appears that the app that uses SQL is pointing to
a file share on another server. The backup file (BAK) is local, and it is
killing me. As I said, it is 2 GB and growing.
If it is the BAK file that is huge; will that fix my problem? The database
itself is only 132 MB.
TIA;
PB
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:44e901c47fb8$3fa1b9d0$a401280a@.phx.gbl...[vbcol=seagreen]
> Welcome to SQL
> Try doing the following at a time when the database has
> few or no users.
> Right Click on the Database and select Properties
> Select Options Tab
> Under Recovery - Model if its not set to simple change it
> to simple.
> Press OK
> Right Click the database and select All Tasks -> Shrink
> Database
> Select the check box 'Move Pages to beginning...'
> Press ok
> Go make yourself a drink whilst your waiting ;)
> And after if finishes change your 'Recovery - Model' back
> to what it was prior to your change.
> Peter
>
>
> so here goes:
> creating a backup
|||When releasing space SQL Server doesn't actually free
disk space, its thinking is if its needed it before, it
needs it now, so if you say delete half your database you
will see the same disk space.
The problem though is probably to do with your log file
that will grows a heck of a lot.
To work out where your files are click onto your database
then at the top menu selecy view 'Something (I'm away
from SQL) pad'
It will give you the location and size of your data files
and log files.
These files can be anywhere on your Network.
As for your backup files (.BAK) its considered good
practice to store them on a different server than the one
that SQL is on.
And yes, performing the steps will solve the problem as
the steps will release the unused disk space and so the
backups will not be fooled into thinking there is more to
the files than there actually is.
Anyway its 22:15 here and I am off to do something else.
Good luck
Peter
Peter
>--Original Message--
>Please forgive my ignorance, but:
>Where is the database? It appears that the app that uses
SQL is pointing to
>a file share on another server. The backup file (BAK) is
local, and it is
>killing me. As I said, it is 2 GB and growing.
>If it is the BAK file that is huge; will that fix my
problem? The database
>itself is only 132 MB.
>TIA;
>PB
>
>"Peter The Spate" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:44e901c47fb8$3fa1b9d0$a401280a@.phx.gbl...
it[vbcol=seagreen]
back[vbcol=seagreen]
guy;[vbcol=seagreen]
is[vbcol=seagreen]
by:
>
>.
>
Showing posts with label time. Show all posts
Showing posts with label time. Show all posts
Friday, March 30, 2012
New to SQL
Hi
I am setting for the first time SQL to access a database. I can get the
Enterprise Manager and the Network Utility to see the databases (on 2
computers) but when I go to the program to access the databases, I get a
Connection error.
Strangely, I set up the exact replica on the server and it can only see
itself and not the other computer.
I have scanned newsgroups etc but cannot locate the problem.
Thanks
cds
Could you please post the exact error message? There are various types of
connectivity issues, and we need to see the error message, to be able to
understand what's happening.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"cds" <cdsaus2001@.yahoo.com.au> wrote in message
news:4140ccde$0$3711$afc38c87@.news.optusnet.com.au ...
> Hi
> I am setting for the first time SQL to access a database. I can get the
> Enterprise Manager and the Network Utility to see the databases (on 2
> computers) but when I go to the program to access the databases, I get a
> Connection error.
> Strangely, I set up the exact replica on the server and it can only see
> itself and not the other computer.
> I have scanned newsgroups etc but cannot locate the problem.
> Thanks
> cds
>
sql
I am setting for the first time SQL to access a database. I can get the
Enterprise Manager and the Network Utility to see the databases (on 2
computers) but when I go to the program to access the databases, I get a
Connection error.
Strangely, I set up the exact replica on the server and it can only see
itself and not the other computer.
I have scanned newsgroups etc but cannot locate the problem.
Thanks
cds
Could you please post the exact error message? There are various types of
connectivity issues, and we need to see the error message, to be able to
understand what's happening.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"cds" <cdsaus2001@.yahoo.com.au> wrote in message
news:4140ccde$0$3711$afc38c87@.news.optusnet.com.au ...
> Hi
> I am setting for the first time SQL to access a database. I can get the
> Enterprise Manager and the Network Utility to see the databases (on 2
> computers) but when I go to the program to access the databases, I get a
> Connection error.
> Strangely, I set up the exact replica on the server and it can only see
> itself and not the other computer.
> I have scanned newsgroups etc but cannot locate the problem.
> Thanks
> cds
>
sql
New to reporting service
I am new to reporting service but has used VS 2005 beta to develop winform app for a long time. I have the following questions:
1. Are the report object and report viewer in VS2005(winform) related to those of SQL server reporting service? If yes, what are the relationship?
2. If I just want to create/view report with report viewer of VS2005 in my app which connect to SQL Server Express, do I need reporting service?
3. I can see there are options to install reporting service while installing SQL Server Express(free of charge), can I develop app for my client which use reporting service with SQL Server Express?
Thank a lot!Any idea?|||
Okay, here we go.
Reporting Services
Reporting Services is a component of SQL Server 2000 and SQL Server 2005. Basically the Reporting Services acts as a Report Repository and supports such features as:
* Server-Side Rendering = The server does the work
* Subscriptions - Reports can be generated at scheduled times and be automatically distributed to email or file shares.
* Report Snapshots - Report output can be rendered and stored on the server, for instance a monthly report can have a monthly snapshot. This way you never to need to print and store common reports, the server has the old copy even if the orginial report data is gone.
ReportViewer Control
Okay, so Reporting Services basically rocks because it solved the majority of your reporting issues and comes free with most versions of SQL Server. Now, in with SQL Server 2005 and Visual Studio 2005 there are 2 new controls that make reporting services even better. There is a Windows forms and asp.net ReportViewer control. The control can work in 2 modes, Remote and Local. In Remote mode it can be used to integrate with Reporting Services as users can view reports stored on the server. In local mode (what you want) it can displayed reports that have been embedded within your application. In this mode Reporting Services is not required, which makes it ideal to use with SQL Express. There are only 2 minor disadvantages to running in local mode. The first is that the client computer has to do all the work and report rendering, but its not bad for smaller applications. The second is that the client must have this ReportViewer pack installed. Basically, it contains all of the rendering pieces needed to render a report on the client machine. The great news is that if you deploy your application using the new ClickOnce, you can automatically deploy the ReportViewerPack (also it is very small like only a couple of MB!).
New to reporting service
I am new to reporting service but has used VS 2005 beta to develop winform app for a long time. I have the following questions:
1. Are the report object and report viewer in VS2005(winform) related to those of SQL server reporting service? If yes, what are the relationship?
2. If I just want to create/view report with report viewer of VS2005 in my app which connect to SQL Server Express, do I need reporting service?
3. I can see there are options to install reporting service while installing SQL Server Express(free of charge), can I develop app for my client which use reporting service with SQL Server Express?
Thank a lot!
Any idea?|||
Okay, here we go.
Reporting Services
Reporting Services is a component of SQL Server 2000 and SQL Server 2005. Basically the Reporting Services acts as a Report Repository and supports such features as:
* Server-Side Rendering = The server does the work
* Subscriptions - Reports can be generated at scheduled times and be automatically distributed to email or file shares.
* Report Snapshots - Report output can be rendered and stored on the server, for instance a monthly report can have a monthly snapshot. This way you never to need to print and store common reports, the server has the old copy even if the orginial report data is gone.
ReportViewer Control
Okay, so Reporting Services basically rocks because it solved the majority of your reporting issues and comes free with most versions of SQL Server. Now, in with SQL Server 2005 and Visual Studio 2005 there are 2 new controls that make reporting services even better. There is a Windows forms and asp.net ReportViewer control. The control can work in 2 modes, Remote and Local. In Remote mode it can be used to integrate with Reporting Services as users can view reports stored on the server. In local mode (what you want) it can displayed reports that have been embedded within your application. In this mode Reporting Services is not required, which makes it ideal to use with SQL Express. There are only 2 minor disadvantages to running in local mode. The first is that the client computer has to do all the work and report rendering, but its not bad for smaller applications. The second is that the client must have this ReportViewer pack installed. Basically, it contains all of the rendering pieces needed to render a report on the client machine. The great news is that if you deploy your application using the new ClickOnce, you can automatically deploy the ReportViewerPack (also it is very small like only a couple of MB!).
Wednesday, March 28, 2012
New Time Dimension Role after cube wizard
If I have a data source view consisting of two tables - a fact table and a time dimension table. The fact table has three date columns - transaction begin date, transaction end date, and updated date. When I initially designed the data source view my requirements only called for the trans begin and end dates so I made two joins to the time table from the sales table. I then ran the cube wizard which correctly detected that I intended to use the time table twice for two different Time hierarchies (Roles) on a single time dimension.
I have recently been asked to add the updated date but I cannot figure out how to add a new hierarchy (Role) on the time dimension. Any Ideas?
You should be able to go to the Dimension Usage tab in the cube designer and click on the Add Cube Dimension button on the toolbar (the third button from the left). When the list of dimensions comes up, simply select your Time dimension and add it again. You'll then see the dimension added within the list of dimensions down the left side of the tab, likely with a name like Time (Time 1) or something similar. Now, simply highlight the newly added role-playing dimension, hit F2, and rename it whatever you want. Then, of course, set the appropriate relationship between this new dimension and the measure group(s) within the cube...
HTH,
Dave Fackler
sqlnew tables everyday
We have a software package that exports its data in MS Access 97 and 2000
formats. It overwrites and creates a new Access file each time it exports.
These exports serve a handful of front end applications. I'd like to get
this data tied to our SQL 2005 server. Any suggestions on whether to look at
just linking these in vs importing, etc?Hi,
Are you using the data imported just to query against it from an application
that connects to SQL Server? In that case you can indeed avoid the hassle
of importing by setting up linked servers (see
http://msdn2.microsoft.com/en-us/library/ms190479.aspx). This will allow
you to access your data over connections to the SQL Server using a four part
object name i.e. linkedservername.database.schema.table. You can also use
functions like OPENROWSET and OPENDATASOURCE, but if you access the external
data in various places in your code then I would suggest that you use linked
servers instead.
Jonathan
"Schmeg" <sschmeg@.yahoo.com> wrote in message
news:OE54Ig14HHA.1484@.TK2MSFTNGP06.phx.gbl...
> We have a software package that exports its data in MS Access 97 and 2000
> formats. It overwrites and creates a new Access file each time it exports.
> These exports serve a handful of front end applications. I'd like to get
> this data tied to our SQL 2005 server. Any suggestions on whether to look
> at just linking these in vs importing, etc?
>|||On Aug 20, 11:31 am, "Schmeg" <ssch...@.yahoo.com> wrote:
> We have a software package that exports its data in MS Access 97 and 2000
> formats. It overwrites and creates a new Access file each time it exports.
> These exports serve a handful of front end applications. I'd like to get
> this data tied to our SQL 2005 server. Any suggestions on whether to look at
> just linking these in vs importing, etc?
Why do you export the data to Access? Is it for off line use or just
because? I support multipule Access Projects that connect directly to
MS SQL server and they have thousands of lines of code for working
with the data. This works well and is good for rappid development.
On the other hand if you only want a couple of the tables in the SQL
DB available for the users to work in then link the tables in access.
formats. It overwrites and creates a new Access file each time it exports.
These exports serve a handful of front end applications. I'd like to get
this data tied to our SQL 2005 server. Any suggestions on whether to look at
just linking these in vs importing, etc?Hi,
Are you using the data imported just to query against it from an application
that connects to SQL Server? In that case you can indeed avoid the hassle
of importing by setting up linked servers (see
http://msdn2.microsoft.com/en-us/library/ms190479.aspx). This will allow
you to access your data over connections to the SQL Server using a four part
object name i.e. linkedservername.database.schema.table. You can also use
functions like OPENROWSET and OPENDATASOURCE, but if you access the external
data in various places in your code then I would suggest that you use linked
servers instead.
Jonathan
"Schmeg" <sschmeg@.yahoo.com> wrote in message
news:OE54Ig14HHA.1484@.TK2MSFTNGP06.phx.gbl...
> We have a software package that exports its data in MS Access 97 and 2000
> formats. It overwrites and creates a new Access file each time it exports.
> These exports serve a handful of front end applications. I'd like to get
> this data tied to our SQL 2005 server. Any suggestions on whether to look
> at just linking these in vs importing, etc?
>|||On Aug 20, 11:31 am, "Schmeg" <ssch...@.yahoo.com> wrote:
> We have a software package that exports its data in MS Access 97 and 2000
> formats. It overwrites and creates a new Access file each time it exports.
> These exports serve a handful of front end applications. I'd like to get
> this data tied to our SQL 2005 server. Any suggestions on whether to look at
> just linking these in vs importing, etc?
Why do you export the data to Access? Is it for off line use or just
because? I support multipule Access Projects that connect directly to
MS SQL server and they have thousands of lines of code for working
with the data. This works well and is good for rappid development.
On the other hand if you only want a couple of the tables in the SQL
DB available for the users to work in then link the tables in access.
Monday, March 26, 2012
New Subscriptions never show
If I select "New Subscription" and I select a delivery method and time and
select OK, the screen flashes, but no subscriptions are listed. I have the
user as a Browser and Publisher, but I don't get an error. Is there
something else I have to check or setup?
BartNot sure why you are seeing this. Can you look in the subscription table
and see if subscription rows are being added?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bart" <test@.test.com> wrote in message
news:#Kd6Am$VEHA.3024@.TK2MSFTNGP09.phx.gbl...
> If I select "New Subscription" and I select a delivery method and time and
> select OK, the screen flashes, but no subscriptions are listed. I have the
> user as a Browser and Publisher, but I don't get an error. Is there
> something else I have to check or setup?
> Bart
>|||I got that fixed, but now I can't deliver the subscription.
The Server is 2000 Advanced Server connecting remotely to SQL 2000 on a
Windows 2003 Server.
It looks like an AuthZ problem, but I'm not sure how to resolve it.
Here is the log Info:
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO: Call to
RenderFirst( '/Users Folders/OSCARWEB blynn/My Reports/DVNote Sample' )
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 87;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!b7c!06/22/2004-12:35:49:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32& executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
"Bart" <test@.test.com> wrote in message
news:%23Kd6Am$VEHA.3024@.TK2MSFTNGP09.phx.gbl...
> If I select "New Subscription" and I select a delivery method and time and
> select OK, the screen flashes, but no subscriptions are listed. I have the
> user as a Browser and Publisher, but I don't get an error. Is there
> something else I have to check or setup?
> Bart
>|||Bart, no help for you but this Win32 error 87 is exactly what I'm fighting
since weeks. Could you please doublecheck on the properties page of your
reports with details on: Is there some entry like this:
changed by
<name_of_the_user> [unknown]
For me the "unknown" is the key.
Please refer to news:execmMdVEHA.1472@.TK2MSFTNGP09.phx.gbl I have a thread
with Brian concerning this issue.
r|||It seems that after installing SP1, the problem was resolved. I will
continue testing.
Bart
"Roland" <nomail@.spamprotect.com> wrote in message
news:uPS$4MJWEHA.3236@.tk2msftngp13.phx.gbl...
> Bart, no help for you but this Win32 error 87 is exactly what I'm fighting
> since weeks. Could you please doublecheck on the properties page of your
> reports with details on: Is there some entry like this:
> changed by
> <name_of_the_user> [unknown]
> For me the "unknown" is the key.
> Please refer to news:execmMdVEHA.1472@.TK2MSFTNGP09.phx.gbl I have a thread
> with Brian concerning this issue.
> r
>|||Oh that sounds good. I will install SP1 on my servers tomorrow and let you
know.
r.|||Bart wrote:
> If I select "New Subscription" and I select a delivery method and
> time and select OK, the screen flashes, but no subscriptions are
> listed. I have the user as a Browser and Publisher, but I don't get
> an error. Is there something else I have to check or setup?
> Bart
Arrgggh... After all those dark days w/o SP1 and a running eMail
subscription I'm now facing a strange problem:
* User with role "Browser" is logging in
* User subscribes to a report
* User is able to enter his eMail (RS is configured as described by Daniel
Reib in thread "Stupid question - how to setup the eMail...")
* The subscription process finishes w/o error message
* The subscription action is performed in time and correctly
-- BUT --
the subscription itself is NOT listed, neither under "My Subscriptions" nor
under the subscription pane of the given report for the user with role
"Browser"
-- BUT -- (Again)
if I login as admin I can view and edit the subscription.
I have currently no access to the logs and so no further info, why the
subscription does not appear for the subscriber itself. Nevermind, probably
one of you has an idea?
roland
select OK, the screen flashes, but no subscriptions are listed. I have the
user as a Browser and Publisher, but I don't get an error. Is there
something else I have to check or setup?
BartNot sure why you are seeing this. Can you look in the subscription table
and see if subscription rows are being added?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bart" <test@.test.com> wrote in message
news:#Kd6Am$VEHA.3024@.TK2MSFTNGP09.phx.gbl...
> If I select "New Subscription" and I select a delivery method and time and
> select OK, the screen flashes, but no subscriptions are listed. I have the
> user as a Browser and Publisher, but I don't get an error. Is there
> something else I have to check or setup?
> Bart
>|||I got that fixed, but now I can't deliver the subscription.
The Server is 2000 Advanced Server connecting remotely to SQL 2000 on a
Windows 2003 Server.
It looks like an AuthZ problem, but I'm not sure how to resolve it.
Here is the log Info:
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO: Call to
RenderFirst( '/Users Folders/OSCARWEB blynn/My Reports/DVNote Sample' )
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 87;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!b7c!06/22/2004-12:35:49:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!b7c!06/22/2004-12:35:49:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32& executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
"Bart" <test@.test.com> wrote in message
news:%23Kd6Am$VEHA.3024@.TK2MSFTNGP09.phx.gbl...
> If I select "New Subscription" and I select a delivery method and time and
> select OK, the screen flashes, but no subscriptions are listed. I have the
> user as a Browser and Publisher, but I don't get an error. Is there
> something else I have to check or setup?
> Bart
>|||Bart, no help for you but this Win32 error 87 is exactly what I'm fighting
since weeks. Could you please doublecheck on the properties page of your
reports with details on: Is there some entry like this:
changed by
<name_of_the_user> [unknown]
For me the "unknown" is the key.
Please refer to news:execmMdVEHA.1472@.TK2MSFTNGP09.phx.gbl I have a thread
with Brian concerning this issue.
r|||It seems that after installing SP1, the problem was resolved. I will
continue testing.
Bart
"Roland" <nomail@.spamprotect.com> wrote in message
news:uPS$4MJWEHA.3236@.tk2msftngp13.phx.gbl...
> Bart, no help for you but this Win32 error 87 is exactly what I'm fighting
> since weeks. Could you please doublecheck on the properties page of your
> reports with details on: Is there some entry like this:
> changed by
> <name_of_the_user> [unknown]
> For me the "unknown" is the key.
> Please refer to news:execmMdVEHA.1472@.TK2MSFTNGP09.phx.gbl I have a thread
> with Brian concerning this issue.
> r
>|||Oh that sounds good. I will install SP1 on my servers tomorrow and let you
know.
r.|||Bart wrote:
> If I select "New Subscription" and I select a delivery method and
> time and select OK, the screen flashes, but no subscriptions are
> listed. I have the user as a Browser and Publisher, but I don't get
> an error. Is there something else I have to check or setup?
> Bart
Arrgggh... After all those dark days w/o SP1 and a running eMail
subscription I'm now facing a strange problem:
* User with role "Browser" is logging in
* User subscribes to a report
* User is able to enter his eMail (RS is configured as described by Daniel
Reib in thread "Stupid question - how to setup the eMail...")
* The subscription process finishes w/o error message
* The subscription action is performed in time and correctly
-- BUT --
the subscription itself is NOT listed, neither under "My Subscriptions" nor
under the subscription pane of the given report for the user with role
"Browser"
-- BUT -- (Again)
if I login as admin I can view and edit the subscription.
I have currently no access to the logs and so no further info, why the
subscription does not appear for the subscriber itself. Nevermind, probably
one of you has an idea?
roland
New SQLXMLBulkLoad user--having problems
I am trying, for the first time to load an xml file into SQL Server 2000, and to get me going I am trying to execute the msdn example:-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_6bos.asp
I have configured all the needed set up and keep getting this error:-
Automation error(80040e21)
With no real error info in the error log
The Connection string details are all correct..I have checked that
The error occurs at line:-
objBL.Execute "SampleSchema.xml", "SampleXMLData.xml"
Have you got any ideas…?
Has anyone actually managed to run this example without errors?
Appreciate your help
Thanks
Raj
Hello,
Send me the schema and the data file and I will try a repro.
Regards,
Monica
sqlNew SQLXMLBulkLoad user--having problems
I am trying, for the first time to load an xml file into SQL Server 2000, and to get me going I am trying to execute the msdn example:-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_6bos.asp
I have configured all the needed set up and keep getting this error:-
Automation error(80040e21)
With no real error info in the error log
The Connection string details are all correct..I have checked that
The error occurs at line:-
objBL.Execute "SampleSchema.xml", "SampleXMLData.xml"
Have you got any ideas…?
Has anyone actually managed to run this example without errors?
Appreciate your help
Thanks
Raj
Hello,
Send me the schema and the data file and I will try a repro.
Regards,
Monica
Saturday, February 25, 2012
New features/bug fixes in Sept CTP?
Does anyone know where I can find a list of new features/bug fixes in the Sept CTP? I've been having a hard time tracking down this info. If someone could post it that would be great!
Thanks,
Adrian
Anyone know if this list exists? I'd be keen to see it.
Thanks,
Adrian
Anyone know if this list exists? I'd be keen to see it.
-Jamie|||Can we request someone from SSIS team to post such a list. It will be helpful for all.
thanks,
Nitesh|||It would be very hard to combine a list of all the changes
SSIS team did in 3 months (plus all the changes .NET &
Visual Studio teams did in 5 months).
Mostly the changes are bug fixes, stability and performance
improvements. Very little new features, no new tasks or
transforms for sure 
Michael Entin SSIS wrote:
It would be very hard to combine a list of all the changes
SSIS team did in 3 months (plus all the changes .NET &
Visual Studio teams did in 5 months).Mostly the changes are bug fixes, stability and performance
improvements. Very little new features, no new tasks or
transforms for sure.
Sorry to labour the point Michael
Bug fixing isn't very interesting but I'm interested in performance. What has changed there? Is it pipeline engine perf, runtime engine perf or design tools perf?
-Jamie|||Well, lots of the bugs at this stage are about performance.
I can say about my area - we fixed memory leaks in designer
and project code, so now it should be possible to keep
designer tools open for long time (the memory usage used
to grow over time before).
I know about performance problems fixes in some data flow
component UIs also.|||Bugs found in Sept CTP
I found that I couldn't drag items from the toolbox to the control flow. Had to double click on the items.
The Variables view has a problem displaying itself when associated with an autohide pane.
Loads of exceptions when debugging a custom component, (really annoying)
Devenv crashes when trying to debug a devenv instance with SSIS already loaded into it.
Not much really
oh found a few previously found bugs have been fixed :)|||I'm trying to get the ability to get a list of externally reported bugs that have been fixed in a particular CTP. For what it's worth, I'm told this is on the list of items to provide in the future.
regards,
ash
Subscribe to:
Posts (Atom)