SQL Remove Old Backups: databases

Showing posts with label databases. Show all posts

Tuesday, March 20, 2012

3 questions

Hi -- I'm new to SQL and thus also new to SQL Server.
I'm working on a project that has data stored in 4 databases. I want to
create a 5th database for my work. I will need to retrieve data from those
other 4 databases -- usually creating tables in my 5th database. I want to
put together stored procedures to do this. I can extract data and create
tables within one database, but have no idea how to reach out to a different
one.
Eventually, in this project I will need to read the records, in order and
create a running calculation -- not a running sum. I can do this within VB
pretty easily, but I don't know if this can be done is a query. The
calculation is: (field 2, record n) =
(field 1, record n) * (1 - field 2, record n-1) + (field2,record n)
Finally, can anyone suggest a good book that might help me with some of
these types of questions?
I'd appreciate any help on any portion of the above!
Thanks,
ArtArt,
To access the tables in the other databases (assuming the same server) just
qualify the object using DATABASE.OWNER.OBJECT i.e., pubs.dbo.authors.
Books (SQL):
The Guru's Guide to Transact-SQL
by Ken Henderson
http://www.amazon.com/exec/obidos/t...=glance&s=books
Professional SQL Server 2000 Programming
by Robert Vieira
http://www.amazon.com/exec/obidos/t...=glance&s=books
Joe Celko's SQL for Smarties (2005 ed)
by Joe Celko
http://www.amazon.com/exec/obidos/t...=books&n=507846
HTH
Jerry
"Art" <Art@.discussions.microsoft.com> wrote in message
news:D5386C63-4FEA-42A6-8958-A2CF67FCB726@.microsoft.com...
> Hi -- I'm new to SQL and thus also new to SQL Server.
> I'm working on a project that has data stored in 4 databases. I want to
> create a 5th database for my work. I will need to retrieve data from
> those
> other 4 databases -- usually creating tables in my 5th database. I want
> to
> put together stored procedures to do this. I can extract data and create
> tables within one database, but have no idea how to reach out to a
> different
> one.
> Eventually, in this project I will need to read the records, in order and
> create a running calculation -- not a running sum. I can do this within
> VB
> pretty easily, but I don't know if this can be done is a query. The
> calculation is: (field 2, record n) =
> (field 1, record n) * (1 - field 2, record n-1) + (field2,record n)
> Finally, can anyone suggest a good book that might help me with some of
> these types of questions?
> I'd appreciate any help on any portion of the above!
> Thanks,
> Art|||Jerry,
Thanks very much! For both answers.
Art
"Jerry Spivey" wrote:

> Art,
> To access the tables in the other databases (assuming the same server) jus
t
> qualify the object using DATABASE.OWNER.OBJECT i.e., pubs.dbo.authors.
> Books (SQL):
> The Guru's Guide to Transact-SQL
> by Ken Henderson
> http://www.amazon.com/exec/obidos/t...=glance&s=books
> Professional SQL Server 2000 Programming
> by Robert Vieira
> http://www.amazon.com/exec/obidos/t...=glance&s=books
> Joe Celko's SQL for Smarties (2005 ed)
> by Joe Celko
> http://www.amazon.com/exec/obidos/t...=books&n=507846
> HTH
> Jerry
> "Art" <Art@.discussions.microsoft.com> wrote in message
> news:D5386C63-4FEA-42A6-8958-A2CF67FCB726@.microsoft.com...
>
>|||>> I can extract data and create tables within one database, but have no
Use 3-part naming like database.owner.object
Perhaps if you post the DDLs, sample data & expected results, others could
give it a try. ( www.aspfaq.com/5006 ). In some cases, using a client side
programming language might be the option. In other cases, you might have to
use some looping construct like a cursor.
SQL Server Books Online should give you most of the basics on t-SQL.
Anith|||Thanks Anith,
I had been using a programming language, but was wondering if I might be
better off using SQL (assuming it's possible). Thanks again.
Art
"Anith Sen" wrote:

> Use 3-part naming like database.owner.object
>
> Perhaps if you post the DDLs, sample data & expected results, others could
> give it a try. ( www.aspfaq.com/5006 ). In some cases, using a client side
> programming language might be the option. In other cases, you might have t
o
> use some looping construct like a cursor.
>
> SQL Server Books Online should give you most of the basics on t-SQL.
> --
> Anith
>
>|||Art, you are in trouble. Let's get back to the basics of an RDBMS.
Rows are not records; fields are not columns; tables are not files;
your post is nonsense. But it tells us that you have no idea about
RDBMS, so your design is probably screw to hell and breakfast.
You seem to be doing attribute splitting on databases; Otherwise, it
would not make sense to mix them.|||"But it tells us that you have no idea about RDBMS"
Hey --CELKO--, keep your posts focused on the issue at hand, not the person
posting. The forum is here to help each other, not to put down people.
This a constant problem with you. Your input is valuable and appreciated,
but these kind of comments are not (at least by me).
Are there no moderators on this site?
"--CELKO--" wrote:

> Art, you are in trouble. Let's get back to the basics of an RDBMS.
> Rows are not records; fields are not columns; tables are not files;
> your post is nonsense. But it tells us that you have no idea about
> RDBMS, so your design is probably screw to hell and breakfast.
> You seem to be doing attribute splitting on databases; Otherwise, it
> would not make sense to mix them.
>

Sunday, March 11, 2012

2GB Limit

What happens when an SQL2K MSDE database reaches 2GB? I've actually seen
MSDE databases reach that size and nothing happened.
Thanks,
Ademar.
hi Ademar,
Ademar Nunes wrote:
> What happens when an SQL2K MSDE database reaches 2GB? I've actually
> seen MSDE databases reach that size and nothing happened.
when you exceed that limit, nex time the Storage Engine requires a file
allocation beyond the allocated space, thus trying expanding the data file,
an exception will be raised..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Maybe the 2GB+ installation I'm referring to is actually a Personal edition
and not MSDE.
I'll run the SELECT @.@.VERSION statement on it and I'm assuming that will
tell me if it is MSDE.
Thanks,
Ademar.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3o8jmjF4mu4pU1@.individual.net...
> hi Ademar,
> Ademar Nunes wrote:
> when you exceed that limit, nex time the Storage Engine requires a file
> allocation beyond the allocated space, thus trying expanding the data
> file, an exception will be raised..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||Hi,
If it is Personal edition; there is no db size limitation. See details in
below URL
http://msdn.microsoft.com/library/?u...asp?frame=true
Thanks
Hari
SQL Server MVP
"Ademar Nunes" <anunes@.myemail.com> wrote in message
news:%23VOAP38sFHA.3500@.TK2MSFTNGP09.phx.gbl...
> Maybe the 2GB+ installation I'm referring to is actually a Personal
> edition and not MSDE.
> I'll run the SELECT @.@.VERSION statement on it and I'm assuming that will
> tell me if it is MSDE.
> Thanks,
> Ademar.
> "Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
> news:3o8jmjF4mu4pU1@.individual.net...
>

2G limit in MSDE

I am aware that there is a 2G limit in MSDE. However in some of our
production databases we are running out of space. There is a long term plan
to upgrade to SQL2005 to double the space available to us. However in the
short term is there a quick way to have more space available ?
I could create a second database and then link a table / view back to the
original for example. Or would I be able to create a second filegroup which
would have another 2 G ?
Any ideas ?
Si
Ah, what are you storing in the database? Don't tell me... let me guess...
ah... it's coming to me...
PICTURES! I got it right?...No? Documents?
These are BLOBs. If you want to save space, don't store the BLOBs in the
database--put them on CDs (if they are RO) or on other drives and put the
path and attributes in the database. File IO can far faster (6 to 10x) than
SQL query IO. Yes, it would require a change in your code, but it's not that
much trouble...
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:FA3B4343-37BD-4B74-8EF4-EFFA21EC7B66@.microsoft.com...
>I am aware that there is a 2G limit in MSDE. However in some of our
> production databases we are running out of space. There is a long term
> plan
> to upgrade to SQL2005 to double the space available to us. However in the
> short term is there a quick way to have more space available ?
> I could create a second database and then link a table / view back to the
> original for example. Or would I be able to create a second filegroup
> which
> would have another 2 G ?
> Any ideas ?
> Si
>
|||Check out reindexing with a smaller fill factor.
--DatabaseAdmins.com
Remote DBA Services
"William (Bill) Vaughn" wrote:

> Ah, what are you storing in the database? Don't tell me... let me guess...
> ah... it's coming to me...
> PICTURES! I got it right?...No? Documents?
> These are BLOBs. If you want to save space, don't store the BLOBs in the
> database--put them on CDs (if they are RO) or on other drives and put the
> path and attributes in the database. File IO can far faster (6 to 10x) than
> SQL query IO. Yes, it would require a change in your code, but it's not that
> much trouble...
> hth
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ------
> "Simon" <Simon@.discussions.microsoft.com> wrote in message
> news:FA3B4343-37BD-4B74-8EF4-EFFA21EC7B66@.microsoft.com...
>
>
|||Bill
do you know much about the varbinary method for storing documents?
I read somewhere that you can stored docs as varbinary instead of image and
it's a lot lot lot faster-- but it only works with small docs
thanks
"William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
news:ejV$Kw0XHHA.3952@.TK2MSFTNGP04.phx.gbl...
> Ah, what are you storing in the database? Don't tell me... let me
guess...
> ah... it's coming to me...
> PICTURES! I got it right?...No? Documents?
> These are BLOBs. If you want to save space, don't store the BLOBs in the
> database--put them on CDs (if they are RO) or on other drives and put the
> path and attributes in the database. File IO can far faster (6 to 10x)
than
> SQL query IO. Yes, it would require a change in your code, but it's not
that
> much trouble...
> hth
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ----
---[vbcol=seagreen]
> "Simon" <Simon@.discussions.microsoft.com> wrote in message
> news:FA3B4343-37BD-4B74-8EF4-EFFA21EC7B66@.microsoft.com...
the[vbcol=seagreen]
the
>
|||partition your older data into an archive table-- in a different database
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:FA3B4343-37BD-4B74-8EF4-EFFA21EC7B66@.microsoft.com...
> I am aware that there is a 2G limit in MSDE. However in some of our
> production databases we are running out of space. There is a long term
plan
> to upgrade to SQL2005 to double the space available to us. However in the
> short term is there a quick way to have more space available ?
> I could create a second database and then link a table / view back to the
> original for example. Or would I be able to create a second filegroup
which
> would have another 2 G ?
> Any ideas ?
> Si
>
|||My tests (albeit unscientific at times) shows storing BLOBs (in whatever
datatype) in the database is 6x slower than storing the same data on a file.
Your mileage may vary.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Aaron Kempf" <akempf@.dol.wa.gov> wrote in message
news:eBBZVECjHHA.1240@.TK2MSFTNGP04.phx.gbl...
> Bill
> do you know much about the varbinary method for storing documents?
> I read somewhere that you can stored docs as varbinary instead of image
> and
> it's a lot lot lot faster-- but it only works with small docs
> thanks
>
> "William (Bill) Vaughn" <billvaRemoveThis@.nwlink.com> wrote in message
> news:ejV$Kw0XHHA.3952@.TK2MSFTNGP04.phx.gbl...
> guess...
> than
> that
> rights.
> the
> the
>

Thursday, March 8, 2012

24 - 7 and the need for maintainence

Hi,
I hope someone can point me in the right direction at least on our
maintainence problem. As a 24x7 shop the databases are up all the time. We
are running enterprise edition 2000 on clustered servers.
The little mundane things like reindexing, torn page fix and other little
things that you would normally run in dead time are the problem.
How do you guys take care of these chores?
TIA
JohnJohn,
For reindexing, you might want to look at DBCC INDEXDEFRAG. Locking is totally different than
the other methods (essentially only locks the area where it currently "sweeps").
As for torn page fixing: This is not something you would normally have. Are you saying that this
is common in your installation?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"John Campbell" <jcampbell@.us-south.net> wrote in message
news:ejiBemtRDHA.304@.tk2msftngp13.phx.gbl...
> Hi,
> I hope someone can point me in the right direction at least on our
> maintainence problem. As a 24x7 shop the databases are up all the time. We
> are running enterprise edition 2000 on clustered servers.
> The little mundane things like reindexing, torn page fix and other little
> things that you would normally run in dead time are the problem.
> How do you guys take care of these chores?
> TIA
> John
>|||I currently use the indexdefrag command. I have seen more torn pages at
this job than I have ever seen in the past. In the past I would only see
them on non-production type servers. Here I see them about every 2 to 3
months on the same server, different databases.
The normal solution is to drop the indexes and then recreate them.
The general maintainence issue is that I went on vacation a few weeks back.
Before I left I was running the DBCC INDEXDEFRAG on the 10 largest tables
about 2 or 3 times a week depenting on my schedule and system load.
Since I have come back, I am unable to run any of my maintenance without
blocking on this particular production server......
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:ebQ8HztRDHA.3144@.tk2msftngp13.phx.gbl...
> John,
> For reindexing, you might want to look at DBCC INDEXDEFRAG. Locking is
totally different than
> the other methods (essentially only locks the area where it currently
"sweeps").
> As for torn page fixing: This is not something you would normally have.
Are you saying that this
> is common in your installation?
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "John Campbell" <jcampbell@.us-south.net> wrote in message
> news:ejiBemtRDHA.304@.tk2msftngp13.phx.gbl...
> > Hi,
> > I hope someone can point me in the right direction at least on our
> > maintainence problem. As a 24x7 shop the databases are up all the time.
We
> > are running enterprise edition 2000 on clustered servers.
> > The little mundane things like reindexing, torn page fix and other
little
> > things that you would normally run in dead time are the problem.
> > How do you guys take care of these chores?
> >
> > TIA
> > John
> >
> >
>|||If your getting that many torn pages the I would take a good look at your
hardware, especially your disk subsystem to ensure it is working properly.
Torn pages usually occur when the write to the disk was not completed and
that is mainly caused by the hardware or power failures. As for your other
issue, are you saying that DBCC INDEXDEFRAG is now causing blocking at a
point it interferes with your app? It should only block pages at a time and
for brief periods. This should not adversely affect a properly designed
app. One thing it does do is take a shared lock on the table so if you have
any code in your app that takes out a table level lock this can be a
problem. What kind of blocking are you seeing?
Andrew J. Kelly
SQL Server MVP
"John Campbell" <jcampbell@.us-south.net> wrote in message
news:uBijd6tRDHA.3192@.TK2MSFTNGP10.phx.gbl...
> I currently use the indexdefrag command. I have seen more torn pages at
> this job than I have ever seen in the past. In the past I would only see
> them on non-production type servers. Here I see them about every 2 to 3
> months on the same server, different databases.
> The normal solution is to drop the indexes and then recreate them.
> The general maintainence issue is that I went on vacation a few weeks
back.
> Before I left I was running the DBCC INDEXDEFRAG on the 10 largest tables
> about 2 or 3 times a week depenting on my schedule and system load.
> Since I have come back, I am unable to run any of my maintenance without
> blocking on this particular production server......
> "Tibor Karaszi"
<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:ebQ8HztRDHA.3144@.tk2msftngp13.phx.gbl...
> > John,
> >
> > For reindexing, you might want to look at DBCC INDEXDEFRAG. Locking is
> totally different than
> > the other methods (essentially only locks the area where it currently
> "sweeps").
> >
> > As for torn page fixing: This is not something you would normally have.
> Are you saying that this
> > is common in your installation?
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "John Campbell" <jcampbell@.us-south.net> wrote in message
> > news:ejiBemtRDHA.304@.tk2msftngp13.phx.gbl...
> > > Hi,
> > > I hope someone can point me in the right direction at least on our
> > > maintainence problem. As a 24x7 shop the databases are up all the
time.
> We
> > > are running enterprise edition 2000 on clustered servers.
> > > The little mundane things like reindexing, torn page fix and other
> little
> > > things that you would normally run in dead time are the problem.
> > > How do you guys take care of these chores?
> > >
> > > TIA
> > > John
> > >
> > >
> >
> >
>

Tuesday, March 6, 2012

2005/2000 question!

Hi I have both sql 2005 and 2000 installed on a machine. When I start
management studio it can connect to legacy 2000 databases. What I want to do
is create a new database with all of the 2005 attributes. Is there a way to
put management studio in a mode where it will create a new 2005 database and
have all of the 2005 features with 2000 still on the machine?
thanks.
--
Paul G
Software engineer.SQL Server 2000 and SQL Server 2005 can coexist on the same machine
without problem, but only one can be the default instance. The
default instance is the one that will be referenced when only the
computer name is supplied. There can be one or more named instances
for each version of SQL Server, but referencing those requires
computer_name\instance_name.
Having said that, Management Studio can work with any instance of 2000
or 2005. Open the Registered Servers window and make sure there is an
entry for every instance on the machine. When you want to create a
new database "with all of the 2005 attributes", choose a SQL Server
2005 instance from this list, right click and choose Connect / Object
Explorer. In the Object Explorer window, right-click on Databases in
a 2005 instance and choose New.
Roy Harvey
Beacon Falls, CT
On Mon, 24 Sep 2007 09:02:08 -0700, Paul
<Paul@.discussions.microsoft.com> wrote:
>Hi I have both sql 2005 and 2000 installed on a machine. When I start
>management studio it can connect to legacy 2000 databases. What I want to do
>is create a new database with all of the 2005 attributes. Is there a way to
>put management studio in a mode where it will create a new 2005 database and
>have all of the 2005 features with 2000 still on the machine?
>thanks.|||On Mon, 24 Sep 2007 09:02:08 -0700, Paul wrote:
>Hi I have both sql 2005 and 2000 installed on a machine. When I start
>management studio it can connect to legacy 2000 databases. What I want to do
>is create a new database with all of the 2005 attributes. Is there a way to
>put management studio in a mode where it will create a new 2005 database and
>have all of the 2005 features with 2000 still on the machine?
>thanks.
Hi Paul,
I have both SQL Server 2000 and SQL Server 2005 running on my machine,
and I use SSMS to connect to both. When connected to SQL Server 2005, I
can use all the new features. When connected to SQL Server 2000, I am
obviously limited to the old feature set.
So if you connect SSMS to your SQL Server 2005 instance, you should be
able to create new SQL Server 2005 databases without problems.
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis|||Hi I did not see an entry for the 2005 instance. I also opened the SQL
Server Configuartion manager and it lists the following, 1. SQL Server 2005
services, 2. SQL Server 2005 Network config, 3. SQL Native client config.
Wondering if there is something I missed in the installation?
thanks.
--
Paul G
Software engineer.
"Roy Harvey (SQL Server MVP)" wrote:
> SQL Server 2000 and SQL Server 2005 can coexist on the same machine
> without problem, but only one can be the default instance. The
> default instance is the one that will be referenced when only the
> computer name is supplied. There can be one or more named instances
> for each version of SQL Server, but referencing those requires
> computer_name\instance_name.
> Having said that, Management Studio can work with any instance of 2000
> or 2005. Open the Registered Servers window and make sure there is an
> entry for every instance on the machine. When you want to create a
> new database "with all of the 2005 attributes", choose a SQL Server
> 2005 instance from this list, right click and choose Connect / Object
> Explorer. In the Object Explorer window, right-click on Databases in
> a 2005 instance and choose New.
> Roy Harvey
> Beacon Falls, CT
> On Mon, 24 Sep 2007 09:02:08 -0700, Paul
> <Paul@.discussions.microsoft.com> wrote:
> >Hi I have both sql 2005 and 2000 installed on a machine. When I start
> >management studio it can connect to legacy 2000 databases. What I want to do
> >is create a new database with all of the 2005 attributes. Is there a way to
> >put management studio in a mode where it will create a new 2005 database and
> >have all of the 2005 features with 2000 still on the machine?
> >thanks.
>

Friday, February 24, 2012

2005 selected databas monitoring - how?

I have three databases with same user login. How can I monitor activity only
for one database (logins, transactions) in SQL 2005 server?
I can't change the user for this database.Hi
You can filter the database by db_id within sql server profiler
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>I have three databases with same user login. How can I monitor activity
>only for one database (logins, transactions) in SQL 2005 server?
> I can't change the user for this database.
>|||Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that it
was in 2000 profiler, but it's like here is some changes in 2005.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
> Hi
> You can filter the database by db_id within sql server profiler
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>>I have three databases with same user login. How can I monitor activity
>>only for one database (logins, transactions) in SQL 2005 server?
>> I can't change the user for this database.
>|||No, just check all events and all columns and you will see
"Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
> Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that
> it was in 2000 profiler, but it's like here is some changes in 2005.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>> Hi
>> You can filter the database by db_id within sql server profiler
>>
>> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
>> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>>I have three databases with same user login. How can I monitor activity
>>only for one database (logins, transactions) in SQL 2005 server?
>> I can't change the user for this database.
>>
>|||Thank You. I found it.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:urV6K7WZHHA.4396@.TK2MSFTNGP06.phx.gbl...
> No, just check all events and all columns and you will see
>
>
>
> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
> news:uwTjr1WZHHA.5080@.TK2MSFTNGP02.phx.gbl...
>> Unfortunately I can't find DB_ID field in 2005 SQL Profiler. I know that
>> it was in 2000 profiler, but it's like here is some changes in 2005.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:ePqsQWWZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>> Hi
>> You can filter the database by db_id within sql server profiler
>>
>> "Sergejs Degtjars" <sergeydeg@.inbox.lv> wrote in message
>> news:OFp1vMWZHHA.1220@.TK2MSFTNGP03.phx.gbl...
>>I have three databases with same user login. How can I monitor activity
>>only for one database (logins, transactions) in SQL 2005 server?
>> I can't change the user for this database.
>>
>>
>

2005 selected databas monitoring - how?

Monday, February 13, 2012

2005 features not working

I have both sql 2000 and sql2005 installed on a machine and with management
studio it seems to show the databases created in 2000 but does not seem to
have many of the new features of 2005. It seems as though it is not
operating against a SQL Server 2005 installation although 2005 is installed.
Just wondering if I would need to remove sql2000 for 2005 to operate with
full features?
thanks.
--
Paul G
Software engineer.What new features are you referring to that you expect to see that you
don't? If you are talking about not being able to use some of the new
features make sure your db in 90 compatibility mode. If you upgrade a 2000
db it stays in 80 compat mode.
--
Andrew J. Kelly SQL MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:B5275E28-3080-4D05-ABBC-D575D11C43B8@.microsoft.com...
>I have both sql 2000 and sql2005 installed on a machine and with management
> studio it seems to show the databases created in 2000 but does not seem to
> have many of the new features of 2005. It seems as though it is not
> operating against a SQL Server 2005 installation although 2005 is
> installed.
> Just wondering if I would need to remove sql2000 for 2005 to operate with
> full features?
> thanks.
> --
> Paul G
> Software engineer.|||for example in viewing databases I did not see a section for schema in the
object explorer so could not add one. Also in following the instructions to
create a cube, I could not because a cube folder was not present after a new
solution was created in the project explorer. Also I noticed on the status
bar it lists the computer name followed by (8.0 RTM), does this mean it is
not the full feature version running? Also how do you switch it to the 90
compatable mode?
thanks
--
Paul G
Software engineer.
"Andrew J. Kelly" wrote:
> What new features are you referring to that you expect to see that you
> don't? If you are talking about not being able to use some of the new
> features make sure your db in 90 compatibility mode. If you upgrade a 2000
> db it stays in 80 compat mode.
> --
> Andrew J. Kelly SQL MVP
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:B5275E28-3080-4D05-ABBC-D575D11C43B8@.microsoft.com...
> >I have both sql 2000 and sql2005 installed on a machine and with management
> > studio it seems to show the databases created in 2000 but does not seem to
> > have many of the new features of 2005. It seems as though it is not
> > operating against a SQL Server 2005 installation although 2005 is
> > installed.
> > Just wondering if I would need to remove sql2000 for 2005 to operate with
> > full features?
> > thanks.
> > --
> > Paul G
> > Software engineer.
>
>|||> Also I noticed on the status
> bar it lists the computer name followed by (8.0 RTM), does this mean it is
> not the full feature version running?
It means that the server (instance) you have connected to is SQL Server 2000. Perhaps you only
upgraded the client tools?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:57529330-1DD6-41F7-A6A1-6A38C416AFA1@.microsoft.com...
> for example in viewing databases I did not see a section for schema in the
> object explorer so could not add one. Also in following the instructions to
> create a cube, I could not because a cube folder was not present after a new
> solution was created in the project explorer. Also I noticed on the status
> bar it lists the computer name followed by (8.0 RTM), does this mean it is
> not the full feature version running? Also how do you switch it to the 90
> compatable mode?
> thanks
> --
> Paul G
> Software engineer.
>
> "Andrew J. Kelly" wrote:
>> What new features are you referring to that you expect to see that you
>> don't? If you are talking about not being able to use some of the new
>> features make sure your db in 90 compatibility mode. If you upgrade a 2000
>> db it stays in 80 compat mode.
>> --
>> Andrew J. Kelly SQL MVP
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:B5275E28-3080-4D05-ABBC-D575D11C43B8@.microsoft.com...
>> >I have both sql 2000 and sql2005 installed on a machine and with management
>> > studio it seems to show the databases created in 2000 but does not seem to
>> > have many of the new features of 2005. It seems as though it is not
>> > operating against a SQL Server 2005 installation although 2005 is
>> > installed.
>> > Just wondering if I would need to remove sql2000 for 2005 to operate with
>> > full features?
>> > thanks.
>> > --
>> > Paul G
>> > Software engineer.
>>|||Also note that you can have only one default (server name only) instance.
If your SQL 2000 instance is the default instance, then the installed SQL
2005 instance must be a named instance. You can connect to named instances
using '<server name>\<instance name>'.
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:57529330-1DD6-41F7-A6A1-6A38C416AFA1@.microsoft.com...
> for example in viewing databases I did not see a section for schema in the
> object explorer so could not add one. Also in following the instructions
> to
> create a cube, I could not because a cube folder was not present after a
> new
> solution was created in the project explorer. Also I noticed on the
> status
> bar it lists the computer name followed by (8.0 RTM), does this mean it is
> not the full feature version running? Also how do you switch it to the 90
> compatable mode?
> thanks
> --
> Paul G
> Software engineer.
>
> "Andrew J. Kelly" wrote:
>> What new features are you referring to that you expect to see that you
>> don't? If you are talking about not being able to use some of the new
>> features make sure your db in 90 compatibility mode. If you upgrade a
>> 2000
>> db it stays in 80 compat mode.
>> --
>> Andrew J. Kelly SQL MVP
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:B5275E28-3080-4D05-ABBC-D575D11C43B8@.microsoft.com...
>> >I have both sql 2000 and sql2005 installed on a machine and with
>> >management
>> > studio it seems to show the databases created in 2000 but does not seem
>> > to
>> > have many of the new features of 2005. It seems as though it is not
>> > operating against a SQL Server 2005 installation although 2005 is
>> > installed.
>> > Just wondering if I would need to remove sql2000 for 2005 to operate
>> > with
>> > full features?
>> > thanks.
>> > --
>> > Paul G
>> > Software engineer.
>>|||> Thanks for the information, I looked at the programs installed it lists
> Microsoft SQL 2005 so think I have it installed.
That could still only be the client tools.
Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
Server", or both?
A|||What services (related to SQL Server) do you have. There is no doubt that you did connect to an SQL
Server 2000 instance. So either you only upgraded/installed the client tools, or you installed a new
instance but you still connect to the 2000 instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:1DFFDACB-423B-453C-A4C0-D2CA872B698C@.microsoft.com...
> Thanks for the information, I looked at the programs installed it lists
> Microsoft SQL 2005 so think I have it installed.
> --
> Paul G
> Software engineer.
>
> "Tibor Karaszi" wrote:
>> > Also I noticed on the status
>> > bar it lists the computer name followed by (8.0 RTM), does this mean it is
>> > not the full feature version running?
>> It means that the server (instance) you have connected to is SQL Server 2000. Perhaps you only
>> upgraded the client tools?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:57529330-1DD6-41F7-A6A1-6A38C416AFA1@.microsoft.com...
>> > for example in viewing databases I did not see a section for schema in the
>> > object explorer so could not add one. Also in following the instructions to
>> > create a cube, I could not because a cube folder was not present after a new
>> > solution was created in the project explorer. Also I noticed on the status
>> > bar it lists the computer name followed by (8.0 RTM), does this mean it is
>> > not the full feature version running? Also how do you switch it to the 90
>> > compatable mode?
>> > thanks
>> > --
>> > Paul G
>> > Software engineer.
>> >
>> >
>> > "Andrew J. Kelly" wrote:
>> >
>> >> What new features are you referring to that you expect to see that you
>> >> don't? If you are talking about not being able to use some of the new
>> >> features make sure your db in 90 compatibility mode. If you upgrade a 2000
>> >> db it stays in 80 compat mode.
>> >>
>> >> --
>> >> Andrew J. Kelly SQL MVP
>> >>
>> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> >> news:B5275E28-3080-4D05-ABBC-D575D11C43B8@.microsoft.com...
>> >> >I have both sql 2000 and sql2005 installed on a machine and with management
>> >> > studio it seems to show the databases created in 2000 but does not seem to
>> >> > have many of the new features of 2005. It seems as though it is not
>> >> > operating against a SQL Server 2005 installation although 2005 is
>> >> > installed.
>> >> > Just wondering if I would need to remove sql2000 for 2005 to operate with
>> >> > full features?
>> >> > thanks.
>> >> > --
>> >> > Paul G
>> >> > Software engineer.
>> >>
>> >>
>> >>
>>|||The services with the long names are 2005 services. So, it seems you have a lot of 2005 stuff
installed, *except* the database engine (and Agent). I.e., below are 2000 or 7.0 (based on the
service name):
MSSQLSERVER
SQLSERVERAGENT
(In 2005, a service has both a long name and a short name. However, the tools you use will present
the long name.)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:D2E27CD8-2D39-4E97-B954-8D9C9B64488B@.microsoft.com...
> Hi here is what I have listed in the services section from the control panel,
> SQL Server (SQLEXPRESS)-probably should remove this
> SQL Server Active Directory Helper
> SQL Server Analysis Services (MSSQLSERVER)
> SQL Server Browser
> SQL Server Integration Services
> SQL Server Reporting Services (MSSQLSERVER)
> SQL Server VSS Writer
> MSSQLSERVER
> SQLSERVERAGENT
> I did not see a SQL Server by itself. Guess it does not specify the year
> just from the service listing. Does this look like only the client may be
> installed? Also I installed it off of the Visual Studio 2005 professional
> addition, disk labeled SQL Server 2005 Developer edition. Thanks.
> --
> Paul G
> Software engineer.
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>> > Thanks for the information, I looked at the programs installed it lists
>> > Microsoft SQL 2005 so think I have it installed.
>> That could still only be the client tools.
>> Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
>> Server", or both?
>> A
>>|||> Do you know if I can install the
> 2005 SQL Server agent without effecting the 2000 server agent as I have
> several jobs scheduled?
Yes. Install another SQL Server Database Engine instance. Each Database Engine comes with Agent.
>Also looks like I do not have the database engine
> installed 2005 as you noted. Does this come with the SQL Server 2005
> Developer edition (guessing it does) and can it be installed along with the
> 2000 database engine without effecting the 2000 instance?
Yep. As per above, just install a new database engine instance.
>If so not sure why
> it was not installed, guess I may have not selected the proper installation
> option.
That would be my guess as well.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:43AF09FA-ED81-45F2-98F4-E25C64C70927@.microsoft.com...
> Hi thanks for the additional information. Do you know if I can install the
> 2005 SQL Server agent without effecting the 2000 server agent as I have
> several jobs scheduled? Also looks like I do not have the database engine
> installed 2005 as you noted. Does this come with the SQL Server 2005
> Developer edition (guessing it does) and can it be installed along with the
> 2000 database engine without effecting the 2000 instance? If so not sure why
> it was not installed, guess I may have not selected the proper installation
> option.
> --
> Paul G
> Software engineer.
>
> "Tibor Karaszi" wrote:
>> The services with the long names are 2005 services. So, it seems you have a lot of 2005 stuff
>> installed, *except* the database engine (and Agent). I.e., below are 2000 or 7.0 (based on the
>> service name):
>> MSSQLSERVER
>> SQLSERVERAGENT
>> (In 2005, a service has both a long name and a short name. However, the tools you use will
>> present
>> the long name.)
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:D2E27CD8-2D39-4E97-B954-8D9C9B64488B@.microsoft.com...
>> > Hi here is what I have listed in the services section from the control panel,
>> > SQL Server (SQLEXPRESS)-probably should remove this
>> > SQL Server Active Directory Helper
>> > SQL Server Analysis Services (MSSQLSERVER)
>> > SQL Server Browser
>> > SQL Server Integration Services
>> > SQL Server Reporting Services (MSSQLSERVER)
>> > SQL Server VSS Writer
>> > MSSQLSERVER
>> > SQLSERVERAGENT
>> > I did not see a SQL Server by itself. Guess it does not specify the year
>> > just from the service listing. Does this look like only the client may be
>> > installed? Also I installed it off of the Visual Studio 2005 professional
>> > addition, disk labeled SQL Server 2005 Developer edition. Thanks.
>> >
>> > --
>> > Paul G
>> > Software engineer.
>> >
>> >
>> > "Aaron Bertrand [SQL Server MVP]" wrote:
>> >
>> >> > Thanks for the information, I looked at the programs installed it lists
>> >> > Microsoft SQL 2005 so think I have it installed.
>> >>
>> >> That could still only be the client tools.
>> >>
>> >> Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
>> >> Server", or both?
>> >>
>> >> A
>> >>
>> >>
>> >>
>>|||> Anyhow I was expecting to see SQL Server components but did not, do you know
> if the SQL Server Database Services should install the database engine?
Yes, this is the database engine.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:3ED5DEB6-8FDA-4E00-B814-EFEB0D4BBFDC@.microsoft.com...
> Hi I installed the SQL Svr Developer Edtn 2005 disk and have the following
> selections for installation/repair
> SQL Server Database Services
> Analysis Services
> Reporting Services
> Notification Services
> Integration Services
> Workstation Components, Books online and Development tools.
> Anyhow I was expecting to see SQL Server components but did not, do you know
> if the SQL Server Database Services should install the database engine?
> thanks.
> --
> Paul G
> Software engineer.
>
> "Tibor Karaszi" wrote:
>> > Do you know if I can install the
>> > 2005 SQL Server agent without effecting the 2000 server agent as I have
>> > several jobs scheduled?
>> Yes. Install another SQL Server Database Engine instance. Each Database Engine comes with Agent.
>>
>> >Also looks like I do not have the database engine
>> > installed 2005 as you noted. Does this come with the SQL Server 2005
>> > Developer edition (guessing it does) and can it be installed along with the
>> > 2000 database engine without effecting the 2000 instance?
>> Yep. As per above, just install a new database engine instance.
>>
>> >If so not sure why
>> > it was not installed, guess I may have not selected the proper installation
>> > option.
>> That would be my guess as well.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:43AF09FA-ED81-45F2-98F4-E25C64C70927@.microsoft.com...
>> > Hi thanks for the additional information. Do you know if I can install the
>> > 2005 SQL Server agent without effecting the 2000 server agent as I have
>> > several jobs scheduled? Also looks like I do not have the database engine
>> > installed 2005 as you noted. Does this come with the SQL Server 2005
>> > Developer edition (guessing it does) and can it be installed along with the
>> > 2000 database engine without effecting the 2000 instance? If so not sure why
>> > it was not installed, guess I may have not selected the proper installation
>> > option.
>> > --
>> > Paul G
>> > Software engineer.
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> The services with the long names are 2005 services. So, it seems you have a lot of 2005 stuff
>> >> installed, *except* the database engine (and Agent). I.e., below are 2000 or 7.0 (based on the
>> >> service name):
>> >>
>> >> MSSQLSERVER
>> >> SQLSERVERAGENT
>> >>
>> >> (In 2005, a service has both a long name and a short name. However, the tools you use will
>> >> present
>> >> the long name.)
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> >> news:D2E27CD8-2D39-4E97-B954-8D9C9B64488B@.microsoft.com...
>> >> > Hi here is what I have listed in the services section from the control panel,
>> >> > SQL Server (SQLEXPRESS)-probably should remove this
>> >> > SQL Server Active Directory Helper
>> >> > SQL Server Analysis Services (MSSQLSERVER)
>> >> > SQL Server Browser
>> >> > SQL Server Integration Services
>> >> > SQL Server Reporting Services (MSSQLSERVER)
>> >> > SQL Server VSS Writer
>> >> > MSSQLSERVER
>> >> > SQLSERVERAGENT
>> >> > I did not see a SQL Server by itself. Guess it does not specify the year
>> >> > just from the service listing. Does this look like only the client may be
>> >> > installed? Also I installed it off of the Visual Studio 2005 professional
>> >> > addition, disk labeled SQL Server 2005 Developer edition. Thanks.
>> >> >
>> >> > --
>> >> > Paul G
>> >> > Software engineer.
>> >> >
>> >> >
>> >> > "Aaron Bertrand [SQL Server MVP]" wrote:
>> >> >
>> >> >> > Thanks for the information, I looked at the programs installed it lists
>> >> >> > Microsoft SQL 2005 so think I have it installed.
>> >> >>
>> >> >> That could still only be the client tools.
>> >> >>
>> >> >> Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
>> >> >> Server", or both?
>> >> >>
>> >> >> A
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Hi, looks like for some reason the upgrade was blocked as I found the message
below during an installation attempt of the database engine. Also since this
is an upgrade wondering if it will remove sql 2000 or allow both to reside
and run on the same machine?
Name: Microsoft SQL Server 2000
Reason: Your upgrade is blocked. For more information about upgrade support,
see the "Version and Edition Upgrades" and "Hardware and Software
Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
Online.
--
Paul G
Software engineer.
"Tibor Karaszi" wrote:
> > Do you know if I can install the
> > 2005 SQL Server agent without effecting the 2000 server agent as I have
> > several jobs scheduled?
> Yes. Install another SQL Server Database Engine instance. Each Database Engine comes with Agent.
>
> >Also looks like I do not have the database engine
> > installed 2005 as you noted. Does this come with the SQL Server 2005
> > Developer edition (guessing it does) and can it be installed along with the
> > 2000 database engine without effecting the 2000 instance?
> Yep. As per above, just install a new database engine instance.
>
> >If so not sure why
> > it was not installed, guess I may have not selected the proper installation
> > option.
> That would be my guess as well.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:43AF09FA-ED81-45F2-98F4-E25C64C70927@.microsoft.com...
> > Hi thanks for the additional information. Do you know if I can install the
> > 2005 SQL Server agent without effecting the 2000 server agent as I have
> > several jobs scheduled? Also looks like I do not have the database engine
> > installed 2005 as you noted. Does this come with the SQL Server 2005
> > Developer edition (guessing it does) and can it be installed along with the
> > 2000 database engine without effecting the 2000 instance? If so not sure why
> > it was not installed, guess I may have not selected the proper installation
> > option.
> > --
> > Paul G
> > Software engineer.
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> The services with the long names are 2005 services. So, it seems you have a lot of 2005 stuff
> >> installed, *except* the database engine (and Agent). I.e., below are 2000 or 7.0 (based on the
> >> service name):
> >>
> >> MSSQLSERVER
> >> SQLSERVERAGENT
> >>
> >> (In 2005, a service has both a long name and a short name. However, the tools you use will
> >> present
> >> the long name.)
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> >> news:D2E27CD8-2D39-4E97-B954-8D9C9B64488B@.microsoft.com...
> >> > Hi here is what I have listed in the services section from the control panel,
> >> > SQL Server (SQLEXPRESS)-probably should remove this
> >> > SQL Server Active Directory Helper
> >> > SQL Server Analysis Services (MSSQLSERVER)
> >> > SQL Server Browser
> >> > SQL Server Integration Services
> >> > SQL Server Reporting Services (MSSQLSERVER)
> >> > SQL Server VSS Writer
> >> > MSSQLSERVER
> >> > SQLSERVERAGENT
> >> > I did not see a SQL Server by itself. Guess it does not specify the year
> >> > just from the service listing. Does this look like only the client may be
> >> > installed? Also I installed it off of the Visual Studio 2005 professional
> >> > addition, disk labeled SQL Server 2005 Developer edition. Thanks.
> >> >
> >> > --
> >> > Paul G
> >> > Software engineer.
> >> >
> >> >
> >> > "Aaron Bertrand [SQL Server MVP]" wrote:
> >> >
> >> >> > Thanks for the information, I looked at the programs installed it lists
> >> >> > Microsoft SQL 2005 so think I have it installed.
> >> >>
> >> >> That could still only be the client tools.
> >> >>
> >> >> Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
> >> >> Server", or both?
> >> >>
> >> >> A
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||> Hi, looks like for some reason the upgrade was blocked as I found the
> message
> below during an installation attempt of the database engine. Also since
> this
> is an upgrade wondering if it will remove sql 2000 or allow both to reside
> and run on the same machine?
An upgrade will replace SQL Server 2000. Of you want to keep both, then
DON'T RUN AN UPGRADE.
A|||thanks for the information. We have several SQL 2000 licenses not being used
so guess I could install virtual pc on the machine and then install SQL2000
followed by SQL2005.
--
Paul G
Software engineer.
"Aaron Bertrand [SQL Server MVP]" wrote:
> > Hi, looks like for some reason the upgrade was blocked as I found the
> > message
> > below during an installation attempt of the database engine. Also since
> > this
> > is an upgrade wondering if it will remove sql 2000 or allow both to reside
> > and run on the same machine?
> An upgrade will replace SQL Server 2000. Of you want to keep both, then
> DON'T RUN AN UPGRADE.
> A
>
>|||> Also since this
> is an upgrade wondering if it will remove sql 2000 or allow both to reside
> and run on the same machine?
If you specify the same instance as your 2000 instance, it will upgrade. If you specify a new
instance name, it will leave the 2000 instance alone.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:5BAC66BC-D95B-4B8F-985F-94F18D19A115@.microsoft.com...
> Hi, looks like for some reason the upgrade was blocked as I found the message
> below during an installation attempt of the database engine. Also since this
> is an upgrade wondering if it will remove sql 2000 or allow both to reside
> and run on the same machine?
> Name: Microsoft SQL Server 2000
> Reason: Your upgrade is blocked. For more information about upgrade support,
> see the "Version and Edition Upgrades" and "Hardware and Software
> Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
> Online.
> --
> Paul G
> Software engineer.
>
> "Tibor Karaszi" wrote:
>> > Do you know if I can install the
>> > 2005 SQL Server agent without effecting the 2000 server agent as I have
>> > several jobs scheduled?
>> Yes. Install another SQL Server Database Engine instance. Each Database Engine comes with Agent.
>>
>> >Also looks like I do not have the database engine
>> > installed 2005 as you noted. Does this come with the SQL Server 2005
>> > Developer edition (guessing it does) and can it be installed along with the
>> > 2000 database engine without effecting the 2000 instance?
>> Yep. As per above, just install a new database engine instance.
>>
>> >If so not sure why
>> > it was not installed, guess I may have not selected the proper installation
>> > option.
>> That would be my guess as well.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:43AF09FA-ED81-45F2-98F4-E25C64C70927@.microsoft.com...
>> > Hi thanks for the additional information. Do you know if I can install the
>> > 2005 SQL Server agent without effecting the 2000 server agent as I have
>> > several jobs scheduled? Also looks like I do not have the database engine
>> > installed 2005 as you noted. Does this come with the SQL Server 2005
>> > Developer edition (guessing it does) and can it be installed along with the
>> > 2000 database engine without effecting the 2000 instance? If so not sure why
>> > it was not installed, guess I may have not selected the proper installation
>> > option.
>> > --
>> > Paul G
>> > Software engineer.
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> The services with the long names are 2005 services. So, it seems you have a lot of 2005 stuff
>> >> installed, *except* the database engine (and Agent). I.e., below are 2000 or 7.0 (based on the
>> >> service name):
>> >>
>> >> MSSQLSERVER
>> >> SQLSERVERAGENT
>> >>
>> >> (In 2005, a service has both a long name and a short name. However, the tools you use will
>> >> present
>> >> the long name.)
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> >> news:D2E27CD8-2D39-4E97-B954-8D9C9B64488B@.microsoft.com...
>> >> > Hi here is what I have listed in the services section from the control panel,
>> >> > SQL Server (SQLEXPRESS)-probably should remove this
>> >> > SQL Server Active Directory Helper
>> >> > SQL Server Analysis Services (MSSQLSERVER)
>> >> > SQL Server Browser
>> >> > SQL Server Integration Services
>> >> > SQL Server Reporting Services (MSSQLSERVER)
>> >> > SQL Server VSS Writer
>> >> > MSSQLSERVER
>> >> > SQLSERVERAGENT
>> >> > I did not see a SQL Server by itself. Guess it does not specify the year
>> >> > just from the service listing. Does this look like only the client may be
>> >> > installed? Also I installed it off of the Visual Studio 2005 professional
>> >> > addition, disk labeled SQL Server 2005 Developer edition. Thanks.
>> >> >
>> >> > --
>> >> > Paul G
>> >> > Software engineer.
>> >> >
>> >> >
>> >> > "Aaron Bertrand [SQL Server MVP]" wrote:
>> >> >
>> >> >> > Thanks for the information, I looked at the programs installed it lists
>> >> >> > Microsoft SQL 2005 so think I have it installed.
>> >> >>
>> >> >> That could still only be the client tools.
>> >> >>
>> >> >> Look at the services that are running. Is "MSSQLSERVER" listed, or "SQL
>> >> >> Server", or both?
>> >> >>
>> >> >> A
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

2005 features not working

2005 Express Edition CREATE statement issues

Hello everyone,

i am using the Express Edition to build an application which requires rather large databases to store binary documents. I've been experiencing weird behaviour with the Express Edition on Vista and XP running the following CREATE statement:

Code Snippet

USE master;
GO
CREATE DATABASE [document_archive]
ON PRIMARY
( NAME='document_archive_Primary',
FILENAME='D:\Data\document_archive.mdf',
SIZE=32MB,
MAXSIZE=1536MB,
FILEGROWTH=10%)
LOG ON
( NAME='document_archive_Log',
FILENAME = 'D:\Data\document_archive.ldf',
SIZE=8MB,
MAXSIZE=64MB,
FILEGROWTH=10%);
GO

The server is telling me that everything went ok but the database doesent show up in the TreeView, nor it is accessible. Retrying to execute the script i cought an error telling me that the database couldnt be created because of existing files, which is the behaviour Id expect.

I dropped the database and went testing the script on a SQL 2000 Server Enterprise Edition which worked as expected, immediately showing up in the TreeView.

As far i remember the 2005 Express Edition can handle databases up to 2GB (or maybe 5GB? Dont remember exactly).

I am having a hard time to figure out what might cause the weird behaviour.

However, heres the system specs of the two 2005 Express installations:

Box#1: Vista RC1

Box#2: XP SP 2

Both running SQL Server 2005 Express Edition SP2, installed on 'C:\Program Files\Microsoft SQL Server', having tons of free disk space and spare resources to handle this CREATE statement and requests.

Any hint that might help solve my issue would be greatly appreciated

Many thanks in advance,

Yours,

trahho.

How are running this script?

When you run the script above, can you immediately run a select * from sys.databases and see if your database is listed.

The DB limit for Express is 4gb so there is not a problem there.

Tuesday, March 20, 2012

3 questions

Sunday, March 11, 2012

2GB Limit

2G limit in MSDE

Thursday, March 8, 2012

24 - 7 and the need for maintainence

Tuesday, March 6, 2012

2005/2000 question!

Friday, February 24, 2012

2005 selected databas monitoring - how?

2005 selected databas monitoring - how?

2005 selected databas monitoring - how?

2005 selected databas monitoring - how?

Monday, February 13, 2012

2005 features not working

2005 features not working

2005 features not working

2005 Express Edition CREATE statement issues

SQL Remove Old Backups

Blog Archive

About Me