all groups > sql server msde > march 2006 > threads for march 22 - 28, 2006
Filter by week: 1 2 3 4 5
MSDE (SQL Server 2000) does not return @@Identity
Posted by Anbu at 3/28/2006 9:03:54 PM
Hi All,
First my apologize for cross posting. It's already posted in
sqlserver.programming. But I see this group would also help me.
I'm creating an appplication with some stored procedures. The stored
procedure needs to return the @@Identity of the table's new record. The
function has no... more >>
Does anyone know a utility/batch script to Warn when close to Max DB size
Posted by Uffe Bak at 3/28/2006 8:12:25 PM
Hello Group
Does anyone know of a utility or Batch script (osql or Windows cmd or mix)
to Warn an Admin when a MSDE DB is closing in on 2 GB in size (or 2005
Express closes in on 4 GB).
Any leads or tips will be appriciated highly
Best regards
Uffe
... more >>
strange message
Posted by Josep SolĂ at 3/28/2006 6:24:16 PM
Hello,
When I run a backup sentence, query analizer shows me anything like this:
The string could be crypted 0x80090016 (KeySet doesn't exist)
any idea?
Thanks,,
... more >>
MSDE and Profiler
Posted by MrBaseball34 at 3/28/2006 12:08:50 PM
We are in dire need of a redistributable Profiler for MSDE installed on
our
client's machines.
Does anyone know:
1. If there are any 3rd-party profilers avail to work with MSDE?
2. Is there any way to install SQL Server's profiler?
3. How to begin writing a profiler (in Delphi)?
4. How to... more >>
SQL Profiler for MSDE???
Posted by CF at 3/27/2006 4:29:02 PM
Anyone know of a tool (hopefully free???) to capture sql queries sent to and
MSDE 2.0 database? ... more >>
MSDE and ADO
Posted by Marcos Lommez at 3/27/2006 12:58:26 PM
When i call ADOConnection.Connected := False
The connection with the MSDE server is still opened, why that?
I want to close that connection with the server
The connection is only closed when my application is terminated
Im using MSDE 2000 and my application is writen in Delphi
... more >>
MSDE and SQL Enterprise Manager
Posted by Werner Cornelis at 3/26/2006 2:46:48 PM
Hi,
I wonder if it is allowed to use SQL 2000 Enterprise Manager to manage all
of the MSDE installatie we have?
We have a SQL 2000 server. But the MSDE database used on some laptops have
nothing to do with the SQL Server.
--
Werner Cornelis... more >>
MSDE refuses to install on Server 2003
Posted by J at 3/25/2006 2:56:00 PM
Hi,
I'm trying to install some apps onto one of my server 2003 boxes, on one
server it all goes fine, on the other however the msde installations all
give up and rollback I just get errors in the event logs that state that the
installation failed. Any ideas? It won't even let me install the va... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
WSUS/WMSDE How to upgrade?
Posted by GuitarHero at 3/24/2006 11:54:01 AM
We have WSUS installed with the WMSDE database engine. I have 2 questions
which can't seem to be answered anywhere on the net:
1. We have various vulnerability scanning tools that show WMSDE not having
SQL SP4 applied. I can't find any way of installing SP4. I've tried with
the full-bl... more >>
MSDE2000 newbie questions
Posted by Sagaert Johan at 3/24/2006 12:00:00 AM
Hi
I created a small test app that opens an sql database on the same machine
(TESTPC).
When i move the compiled app to another pc in the network i receive this
error:
Login failed for user TESTPC\Guest.
What should i do to make it work ?
Connection string ? or doe i need to created ... more >>
Limit of concurrent queries
Posted by Vycka at 3/24/2006 12:00:00 AM
Hi,
I noticed messages in my sql server log that says:
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
The question:
Is this message is generated each time such situation occure?
I get only l... more >>
MSDE and SQL 2005 Trial Mangement Tools
Posted by Raymond Geering at 3/23/2006 12:00:00 AM
Hello,
I read that the SQL 2005 Management Tools from the Trial
version can be used to manage the MSDE. So I installed MSDE and
the SQL 2005 management tools on my test server and it seems to
work fine.
But my question is if the "Microsoft SQL Server Management Studio"
will stop running af... more >>
|