MSDB database restore: system

Showing posts with label system. Show all posts

Friday, March 30, 2012

MSDE along side WMSDE?

I've got a situation where WSUS is already installed on a server and I'm
looking
at moving my anti-virus system on to the same server, however my AV uses
MSDE. The server is running 2003 and therefore WSUS is running in WMSDE.
I take it I can't use WMSDE for my AV solution so I'd like to know, is it
viable to simply install MSDE 2000 along side WMSDE, or will I have to move
WSUS out of WMSDE and into MSDE 2000?
I assume I'll have some conflicts at minimum with the ports clashing if the
two live together, and there are likely to be other major problems.
Does anyone have any ideas or suggestions?
hi,
AC wrote:
> I've got a situation where WSUS is already installed on a server and
> I'm looking
> at moving my anti-virus system on to the same server, however my AV
> uses MSDE. The server is running 2003 and therefore WSUS is running
> in WMSDE.
> I take it I can't use WMSDE for my AV solution so I'd like to know,
> is it viable to simply install MSDE 2000 along side WMSDE, or will I
> have to move WSUS out of WMSDE and into MSDE 2000?
> I assume I'll have some conflicts at minimum with the ports clashing
> if the two live together, and there are likely to be other major
> problems.
> Does anyone have any ideas or suggestions?
WMSDE should not be used for other means then the ones it has been released
for, so just install another instance of MSDE for your AV...
you'll have no "ports clashing" or conflicts, as SQL Server 2000 allows up
to 16 instances to be locally installed...
only one of them can be the "default" instance, litening (by default) on
TCP/IP 1433 where all other instances have to be named instances, where
their full name is composed by the ComputerName\InstanceName...
you can leave for all of them the default "dynamically assigned port"
setting, an additional service, the SQL Server Resolution Service is then
listening on UDP 1434 to resolve and address the correct named instance on
it's appropriate port..
if you manually set the TCP/IP port the named instance(s) will be listen on,
you can close (on your firewall) the UDP 1434 port as it is no longer
needed, but you'll probably need to specify an ALIAS (via Client Network
Utility, cliconfg.exe) on all your remote clients..
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
|||Thank you very much for your reply Andrea.
Although I've seen installations with several MSDE instances before I never
thought about how they worked untill now, therefore I've never even realised
there is a manager service to resolve the ports for each service!
Thank you for enlightening to this!
"Andrea Montanari" wrote:

> hi,
> AC wrote:
> WMSDE should not be used for other means then the ones it has been released
> for, so just install another instance of MSDE for your AV...
> you'll have no "ports clashing" or conflicts, as SQL Server 2000 allows up
> to 16 instances to be locally installed...
> only one of them can be the "default" instance, litening (by default) on
> TCP/IP 1433 where all other instances have to be named instances, where
> their full name is composed by the ComputerName\InstanceName...
> you can leave for all of them the default "dynamically assigned port"
> setting, an additional service, the SQL Server Resolution Service is then
> listening on UDP 1434 to resolve and address the correct named instance on
> it's appropriate port..
> if you manually set the TCP/IP port the named instance(s) will be listen on,
> you can close (on your firewall) the UDP 1434 port as it is no longer
> needed, but you'll probably need to specify an ALIAS (via Client Network
> Utility, cliconfg.exe) on all your remote clients..
> --
> 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
>
>
sql

Wednesday, March 28, 2012

MSDE 2000 vs SQL express 2005 ??

Dear all,
We are starting a new developmement of our supervisiob system that will run
uner vista and we will use VS 2005 as a development platform ..
Based on that we need to select proper local database for our local data
archiving.
For that I will certainly us SQL express advance feature edition but some
say that there are connection limitation ?
As far as Icould read around, the only limitation there is is the 4GB
database sizte, 1 single processore handling, and 1GB of RAm for cachin
querries.
I did not get answer that sql express as a limitation in connection, is
there ?
Next I have heard also as an SQL personnal edition version.. Is it the MSDE
base on 2000 ? if its the case then it is not supported under Vista, si my
choice will be explain clearly then..
Thnaks for clarification and comments .
Regards
Serge
MCAD.NET
Thanks andrea, its clear now
"Andrea Montanari" wrote:

> hi Serge,
> calderara wrote:
> then you can only go for SQLExpress sp2 (not yet released)..
>
> tere aren't.. SQLExpress (as MSDE as well) does not include a component to
> limit connections.. it is limited as you already noticed..
> nope
>
> SQL Server Personal edition is based on SQL Server 2000 code base..
> regards
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>
>
|||Hello,
Perhaps you should also look "out-of-the-box" and take a look at some other
free database systems that do not impose these ridiculous limits such as
1cpu and no SQL Agent.
Primarily, PostgreSQL and Firebird.
"calderara" <calderara@.discussions.microsoft.com> wrote in message
news:49AE1207-0D8F-4166-8B8E-7FF970F39212@.microsoft.com...[vbcol=seagreen]
> Thanks andrea, its clear now
> "Andrea Montanari" wrote:

MSDE 2000 to MSDE 2000 Replication?

Hi,
I would like to know if I can do Replication from a MSDE 2000 to another
MSDE 2000 system (one way).
All I need to do is Sync Server database changes on to a Workstation
database(Real-Time).
Let me give an example.
We have Server and Workstation product. Our Server will have a LiveConfig db
and each workstation will have a localLookupDB(basically same as
LiveConfig). I know If I have the Server as Std SQL Server 2000 I can use
Replication to propogate changes onto workstation what if the Server is
MSDE?
Are there any ways to Replicate data From a Server database onto Workstation
database (Real-Time).
Your advice is appreciated.
Thanks
Arun
hi Arun,
Arun Kumar wrote:
> Hi,
> I would like to know if I can do Replication from a MSDE 2000 to
> another MSDE 2000 system (one way).
> All I need to do is Sync Server database changes on to a Workstation
> database(Real-Time).
> Let me give an example.
> We have Server and Workstation product. Our Server will have a
> LiveConfig db and each workstation will have a
> localLookupDB(basically same as LiveConfig). I know If I have the
> Server as Std SQL Server 2000 I can use Replication to propogate
> changes onto workstation what if the Server is MSDE?
> Are there any ways to Replicate data From a Server database onto
> Workstation database (Real-Time).
>
MSDE supports both snapshot and merge replication both as publisher and as
subcriber, so your potential design could be supported... but remember that
replication is non just one way (publisher to subscriber(s)) but the sync
goes both ways ( subscriber to publisher to other subscriber(s)) to
propagate modification at all levels..
I'm not a replication guy but I do not think "real-time" replication is that
suitable as a certain degree of latency should be expected in order not to
overhelm all the servers with replication schedules and related activity,
that, depending on the amount of the involved data, can be time consuming..
merge replication can be indicated if the data load per scheduled timeframe
is not very very high, but it supports simultaneous data entry on all
servers (per server autonomy, so tthat each individual instance can continue
it's own work in case of net problems), continuos data transfer.. you can
even take care of conflicts providing your own preferred conflicts
resolution policy, but you have to do it your own via DMO and/or scripts as
MSDE is not provided with Enterprise Manager which has built-in tools and
wizards for configuring and troubleshooting replication... anyway, merge
replication, provides an out of the box mechanism for resolving conflicts at
the column level and high transactional consistency of operations in case of
low conflicts rates and few sites involved.. the more autonoms servers are
involved, the more heavy load will the scenario introduce...
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
|||Andrea,
Thanks for the reply. I agree with the latency, but Can you suggest me any
other way.
Here's my idea
Workstations user enters the data and the Business layer on the Server will
insert/update those records on the LiveConfig Server database using Stored
procedures.
My idea is use add insert/Update statement into the same stored procedure to
insert/update other Workstation Databases. When we configure the Workstation
Database we add the Workstation Server/Database name onto one of the tables
in LiveConfig Server Database table.
Here's how i envision, correct me if I am wrong.
User enters data -> Business Layer ->
->Stored Procedure -- >(Inside str proc)
Call StoredProcedure Insert/Update, MainServer,MainDatabase
Select WorkstationServer,WorkstationDBName From
MainServer.MainDatabase.DBTable
If found THEN
Begin
Use Cursors
While Not MainServer.MainDatabase.DBTable.Eof
Begin
StoredProcedure Insert/Update,
WorkstationServer,Database
End
End
Do you think this method will work? any drawbacks on this?
I know the above statement is not a real SQL Statements its just a concept.
Let me know your comments.
Thanks
Arun
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3n0q38F18covhU1@.individual.net...
> hi Arun,
> Arun Kumar wrote:
> MSDE supports both snapshot and merge replication both as publisher and as
> subcriber, so your potential design could be supported... but remember
> that replication is non just one way (publisher to subscriber(s)) but the
> sync goes both ways ( subscriber to publisher to other subscriber(s)) to
> propagate modification at all levels..
> I'm not a replication guy but I do not think "real-time" replication is
> that suitable as a certain degree of latency should be expected in order
> not to overhelm all the servers with replication schedules and related
> activity, that, depending on the amount of the involved data, can be time
> consuming..
> merge replication can be indicated if the data load per scheduled
> timeframe is not very very high, but it supports simultaneous data entry
> on all servers (per server autonomy, so tthat each individual instance can
> continue it's own work in case of net problems), continuos data transfer..
> you can even take care of conflicts providing your own preferred conflicts
> resolution policy, but you have to do it your own via DMO and/or scripts
> as MSDE is not provided with Enterprise Manager which has built-in tools
> and wizards for configuring and troubleshooting replication... anyway,
> merge replication, provides an out of the box mechanism for resolving
> conflicts at the column level and high transactional consistency of
> operations in case of low conflicts rates and few sites involved.. the
> more autonoms servers are involved, the more heavy load will the scenario
> introduce...
> --
> 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 Arun,
Arun Kumar wrote:
> Andrea,
> Thanks for the reply. I agree with the latency, but Can you suggest
> me any other way.
> Here's my idea
> Workstations user enters the data and the Business layer on the
> Server will insert/update those records on the LiveConfig Server
> database using Stored procedures.
> My idea is use add insert/Update statement into the same stored
> procedure to insert/update other Workstation Databases. When we
> configure the Workstation Database we add the Workstation
> Server/Database name onto one of the tables in LiveConfig Server
> Database table. Here's how i envision, correct me if I am wrong.
> User enters data -> Business Layer ->
> ->Stored Procedure -- >(Inside str proc)
> Call StoredProcedure Insert/Update, MainServer,MainDatabase
> Select WorkstationServer,WorkstationDBName From
> MainServer.MainDatabase.DBTable
> If found THEN
> Begin
> Use Cursors
> While Not MainServer.MainDatabase.DBTable.Eof
> Begin
> StoredProcedure Insert/Update,
> WorkstationServer,Database
> End
> End
> Do you think this method will work? any drawbacks on this?
> I know the above statement is not a real SQL Statements its just a
> concept.
ok, this pseudo code will actually be in your business layer and not in
Transact-SQL stored procedure code...
so you cycle in the "pseudo Registered servers" table you populate from your
SELECT s.WorkstationServer, s.WorkstationDBName FROM dbo.DBTable s
connect to that specified instance (and appropriate database) in the loop
and re-execute the stored procedure...
this is a lot of work and can be very time consuming for a large number of
servers... more, I hope that a rollback in an inner loop server will not
break the whole transaction requiring to rollback on all other servers :D
(how do you handle later sync in case of out of sync situations will
probably become a nightmare)
but if all your clients connects to the master , why do you need local sync?
can you not rely on scheduled (weekly, dayly, twice a day, ...) sync via a
set of SQL Server Agent jobs to send all workstation a sort of sync via
standard INSERT INTO ... DDL scripts you can create via simple queryes on
your live db?
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
|||Well, the problem is our product is a Real-Time Application talking to
hardware. Depending on the time of the day, the transactions from the
hardware will vary, not all workstations need to be synced. Our Host
App(Real-Time) talking to hardware can installed on Workstations, so it
needs a local lookup database of names, configurations and settings which
should go down the hardware. I only need a Local Lookup database of that
application. Users will update or add new hardware records from their
station which will be inserted into the Main Server DB and it should be
picked up by the Host App within few seconds or max 10-20 seconds.
Typical setup will be:
Server --> Master DB
- Workstation 1
- Workstation 2 with Host App (need a Local LookUp db)
- Workstation 3 with Host App (need a Local LookUp db)
I hope I explained my situation.
Thanks
Arun
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3n12msF194jhfU1@.individual.net...
> hi Arun,
> Arun Kumar wrote:
> ok, this pseudo code will actually be in your business layer and not in
> Transact-SQL stored procedure code...
> so you cycle in the "pseudo Registered servers" table you populate from
> your
> SELECT s.WorkstationServer, s.WorkstationDBName FROM dbo.DBTable s
> connect to that specified instance (and appropriate database) in the loop
> and re-execute the stored procedure...
> this is a lot of work and can be very time consuming for a large number of
> servers... more, I hope that a rollback in an inner loop server will not
> break the whole transaction requiring to rollback on all other servers :D
> (how do you handle later sync in case of out of sync situations will
> probably become a nightmare)
> but if all your clients connects to the master , why do you need local
> sync?
> can you not rely on scheduled (weekly, dayly, twice a day, ...) sync via a
> set of SQL Server Agent jobs to send all workstation a sort of sync via
> standard INSERT INTO ... DDL scripts you can create via simple queryes on
> your live db?
> --
> 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,
Arun Kumar wrote:
> Well, the problem is our product is a Real-Time Application talking to
> hardware. Depending on the time of the day, the transactions from the
> hardware will vary, not all workstations need to be synced. Our Host
> App(Real-Time) talking to hardware can installed on Workstations, so
> it needs a local lookup database of names, configurations and
> settings which should go down the hardware. I only need a Local
> Lookup database of that application. Users will update or add new
> hardware records from their station which will be inserted into the
> Main Server DB and it should be picked up by the Host App within few
> seconds or max 10-20 seconds.
> Typical setup will be:
> Server --> Master DB
> - Workstation 1
> - Workstation 2 with Host App (need a Local LookUp db)
> - Workstation 3 with Host App (need a Local LookUp db)
> I hope I explained my situation.
real time applications are hard to manage by them selves, and you are adding
a layer of complexity that's not that little..
replicating data across a sytem requires time and cpu, and real time
requirements do usually not provide them...
plan carefully and test your scenario... with lot of active subscriber you
can get deep in trouble...
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
|||Andrea,
I agree that for real-time its tough to maintain. I have come up with
another idea I don't if its the best idea let me know your comments on it.
Server -> Main Database
Workstation ->Lookup database
I thought of creating a utility NT Service Synchronizer (Btw Main<-->Lookup)
which will be installed on each workstation and will poll the main server
for updates on a timely basis(adjustable).
What do you think of this?
Thanks
Arun
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3n3fp1F10cej4U1@.individual.net...
> hi,
> Arun Kumar wrote:
> real time applications are hard to manage by them selves, and you are
> adding a layer of complexity that's not that little..
> replicating data across a sytem requires time and cpu, and real time
> requirements do usually not provide them...
> plan carefully and test your scenario... with lot of active subscriber you
> can get deep in trouble...
> --
> 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 Arun
Arun Kumar wrote:
> Andrea,
> I agree that for real-time its tough to maintain. I have come up with
> another idea I don't if its the best idea let me know your comments
> on it. Server -> Main Database
> Workstation ->Lookup database
> I thought of creating a utility NT Service Synchronizer (Btw
> Main<-->Lookup) which will be installed on each workstation and will
> poll the main server for updates on a timely basis(adjustable).
> What do you think of this?
just another home made replication... perhaps you've better use a
traditional supported one and adjust (as required/supported) your
scheduling...
my $0.02
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
|||Thanks for your comment.
I will see what's best way to go keeping all options open.
Thanks
Arun
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3n63etF1sb8U1@.individual.net...
> hi Arun
> Arun Kumar wrote:
> just another home made replication... perhaps you've better use a
> traditional supported one and adjust (as required/supported) your
> scheduling...
> my $0.02
> --
> 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
>

Friday, March 23, 2012

MSDE 2000 install on W2K3 64bit

I'm trying to install MSDE 2000 on an Itanium system running 64bit Windows
2003 Server. The install fails and the eventviewer shows:
Product: Microsoft SQL Server Desktop Engine -- Setup failed to configure
the server. Refer to the server error logs and setup error logs for more
information.
The install log contains:
2004-10-22 10:13:31.65 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: )
2004-10-22 10:13:31.66 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-10-22 10:13:31.66 server All rights reserved.
2004-10-22 10:13:31.66 server Server Process ID is 3944.
2004-10-22 10:13:31.66 server Logging SQL Server messages in file
'C:\Program Files (x86)\Microsoft SQL Server\MSSQL$BE_DLO\LOG\ERRORLOG'.
2004-10-22 10:13:31.68 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2004-10-22 10:13:31.89 server SQL Server configured for thread mode
processing.
2004-10-22 10:13:31.89 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2004-10-22 10:13:31.98 spid4 Warning ******************
2004-10-22 10:13:31.98 spid4 SQL Server started in single user mode.
Updates allowed to system catalogs.
2004-10-22 10:13:32.01 spid4 Starting up database 'master'.
2004-10-22 10:13:32.15 spid4 Error: 823, Severity: 24, State: 2.
2004-10-22 10:13:32.19 spid4 Cannot recover the master database. Exiting.
Anyone know if this is related to:
http://support.microsoft.com/default...b;en-us;872768
Thanx,
Ernie Billing
VERITAS Software
ebilling@.veritas.com
I looked at the list of supported operating systems for MSDE and W2K3 Server
64 was not one of them.
Given that there is a special 64 bit version of SQL Server for this OS, I
would be surprised if MSDE installed on W2K3 Server 64.
Jim
"Ernie Billing" <Ernie Billing@.discussions.microsoft.com> wrote in message
news:41F181D1-5632-4A16-9287-809A30087B97@.microsoft.com...
> I'm trying to install MSDE 2000 on an Itanium system running 64bit Windows
> 2003 Server. The install fails and the eventviewer shows:
> Product: Microsoft SQL Server Desktop Engine -- Setup failed to configure
> the server. Refer to the server error logs and setup error logs for more
> information.
> The install log contains:
> 2004-10-22 10:13:31.65 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.2 (Build 3790: )
> 2004-10-22 10:13:31.66 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2004-10-22 10:13:31.66 server All rights reserved.
> 2004-10-22 10:13:31.66 server Server Process ID is 3944.
> 2004-10-22 10:13:31.66 server Logging SQL Server messages in file
> 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL$BE_DLO\LOG\ERRORLOG'.
> 2004-10-22 10:13:31.68 server SQL Server is starting at priority class
> 'normal'(2 CPUs detected).
> 2004-10-22 10:13:31.89 server SQL Server configured for thread mode
> processing.
> 2004-10-22 10:13:31.89 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2004-10-22 10:13:31.98 spid4 Warning ******************
> 2004-10-22 10:13:31.98 spid4 SQL Server started in single user mode.
> Updates allowed to system catalogs.
> 2004-10-22 10:13:32.01 spid4 Starting up database 'master'.
> 2004-10-22 10:13:32.15 spid4 Error: 823, Severity: 24, State: 2.
> 2004-10-22 10:13:32.19 spid4 Cannot recover the master database.
Exiting.
> Anyone know if this is related to:
> http://support.microsoft.com/default...b;en-us;872768
> Thanx,
> Ernie Billing
> VERITAS Software
> ebilling@.veritas.com

Monday, March 19, 2012

MSDE : find out what triggers are created

Hi
may i know is there anyway for me to find out from any system table in
MSDE what are the triggers that have been created ?
I wish to delete all and log in a new set of triggers, just in case
some old triggers cause some problems to the new ones.
Thank you
Best regards
Boon Yiang
Hi,
From OSQL Query the SYSOBJECTS table.
use <dbname>
go
Select name from sysobjects where xtype = 'tr'
Thanks
Hari
<chuaby@.hotmail.com> wrote in message
news:1174143091.658347.48080@.e65g2000hsc.googlegro ups.com...
> Hi
> may i know is there anyway for me to find out from any system table in
> MSDE what are the triggers that have been created ?
> I wish to delete all and log in a new set of triggers, just in case
> some old triggers cause some problems to the new ones.
> Thank you
> Best regards
> Boon Yiang
>

MSDE / SQL - SERVER

Dear all,
I have installed both environments on my system, running windows 2000.
When I start the SQL Enterprise Manager I can see 1 SQL Server Group,
containing two branches:
- (local) (windows nt) which contains the msde
- named instance which contains the sql server 2000
I have an application running in which I can make a selection between
servers. After installing sql server the servers running on my system are no
longer presented. My application still runs with the msde server if I type in
the name of the server but not with the sql server.
To check wehther the problem is caused by the application or not, I tried to
create a DSN (odbc data source) on my system. Because there the server is
also requested. When I click on the list box for the server no servers are
presented. When I type in the name I get an error message that the connection
failed.
sql server error: 1231
.....
sqlstate: '08001'
sql server error: 17
[microsoft][odbc sql server dirver][dbnetlib]sql server does not exist or
access denied
Because I did not see the servers available in the list box I the server
does not exist part of the message seems to match my problem. But looking
into the enterprise manager I have it up and running.
Has someone experienced this in the past and solved it. Can you share the
solution for this problem.
regards,
Danny Gaethofs
Dear all,
I have to rephrase my problem statement. After a bit of experimenting I am
able to get connected to both msde and sql server using my application.
However the problem I described that the servers are not shown in the list
box that opens for example when you create a data source remains.
Because this is a bit crucial when creating new connections can someone help
me out with this and explain why it is happening.
regards,
Danny Gaethofs
"Danny Gaethofs" wrote:

> Dear all,
> I have installed both environments on my system, running windows 2000.
> When I start the SQL Enterprise Manager I can see 1 SQL Server Group,
> containing two branches:
> - (local) (windows nt) which contains the msde
> - named instance which contains the sql server 2000
> I have an application running in which I can make a selection between
> servers. After installing sql server the servers running on my system are no
> longer presented. My application still runs with the msde server if I type in
> the name of the server but not with the sql server.
> To check wehther the problem is caused by the application or not, I tried to
> create a DSN (odbc data source) on my system. Because there the server is
> also requested. When I click on the list box for the server no servers are
> presented. When I type in the name I get an error message that the connection
> failed.
> sql server error: 1231
> ....
> sqlstate: '08001'
> sql server error: 17
> [microsoft][odbc sql server dirver][dbnetlib]sql server does not exist or
> access denied
> Because I did not see the servers available in the list box I the server
> does not exist part of the message seems to match my problem. But looking
> into the enterprise manager I have it up and running.
> Has someone experienced this in the past and solved it. Can you share the
> solution for this problem.
> regards,
> Danny Gaethofs
|||When you say "list box," what object are you referring to? I am assuming
this is the developement configuration. How will the architecture look when
you roll this out to your clients? Will they also have two SQL Server
installations on their workstations? Or, will there be an actual server and
then a local MSDE? Or, might there just be several server installations?
You can use the Client Configuration Utility to simulate the "names" of your
production servers but redirect them to each of the "instances" running in
your developement environment.
First, all SQL Server installations run as an "instance." There is the
default instance and up to 15 named instances on any given host. Or, you
can have 16 named instances. They all comprise the <host name>[\<instance
name>], with the default instance being NULL for the instance name. You can
map those, with the Client Configuration Utility, to just a virtual host
name if you wish.
If multiple instances are running on one server, then they can not all share
the same default 1433 port. The other instances can be configured for
specific ports or can be dynamically generated each time the instance is
restarted. If dynamic, then all of your users will have to be on the same
VLAN, the UDP 1434 port must not be blocked, and they must set their client
configuration to Dynamic Discovery for the port detection.
Hope this narrows down this list of issues for you.
Sincerely,
Anthony Thomas

"Danny Gaethofs" <DannyGaethofs@.discussions.microsoft.com> wrote in message
news:85A69D33-EFD8-4D8E-A908-34027B510269@.microsoft.com...
Dear all,
I have to rephrase my problem statement. After a bit of experimenting I am
able to get connected to both msde and sql server using my application.
However the problem I described that the servers are not shown in the list
box that opens for example when you create a data source remains.
Because this is a bit crucial when creating new connections can someone help
me out with this and explain why it is happening.
regards,
Danny Gaethofs
"Danny Gaethofs" wrote:

> Dear all,
> I have installed both environments on my system, running windows 2000.
> When I start the SQL Enterprise Manager I can see 1 SQL Server Group,
> containing two branches:
> - (local) (windows nt) which contains the msde
> - named instance which contains the sql server 2000
> I have an application running in which I can make a selection between
> servers. After installing sql server the servers running on my system are
no
> longer presented. My application still runs with the msde server if I type
in
> the name of the server but not with the sql server.
> To check wehther the problem is caused by the application or not, I tried
to
> create a DSN (odbc data source) on my system. Because there the server is
> also requested. When I click on the list box for the server no servers are
> presented. When I type in the name I get an error message that the
connection
> failed.
> sql server error: 1231
> ....
> sqlstate: '08001'
> sql server error: 17
> [microsoft][odbc sql server dirver][dbnetlib]sql server does not exist or
> access denied
> Because I did not see the servers available in the list box I the server
> does not exist part of the message seems to match my problem. But looking
> into the enterprise manager I have it up and running.
> Has someone experienced this in the past and solved it. Can you share the
> solution for this problem.
> regards,
> Danny Gaethofs
|||Dear all,
I have removed everything now, both MSDE and SQL Server. I reinstalled MSDE
only and when I try to create a ODBC DSN the system is not showing me the
available server at all.
Is there an explanation for this behavior and how can I solve it.
regards,
Danny
"AnthonyThomas" <Anthony.Thomas@.CommerceBank.com> schreef in bericht
news:uW3wrS43EHA.2012@.TK2MSFTNGP15.phx.gbl...
> When you say "list box," what object are you referring to? I am assuming
> this is the developement configuration. How will the architecture look
> when
> you roll this out to your clients? Will they also have two SQL Server
> installations on their workstations? Or, will there be an actual server
> and
> then a local MSDE? Or, might there just be several server installations?
> You can use the Client Configuration Utility to simulate the "names" of
> your
> production servers but redirect them to each of the "instances" running in
> your developement environment.
> First, all SQL Server installations run as an "instance." There is the
> default instance and up to 15 named instances on any given host. Or, you
> can have 16 named instances. They all comprise the <host name>[\<instance
> name>], with the default instance being NULL for the instance name. You
> can
> map those, with the Client Configuration Utility, to just a virtual host
> name if you wish.
> If multiple instances are running on one server, then they can not all
> share
> the same default 1433 port. The other instances can be configured for
> specific ports or can be dynamically generated each time the instance is
> restarted. If dynamic, then all of your users will have to be on the same
> VLAN, the UDP 1434 port must not be blocked, and they must set their
> client
> configuration to Dynamic Discovery for the port detection.
> Hope this narrows down this list of issues for you.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Danny Gaethofs" <DannyGaethofs@.discussions.microsoft.com> wrote in
> message
> news:85A69D33-EFD8-4D8E-A908-34027B510269@.microsoft.com...
> Dear all,
> I have to rephrase my problem statement. After a bit of experimenting I am
> able to get connected to both msde and sql server using my application.
> However the problem I described that the servers are not shown in the list
> box that opens for example when you create a data source remains.
> Because this is a bit crucial when creating new connections can someone
> help
> me out with this and explain why it is happening.
> regards,
> Danny Gaethofs
> "Danny Gaethofs" wrote:
> no
> in
> to
> connection
>
|||When you run the setup on a system that has or has had the server components
installed, in all likelihood, you have also installed the Client
Configuration utility. Once there, ODBC Administrator is limited as far as
its ability to search out installations. Use the Client Config tool to
define these and then ODBC Administrator to define DSN's on top of that. Be
careful though, because then you are likely forcing the overhead of using
ODBC on top OLEDB. That's just another API layer between you and the
database access.
I would consider using Data Links instead of DSN. These use the native
OLEDB API ans server a similar purpose, persisting the connection parameters
on the local machine. One way to create one quickly is to create a NEW TEXT
FILE, then rename it with the .udl extension. It will automatically be
changed to a Data Link file which can be managed by the Data Link
Administrator.
Sincerely,
Anthony Thomas

"Danny Gaethofs" <dangaet@.home.nl> wrote in message
news:OGKwFlP4EHA.2192@.TK2MSFTNGP14.phx.gbl...
Dear all,
I have removed everything now, both MSDE and SQL Server. I reinstalled MSDE
only and when I try to create a ODBC DSN the system is not showing me the
available server at all.
Is there an explanation for this behavior and how can I solve it.
regards,
Danny
"AnthonyThomas" <Anthony.Thomas@.CommerceBank.com> schreef in bericht
news:uW3wrS43EHA.2012@.TK2MSFTNGP15.phx.gbl...
> When you say "list box," what object are you referring to? I am assuming
> this is the developement configuration. How will the architecture look
> when
> you roll this out to your clients? Will they also have two SQL Server
> installations on their workstations? Or, will there be an actual server
> and
> then a local MSDE? Or, might there just be several server installations?
> You can use the Client Configuration Utility to simulate the "names" of
> your
> production servers but redirect them to each of the "instances" running in
> your developement environment.
> First, all SQL Server installations run as an "instance." There is the
> default instance and up to 15 named instances on any given host. Or, you
> can have 16 named instances. They all comprise the <host name>[\<instance
> name>], with the default instance being NULL for the instance name. You
> can
> map those, with the Client Configuration Utility, to just a virtual host
> name if you wish.
> If multiple instances are running on one server, then they can not all
> share
> the same default 1433 port. The other instances can be configured for
> specific ports or can be dynamically generated each time the instance is
> restarted. If dynamic, then all of your users will have to be on the same
> VLAN, the UDP 1434 port must not be blocked, and they must set their
> client
> configuration to Dynamic Discovery for the port detection.
> Hope this narrows down this list of issues for you.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Danny Gaethofs" <DannyGaethofs@.discussions.microsoft.com> wrote in
> message
> news:85A69D33-EFD8-4D8E-A908-34027B510269@.microsoft.com...
> Dear all,
> I have to rephrase my problem statement. After a bit of experimenting I am
> able to get connected to both msde and sql server using my application.
> However the problem I described that the servers are not shown in the list
> box that opens for example when you create a data source remains.
> Because this is a bit crucial when creating new connections can someone
> help
> me out with this and explain why it is happening.
> regards,
> Danny Gaethofs
> "Danny Gaethofs" wrote:
> no
> in
> to
> connection
>

MSDE / SQL - SERVER

Dear all,
I have installed both environments on my system, running windows 2000.
When I start the SQL Enterprise Manager I can see 1 SQL Server Group,
containing two branches:
- (local) (windows nt) which contains the msde
- named instance which contains the sql server 2000
I have an application running in which I can make a selection between
servers. After installing sql server the servers running on my system are no
longer presented. My application still runs with the msde server if I type in
the name of the server but not with the sql server.
To check wehther the problem is caused by the application or not, I tried to
create a DSN (odbc data source) on my system. Because there the server is
also requested. When I click on the list box for the server no servers are
presented. When I type in the name I get an error message that the connection
failed.
sql server error: 1231
....
sqlstate: '08001'
sql server error: 17
[microsoft][odbc sql server dirver][dbnetlib]sql server does not exist or
access denied
Because I did not see the servers available in the list box I the server
does not exist part of the message seems to match my problem. But looking
into the enterprise manager I have it up and running.
Has someone experienced this in the past and solved it. Can you share the
solution for this problem.
regards,
Danny GaethofsDear all,
I have to rephrase my problem statement. After a bit of experimenting I am
able to get connected to both msde and sql server using my application.
However the problem I described that the servers are not shown in the list
box that opens for example when you create a data source remains.
Because this is a bit crucial when creating new connections can someone help
me out with this and explain why it is happening.
regards,
Danny Gaethofs
"Danny Gaethofs" wrote:
> Dear all,
> I have installed both environments on my system, running windows 2000.
> When I start the SQL Enterprise Manager I can see 1 SQL Server Group,
> containing two branches:
> - (local) (windows nt) which contains the msde
> - named instance which contains the sql server 2000
> I have an application running in which I can make a selection between
> servers. After installing sql server the servers running on my system are no
> longer presented. My application still runs with the msde server if I type in
> the name of the server but not with the sql server.
> To check wehther the problem is caused by the application or not, I tried to
> create a DSN (odbc data source) on my system. Because there the server is
> also requested. When I click on the list box for the server no servers are
> presented. When I type in the name I get an error message that the connection
> failed.
> sql server error: 1231
> ....
> sqlstate: '08001'
> sql server error: 17
> [microsoft][odbc sql server dirver][dbnetlib]sql server does not exist or
> access denied
> Because I did not see the servers available in the list box I the server
> does not exist part of the message seems to match my problem. But looking
> into the enterprise manager I have it up and running.
> Has someone experienced this in the past and solved it. Can you share the
> solution for this problem.
> regards,
> Danny Gaethofs|||When you say "list box," what object are you referring to? I am assuming
this is the developement configuration. How will the architecture look when
you roll this out to your clients? Will they also have two SQL Server
installations on their workstations? Or, will there be an actual server and
then a local MSDE? Or, might there just be several server installations?
You can use the Client Configuration Utility to simulate the "names" of your
production servers but redirect them to each of the "instances" running in
your developement environment.
First, all SQL Server installations run as an "instance." There is the
default instance and up to 15 named instances on any given host. Or, you
can have 16 named instances. They all comprise the <host name>[\<instance
name>], with the default instance being NULL for the instance name. You can
map those, with the Client Configuration Utility, to just a virtual host
name if you wish.
If multiple instances are running on one server, then they can not all share
the same default 1433 port. The other instances can be configured for
specific ports or can be dynamically generated each time the instance is
restarted. If dynamic, then all of your users will have to be on the same
VLAN, the UDP 1434 port must not be blocked, and they must set their client
configuration to Dynamic Discovery for the port detection.
Hope this narrows down this list of issues for you.
Sincerely,
Anthony Thomas
"Danny Gaethofs" <DannyGaethofs@.discussions.microsoft.com> wrote in message
news:85A69D33-EFD8-4D8E-A908-34027B510269@.microsoft.com...
Dear all,
I have to rephrase my problem statement. After a bit of experimenting I am
able to get connected to both msde and sql server using my application.
However the problem I described that the servers are not shown in the list
box that opens for example when you create a data source remains.
Because this is a bit crucial when creating new connections can someone help
me out with this and explain why it is happening.
regards,
Danny Gaethofs
"Danny Gaethofs" wrote:
> Dear all,
> I have installed both environments on my system, running windows 2000.
> When I start the SQL Enterprise Manager I can see 1 SQL Server Group,
> containing two branches:
> - (local) (windows nt) which contains the msde
> - named instance which contains the sql server 2000
> I have an application running in which I can make a selection between
> servers. After installing sql server the servers running on my system are
no
> longer presented. My application still runs with the msde server if I type
in
> the name of the server but not with the sql server.
> To check wehther the problem is caused by the application or not, I tried
to
> create a DSN (odbc data source) on my system. Because there the server is
> also requested. When I click on the list box for the server no servers are
> presented. When I type in the name I get an error message that the
connection
> failed.
> sql server error: 1231
> ....
> sqlstate: '08001'
> sql server error: 17
> [microsoft][odbc sql server dirver][dbnetlib]sql server does not exist or
> access denied
> Because I did not see the servers available in the list box I the server
> does not exist part of the message seems to match my problem. But looking
> into the enterprise manager I have it up and running.
> Has someone experienced this in the past and solved it. Can you share the
> solution for this problem.
> regards,
> Danny Gaethofs|||Dear all,
I have removed everything now, both MSDE and SQL Server. I reinstalled MSDE
only and when I try to create a ODBC DSN the system is not showing me the
available server at all.
Is there an explanation for this behavior and how can I solve it.
regards,
Danny
"AnthonyThomas" <Anthony.Thomas@.CommerceBank.com> schreef in bericht
news:uW3wrS43EHA.2012@.TK2MSFTNGP15.phx.gbl...
> When you say "list box," what object are you referring to? I am assuming
> this is the developement configuration. How will the architecture look
> when
> you roll this out to your clients? Will they also have two SQL Server
> installations on their workstations? Or, will there be an actual server
> and
> then a local MSDE? Or, might there just be several server installations?
> You can use the Client Configuration Utility to simulate the "names" of
> your
> production servers but redirect them to each of the "instances" running in
> your developement environment.
> First, all SQL Server installations run as an "instance." There is the
> default instance and up to 15 named instances on any given host. Or, you
> can have 16 named instances. They all comprise the <host name>[\<instance
> name>], with the default instance being NULL for the instance name. You
> can
> map those, with the Client Configuration Utility, to just a virtual host
> name if you wish.
> If multiple instances are running on one server, then they can not all
> share
> the same default 1433 port. The other instances can be configured for
> specific ports or can be dynamically generated each time the instance is
> restarted. If dynamic, then all of your users will have to be on the same
> VLAN, the UDP 1434 port must not be blocked, and they must set their
> client
> configuration to Dynamic Discovery for the port detection.
> Hope this narrows down this list of issues for you.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Danny Gaethofs" <DannyGaethofs@.discussions.microsoft.com> wrote in
> message
> news:85A69D33-EFD8-4D8E-A908-34027B510269@.microsoft.com...
> Dear all,
> I have to rephrase my problem statement. After a bit of experimenting I am
> able to get connected to both msde and sql server using my application.
> However the problem I described that the servers are not shown in the list
> box that opens for example when you create a data source remains.
> Because this is a bit crucial when creating new connections can someone
> help
> me out with this and explain why it is happening.
> regards,
> Danny Gaethofs
> "Danny Gaethofs" wrote:
>> Dear all,
>> I have installed both environments on my system, running windows 2000.
>> When I start the SQL Enterprise Manager I can see 1 SQL Server Group,
>> containing two branches:
>> - (local) (windows nt) which contains the msde
>> - named instance which contains the sql server 2000
>> I have an application running in which I can make a selection between
>> servers. After installing sql server the servers running on my system are
> no
>> longer presented. My application still runs with the msde server if I
>> type
> in
>> the name of the server but not with the sql server.
>> To check wehther the problem is caused by the application or not, I tried
> to
>> create a DSN (odbc data source) on my system. Because there the server is
>> also requested. When I click on the list box for the server no servers
>> are
>> presented. When I type in the name I get an error message that the
> connection
>> failed.
>> sql server error: 1231
>> ....
>> sqlstate: '08001'
>> sql server error: 17
>> [microsoft][odbc sql server dirver][dbnetlib]sql server does not exist or
>> access denied
>> Because I did not see the servers available in the list box I the server
>> does not exist part of the message seems to match my problem. But looking
>> into the enterprise manager I have it up and running.
>> Has someone experienced this in the past and solved it. Can you share the
>> solution for this problem.
>> regards,
>> Danny Gaethofs
>|||When you run the setup on a system that has or has had the server components
installed, in all likelihood, you have also installed the Client
Configuration utility. Once there, ODBC Administrator is limited as far as
its ability to search out installations. Use the Client Config tool to
define these and then ODBC Administrator to define DSN's on top of that. Be
careful though, because then you are likely forcing the overhead of using
ODBC on top OLEDB. That's just another API layer between you and the
database access.
I would consider using Data Links instead of DSN. These use the native
OLEDB API ans server a similar purpose, persisting the connection parameters
on the local machine. One way to create one quickly is to create a NEW TEXT
FILE, then rename it with the .udl extension. It will automatically be
changed to a Data Link file which can be managed by the Data Link
Administrator.
Sincerely,
Anthony Thomas
"Danny Gaethofs" <dangaet@.home.nl> wrote in message
news:OGKwFlP4EHA.2192@.TK2MSFTNGP14.phx.gbl...
Dear all,
I have removed everything now, both MSDE and SQL Server. I reinstalled MSDE
only and when I try to create a ODBC DSN the system is not showing me the
available server at all.
Is there an explanation for this behavior and how can I solve it.
regards,
Danny
"AnthonyThomas" <Anthony.Thomas@.CommerceBank.com> schreef in bericht
news:uW3wrS43EHA.2012@.TK2MSFTNGP15.phx.gbl...
> When you say "list box," what object are you referring to? I am assuming
> this is the developement configuration. How will the architecture look
> when
> you roll this out to your clients? Will they also have two SQL Server
> installations on their workstations? Or, will there be an actual server
> and
> then a local MSDE? Or, might there just be several server installations?
> You can use the Client Configuration Utility to simulate the "names" of
> your
> production servers but redirect them to each of the "instances" running in
> your developement environment.
> First, all SQL Server installations run as an "instance." There is the
> default instance and up to 15 named instances on any given host. Or, you
> can have 16 named instances. They all comprise the <host name>[\<instance
> name>], with the default instance being NULL for the instance name. You
> can
> map those, with the Client Configuration Utility, to just a virtual host
> name if you wish.
> If multiple instances are running on one server, then they can not all
> share
> the same default 1433 port. The other instances can be configured for
> specific ports or can be dynamically generated each time the instance is
> restarted. If dynamic, then all of your users will have to be on the same
> VLAN, the UDP 1434 port must not be blocked, and they must set their
> client
> configuration to Dynamic Discovery for the port detection.
> Hope this narrows down this list of issues for you.
> Sincerely,
>
> Anthony Thomas
>
> --
> "Danny Gaethofs" <DannyGaethofs@.discussions.microsoft.com> wrote in
> message
> news:85A69D33-EFD8-4D8E-A908-34027B510269@.microsoft.com...
> Dear all,
> I have to rephrase my problem statement. After a bit of experimenting I am
> able to get connected to both msde and sql server using my application.
> However the problem I described that the servers are not shown in the list
> box that opens for example when you create a data source remains.
> Because this is a bit crucial when creating new connections can someone
> help
> me out with this and explain why it is happening.
> regards,
> Danny Gaethofs
> "Danny Gaethofs" wrote:
>> Dear all,
>> I have installed both environments on my system, running windows 2000.
>> When I start the SQL Enterprise Manager I can see 1 SQL Server Group,
>> containing two branches:
>> - (local) (windows nt) which contains the msde
>> - named instance which contains the sql server 2000
>> I have an application running in which I can make a selection between
>> servers. After installing sql server the servers running on my system are
> no
>> longer presented. My application still runs with the msde server if I
>> type
> in
>> the name of the server but not with the sql server.
>> To check wehther the problem is caused by the application or not, I tried
> to
>> create a DSN (odbc data source) on my system. Because there the server is
>> also requested. When I click on the list box for the server no servers
>> are
>> presented. When I type in the name I get an error message that the
> connection
>> failed.
>> sql server error: 1231
>> ....
>> sqlstate: '08001'
>> sql server error: 17
>> [microsoft][odbc sql server dirver][dbnetlib]sql server does not exist or
>> access denied
>> Because I did not see the servers available in the list box I the server
>> does not exist part of the message seems to match my problem. But looking
>> into the enterprise manager I have it up and running.
>> Has someone experienced this in the past and solved it. Can you share the
>> solution for this problem.
>> regards,
>> Danny Gaethofs
>

Monday, March 12, 2012

msde - uses too much memory and is getting very slow!

Juergen,
What else is this computer used for?
If only MSDE, then the system page file can be reduced to a minimum (or even
eliminated) -thereby reducing the memory 'pressure' on SQL Server (MSDE).
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eOxWF3zAHHA.996@.TK2MSFTNGP02.phx.gbl...
> hi newsgroup!
> we have already some msde databases installed and we didn't had any
> troubles until now!
> the OS is a Windows XP prof. SP2 with MSDE Version; msde desktop engine
> 8.00.7630SP3
> now our trouble is that the sqlserver.exe process is using more and more
> ram and the pagefile grows and grows!
> The PC (server) HP DL385 has 2 GB RAM so this shuldn't be the problem! So
> when the sqlserver.exe process is running about 2-3 days the amout of
> memory usages grows to 1,3GB and about this size the PC is realy getting
> slow, so you can't work anymore!
> The problem is solved when i start and stop the sqlserver, but this isn't
> how i will solve the problem!
> So does anyone have the some troubles, and does anybody now how to solve
> this problem?
> kind regards
> Juergen Strutzenberger
>
What has changed in the past short period of time? New VB.NET program?
Does the VB.NET program properly dispose of all connection objects created?
You may want to run performance monitor to discover what is using the cpu
cycles and the memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eaVNo1BBHHA.3396@.TK2MSFTNGP02.phx.gbl...
> we also run a selfe made programm, witch is programmed with VB.net!
> we already uninstalled some programs we didn't need!
> we also removed the Norton AV because we thought that this is using to
> much ressources and the pc is getting slow!
> bye
> juergen
> "Arnie Rowland" <arnie@.1568.com> schrieb im Newsbeitrag
> news:eSaidM1AHHA.4808@.TK2MSFTNGP03.phx.gbl...
>
|||What has changed in the past short period of time? New VB.NET program?
Does the VB.NET program properly dispose of all connection objects created?
You may want to run performance monitor to discover what is using the cpu
cycles and the memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eaVNo1BBHHA.3396@.TK2MSFTNGP02.phx.gbl...
> we also run a selfe made programm, witch is programmed with VB.net!
> we already uninstalled some programs we didn't need!
> we also removed the Norton AV because we thought that this is using to
> much ressources and the pc is getting slow!
> bye
> juergen
> "Arnie Rowland" <arnie@.1568.com> schrieb im Newsbeitrag
> news:eSaidM1AHHA.4808@.TK2MSFTNGP03.phx.gbl...
>
|||What has changed in the past short period of time? New VB.NET program?
Does the VB.NET program properly dispose of all connection objects created?
You may want to run performance monitor to discover what is using the cpu
cycles and the memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eaVNo1BBHHA.3396@.TK2MSFTNGP02.phx.gbl...
> we also run a selfe made programm, witch is programmed with VB.net!
> we already uninstalled some programs we didn't need!
> we also removed the Norton AV because we thought that this is using to
> much ressources and the pc is getting slow!
> bye
> juergen
> "Arnie Rowland" <arnie@.1568.com> schrieb im Newsbeitrag
> news:eSaidM1AHHA.4808@.TK2MSFTNGP03.phx.gbl...
>

Friday, March 9, 2012

Msde - Connecting To The Database

Hi,

I have installed MSDE into my system, in which SQL Server is not installed. I have followed the installation instructions and installed MSDE.
How can i connect to the database? I have the .MDF file of the database (already created in sqlserver) in the Data Folder. How can i connect to the database from Visual Basic 6?Check out the following download from microsoft. Note - It shows you 2 methods dao and ado - also, the objects are created using late binding - once you have decided what you are going to use, make sure to change this to early binding.
link (http://download.microsoft.com/download/vstudio60ent/Update/6/WIN98MeXP/EN-US/msde_vb6.exe)

MSDE - 17207, udopen: Operating system error 32(error not found) during the creation/openi

Hi there
I'm hoping somebody here can help with this problem. In the Application Event Viewer we're seeing a problem. The error message is below
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 17207, udopen: Operating system error 32(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf
Its promptly followed by this error
The description for Event ID ( 17055 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 17204, FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf for virtual device number (VDN) 1
The machine is running MSDE as its SQL Server and has two DBs
DB on D: which is 148,628k
DB on C: which is 237,568k
I'm pretty stuck on this one, so if anybody knows what's causing this problem, and more importantly how I can go about fixing it, it'd be most appreciated - I'm no SQL Guru and haven't been able to find a huge amount on knowledgebase searches or google searches
Thanks in anticipation
Steve S
stevesdmREMOVETHIS@.hotmail.comI dont know if this will help anyone, but the sql log shows this
2004-05-26 12:33:58.27 spid7 Starting up database 'Genifax'
2004-05-26 12:34:56.71 spid52 Starting up database 'Genifax'
2004-05-26 12:34:58.60 spid7 Starting up database 'Genifax'
2004-05-26 12:35:06.49 spid52 Starting up database 'Genifax'
2004-05-26 12:35:28.27 spid7 Starting up database 'Genifax'
2004-05-26 12:35:53.69 spid52 Starting up database 'Genifax'
2004-05-26 12:35:58.68 spid7 Starting up database 'Genifax'
2004-05-26 12:36:00.65 spid52 Starting up database 'Genifax'
2004-05-26 12:36:28.43 spid7 Starting up database 'Genifax'
2004-05-26 12:36:53.69 spid52 Starting up database 'Genifax'
2004-05-26 12:37:52.49 spid52 Starting up database 'Genifax'
2004-05-26 12:38:01.08 spid52 Starting up database 'Genifax'
2004-05-26 12:38:53.72 spid52 Starting up database 'Genifax'
2004-05-26 12:38:53.72 spid52 udopen: Operating system error 32(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf
2004-05-26 12:38:53.74 spid52 FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\Data\Genifax.mdf for virtual device number (VDN) 1
2004-05-26 13:23:09.55 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager
The bottom line is where MSDE is restarted (which cures the problem for a day or two upon which MSDE causes problems again)
Like I said in my last message, any help is very very much appreciated
Thanks
Stev

MSDE

I installed MSDE 2000 in my system. There is no icon & gui screen. How can i create/alter database using MSDE without using any programming language? from where can i get stored data in msde? How can i take backup for this data?See this thread for some ideas on how to manage MSDE:http://forums.asp.net/658936/showpost.aspx
|||

tmorton wrote:
See this thread for some ideas on how to manage MSDE:http://forums.asp.net/658936/showpost.aspx

Thank you very much

MSDE

I switched the database from a full version of SQL Server to MSDE 2000 and
the staff is complaining that the system is running slower (about 10 users)
Does it sound familiar?
Is there anything to do about that?
Thanks,
Samuelhi Samuel,
Samuel Shulman wrote:
> I switched the database from a full version of SQL Server to MSDE
> 2000 and the staff is complaining that the system is running slower
> (about 10 users)
> Does it sound familiar?
> Is there anything to do about that?
> Thanks,
> Samuel
MSDE includes a builtin query governor that kicks in when 8 concurrents
worloads are executing at the same time... this will result in a linear
performance degradation of all workloads... when the number of concurrent
workloads goes under that magic number, performances will be non longer
penalized..
http://msdn.microsoft.com/library/d...r />
_6dip.asp
http://msdn.microsoft.com/library/d...r />
_0neh.asp
http://msdn.microsoft.com/library/d...r />
_5fs6.asp
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply|||Thank you,
Samuel
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:4n7c9vF8o9bsU1@.individual.net...
> hi Samuel,
> Samuel Shulman wrote:
> MSDE includes a builtin query governor that kicks in when 8 concurrents
> worloads are executing at the same time... this will result in a linear
> performance degradation of all workloads... when the number of concurrent
> workloads goes under that magic number, performances will be non longer
> penalized..
> http://msdn.microsoft.com/library/d.../>
a2_6dip.asp
> http://msdn.microsoft.com/library/d.../>
a2_0neh.asp
> http://msdn.microsoft.com/library/d.../>
a2_5fs6.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>

Wednesday, March 7, 2012

MSDE

I switched the database from a full version of SQL Server to MSDE 2000 and
the staff is complaining that the system is running slower (about 10 users)
Does it sound familiar?
Is there anything to do about that?
Thanks,
Samuel
hi Samuel,
Samuel Shulman wrote:
> I switched the database from a full version of SQL Server to MSDE
> 2000 and the staff is complaining that the system is running slower
> (about 10 users)
> Does it sound familiar?
> Is there anything to do about that?
> Thanks,
> Samuel
MSDE includes a builtin query governor that kicks in when 8 concurrents
worloads are executing at the same time... this will result in a linear
performance degradation of all workloads... when the number of concurrent
workloads goes under that magic number, performances will be non longer
penalized..
http://msdn.microsoft.com/library/de...r_sa2_6dip.asp
http://msdn.microsoft.com/library/de...r_sa2_0neh.asp
http://msdn.microsoft.com/library/de...r_sa2_5fs6.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply
|||Thank you,
Samuel
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:4n7c9vF8o9bsU1@.individual.net...
> hi Samuel,
> Samuel Shulman wrote:
> MSDE includes a builtin query governor that kicks in when 8 concurrents
> worloads are executing at the same time... this will result in a linear
> performance degradation of all workloads... when the number of concurrent
> workloads goes under that magic number, performances will be non longer
> penalized..
> http://msdn.microsoft.com/library/de...r_sa2_6dip.asp
> http://msdn.microsoft.com/library/de...r_sa2_0neh.asp
> http://msdn.microsoft.com/library/de...r_sa2_5fs6.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>

MSDE

Hi there,
I have a couple of questions related to MSDE 2000.
1. Is there only one SA account for all instances that may be present on a system or each instance has its own SA account and password?
2. When there is an MSDE instance already installed and it is set to Windows Authentication mode, are the instances installed later going to have to use Windows Authentication mode or they could be in Mixed mode?
Thank you for your help,
GDD1499
GDD1499,
Each instance of MSDE 2000 is completely independent and separate from all
other instances. So, to be specific, each instance of MSDE 2000 has its own
sa account and password. Additionally, one (or more) instances of MSDE 2000
can use Windows Authentication mode, while other instances on the same box
may be using Mixed Mode Authentication.
Chief Tenaya
"GDD1499" <anonymous@.discussions.microsoft.com> wrote in message
news:A38DA9C9-13F4-4C67-B911-74F24CD9D9DF@.microsoft.com...
> Hi there,
> I have a couple of questions related to MSDE 2000.
> 1. Is there only one SA account for all instances that may be present on a
system or each instance has its own SA account and password?
> 2. When there is an MSDE instance already installed and it is set to
Windows Authentication mode, are the instances installed later going to have
to use Windows Authentication mode or they could be in Mixed mode?
> Thank you for your help,
> GDD1499

MSDE

I switched the database from a full version of SQL Server to MSDE 2000 and
the staff is complaining that the system is running slower (about 10 users)
Does it sound familiar?
Is there anything to do about that?
Thanks,
Samuelhi Samuel,
Samuel Shulman wrote:
> I switched the database from a full version of SQL Server to MSDE
> 2000 and the staff is complaining that the system is running slower
> (about 10 users)
> Does it sound familiar?
> Is there anything to do about that?
> Thanks,
> Samuel
MSDE includes a builtin query governor that kicks in when 8 concurrents
worloads are executing at the same time... this will result in a linear
performance degradation of all workloads... when the number of concurrent
workloads goes under that magic number, performances will be non longer
penalized..
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_6dip.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0neh.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_5fs6.asp
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply|||Thank you,
Samuel
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:4n7c9vF8o9bsU1@.individual.net...
> hi Samuel,
> Samuel Shulman wrote:
>> I switched the database from a full version of SQL Server to MSDE
>> 2000 and the staff is complaining that the system is running slower
>> (about 10 users)
>> Does it sound familiar?
>> Is there anything to do about that?
>> Thanks,
>> Samuel
> MSDE includes a builtin query governor that kicks in when 8 concurrents
> worloads are executing at the same time... this will result in a linear
> performance degradation of all workloads... when the number of concurrent
> workloads goes under that magic number, performances will be non longer
> penalized..
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_6dip.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0neh.asp
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_5fs6.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.bizhttp://italy.mvps.org
> DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
> -- remove DMO to reply
>

Saturday, February 25, 2012

msdb sysmail_attachments_transfer - very large, but 0 records

Our SQL server 2005 has a system table in the MSDB database called
sysmail_attachments_transfer. The management console summary report
shows almost 5 GB of data for the table with 0 records.
Table Name # Records Reserved Data
Indexes Unused
----
dbo.sysmail_attachments 1533 6178008 KB 6174160 KB 8
KB 3840 KB
dbo.sysmail_attachments_transfer 0 4936816 KB 4935864 KB 8
KB 944 KB
This is puzzling. I would like to know more about this system table,
and to get back some of the space used, if possible. Does anyone know
anything about this? There doesn't seem to be any documentation
anywhere on it.
Rob Fisch
Kaz, Inc.Hi
This looks like it holds the results of queries that are attached see
http://www.elsasoft.org/SUMMER.msdb/sp_dbospsenddbmail.htm but I have not
found much more than this.
What does sp_spaceused give for this table?
Although this information should be correct you may want to try DBCC
UPDATEUSAGE to see if anything changes.
John
"rfisch@.gmail.com" wrote:
> Our SQL server 2005 has a system table in the MSDB database called
> sysmail_attachments_transfer. The management console summary report
> shows almost 5 GB of data for the table with 0 records.
> Table Name # Records Reserved Data
> Indexes Unused
> ----
> dbo.sysmail_attachments 1533 6178008 KB 6174160 KB 8
> KB 3840 KB
> dbo.sysmail_attachments_transfer 0 4936816 KB 4935864 KB 8
> KB 944 KB
> This is puzzling. I would like to know more about this system table,
> and to get back some of the space used, if possible. Does anyone know
> anything about this? There doesn't seem to be any documentation
> anywhere on it.
> Rob Fisch
> Kaz, Inc.
>|||Hi John,
sp_spaceused gave the same reading as the summary report.
DBCC UPDATEUSAGE didn't change anything to speak of.
Thanks for the link. It was interesting. There may be some clues in
there, but nothing jumps out at me.
Thanks for giving it a stab.
Rob
John Bell wrote:
> Hi
> This looks like it holds the results of queries that are attached see
> http://www.elsasoft.org/SUMMER.msdb/sp_dbospsenddbmail.htm but I have not
> found much more than this.
> What does sp_spaceused give for this table?
> Although this information should be correct you may want to try DBCC
> UPDATEUSAGE to see if anything changes.
> John
>
> "rfisch@.gmail.com" wrote:
> > Our SQL server 2005 has a system table in the MSDB database called
> > sysmail_attachments_transfer. The management console summary report
> > shows almost 5 GB of data for the table with 0 records.
> >
> > Table Name # Records Reserved Data
> > Indexes Unused
> > ----
> > dbo.sysmail_attachments 1533 6178008 KB 6174160 KB 8
> > KB 3840 KB
> > dbo.sysmail_attachments_transfer 0 4936816 KB 4935864 KB 8
> > KB 944 KB
> >
> > This is puzzling. I would like to know more about this system table,
> > and to get back some of the space used, if possible. Does anyone know
> > anything about this? There doesn't seem to be any documentation
> > anywhere on it.
> >
> > Rob Fisch
> > Kaz, Inc.
> >
> >|||Hi
I am not sure what has caused this. Have you tried DBCC CHECKDB?
John
On Nov 4, 1:55 am, "Rob Fisch" <rfi...@.gmail.com> wrote:
> Hi John,
> sp_spaceused gave the same reading as the summary report.
> DBCC UPDATEUSAGE didn't change anything to speak of.
> Thanks for the link. It was interesting. There may be some clues in
> there, but nothing jumps out at me.
> Thanks for giving it a stab.
> Rob
>
> John Bell wrote:
> > Hi
> > This looks like it holds the results of queries that are attached see
> >http://www.elsasoft.org/SUMMER.msdb/sp_dbospsenddbmail.htmbut I have not
> > found much more than this.
> > What does sp_spaceused give for this table?
> > Although this information should be correct you may want to try DBCC
> > UPDATEUSAGE to see if anything changes.
> > John
> > "rfi...@.gmail.com" wrote:
> > > Our SQL server 2005 has a system table in the MSDB database called
> > > sysmail_attachments_transfer. The management console summary report
> > > shows almost 5 GB of data for the table with 0 records.
> > > Table Name # Records Reserved Data
> > > Indexes Unused
> > > ----
> > > dbo.sysmail_attachments 1533 6178008 KB 6174160 KB 8
> > > KB 3840 KB
> > > dbo.sysmail_attachments_transfer 0 4936816 KB 4935864 KB 8
> > > KB 944 KB
> > > This is puzzling. I would like to know more about this system table,
> > > and to get back some of the space used, if possible. Does anyone know
> > > anything about this? There doesn't seem to be any documentation
> > > anywhere on it.
> > > Rob Fisch
> > > Kaz, Inc.- Hide quoted text -- Show quoted text -|||Well I guess the good news is that DBCC CHECKDB reports "CHECKDB found
0 allocation errors and 0 consistency errors ".
John Bell wrote:
> Hi
> I am not sure what has caused this. Have you tried DBCC CHECKDB?
> John
> On Nov 4, 1:55 am, "Rob Fisch" <rfi...@.gmail.com> wrote:
> > Hi John,
> >
> > sp_spaceused gave the same reading as the summary report.
> > DBCC UPDATEUSAGE didn't change anything to speak of.
> >
> > Thanks for the link. It was interesting. There may be some clues in
> > there, but nothing jumps out at me.
> >
> > Thanks for giving it a stab.
> > Rob
> >
> >
> >
> > John Bell wrote:
> > > Hi
> >
> > > This looks like it holds the results of queries that are attached see
> > >http://www.elsasoft.org/SUMMER.msdb/sp_dbospsenddbmail.htmbut I have not
> > > found much more than this.
> >
> > > What does sp_spaceused give for this table?
> > > Although this information should be correct you may want to try DBCC
> > > UPDATEUSAGE to see if anything changes.
> >
> > > John
> >
> > > "rfi...@.gmail.com" wrote:
> >
> > > > Our SQL server 2005 has a system table in the MSDB database called
> > > > sysmail_attachments_transfer. The management console summary report
> > > > shows almost 5 GB of data for the table with 0 records.
> >
> > > > Table Name # Records Reserved Data
> > > > Indexes Unused
> > > > ----
> > > > dbo.sysmail_attachments 1533 6178008 KB 6174160 KB 8
> > > > KB 3840 KB
> > > > dbo.sysmail_attachments_transfer 0 4936816 KB 4935864 KB 8
> > > > KB 944 KB
> >
> > > > This is puzzling. I would like to know more about this system table,
> > > > and to get back some of the space used, if possible. Does anyone know
> > > > anything about this? There doesn't seem to be any documentation
> > > > anywhere on it.
> >
> > > > Rob Fisch
> > > > Kaz, Inc.- Hide quoted text -- Show quoted text -|||Hi ROb
What version are you using (SELECT @.@.VERSION) ?
I guess you could try manually deleting from/truncating the table even
though it is reporting no rows.
"Rob Fisch" wrote:
> Well I guess the good news is that DBCC CHECKDB reports "CHECKDB found
> 0 allocation errors and 0 consistency errors ".
>
>
> John Bell wrote:
> > Hi
> >
> > I am not sure what has caused this. Have you tried DBCC CHECKDB?
> >
> > John
> >
> > On Nov 4, 1:55 am, "Rob Fisch" <rfi...@.gmail.com> wrote:
> > > Hi John,
> > >
> > > sp_spaceused gave the same reading as the summary report.
> > > DBCC UPDATEUSAGE didn't change anything to speak of.
> > >
> > > Thanks for the link. It was interesting. There may be some clues in
> > > there, but nothing jumps out at me.
> > >
> > > Thanks for giving it a stab.
> > > Rob
> > >
> > >
> > >
> > > John Bell wrote:
> > > > Hi
> > >
> > > > This looks like it holds the results of queries that are attached see
> > > >http://www.elsasoft.org/SUMMER.msdb/sp_dbospsenddbmail.htmbut I have not
> > > > found much more than this.
> > >
> > > > What does sp_spaceused give for this table?
> > > > Although this information should be correct you may want to try DBCC
> > > > UPDATEUSAGE to see if anything changes.
> > >
> > > > John
> > >
> > > > "rfi...@.gmail.com" wrote:
> > >
> > > > > Our SQL server 2005 has a system table in the MSDB database called
> > > > > sysmail_attachments_transfer. The management console summary report
> > > > > shows almost 5 GB of data for the table with 0 records.
> > >
> > > > > Table Name # Records Reserved Data
> > > > > Indexes Unused
> > > > > ----
> > > > > dbo.sysmail_attachments 1533 6178008 KB 6174160 KB 8
> > > > > KB 3840 KB
> > > > > dbo.sysmail_attachments_transfer 0 4936816 KB 4935864 KB 8
> > > > > KB 944 KB
> > >
> > > > > This is puzzling. I would like to know more about this system table,
> > > > > and to get back some of the space used, if possible. Does anyone know
> > > > > anything about this? There doesn't seem to be any documentation
> > > > > anywhere on it.
> > >
> > > > > Rob Fisch
> > > > > Kaz, Inc.- Hide quoted text -- Show quoted text -
>|||Or perhaps ALTER INDEX with REORGANIZE and LOB_COMPACTION? I don't deal that much with blobs, and
I'd guess that compaction shouldn't be necessary in this case, but it might be worth a try?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:9406A927-93E5-4E82-B52F-745E6AE4CD6E@.microsoft.com...
> Hi ROb
> What version are you using (SELECT @.@.VERSION) ?
> I guess you could try manually deleting from/truncating the table even
> though it is reporting no rows.
> "Rob Fisch" wrote:
>> Well I guess the good news is that DBCC CHECKDB reports "CHECKDB found
>> 0 allocation errors and 0 consistency errors ".
>>
>>
>> John Bell wrote:
>> > Hi
>> >
>> > I am not sure what has caused this. Have you tried DBCC CHECKDB?
>> >
>> > John
>> >
>> > On Nov 4, 1:55 am, "Rob Fisch" <rfi...@.gmail.com> wrote:
>> > > Hi John,
>> > >
>> > > sp_spaceused gave the same reading as the summary report.
>> > > DBCC UPDATEUSAGE didn't change anything to speak of.
>> > >
>> > > Thanks for the link. It was interesting. There may be some clues in
>> > > there, but nothing jumps out at me.
>> > >
>> > > Thanks for giving it a stab.
>> > > Rob
>> > >
>> > >
>> > >
>> > > John Bell wrote:
>> > > > Hi
>> > >
>> > > > This looks like it holds the results of queries that are attached see
>> > > >http://www.elsasoft.org/SUMMER.msdb/sp_dbospsenddbmail.htmbut I have not
>> > > > found much more than this.
>> > >
>> > > > What does sp_spaceused give for this table?
>> > > > Although this information should be correct you may want to try DBCC
>> > > > UPDATEUSAGE to see if anything changes.
>> > >
>> > > > John
>> > >
>> > > > "rfi...@.gmail.com" wrote:
>> > >
>> > > > > Our SQL server 2005 has a system table in the MSDB database called
>> > > > > sysmail_attachments_transfer. The management console summary report
>> > > > > shows almost 5 GB of data for the table with 0 records.
>> > >
>> > > > > Table Name # Records Reserved Data
>> > > > > Indexes Unused
>> > > > > ----
>> > > > > dbo.sysmail_attachments 1533 6178008 KB 6174160 KB 8
>> > > > > KB 3840 KB
>> > > > > dbo.sysmail_attachments_transfer 0 4936816 KB 4935864 KB 8
>> > > > > KB 944 KB
>> > >
>> > > > > This is puzzling. I would like to know more about this system table,
>> > > > > and to get back some of the space used, if possible. Does anyone know
>> > > > > anything about this? There doesn't seem to be any documentation
>> > > > > anywhere on it.
>> > >
>> > > > > Rob Fisch
>> > > > > Kaz, Inc.- Hide quoted text -- Show quoted text -
>>

Friday, March 30, 2012

MSDE along side WMSDE?

Wednesday, March 28, 2012

MSDE 2000 vs SQL express 2005 ??

MSDE 2000 to MSDE 2000 Replication?

Friday, March 23, 2012

MSDE 2000 install on W2K3 64bit

Monday, March 19, 2012

MSDE : find out what triggers are created

MSDE / SQL - SERVER

MSDE / SQL - SERVER

Monday, March 12, 2012

msde - uses too much memory and is getting very slow!

Friday, March 9, 2012

Msde - Connecting To The Database

MSDE - 17207, udopen: Operating system error 32(error not found) during the creation/openi

MSDE

MSDE

Wednesday, March 7, 2012

MSDE

MSDE

MSDE

Saturday, February 25, 2012

msdb sysmail_attachments_transfer - very large, but 0 records

msdb sysmail_attachments_transfer - very large, but 0 records

msdb sysmail_attachments_transfer - very large, but 0 records

MSDB database restore

Blog Archive

About Me