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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|