SQL Alternative to cursor: copy

Showing posts with label copy. Show all posts

Sunday, March 25, 2012

Analysis Server not working with MSDE SQL Server

I installed Visual Studio .NET v.1.0 and the included MSDE version of
SQL Server. I have an additional copy of MS SQL Server 2000 Enterprise
Ed. on CD. I installed Microsoft Analysis Services from this CD on my
machine with MSDE SQL Server; it appeared to install cleanly.
I ran Analysis Manager from the Start menu under Windows XP Pro. The
local SQL Server showed red block indicating the server was not
running. I tried to connect, and got the following error message:
Unable to connect to the registry on the server (myserver_name), or you
are not a member of the OLAP Administrators group on this server.
Does anyone know the problem here? I was wondering whether I had to
install MS SQL Server enterprise ed. to use Analysis Server with it,
rather than more limited MSDE version of SQL Server ?!
Thanks all.
Fred Z.
hi Fred,
silversw2000@.yahoo.com wrote:
> I installed Visual Studio .NET v.1.0 and the included MSDE version of
> SQL Server. I have an additional copy of MS SQL Server 2000 Enterprise
> Ed. on CD. I installed Microsoft Analysis Services from this CD on my
> machine with MSDE SQL Server; it appeared to install cleanly.
> I ran Analysis Manager from the Start menu under Windows XP Pro. The
> local SQL Server showed red block indicating the server was not
> running. I tried to connect, and got the following error message:
> Unable to connect to the registry on the server (myserver_name), or
> you are not a member of the OLAP Administrators group on this server.
> Does anyone know the problem here? I was wondering whether I had to
> install MS SQL Server enterprise ed. to use Analysis Server with it,
> rather than more limited MSDE version of SQL Server ?!
> Thanks all.
> Fred Z.
I do not think Analysis Service is supported on MSDE..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Tuesday, March 20, 2012

An other DB copy Q:

Hello,
In an instance, I've two DBs: ABC y copyABC. I would like to update the
tables (and their contents added or removed) from ABC to copyABC twice a
day. For it will be using a Job but, what would be the syntax?
The idea is to get data for my reports from copyABC and creating my own
queries without disrupting the daily usage of ABC.
Would appreciate some directions.
Thank you
MarySSIS script or BulkCopy or SqlBulkCopy method. You might also consider
ADO.NET 3.5 Sync Services.
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
"Mary" <noemail@.hotmail.com> wrote in message
news:C17402E7-3501-44B5-9D2F-7D03FA01B161@.microsoft.com...
> Hello,
> In an instance, I've two DBs: ABC y copyABC. I would like to update the
> tables (and their contents added or removed) from ABC to copyABC twice a
> day. For it will be using a Job but, what would be the syntax?
> The idea is to get data for my reports from copyABC and creating my own
> queries without disrupting the daily usage of ABC.
> Would appreciate some directions.
> Thank you
> Mary
>|||Can a query be used? is so, how?
"William Vaughn [MVP]" <billvaNoSPAM@.betav.com> escribió en el mensaje de
noticias news:AAC71D98-1B95-4F63-90F4-0607B79F1222@.microsoft.com...
> SSIS script or BulkCopy or SqlBulkCopy method. You might also consider
> ADO.NET 3.5 Sync Services.
> --
> __________________________________________________________________________
> William R. Vaughn
> President and Founder Beta V Corporation
> Author, Mentor, Dad, Grandpa
> Microsoft MVP
> (425) 556-9205 (Pacific time)
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> ____________________________________________________________________________________________
> "Mary" <noemail@.hotmail.com> wrote in message
> news:C17402E7-3501-44B5-9D2F-7D03FA01B161@.microsoft.com...
>> Hello,
>> In an instance, I've two DBs: ABC y copyABC. I would like to update the
>> tables (and their contents added or removed) from ABC to copyABC twice a
>> day. For it will be using a Job but, what would be the syntax?
>> The idea is to get data for my reports from copyABC and creating my own
>> queries without disrupting the daily usage of ABC.
>> Would appreciate some directions.
>> Thank you
>> Mary
>|||SSIS (as launched via SQL Server Management Services) can support a query to
specify which rows to import/export
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
"Mary" <noemail@.hotmail.com> wrote in message
news:72185CFE-FB07-4E0C-8255-1FC84A034C8E@.microsoft.com...
> Can a query be used? is so, how?
> "William Vaughn [MVP]" <billvaNoSPAM@.betav.com> escribió en el mensaje de
> noticias news:AAC71D98-1B95-4F63-90F4-0607B79F1222@.microsoft.com...
>> SSIS script or BulkCopy or SqlBulkCopy method. You might also consider
>> ADO.NET 3.5 Sync Services.
>> --
>> __________________________________________________________________________
>> William R. Vaughn
>> President and Founder Beta V Corporation
>> Author, Mentor, Dad, Grandpa
>> Microsoft MVP
>> (425) 556-9205 (Pacific time)
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> ____________________________________________________________________________________________
>> "Mary" <noemail@.hotmail.com> wrote in message
>> news:C17402E7-3501-44B5-9D2F-7D03FA01B161@.microsoft.com...
>> Hello,
>> In an instance, I've two DBs: ABC y copyABC. I would like to update the
>> tables (and their contents added or removed) from ABC to copyABC twice a
>> day. For it will be using a Job but, what would be the syntax?
>> The idea is to get data for my reports from copyABC and creating my own
>> queries without disrupting the daily usage of ABC.
>> Would appreciate some directions.
>> Thank you
>> Mary
>>
>

Wednesday, March 7, 2012

An attempt to attach an auto-named database failed

I have a problem with Microsoft SQL Server 2005 Express,
My web application runs fine on my development PC, but when I copy it to my
server (My server is running Windows 2000 Server) and try to access it from
the web I get following error:
An attempt to attach an auto-named database for file
C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
same name exists, or specified file cannot be opened, or it is located on UNC
share.
The ASPNET account has full control of the database.
Is this a known bug in Microsoft SQL Server?
What should I do?
Thanks for your help in advance,
Noah.Noah
How do you perform an attach operation?
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> same name exists, or specified file cannot be opened, or it is located on
> UNC
> share.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>|||Assuming you are using the default settings, the .mdf and .ldf files must be
located in the same directory as your application on the server. The other
common cause for this is having the database open in the IDE or having the
database files with no write permissions for the ASPNET account. There is
more info here:
http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> same name exists, or specified file cannot be opened, or it is located on
> UNC
> share.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>|||I use the following command:
data source=.\SQLEXPRESS;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true
"Uri Dimant" wrote:
> Noah
> How do you perform an attach operation?
>
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
> >I have a problem with Microsoft SQL Server 2005 Express,
> > My web application runs fine on my development PC, but when I copy it to
> > my
> > server (My server is running Windows 2000 Server) and try to access it
> > from
> > the web I get following error:
> >
> > An attempt to attach an auto-named database for file
> > C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> > same name exists, or specified file cannot be opened, or it is located on
> > UNC
> > share.
> >
> > The ASPNET account has full control of the database.
> > Is this a known bug in Microsoft SQL Server?
> > What should I do?
> >
> > Thanks for your help in advance,
> >
> > Noah.
> >
>
>|||As I said... The ASPNET account has full control of the database and of the
application root folder.
Read, Write, Modify, etc.
I thought that was the problem, but it isn't. I had already given the ASPNET
account full control when I had problems with a hit counter. That took me two
days to figure out...
Anyway,
With the info you have now what do you suggest I do?
Thanks,
Noah.
"Roger Wolter[MSFT]" wrote:
> Assuming you are using the default settings, the .mdf and .ldf files must be
> located in the same directory as your application on the server. The other
> common cause for this is having the database open in the IDE or having the
> database files with no write permissions for the ASPNET account. There is
> more info here:
> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
> >I have a problem with Microsoft SQL Server 2005 Express,
> > My web application runs fine on my development PC, but when I copy it to
> > my
> > server (My server is running Windows 2000 Server) and try to access it
> > from
> > the web I get following error:
> >
> > An attempt to attach an auto-named database for file
> > C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> > same name exists, or specified file cannot be opened, or it is located on
> > UNC
> > share.
> >
> > The ASPNET account has full control of the database.
> > Is this a known bug in Microsoft SQL Server?
> > What should I do?
> >
> > Thanks for your help in advance,
> >
> > Noah.
> >
>
>|||So, you eliminated one of the three things I suggested. How about the other
two? Di reading the article give you any things to try?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...
> As I said... The ASPNET account has full control of the database and of
> the
> application root folder.
> Read, Write, Modify, etc.
> I thought that was the problem, but it isn't. I had already given the
> ASPNET
> account full control when I had problems with a hit counter. That took me
> two
> days to figure out...
> Anyway,
> With the info you have now what do you suggest I do?
> Thanks,
> Noah.
> "Roger Wolter[MSFT]" wrote:
>> Assuming you are using the default settings, the .mdf and .ldf files must
>> be
>> located in the same directory as your application on the server. The
>> other
>> common cause for this is having the database open in the IDE or having
>> the
>> database files with no write permissions for the ASPNET account. There
>> is
>> more info here:
>> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Noah" <Noah@.discussions.microsoft.com> wrote in message
>> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>> >I have a problem with Microsoft SQL Server 2005 Express,
>> > My web application runs fine on my development PC, but when I copy it
>> > to
>> > my
>> > server (My server is running Windows 2000 Server) and try to access it
>> > from
>> > the web I get following error:
>> >
>> > An attempt to attach an auto-named database for file
>> > C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with
>> > the
>> > same name exists, or specified file cannot be opened, or it is located
>> > on
>> > UNC
>> > share.
>> >
>> > The ASPNET account has full control of the database.
>> > Is this a known bug in Microsoft SQL Server?
>> > What should I do?
>> >
>> > Thanks for your help in advance,
>> >
>> > Noah.
>> >
>>|||Yes.
"Roger Wolter[MSFT]" wrote:
> So, you eliminated one of the three things I suggested. How about the other
> two? Di reading the article give you any things to try?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...
> > As I said... The ASPNET account has full control of the database and of
> > the
> > application root folder.
> > Read, Write, Modify, etc.
> > I thought that was the problem, but it isn't. I had already given the
> > ASPNET
> > account full control when I had problems with a hit counter. That took me
> > two
> > days to figure out...
> > Anyway,
> > With the info you have now what do you suggest I do?
> >
> > Thanks,
> > Noah.
> >
> > "Roger Wolter[MSFT]" wrote:
> >
> >> Assuming you are using the default settings, the .mdf and .ldf files must
> >> be
> >> located in the same directory as your application on the server. The
> >> other
> >> common cause for this is having the database open in the IDE or having
> >> the
> >> database files with no write permissions for the ASPNET account. There
> >> is
> >> more info here:
> >>
> >> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
> >>
> >>
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> Use of included script samples are subject to the terms specified at
> >> http://www.microsoft.com/info/cpyright.htm
> >>
> >> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> >> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
> >> >I have a problem with Microsoft SQL Server 2005 Express,
> >> > My web application runs fine on my development PC, but when I copy it
> >> > to
> >> > my
> >> > server (My server is running Windows 2000 Server) and try to access it
> >> > from
> >> > the web I get following error:
> >> >
> >> > An attempt to attach an auto-named database for file
> >> > C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with
> >> > the
> >> > same name exists, or specified file cannot be opened, or it is located
> >> > on
> >> > UNC
> >> > share.
> >> >
> >> > The ASPNET account has full control of the database.
> >> > Is this a known bug in Microsoft SQL Server?
> >> > What should I do?
> >> >
> >> > Thanks for your help in advance,
> >> >
> >> > Noah.
> >> >
> >>
> >>
> >>
>
>

An attempt to attach an auto-named database failed

Monday, February 13, 2012

Am I correct?

I read the message with the subject "Can I recover?". It states that the
user only has a copy of the database backup in February and he executed an
update statement without a where clause. He wants to know if it can be
recovered...
From what I know, if the February backup was a Full backup and if the
database recovery mode has been setup in "Full", he should be able to backup
the current Transaction Log and do a "point in time restore" to restore data
back before he executed an update statement. Am I correct? I did test it s
o
many times for the "point in time" long time ago... and the point in time
could be used anytime in between "Full Backup"/Diff. Backup and a Transactio
n
Log backup.
I could be so suprise if I am wrong... I don't want to be shame on myseft
since I am a DBA for a fortunate 500 company...
Ed>Am I correct?
Yep.
Hope this helps.
Dan Guzman
SQL Server MVP
"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:E1EE8615-658E-4779-ACF9-71C2357EC8A4@.microsoft.com...
>I read the message with the subject "Can I recover?". It states that the
> user only has a copy of the database backup in February and he executed an
> update statement without a where clause. He wants to know if it can be
> recovered...
> From what I know, if the February backup was a Full backup and if the
> database recovery mode has been setup in "Full", he should be able to
> backup
> the current Transaction Log and do a "point in time restore" to restore
> data
> back before he executed an update statement. Am I correct? I did test it
> so
> many times for the "point in time" long time ago... and the point in time
> could be used anytime in between "Full Backup"/Diff. Backup and a
> Transaction
> Log backup.
> I could be so suprise if I am wrong... I don't want to be shame on myseft
> since I am a DBA for a fortunate 500 company...
> Ed

Sunday, March 25, 2012

Analysis Server not working with MSDE SQL Server

Tuesday, March 20, 2012

An other DB copy Q:

Wednesday, March 7, 2012

An attempt to attach an auto-named database failed

An attempt to attach an auto-named database failed

An attempt to attach an auto-named database failed

Monday, February 13, 2012

Am I correct?

SQL Alternative to cursor

Blog Archive

About Me