Cant Connect

I have installed SQL 2005 and just done a normal install. I have opened
Server Management Studio and try and connect but I get the error;
...this failure may be caused buy the face that under the default settings
SQL server does not allow remote connections (provider: TCP Provider, error:
0 - No connection could be made because the target machine actively refused
it) (Microsoft SQL Server, error 10061)
Now this error only happens when connecting to the DB engine, it works fine
connecting to analysis services. I have chosen Windows Auth and also
specifying my sql account with the password with is a member of the SQL
groups in the users container but still doesn't work. I am logged in as
Administrator but I get this error.
I have installed SQL before and it worked fine, then it messed up so I
installed SQLExpress now I installed 2005 beta again to play some more and
its done this.
I am using server 2003 SP1
Thanks for your help
ChrisFIXED :D
I just needed to manually create the MSSQL ODBC connector and its fine
learn something new everyday
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co.uk...
>I have installed SQL 2005 and just done a normal install. I have opened
>Server Management Studio and try and connect but I get the error;
> ...this failure may be caused buy the face that under the default settings
> SQL server does not allow remote connections (provider: TCP Provider,
> error: 0 - No connection could be made because the target machine actively
> refused it) (Microsoft SQL Server, error 10061)
> Now this error only happens when connecting to the DB engine, it works
> fine connecting to analysis services. I have chosen Windows Auth and also
> specifying my sql account with the password with is a member of the SQL
> groups in the users container but still doesn't work. I am logged in as
> Administrator but I get this error.
> I have installed SQL before and it worked fine, then it messed up so I
> installed SQLExpress now I installed 2005 beta again to play some more and
> its done this.
> I am using server 2003 SP1
> Thanks for your help
> Chris
>|||Going on from this however, if i wanted a desktop machine to connect, say,
Microsoft Access to my SQL database, do i need to create a MSSQL client
connection in the desktop ODBC?
Thanks
Chris
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:zsjQf.138255$DM.65219@.fe3.news.blueyonder.co.uk...
> FIXED :D
> I just needed to manually create the MSSQL ODBC connector and its fine
> learn something new everyday
> "kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
> news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co.uk...
>|||> Going on from this however, if i wanted a desktop machine to connect,
> say, Microsoft Access to my SQL database, do i need to create a MSSQL
> client connection in the desktop ODBC?
This is one of two possible choices.
The other one is to create an ADP and use OLE DB provider.
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution|||sorry to sound dumb, but could you dumb that down a bit please lol
thanks
chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bbff8c8132b72f2d7d6@.news.virgilio.it...
> This is one of two possible choices.
> The other one is to create an ADP and use OLE DB provider.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>|||> sorry to sound dumb, but could you dumb that down a bit please lol
Sorry for my poor english, but I was not able to welle translate your senten
ce.
May you explain better, please?
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution|||Can you explain what you mean by
"The other one is to create an ADP and use OLE DB provider."
I dont know what it is, also, would it be better to do it your way or my
way?
Thanks
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc088c813301ae47a36@.news.virgilio.it...
> Sorry for my poor english, but I was not able to welle translate your
> sentence. May you explain better, please?
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>|||> 2) ODBC driver
> 2) this method lets you use Access as simply as with any other MDB.
> Indeed, you have to define a system DSN in Windows Data Source, then
> you create an MDB and link tables from the ODBC source you defined.
> Yet, you are not able to exploit stored procedures, views, functions,
> and so on.
I forgot to say that using ODBC driver you cannot see relationships too.
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution|||Ah yes I do remember now, I think I have tried to use these befor.
Thanks for your assistance
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:hr2612lvbhhr1teiojvhb7aba44nb3huoe@.
4ax.com...
> ADP is an Access Data Project - an Access front end that
> uses SQL Server as the backend and doesn't involve Jet or
> mdb files. You can find more information on this in the
> Access help files - look for Access Project topics.
> -Sue
> On Sat, 11 Mar 2006 15:16:14 GMT, "kicken18"
> <chrisflyer@.blueyonder.co.uk> wrote:
>
>|||Thank you for the good help there, I can now go and test this.
Thank you for your time
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc418c813581ba41986@.news.virgilio.it...
> From Access you have two possibilities to use a MS SQL database.
> 1) OLE DB provider
> 2) ODBC driver
> 1) this is the best choice, in conjuntion to an Access Data Project.
> Microsoft created ADPs in order to interface SQL Server databases by
> Access via OLE DB provider and Jet Data Provider. ADPs connect to a SQL
> instance and let you see tables, stored procedures, views, functions, and
> so on.
> 2) this method lets you use Access as simply as with any other MDB.
> Indeed, you have to define a system DSN in Windows Data Source, then you
> create an MDB and link tables from the ODBC source you defined. Yet, you
> are not able to exploit stored procedures, views, functions, and so on.
> I suggest you to use the first method.
> Bye.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>sql

Cant Connect

I have installed SQL 2005 and just done a normal install. I have opened
Server Management Studio and try and connect but I get the error;
...this failure may be caused buy the face that under the default settings
SQL server does not allow remote connections (provider: TCP Provider, error:
0 - No connection could be made because the target machine actively refused
it) (Microsoft SQL Server, error 10061)
Now this error only happens when connecting to the DB engine, it works fine
connecting to analysis services. I have chosen Windows Auth and also
specifying my sql account with the password with is a member of the SQL
groups in the users container but still doesn't work. I am logged in as
Administrator but I get this error.
I have installed SQL before and it worked fine, then it messed up so I
installed SQLExpress now I installed 2005 beta again to play some more and
its done this.
I am using server 2003 SP1
Thanks for your help
Chris
FIXED :D
I just needed to manually create the MSSQL ODBC connector and its fine
learn something new everyday
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co. uk...
>I have installed SQL 2005 and just done a normal install. I have opened
>Server Management Studio and try and connect but I get the error;
> ...this failure may be caused buy the face that under the default settings
> SQL server does not allow remote connections (provider: TCP Provider,
> error: 0 - No connection could be made because the target machine actively
> refused it) (Microsoft SQL Server, error 10061)
> Now this error only happens when connecting to the DB engine, it works
> fine connecting to analysis services. I have chosen Windows Auth and also
> specifying my sql account with the password with is a member of the SQL
> groups in the users container but still doesn't work. I am logged in as
> Administrator but I get this error.
> I have installed SQL before and it worked fine, then it messed up so I
> installed SQLExpress now I installed 2005 beta again to play some more and
> its done this.
> I am using server 2003 SP1
> Thanks for your help
> Chris
>
|||Going on from this however, if i wanted a desktop machine to connect, say,
Microsoft Access to my SQL database, do i need to create a MSSQL client
connection in the desktop ODBC?
Thanks
Chris
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:zsjQf.138255$DM.65219@.fe3.news.blueyonder.co. uk...
> FIXED :D
> I just needed to manually create the MSSQL ODBC connector and its fine
> learn something new everyday
> "kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
> news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co. uk...
>
|||> Going on from this however, if i wanted a desktop machine to connect,
> say, Microsoft Access to my SQL database, do i need to create a MSSQL
> client connection in the desktop ODBC?
This is one of two possible choices.
The other one is to create an ADP and use OLE DB provider.
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
|||sorry to sound dumb, but could you dumb that down a bit please lol
thanks
chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bbff8c8132b72f2d7d6@.news.virgilio.it. ..
> This is one of two possible choices.
> The other one is to create an ADP and use OLE DB provider.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>
|||> sorry to sound dumb, but could you dumb that down a bit please lol
Sorry for my poor english, but I was not able to welle translate your sentence.
May you explain better, please?
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
|||Can you explain what you mean by
"The other one is to create an ADP and use OLE DB provider."
I dont know what it is, also, would it be better to do it your way or my
way?
Thanks
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc088c813301ae47a36@.news.virgilio.it. ..
> Sorry for my poor english, but I was not able to welle translate your
> sentence. May you explain better, please?
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>
|||ADP is an Access Data Project - an Access front end that
uses SQL Server as the backend and doesn't involve Jet or
mdb files. You can find more information on this in the
Access help files - look for Access Project topics.
-Sue
On Sat, 11 Mar 2006 15:16:14 GMT, "kicken18"
<chrisflyer@.blueyonder.co.uk> wrote:

>Can you explain what you mean by
>"The other one is to create an ADP and use OLE DB provider."
>I dont know what it is, also, would it be better to do it your way or my
>way?
>Thanks
>Chris
>"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
>news:875ea355bc088c813301ae47a36@.news.virgilio.it ...
>
|||Ah yes I do remember now, I think I have tried to use these befor.
Thanks for your assistance
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:hr2612lvbhhr1teiojvhb7aba44nb3huoe@.4ax.com...
> ADP is an Access Data Project - an Access front end that
> uses SQL Server as the backend and doesn't involve Jet or
> mdb files. You can find more information on this in the
> Access help files - look for Access Project topics.
> -Sue
> On Sat, 11 Mar 2006 15:16:14 GMT, "kicken18"
> <chrisflyer@.blueyonder.co.uk> wrote:
>
|||Thank you for the good help there, I can now go and test this.
Thank you for your time
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc418c813581ba41986@.news.virgilio.it. ..
> From Access you have two possibilities to use a MS SQL database.
> 1) OLE DB provider
> 2) ODBC driver
> 1) this is the best choice, in conjuntion to an Access Data Project.
> Microsoft created ADPs in order to interface SQL Server databases by
> Access via OLE DB provider and Jet Data Provider. ADPs connect to a SQL
> instance and let you see tables, stored procedures, views, functions, and
> so on.
> 2) this method lets you use Access as simply as with any other MDB.
> Indeed, you have to define a system DSN in Windows Data Source, then you
> create an MDB and link tables from the ODBC source you defined. Yet, you
> are not able to exploit stored procedures, views, functions, and so on.
> I suggest you to use the first method.
> Bye.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>

cant comm with RS

After installing SP1 Report Manager can't communicate with Report Server.
Error says...
Unable to communicate with report server. Please verify that the report
server is operational.
The report server service is running. I rebooted after installing sp1.
Any ideas?
Thanks,
GaryVerify that you can access http://<machinename>/ReportServer. If you can,
make sure this URL is specified in the config file of Report Manager
(RSWebApplication.config).
--
Dmitry Vasilevsky, SQL Server Reporting Services Developer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
---
"Gary D." <Dean@.nospam.com> wrote in message
news:#IQgxtIhEHA.140@.TK2MSFTNGP12.phx.gbl...
> After installing SP1 Report Manager can't communicate with Report Server.
> Error says...
> Unable to communicate with report server. Please verify that the report
> server is operational.
> The report server service is running. I rebooted after installing sp1.
> Any ideas?
> Thanks,
> Gary
>

Can't CHECKDB model

Hello,
When i run DBCC CHECKDB on model, DBBC never end. I try to
backup Model database and the following error appear.
"BAckup, CHECKALLOC, bulk copy, select into, and file
manipulation(such as create file) operations on a database
must be serialized. Reissue the statement after the
current backup, CHECKALLOC or file manipulation is
completed. Backup or Restore operation terminating
abnormally"
I dont know what am i supose to do :\
Best regardsIs the model db backing up right now? Have you backed it up recently?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:ebab01c43cf6$af264a00$a301280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards|||The error message says it all. There are some operations that cannot be perf
ormed simultaneously for a
database. Make sure you schedule your jobs properly.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:ebab01c43cf6$af264a00$a3
01280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards

Can't CHECKDB model

Hello,
When i run DBCC CHECKDB on model, DBBC never end. I try to
backup Model database and the following error appear.
"BAckup, CHECKALLOC, bulk copy, select into, and file
manipulation(such as create file) operations on a database
must be serialized. Reissue the statement after the
current backup, CHECKALLOC or file manipulation is
completed. Backup or Restore operation terminating
abnormally"
I dont know what am i supose to do :\
Best regards
Is the model db backing up right now? Have you backed it up recently?
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:ebab01c43cf6$af264a00$a301280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards
|||The error message says it all. There are some operations that cannot be performed simultaneously for a
database. Make sure you schedule your jobs properly.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:ebab01c43cf6$af264a00$a301280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards
sql

Can't CHECKDB model

Hello,
When i run DBCC CHECKDB on model, DBBC never end. I try to
backup Model database and the following error appear.
"BAckup, CHECKALLOC, bulk copy, select into, and file
manipulation(such as create file) operations on a database
must be serialized. Reissue the statement after the
current backup, CHECKALLOC or file manipulation is
completed. Backup or Restore operation terminating
abnormally"
I dont know what am i supose to do :\
Best regardsIs the model db backing up right now? Have you backed it up recently?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:ebab01c43cf6$af264a00$a301280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards|||The error message says it all. There are some operations that cannot be performed simultaneously for a
database. Make sure you schedule your jobs properly.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:ebab01c43cf6$af264a00$a301280a@.phx.gbl...
> Hello,
> When i run DBCC CHECKDB on model, DBBC never end. I try to
> backup Model database and the following error appear.
> "BAckup, CHECKALLOC, bulk copy, select into, and file
> manipulation(such as create file) operations on a database
> must be serialized. Reissue the statement after the
> current backup, CHECKALLOC or file manipulation is
> completed. Backup or Restore operation terminating
> abnormally"
> I dont know what am i supose to do :\
> Best regards

can't call method CreateReport under asp.net

CreateReport throws an error saying that user IUSR_XXXXX doesn't have
permisssions
to run this method.
So,
1) I went to ReportServices roles and anded a new group for IUSR_XXXXX user
2) Assigned ReportserverSysadmin role for the new group.
3) Also set db_owner permissions for the IUSR_XXXXX user in ReportService
related databases on
my local instance of MS SQL.
No results. Still can't call method CreateReport().
Any ideas ?
Thanks
Paul
PS. BTW this method works fine from *.rss script that is running under
local Admin account.You need to give this user permission in the specific folder that they are
trying to create the report in. The SysAdmin role is just for system level
operations, not item specific operations.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"pTsy" <ptsygura@.bna.com> wrote in message
news:e79HvvadEHA.3944@.tk2msftngp13.phx.gbl...
> CreateReport throws an error saying that user IUSR_XXXXX doesn't have
> permisssions
> to run this method.
> So,
> 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX
user
> 2) Assigned ReportserverSysadmin role for the new group.
> 3) Also set db_owner permissions for the IUSR_XXXXX user in
ReportService
> related databases on
> my local instance of MS SQL.
> No results. Still can't call method CreateReport().
> Any ideas ?
> Thanks
> Paul
> PS. BTW this method works fine from *.rss script that is running under
> local Admin account.
>
>|||Also, try enabling impersonation for your ASP.NET app. See:
http://blogs.msdn.com/bryanke/archive/2004/03/03/83345.aspx
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"pTsy" <ptsygura@.bna.com> wrote in message
news:e79HvvadEHA.3944@.tk2msftngp13.phx.gbl...
> CreateReport throws an error saying that user IUSR_XXXXX doesn't have
> permisssions
> to run this method.
> So,
> 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX
user
> 2) Assigned ReportserverSysadmin role for the new group.
> 3) Also set db_owner permissions for the IUSR_XXXXX user in
ReportService
> related databases on
> my local instance of MS SQL.
> No results. Still can't call method CreateReport().
> Any ideas ?
> Thanks
> Paul
> PS. BTW this method works fine from *.rss script that is running under
> local Admin account.
>
>|||Hi Daniel
Thanks for answering
But how to do it through report server UI ?
or should I use some API function call ?
Thanks
Paul
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:ugZW9KcdEHA.3792@.TK2MSFTNGP09.phx.gbl...
> You need to give this user permission in the specific folder that they are
> trying to create the report in. The SysAdmin role is just for system
level
> operations, not item specific operations.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "pTsy" <ptsygura@.bna.com> wrote in message
> news:e79HvvadEHA.3944@.tk2msftngp13.phx.gbl...
> > CreateReport throws an error saying that user IUSR_XXXXX doesn't have
> > permisssions
> > to run this method.
> >
> > So,
> > 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX
> user
> > 2) Assigned ReportserverSysadmin role for the new group.
> > 3) Also set db_owner permissions for the IUSR_XXXXX user in
> ReportService
> > related databases on
> > my local instance of MS SQL.
> >
> > No results. Still can't call method CreateReport().
> > Any ideas ?
> > Thanks
> > Paul
> >
> > PS. BTW this method works fine from *.rss script that is running under
> > local Admin account.
> >
> >
> >
> >
>|||Go to report manager as a local admin, click on the property tab, click on
the security sub-tab and there you can set permissions. You can do this
for any item in the catalog.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"pTsy" <ptsygura@.bna.com> wrote in message
news:uW47l1veEHA.1724@.TK2MSFTNGP10.phx.gbl...
> Hi Daniel
> Thanks for answering
> But how to do it through report server UI ?
> or should I use some API function call ?
> Thanks
> Paul
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:ugZW9KcdEHA.3792@.TK2MSFTNGP09.phx.gbl...
> > You need to give this user permission in the specific folder that they
are
> > trying to create the report in. The SysAdmin role is just for system
> level
> > operations, not item specific operations.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "pTsy" <ptsygura@.bna.com> wrote in message
> > news:e79HvvadEHA.3944@.tk2msftngp13.phx.gbl...
> > > CreateReport throws an error saying that user IUSR_XXXXX doesn't have
> > > permisssions
> > > to run this method.
> > >
> > > So,
> > > 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX
> > user
> > > 2) Assigned ReportserverSysadmin role for the new group.
> > > 3) Also set db_owner permissions for the IUSR_XXXXX user in
> > ReportService
> > > related databases on
> > > my local instance of MS SQL.
> > >
> > > No results. Still can't call method CreateReport().
> > > Any ideas ?
> > > Thanks
> > > Paul
> > >
> > > PS. BTW this method works fine from *.rss script that is running
under
> > > local Admin account.
> > >
> > >
> > >
> > >
> >
> >
>

can't backup - urgent

Hi,
When I do the backup and click on the add button, an error come
out:
Microsoft SQL-DMO (ODBC SQLSTATE: 42000)
Error 0: Cannot load the DLL xpstar.dll , or one of the DLLs it references.
Reason:998 (invalid access to memory location)
Please help. I cannot do the backup now. Thanks.
Allen,
Have you tried running the backup from Query Analyzer instead of Enterprise
Manager, using the BACKUP DATABASE syntax? I don't know what that error
means, but don't let the UI's failure to respond stop you...
""Allen Iverson"" <no_spam@.bk.com> wrote in message
news:eGZiOvbqEHA.2856@.TK2MSFTNGP10.phx.gbl...
> Hi,
> When I do the backup and click on the add button, an error come
> out:
> Microsoft SQL-DMO (ODBC SQLSTATE: 42000)
> Error 0: Cannot load the DLL xpstar.dll , or one of the DLLs it
references.
> Reason:998 (invalid access to memory location)
>
> Please help. I cannot do the backup now. Thanks.
>
|||Hi,
Should be MDAC issue. But as an immediate solution execute the backup
database command from query analyzer for backup.
Backup database <dbname> to disk='c:\backup\dbname.bak' with init,stats=10
After the backup, First update the SQL server by SP3a (latest service pack)
and try backup from Enterprise manager.
If you still have issues try updating latest MDAC
Thanks
Hari
MCDBA
""Allen Iverson"" <no_spam@.bk.com> wrote in message
news:eGZiOvbqEHA.2856@.TK2MSFTNGP10.phx.gbl...
> Hi,
> When I do the backup and click on the add button, an error come
> out:
> Microsoft SQL-DMO (ODBC SQLSTATE: 42000)
> Error 0: Cannot load the DLL xpstar.dll , or one of the DLLs it
> references. Reason:998 (invalid access to memory location)
>
> Please help. I cannot do the backup now. Thanks.
>
|||Hari and Adam,
This SQL server has already been applied SP3a long time ago.
Last week we got no problem to do the daily backup. But it suddenly happened
this morning. Any clue. I will try the query analyzer now. Thanks.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OfRez2bqEHA.1272@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Should be MDAC issue. But as an immediate solution execute the backup
> database command from query analyzer for backup.
> Backup database <dbname> to disk='c:\backup\dbname.bak' with init,stats=10
> After the backup, First update the SQL server by SP3a (latest service
> pack) and try backup from Enterprise manager.
> If you still have issues try updating latest MDAC
> Thanks
> Hari
> MCDBA
>
>
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:eGZiOvbqEHA.2856@.TK2MSFTNGP10.phx.gbl...
>
|||> This SQL server has already been applied SP3a long time ago.
So some other program with an improper install program or version DLL checking might mess thing up
for the SQL Server. This is why Hari suggested to *reinstall* sp 3, so it might sort things out for
you.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:OhY6AGcqEHA.3592@.TK2MSFTNGP14.phx.gbl...
> Hari and Adam,
> This SQL server has already been applied SP3a long time ago. Last week we got no
> problem to do the daily backup. But it suddenly happened this morning. Any clue. I will try the
> query analyzer now. Thanks.
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:OfRez2bqEHA.1272@.TK2MSFTNGP09.phx.gbl...
>
|||I see. Will this re-apply cause any impact or conflict? Do I need to reboot
the server after? THanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OBI6zYdqEHA.3172@.TK2MSFTNGP10.phx.gbl...
> So some other program with an improper install program or version DLL
> checking might mess thing up for the SQL Server. This is why Hari
> suggested to *reinstall* sp 3, so it might sort things out for you.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:OhY6AGcqEHA.3592@.TK2MSFTNGP14.phx.gbl...
>

can't backup - urgent

Hi,
When I do the backup and click on the add button, an error come
out:
Microsoft SQL-DMO (ODBC SQLSTATE: 42000)
Error 0: Cannot load the DLL xpstar.dll , or one of the DLLs it references.
Reason:998 (invalid access to memory location)
Please help. I cannot do the backup now. Thanks.Allen,
Have you tried running the backup from Query Analyzer instead of Enterprise
Manager, using the BACKUP DATABASE syntax? I don't know what that error
means, but don't let the UI's failure to respond stop you...
""Allen Iverson"" <no_spam@.bk.com> wrote in message
news:eGZiOvbqEHA.2856@.TK2MSFTNGP10.phx.gbl...
> Hi,
> When I do the backup and click on the add button, an error come
> out:
> Microsoft SQL-DMO (ODBC SQLSTATE: 42000)
> Error 0: Cannot load the DLL xpstar.dll , or one of the DLLs it
references.
> Reason:998 (invalid access to memory location)
>
> Please help. I cannot do the backup now. Thanks.
>|||Hi,
Should be MDAC issue. But as an immediate solution execute the backup
database command from query analyzer for backup.
Backup database <dbname> to disk='c:\backup\dbname.bak' with init,stats=10
After the backup, First update the SQL server by SP3a (latest service pack)
and try backup from Enterprise manager.
If you still have issues try updating latest MDAC
Thanks
Hari
MCDBA
""Allen Iverson"" <no_spam@.bk.com> wrote in message
news:eGZiOvbqEHA.2856@.TK2MSFTNGP10.phx.gbl...
> Hi,
> When I do the backup and click on the add button, an error come
> out:
> Microsoft SQL-DMO (ODBC SQLSTATE: 42000)
> Error 0: Cannot load the DLL xpstar.dll , or one of the DLLs it
> references. Reason:998 (invalid access to memory location)
>
> Please help. I cannot do the backup now. Thanks.
>|||Hari and Adam,
This SQL server has already been applied SP3a long time ago.
Last week we got no problem to do the daily backup. But it suddenly happened
this morning. Any clue. I will try the query analyzer now. Thanks.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OfRez2bqEHA.1272@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Should be MDAC issue. But as an immediate solution execute the backup
> database command from query analyzer for backup.
> Backup database <dbname> to disk='c:\backup\dbname.bak' with init,stats=10
> After the backup, First update the SQL server by SP3a (latest service
> pack) and try backup from Enterprise manager.
> If you still have issues try updating latest MDAC
> Thanks
> Hari
> MCDBA
>
>
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:eGZiOvbqEHA.2856@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> When I do the backup and click on the add button, an error come
>> out:
>> Microsoft SQL-DMO (ODBC SQLSTATE: 42000)
>> Error 0: Cannot load the DLL xpstar.dll , or one of the DLLs it
>> references. Reason:998 (invalid access to memory location)
>>
>> Please help. I cannot do the backup now. Thanks.
>|||> This SQL server has already been applied SP3a long time ago.
So some other program with an improper install program or version DLL checking might mess thing up
for the SQL Server. This is why Hari suggested to *reinstall* sp 3, so it might sort things out for
you.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
""Allen Iverson"" <no_spam@.bk.com> wrote in message news:OhY6AGcqEHA.3592@.TK2MSFTNGP14.phx.gbl...
> Hari and Adam,
> This SQL server has already been applied SP3a long time ago. Last week we got no
> problem to do the daily backup. But it suddenly happened this morning. Any clue. I will try the
> query analyzer now. Thanks.
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:OfRez2bqEHA.1272@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> Should be MDAC issue. But as an immediate solution execute the backup database command from
>> query analyzer for backup.
>> Backup database <dbname> to disk='c:\backup\dbname.bak' with init,stats=10
>> After the backup, First update the SQL server by SP3a (latest service pack) and try backup from
>> Enterprise manager.
>> If you still have issues try updating latest MDAC
>> Thanks
>> Hari
>> MCDBA
>>
>>
>> ""Allen Iverson"" <no_spam@.bk.com> wrote in message news:eGZiOvbqEHA.2856@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> When I do the backup and click on the add button, an error come out:
>> Microsoft SQL-DMO (ODBC SQLSTATE: 42000)
>> Error 0: Cannot load the DLL xpstar.dll , or one of the DLLs it references. Reason:998 (invalid
>> access to memory location)
>>
>> Please help. I cannot do the backup now. Thanks.
>>
>|||I see. Will this re-apply cause any impact or conflict? Do I need to reboot
the server after? THanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OBI6zYdqEHA.3172@.TK2MSFTNGP10.phx.gbl...
>> This SQL server has already been applied SP3a long time ago.
> So some other program with an improper install program or version DLL
> checking might mess thing up for the SQL Server. This is why Hari
> suggested to *reinstall* sp 3, so it might sort things out for you.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
> news:OhY6AGcqEHA.3592@.TK2MSFTNGP14.phx.gbl...
>> Hari and Adam,
>> This SQL server has already been applied SP3a long time ago.
>> Last week we got no problem to do the daily backup. But it suddenly
>> happened this morning. Any clue. I will try the query analyzer now.
>> Thanks.
>>
>> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
>> news:OfRez2bqEHA.1272@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> Should be MDAC issue. But as an immediate solution execute the backup
>> database command from query analyzer for backup.
>> Backup database <dbname> to disk='c:\backup\dbname.bak' with
>> init,stats=10
>> After the backup, First update the SQL server by SP3a (latest service
>> pack) and try backup from Enterprise manager.
>> If you still have issues try updating latest MDAC
>> Thanks
>> Hari
>> MCDBA
>>
>>
>> ""Allen Iverson"" <no_spam@.bk.com> wrote in message
>> news:eGZiOvbqEHA.2856@.TK2MSFTNGP10.phx.gbl...
>> Hi,
>> When I do the backup and click on the add button, an error
>> come out:
>> Microsoft SQL-DMO (ODBC SQLSTATE: 42000)
>> Error 0: Cannot load the DLL xpstar.dll , or one of the DLLs it
>> references. Reason:998 (invalid access to memory location)
>>
>> Please help. I cannot do the backup now. Thanks.
>>
>>
>sql

Can't attach database

HI all, I'm trying to move a mdf from a dev machine onto a production server and when I try to re-attach I keep getting the following error " ...the mdf file is not a primary database file" ...and it won't attach.

It's SS2005, does anyone know why this error occurs.

Thanks

How did you detach the original database?|||

Thanks for the prompt Euan, I just found out the database wasn't detached properly, they just burned it onto a CD directly!..hopefully the correctly detached one will be OK.

Can't attach database

HI all, I'm trying to move a mdf from a dev machine onto a production server and when I try to re-attach I keep getting the following error " ...the mdf file is not a primary database file" ...and it won't attach.

It's SS2005, does anyone know why this error occurs.

Thanks

How did you detach the original database?|||

Thanks for the prompt Euan, I just found out the database wasn't detached properly, they just burned it onto a CD directly!..hopefully the correctly detached one will be OK.

Can't attach 2005 DB on Vista - Erland? Anyone? Help me please!

Dear Group

I've installed MSSQL 2005 STD on Vista and now can't attach my
databases.
I've installed SQL SP2 and the SQL Vista Beta Update.
The error I'm getting is:

Unable to open the physical file <Path to MDF>. Operating system error
5: '''5(Error not found)'''. (Microsoft SQL Server, Error: 5120)

Thanks for your help. All your hints are very much appreciated.

Thanks,

Martin N Feuersteiner
Invent2b GroupOn 1 Mar, 14:19, theintrepid...@.hotmail.com wrote:

Quote:

Originally Posted by

Dear Group
>
I've installed MSSQL 2005 STD on Vista and now can't attach my
databases.
I've installed SQL SP2 and the SQL Vista Beta Update.
The error I'm getting is:
>
Unable to open the physical file <Path to MDF>. Operating system error
5: '''5(Error not found)'''. (Microsoft SQL Server, Error: 5120)

Found the Solution on Vista:

- Go to Control Panel and Switch to Classic View
- Click on User Accounts
- Click on Turn User Account Control on or off
- Uncheck use User Account Control (UAC) to help protect your
computer.
- OK
- Restart System

Try again to attach the DB. It should work now.

Hope this helps anyone else having this problem.

Martin
Invent2b Group|||(theintrepidfox@.hotmail.com) writes:

Quote:

Originally Posted by

Found the Solution on Vista:
>
- Go to Control Panel and Switch to Classic View
- Click on User Accounts
- Click on Turn User Account Control on or off
- Uncheck use User Account Control (UAC) to help protect your
computer.
- OK
- Restart System
>
Try again to attach the DB. It should work now.
>
Hope this helps anyone else having this problem.

Maybe a bit heavy-duty. The point with UAC in Vista as I understand it,
is that you should not run as Administrator all the time, only when you
need it. While running as Administrator is convenient, it makes it
easier for any infections your machines may catch to spread. I think
there is a context-menu option "Run As Administrator".

Personally, I have not had any encounter with Vista yet.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On 1 Mar, 22:13, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

(theintrepid...@.hotmail.com) writes:

Quote:

Originally Posted by

Found the Solution on Vista:

>

Quote:

Originally Posted by

- Go to Control Panel and Switch to Classic View
- Click on User Accounts
- Click on Turn User Account Control on or off
- Uncheck use User Account Control (UAC) to help protect your
computer.
- OK
- Restart System

>

Quote:

Originally Posted by

Try again to attach the DB. It should work now.

>

Quote:

Originally Posted by

Hope this helps anyone else having this problem.

>
Maybe a bit heavy-duty. The point with UAC in Vista as I understand it,
is that you should not run as Administrator all the time, only when you
need it. While running as Administrator is convenient, it makes it
easier for any infections your machines may catch to spread. I think
there is a context-menu option "Run As Administrator".
>
Personally, I have not had any encounter with Vista yet.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Hi Erland

Correct. It's heavy duty and my first attempt was to right-click on
the Management Studio Icon and to choose the 'Run As Administrator'
option which didn't work.
UAC is indeed a good feature and helps to protect. But following this
process didn't solve the problem and there was no other choice than
having to turn off UAC.
I haven't tried turning UAC on since I attached the databases to see
what its effect is.

To put it short, UAC is good but not in a development environemnt.
Despite having turned it off VS 2005 still warns me that it may not
work correctly, needing Admin rights but it starts fine without any
errors so far. And anyway, what's the REAL risk of having it turned
off. A Vista machine with UAC off won't become less protected than a
XP machine used to be and any additional security software and common
user sense will help protect the same way. I reckon it's rather good
for my dad who clicks on and executes everything he's prompted with.
Bless him and his viruses.

If anyone has a better suggestion to this workaround which will work
with UAC on, please post it here.

All the best,

Martin
Invent2b Group|||(theintrepidfox@.hotmail.com) writes:

Quote:

Originally Posted by

Correct. It's heavy duty and my first attempt was to right-click on
the Management Studio Icon and to choose the 'Run As Administrator'
option which didn't work.
UAC is indeed a good feature and helps to protect. But following this
process didn't solve the problem and there was no other choice than
having to turn off UAC.
I haven't tried turning UAC on since I attached the databases to see
what its effect is.

Having today having had my first encounter with Vista, and I agree that it
is very irritating. (Then again, there seems to be a whole lot of
irritating fluff in Vista. I want to computer to run SQL Server on, I
don't want this "My Music" etc.)

No, I never came as far installing SQL Server. About every second time
I reboot, the machine powers off while Vista is starting. I will probably
change to a different motherboard.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I agree UAC can be annoying on a development box but I've been running Vista
with UAC and haven't had to resort to turning it off. I need to run VS as
administrator. It's optional with SSMS depending on the features I use
(e.g. stop/start services requires admin).

--
Hope this helps.

Dan Guzman
SQL Server MVP

<theintrepidfox@.hotmail.comwrote in message
news:1173031039.763449.115250@.n33g2000cwc.googlegr oups.com...

Quote:

Originally Posted by

On 1 Mar, 22:13, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

> (theintrepid...@.hotmail.com) writes:

Quote:

Originally Posted by

Found the Solution on Vista:

>>

Quote:

Originally Posted by

- Go to Control Panel and Switch to Classic View
- Click on User Accounts
- Click on Turn User Account Control on or off
- Uncheck use User Account Control (UAC) to help protect your
computer.
- OK
- Restart System

>>

Quote:

Originally Posted by

Try again to attach the DB. It should work now.

>>

Quote:

Originally Posted by

Hope this helps anyone else having this problem.

>>
>Maybe a bit heavy-duty. The point with UAC in Vista as I understand it,
>is that you should not run as Administrator all the time, only when you
>need it. While running as Administrator is convenient, it makes it
>easier for any infections your machines may catch to spread. I think
>there is a context-menu option "Run As Administrator".
>>
>Personally, I have not had any encounter with Vista yet.
>>
>--
>Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>>
>Books Online for SQL Server 2005
>athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
>Books Online for SQL Server 2000
>athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

>
Hi Erland
>
Correct. It's heavy duty and my first attempt was to right-click on
the Management Studio Icon and to choose the 'Run As Administrator'
option which didn't work.
UAC is indeed a good feature and helps to protect. But following this
process didn't solve the problem and there was no other choice than
having to turn off UAC.
I haven't tried turning UAC on since I attached the databases to see
what its effect is.
>
To put it short, UAC is good but not in a development environemnt.
Despite having turned it off VS 2005 still warns me that it may not
work correctly, needing Admin rights but it starts fine without any
errors so far. And anyway, what's the REAL risk of having it turned
off. A Vista machine with UAC off won't become less protected than a
XP machine used to be and any additional security software and common
user sense will help protect the same way. I reckon it's rather good
for my dad who clicks on and executes everything he's prompted with.
Bless him and his viruses.
>
If anyone has a better suggestion to this workaround which will work
with UAC on, please post it here.
>
All the best,
>
Martin
Invent2b Group
>

|||>

Quote:

Originally Posted by

No, I never came as far installing SQL Server. About every second time
I reboot, the machine powers off while Vista is starting. I will probably
change to a different motherboard.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>

How does Vista behave if you install it on a non Vista PC under
Virtual PC 2007?
It does reboot during setup start-up without warning and a blank
screen but else it's much more stable and fine. Just setting up SBS
and some client PCs under Virtual Server on it.
I had that rebooting thing during startup and freezing with three PCs
(non Vista) until it turned out to be a really nasty virus despite
running all sorts of virus checks.
The solution was to actually take the drive out, and stick it as a
slave in another PC with up-to date Free AVG running which actually
detected that bugger.

The only thing that still bugs me with Vista is, and I think it's a
Vista issue, I doesn't list the databases on the SQL Server when
trying to connect (connecting is fine) to an existing instance from
Outlook Business Contact Manager. Checked all the SQL security,
logins, protocols. Any idea?

can't alter function

In sqlserver 2000 I have a UDF which works fine but I want to make a
change to it. When I do an ALTER FUNCTION ... I get an error saying
that I can't alter the function because it is referenced by an object.
Is there any way around this? I reference the UDF in over 100 tables,
do I have to go to each table, remove the all references alter the
function then edit each 100 tables again? How clumsy can it be?

BarryBarry wrote:

Quote:

Originally Posted by

In sqlserver 2000 I have a UDF which works fine but I want to make a
change to it. When I do an ALTER FUNCTION ... I get an error saying
that I can't alter the function because it is referenced by an object.
Is there any way around this? I reference the UDF in over 100 tables,
do I have to go to each table, remove the all references alter the
function then edit each 100 tables again? How clumsy can it be?

Yep, that's it. You can generate a script for the drop/recreate of the
objects that reference the function, using the information from the
system tables. What kind of objects are we talking about
(defaults/check constraints/computed columns) ?

Razvan|||Defaults.

What would a script to look like to do this?

In Oracle I would ALTER TABLE XXX
Modify ( Column default null)

then write a script to fill in XXX from owner_tab_columns where column
exists

Thanks
Barry

Razvan Socol wrote:

Quote:

Originally Posted by

Barry wrote:

Quote:

Originally Posted by

In sqlserver 2000 I have a UDF which works fine but I want to make a
change to it. When I do an ALTER FUNCTION ... I get an error saying
that I can't alter the function because it is referenced by an object.
Is there any way around this? I reference the UDF in over 100 tables,
do I have to go to each table, remove the all references alter the
function then edit each 100 tables again? How clumsy can it be?

>
Yep, that's it. You can generate a script for the drop/recreate of the
objects that reference the function, using the information from the
system tables. What kind of objects are we talking about
(defaults/check constraints/computed columns) ?
>
Razvan

|||How does one reference a UDF in a table?

Jim|||I'm assigning it as a default The return from the function is my
default. I use it for User_id's

jim_geiss...@.countrywide.com wrote:

Quote:

Originally Posted by

How does one reference a UDF in a table?
>
Jim

|||Barry (bgt0990@.optonline.net) writes:

Quote:

Originally Posted by

What would a script to look like to do this?
>
In Oracle I would ALTER TABLE XXX
Modify ( Column default null)
>
then write a script to fill in XXX from owner_tab_columns where column
exists

ALTER TABLE tbl DROP CONSTRAINT <nameofconstraint>

Here is a query that will generate all necessary DROP commands:

SELECT 'ALTER TABLE ' + o.name + ' ALTER COLUMN ' + c.name +
' DROP CONSTRAINT ' + oc.name
FROM sysdepends d
JOIN sysobjects ofn ON d.depid = ofn.id
JOIN sysobjects oc ON d.id = oc.id
JOIN sysobjects o ON o.id = oc.parent_obj
JOIN syscolumns c ON o.id = c.id
AND c.cdefault = oc.id
WHERE ofn.name = '<yourfunction>'

You can also modify it to regenerate the command to restore the default.
Run that modified query, before you execute the result of the above. :-)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hi, Barry

Here is how you can generate a script to drop/recreate the defaults
that depend on a given function:

SELECT 'ALTER TABLE '+QUOTENAME(OBJECT_NAME(parent_obj))
+' DROP CONSTRAINT '+QUOTENAME(name)
FROM sysobjects WHERE xtype='D' AND id IN (
SELECT id FROM sysdepends
WHERE depid=OBJECT_ID('YourFunction')
)

SELECT 'ALTER TABLE '+QUOTENAME(OBJECT_NAME(parent_obj))
+' ADD CONSTRAINT '+QUOTENAME(o.name)
+' DEFAULT '+x.text
+' FOR '+QUOTENAME(c.name)
FROM sysobjects o INNER JOIN syscomments x ON o.id=x.id
INNER JOIN syscolumns c ON c.cdefault=o.id
WHERE o.xtype='D' AND o.id IN (
SELECT id FROM sysdepends
WHERE depid=OBJECT_ID('YourFunction')
)

There is a limitation regarding the size of the definition of the
default (x.text in the above query): if it's more than 4000 characters,
the above query won't work (because there would be multiple rows in
syscomments for the same id); but I'm sure nobody would create a
default with a definition longer than 100 characters to invoke a UDF,
so that should not be a problem.

Razvan

Cant allocate space

Novice MS SQL User

Dell PowerEdge 2300
NT 4 server SP4
MS SQL Server 6.5

i'm trying to upload 250,000 records

Error : 1105, Severity: 17, State: 2
Can't allocate space for object 'Syslogs' in database 'clearance_data' because the 'logsegment' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.

what i'm planning to do is to add a new hard drive to the server, but HOW?

please help

see attached files (jpeg zip) for
Disk Administration
SQL Server
Devices
Databases
Available space

Thanks in advance(Couldn't read your attached files), but:

You might consider trying some of the following:

Temporarily set the DB 'clearance_data' to truncate on checkpoint until you have loaded your data.

Add or increase the size of the existing transaction log for DB 'clearance_data'.

I assume you are loading 250,000 records into the the DB 'clearance_data'? (If so, try loading fewer records at any one time e.g., load 10 25,000 record data subsets, instead of all 250,000 at once.)

To clear the error 'logsegment' segment is full try: Dump Log 'clearance_data' with Truncate_Only

Finally, RE: " ...add a new hard drive to the server, but HOW?"
What kind of (hardware?) issues are you having with the new hard drive?|||Thanks for the quick response

Finally, RE: " ...add a new hard drive to the server, but HOW?"
What kind of (hardware?) issues are you having with the new hard drive?

please download again the attached file, I used WinZip 8.0

NT Server Setup

4338MB DISK 0 C: - 1083MB Mirror Set E: - 3240 Stripe Set
4338MB DISK 1 C: - 1083MB Mirror Set E: - 3240 Stripe set
4299MB DISK 2 F: - 4299MB Primary Partition

SQL Server Setup
Database devices Data Size Available
clearance_device 5500MB 1290MB
DATA2
master
MSDBData
MSDBLog
Databases
clearance_data
master
model
msdb
pubs
tempdb

if I add, lets say 18GB HD
this will become

18GB DISK 3

can I still add/expand the clearance_device to 18GB more
is this doable?

Thanks again in adavce|||Q1 please download again the attached file, I used WinZip 8.0
Q2 can I still add/expand the clearance_device to 18GB more
is this doable?
A1 This time the error (with the image zip) was "images.zip: Either multipart or corrupt ZIP archive."

A2 You may not actually be able to use 100% of the new volume's free space, (even implementing raw partion devices), but generally, yes.

Note: It appears likely that you have separate devices for both DB Log and DB Data (if so, a good thing). In your particular situation, (if you must perform a single large operation in one step); you must provide the DB LOG sufficient space to complete the operation. Obviously, there must also be sufficient room for the actual DB data itself, as well; so it is possible you may also need to provide additional free data device space to successfully complete your load operation. The reason for mentioning this (in this manner) is that Sql Server 6.x allowed the co-mingling of Log / Data on the same device (generally not a desirable configuration, for a number of reasons).|||I tried downloading the file... yes it was corrupted
I'll try to attached it again
. +------+
4338MB DISK 0 C: - 1083MB Mirror Set | E: - 3240 Stripe Set
4338MB DISK 1 C: - 1083MB Mirror Set | E: - 3240 Stripe Set
. +------+

on those stripe set resides the clearance_data

A2 You may not actually be able to use 100% of the new volume's free space, (even implementing raw partion devices), but generally, yes.

assuming I have installed a new device

how can I configure MS SQL 6.5 to use the new device for clearance_data for expansion

Thanks again

please try to download the new attached file|||RE: Q1 Assuming I have installed a new device, how can I configure MS SQL 6.5 to use the new device for clearance_data for expansion?
Q2 Please try to download the new attached file.

A1 I'm not sure exactly what you are asking (I had assumed hardware mirroring, are you using Sql Server DB mirroring? If so I believe you must break the mirror before altering the DB, then remirror subsequently if possible.). If not, as I recall, you may do everything necessary from Sql EM once the new drive volume is available (visible) to the OS (unless maybe, you have done some intersting things with segments). You could use tsql in isqlw as well, for example: (not tested)

/* Find out the maximum VDevNo (XX): Then XXX = XX + 1 (where XX is the first digit of low byte column data) */

Use Master
Go

exec sp_HelpDevice
Go
Select * From SysDevices
Go

/* G: = 18GB DISK 3*/
/* The following tsql would use half of G for Log and half G for Data: */

Disk INIT
Name = 'Clearance_Data_DataDevG_001',
PhysName = 'G:\MsSql\Data\Clearance_Data_DataDevG001.dat'
VDevNo = XXX,
Size = 4608000 /* 4608000 x 2KB = 9GB */
Go

Disk INIT
Name = 'Clearance_Data_LogDevG_001',
PhysName = 'G:\MsSql\Data\Clearance_Data_LogDevG001.log'
VDevNo = XXX,
Size = 4608000 /* 4608000 x 2KB = 9GB */
Go

/* The following tsql should then Alter the clearance_data DB to use about half of each of the log and data device files created on G. : */

Alter DataBase clearance_data
On Clearance_Data_DataDevG_001 = 4500,
Log On Clearance_Data_LogDevG_001 = 4500
Go

/* - NOTE - */
/* If the above statement fails, then the Log On clause may not be valid to use with Alter Table. In that case, use the following tsql which should work: */

Alter DataBase clearance_data
On Clearance_Data_DataDevG_001 = 4500,
Clearance_Data_LogDevG_001 = 4500
Exec sp_LogDevice 'clearance_data', 'Clearance_Data_LogDevG_001'
Go

A2 The latest file has a zero byte size (downloaded).

can't add a new measure after the column is added in the DSV ?!?!

Just found one more nice error in SSAS :-)

If i add a column in my facttable, refresh the DSV and drag the new meassure into my meassuregroup i get an error when processing.

"Errors in the high-level relational engine. The data source view does not contain a definition for the 'MEA_BeregnetErhverv' column in the 'dbo_Fakt_Measures' table or view."

Well this is nice, since i just dragged it from that view :-)

Anyone got a workaround for this, except building the DSV and Cube structure from scrap each time ?

I've tried this exact scenario using Adventure Works sample database on a SQL Server AS 2005 SP1 box and it worked just fine, no errors. What version of the product are you using? Have you applied the latest service pack?

--Artur

|||

I've had this problem and after much trail fixed it by reviewing each of the Relationships in the Cube's Dimension Usage.

The problem turned out to be that one of the Measure Group Columns had a caps change since the last time I defined the relationship and AS couldn't match that column to the column in the Data Source View.

You couldn't see that it was invalid until you clicked on the dropdown list and the column name disappeared. (were as normally it would highlight the current selected column from the available columns).

can't add a new measure after the column is added in the DSV ?!?!

Just found one more nice error in SSAS :-)

If i add a column in my facttable, refresh the DSV and drag the new meassure into my meassuregroup i get an error when processing.

"Errors in the high-level relational engine. The data source view does not contain a definition for the 'MEA_BeregnetErhverv' column in the 'dbo_Fakt_Measures' table or view."

Well this is nice, since i just dragged it from that view :-)

Anyone got a workaround for this, except building the DSV and Cube structure from scrap each time ?

I've tried this exact scenario using Adventure Works sample database on a SQL Server AS 2005 SP1 box and it worked just fine, no errors. What version of the product are you using? Have you applied the latest service pack?

--Artur

|||

I've had this problem and after much trail fixed it by reviewing each of the Relationships in the Cube's Dimension Usage.

The problem turned out to be that one of the Measure Group Columns had a caps change since the last time I defined the relationship and AS couldn't match that column to the column in the Data Source View.

You couldn't see that it was invalid until you clicked on the dropdown list and the column name disappeared. (were as normally it would highlight the current selected column from the available columns).

cant access the datasource control

When I put a sqldatasource in my page and want to configure it and add a new connection to it I recieve this error : "object reference not set to an instance of an object" . Do you have any idea about solving this problem. please help me Thanks

Hi,

when asking a question about code or when you get an error always try to provide therelevant pieces of code and the error message that you get. This helps the people around here to better help you out.

Grz, Kris.

|||

My program has only a simple datagrid that should get data from a sql table and show it.This is only a test after changing the IIS settings. You can see my code here:

When I run this program I don't recieve any error but the explorer shows the blank page. When I try making connectionstring via sqldatasource I recieve that error:"the object reference...".thanks for helping

public

partialclassado1 : System.Web.UI.Page

{

privatevoid bindgrid()

{

string conStr ="Data Source=.;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa";SqlConnection conn =newSqlConnection(conStr);// Open the connection

conn.Open();

// Create a data adapter objectSqlDataAdapter adapter =newSqlDataAdapter("SELECT * FROM testt", conn);DataSet ds =newDataSet();

adapter.Fill(ds);

GridView1.DataBind();

conn.Close();

}

protectedvoid Page_Load(object sender,EventArgs e)

{

if (!IsPostBack)

{

bindgrid();

}}}

///////////////////////////////

the body of aspx file is here:

<

body><formid="form1"runat="server"><div> <asp:SqlDataSourceID="SqlDataSource1"runat="server"></asp:SqlDataSource><asp:GridViewID="GridView1"runat="server"></asp:GridView></div></form>

</

body>

/////////////////////////////////////

|||

Hi,

hsharifi:

publicpartialclassado1 : System.Web.UI.Page

{

privatevoid bindgrid()

{

string conStr ="Data Source=.;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa";

SqlConnection conn =newSqlConnection(conStr);

// Open the connection

conn.Open();

// Create a data adapter objectSqlDataAdapter adapter =newSqlDataAdapter("SELECT * FROM testt", conn);DataSet ds =newDataSet();

adapter.Fill(ds);

GridView1.DataBind();

conn.Close();

}

protectedvoid Page_Load(object sender,EventArgs e)

{

if (!IsPostBack)

{

bindgrid();

}}}

///////////////////////////////

the body of aspx file is here:

<

body><formid="form1"runat="server"><div> <asp:SqlDataSourceID="SqlDataSource1"runat="server"></asp:SqlDataSource><asp:GridViewID="GridView1"runat="server"></asp:GridView></div></form>

</

body>

/////////////////////////////////////

it seems like you're trying to do 2 things here: you want to use code & the SqlDataSource control together, that's a no go.

Get rid of the SqlDataSource control on your page and in the codefile, just before you call the DataBind() method place this line:

GridView1.DataSource = ds;
GridView1.DataBind();

Grz, Kris.

|||

Hi Xlll ,and thank you for replying me.

I did the thing that you said but my problem is still going on. After running my program the browser shows a blank page. I had to change many settings in IIS, do you think this problem is related to these changes or may be I should reinstall vs.net after that.

I would be glad to hear your opinion. Thanks

|||

Hi,

before re?nstalling you can first let the aspnet_regiis -i tool do its work to set the correct settings for the correct framework in IIS.

Something else that you can try: place a TextBox, Button and Label control on a webform. In the Button Click event you place this code:

Label1.Text = TextBox1.Text

and see if it executes well on your server. It's probably something stupid but I like to use such scenario's to quickly test out if ASP.NET is installed properly on a machine.

Grz, Kris.

cant access report manager page

Hi friends
suddenly today i cant access my report manager page. i get error "request timed out". it worked nicely yesterday.
any ideas on how to troubleshoot this one.

am running sql server 2005 on xp professional machine.
ThanksMake sure IIS is running and security hasn't change. Has anything changed on machine since last working (e.g. new software, service packs)?|||

Yes Philip

i tried to uninstall sqlexpress but had issues with it. but finally i managed to uninstall successfully and after restarting my machine i can access report manager page.

Thanks

|||Excellent result!

cant access invisible dimension. (still no solution)

i am trying to access invisible dimension in the reporting services surface. but it is giving error. is there any way to access invisible dimension in the reporting services surface. but this hidden dimension can access in the sql 2005 management server. but in the reporting services cant. pls tel m some way to do that.
pls give me the solution if anyone know about this.
|||

You cannot use Hidden Dimensions in SSRS.

But U can create Hidden Calculated Members in Cube, which U R creating in SSRS MDX.

Then use that Calculated Members in Report MDX Query, It will work fine.

Bhudev

|||thx dev

cant access invisible dimension(urgent). still couldnt find the answer

i am trying to access invisible dimension in the reporting services surface. but it is giving error. is there any way to access invisible dimension in the reporting services surface. but this hidden dimension can access in the sql 2005 management server. but in the reporting services cant. pls tel m some way to do that.
pls give me the solution if anyone know about this.
|||

You cannot use Hidden Dimensions in SSRS.

But U can create Hidden Calculated Members in Cube, which U R creating in SSRS MDX.

Then use that Calculated Members in Report MDX Query, It will work fine.

Bhudev

|||thx dev