Groups | Blog | Home


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

Filter by week: 1 2 3 4 5

msde 2000 and msde 2005 databases
Posted by Raj at 8/30/2007 3:00:00 PM
I need to connect an msde 2000 database to sql 2005 express without upgrading the database itself. Here is what im running into at the moment. I have an msde 2000 database that has torn pages so its pretty much pooched. I have connected it to a msde 2005 (sql 2005 express) in emergency mode...more >>


Exceeding the 4G limit
Posted by jib at 8/30/2007 7:39:43 AM
Hi, I am using a SQL Server 2005 Express database, which, according to the literature is limited to storing a maximum of 4G. So far I haven't reached that limit yet. However, in case I do, what can I expect to see happening? Will my INSERT command come back with a failure? With SQL Server ...more >>

MSDE vs SQL Express storage efficiency
Posted by Lucvdv at 8/27/2007 12:00:00 AM
I've got an applicatipon that was recently updated from MSDE 2000 to SQL Server Express, but I'm beginning to see that more and more as a bad move. Is there any information about storage efficiency of various SQL Server versions? I'm getting extremely poor results with SQL Express. With M...more >>

Convert BCM Database from Express BACK to MSDE?
Posted by Grizz at 8/24/2007 7:50:03 AM
I have a BCM database created using SQL Express that I want to Attach to a SQL 2000 server. Is there any way I can do that? -- Thanx .. . . . . . . Grizz (If I try it I get an error: "could not find row in sysindexes for database id..."...more >>

Debug Trigger
Posted by Danny at 8/22/2007 12:00:00 AM
Hi Folks Trying to develop a trigger - what is the best way to debug a trigger? Any log files or query analyzer available to assist in debugging. Thanks Dan ...more >>

SQL 2005 Embedded and Moving Sharepoint Services Database
Posted by Watt, Bobby at 8/19/2007 11:05:11 AM
I have a SQL 2005 Embedded database that was created by SharePoint Services. It's ldf file has grown to almost 3 gig, and I need to move it off the C drive. I have successfully moved some of the other databases using the OSQL command, but when I try to move this one particular database I keep ...more >>

Accessing SQL2005
Posted by Timbo at 8/17/2007 4:21:10 PM
I have a fairly heavy duty app that can use SQL2005, however I am getting some rather strange behaviour, if MSDE or SQL2000 is used, this doesn't appear to happen. Here's what happens: The VB6 application makes fairly regular calls on the database (only when the user requests data). At wh...more >>

find out the instanceName
Posted by ykffc at 8/13/2007 4:40:02 AM
If after installing and working with MSDE a long while ago I forget the instance Name in my local machine, what could I do to find it out again? ...more >>



Moving MSDE SQL Server with OSQL
Posted by Mark Grantom at 8/7/2007 11:14:03 AM
I am a complete neophyt to SQL. I am attempting to restore a backup from a MSDE 2000 SQL server from a peer to peer server to a server running Small Business Server 2003 using OSQL. (In other words I’m moving the database to a dedicated server.) I performed a RESTORE DATABASE xxx FROM DI...more >>

Checksum problem on system database
Posted by Freaky at 8/7/2007 12:00:00 AM
Hey there, we're having an issue with the SQL (MSDE) database that sharepoint uses. The service starts and immediately stops. In the logs (in dutch) there's an error: "Het checksumbestand van de systeemdatabase heeft een ongeldige ondertekening." freely translated it says "The checksumfile fr...more >>


DevelopmentNow Blog