Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
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 >>



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 >>


DevelopmentNow Blog