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

Re: Not able to installed SQL 2000 Desktop engine on SBS 2003
Posted by Andrea Montanari at 11/1/2007 12:00:00 AM
hi, ritesh wrote: > Dear Mr, Andrea, > > No i am getting RETURN VALUE 1. > > thanks! try posting the last 40/50 lines of the log.. -- 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 T...more >>

Re: Not able to installed SQL 2000 Desktop engine on SBS 2003
Posted by ritesh at 10/31/2007 11:48:01 PM
Dear Mr, Andrea, No i am getting RETURN VALUE 1. thanks! "Andrea Montanari" wrote: > hi, > ritesh wrote: > > > > I have trired with Switch /L*v "c:\msdeLog.txt" setup.exe create > > msdelog.txt file but my setup hang on particular 26%. Can you gime > > your email address so i can ...more >>

Re: Not able to installed SQL 2000 Desktop engine on SBS 2003
Posted by ritesh at 10/31/2007 8:25:00 AM
Dear Sir , I have trired with Switch /L*v "c:\msdeLog.txt" setup.exe create msdelog.txt file but my setup hang on particular 26%. Can you gime your email address so i can send you that log file. Please give me u r email address . Thanks! "Andrea Montanari" wrote: > hi, > ritesh...more >>

Re: Not able to installed SQL 2000 Desktop engine on SBS 2003
Posted by Andrea Montanari at 10/31/2007 12:00:00 AM
hi, ritesh wrote: > > I have trired with Switch /L*v "c:\msdeLog.txt" setup.exe create > msdelog.txt file but my setup hang on particular 26%. Can you gime > your email address so i can send you that log file. have you inspected the file for RETURN VALUE 3 entries? -- Andrea Montanari (...more >>

Re: Not able to installed SQL 2000 Desktop engine on SBS 2003
Posted by Andrea Montanari at 10/31/2007 12:00:00 AM
hi, ritesh wrote: > Dear Sir, > > I have window SBS 2003 server, and i want to installed SQL 2000 > Desktop engine on my server.My server is (Domain > controller,DNS,DHCP,Exchange server 2003).i want this to make my > server as sharepoint server which is bulit in with SBS2003. all on the s...more >>

Not able to installed SQL 2000 Desktop engine on SBS 2003
Posted by ritesh at 10/29/2007 4:11:00 AM
Dear Sir, I have window SBS 2003 server, and i want to installed SQL 2000 Desktop engine on my server.My server is (Domain controller,DNS,DHCP,Exchange server 2003).i want this to make my server as sharepoint server which is bulit in with SBS2003. But when i click on SQL setup it just aske...more >>

RE: msde
Posted by mike3004 at 10/29/2007 1:23:02 AM
I solve the problem because of starting MYSQLSERVER service when installing lastly but not all PCs do so that I have tested to installed 4 PCs. "mike3004" wrote: > should msde run independence ? > I try to install for standalone(winxp pro) but it checks collation name(sql > server name?)....more >>

msde
Posted by mike3004 at 10/26/2007 8:44:01 PM
should msde run independence ? I try to install for standalone(winxp pro) but it checks collation name(sql server name?). So I should install sqlserver before install msde. Is it right? Thanks a lot Lok HK...more >>



sql database in loading state when restore disrupted
Posted by ginger8990 at 10/25/2007 12:50:06 PM
When I am doing restore from files to database, I got netowrk connection error , I restore it again and I cancel it when deciding to do it later then the database is just in loading state for ever. Does anyone know how to clear this and resolve this? Many thanks! Ginger...more >>

Re: 'Microsoft SQL Server Express Edition' redistribution rights.
Posted by Robbe Morris - [MVP] C# at 10/20/2007 7:27:21 PM
And... Check out the link below that tells how to bundle it and set the necessary permissions at install time. -- Robbe Morris [Microsoft MVP - Visual C#] ..NET Setup Deployment - MSI, Cassini, SQL Server, NTFS http://www.eggheadcafe.com/tutorials/aspnet/2a5222d8-3d69-4f1c-b5ab-35ca33da0f65...more >>

Re: msde & sage
Posted by Andrea Montanari at 10/18/2007 12:00:00 AM
hi Roy, Roy Collingwood wrote: > I have installed msde (almost teh latest version) on win2003 server, > the version that came with sage 10, it seems to install fine, the > icon by the clock is green. the program will not connect to it. It > works ok when installed on win2000 server & win2000 pr...more >>

msde & sage
Posted by Roy Collingwood at 10/18/2007 12:00:00 AM
I have installed msde (almost teh latest version) on win2003 server, the version that came with sage 10, it seems to install fine, the icon by the clock is green. the program will not connect to it. It works ok when installed on win2000 server & win2000 prof. Am I not finding a setting somewhere...more >>

Re: Unable to connect with "sa"
Posted by Andrea Montanari at 10/17/2007 4:50:50 PM
multipost answered in microsoft.public.it.sql 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 ...more >>

Re: Unable to connect with "sa"
Posted by Andrea Montanari at 10/17/2007 12:00:00 AM
hi, OxygeN wrote: > Hello there, > got my Windows 2003 SBS installed with its "native" MSDE. There I see > two different instances: SBSMonitoring and another one which is > related to an other software app. Now I have to install a third > software which has to rely on an MSDE or SQL database. ...more >>

Unable to connect with "sa"
Posted by OxygeN at 10/17/2007 12:00:00 AM
Hello there, got my Windows 2003 SBS installed with its "native" MSDE. There I see two different instances: SBSMonitoring and another one which is related to an other software app. Now I have to install a third software which has to rely on an MSDE or SQL database. As I already have MSDE, I ...more >>

Fatloss computer program
Posted by Angel vasquez at 10/15/2007 7:21:46 PM
I have been using this computer program for a couple weeks now and i am very pleased with the results so far. its a software fatloss program, if your looking for a diet/weightloss plan i reccomend you check this place out first: http://fatloss9.50webs.com ...more >>

HP Desktop for sale!
Posted by pbdude at 10/14/2007 3:53:39 AM
Hi, I have an unused HP Pavilion with the fallowing specs: # Processor: AMD Athlon 64 X2 4000+ (2.1GHz, 2000MT/s System Bus) # Memory: 2048MB PC2-5300 DDR2 SDRAM memory (2x1GB) (expandable to 8 GB (4 x 2 GB) (64-bit OS)/ 4 GB (4 x 1 GB) (32-bit OS)) # Hard Drive:320GB 7200RPM SATA 3G (3.0 Gb/s...more >>

Watch NFL Games Online
Posted by Dexter H. at 10/13/2007 9:49:38 PM
Watch NFL Games Online! For every one who wants to watch the games online because they dont live in the teams town or are at work i found a site that has basically every game covered. Its perfect if you have afford a monthly $70 direct tv nfl access subscription. they got a bunch of channels The s...more >>

Re: Migrate data from SQL 2000 Enterprise to SQL 2000 MSDE
Posted by deepdark NO[at]SPAM onvol.net at 10/12/2007 9:12:43 AM
Just to report what I did in case it can help someone else. Just attaching a 20GB database with sp_attach_db to MSDE did not work. However, the following approach worked: In MSDE, I created a blank database with the same file names as the 20GB database I was trying to use with MDSE. Then ...more >>

Re: view MSDE with access
Posted by Norman Yuan at 10/4/2007 4:26:38 PM
Creating *.mdf and *.ldf each day? each pair of *.mdf/*.ldf is an SQL Server database. and you do not access the files directly. With Access, you can use ADP format to connect to a dtabase on MSDE: 1. Start Access. 2. ccreate a new ADP file, choosing to use existing database. 3. In "data Li...more >>

view MSDE with access
Posted by Spechty at 10/4/2007 1:04:00 PM
I am logging ISA to MSDE. it creates a new mdf, and ldf each day. I would like to create an Access front end to view each day. ...more >>

RE: Required help on sql 2005 Server Management Studio.
Posted by Saleem Hakani at 10/1/2007 2:41:00 PM
Hi Kiran, what happens when you completely un-install and re-install SQL Server 2005 workstation components? Do you still see duplicate entries? Thank you, Saleem Hakani WWW.SQLCOMMUNITY.COM (World Wide Microsoft SQL server Community) SQLTips, SQL Articles, SQL Forums, SQL Automation Tools/S...more >>

Re: Upgrade to SQL Express blocked
Posted by Jonathan Psaila-Depasquale at 10/1/2007 12:00:00 AM
Hi Candee, I would suggest that you follow the suggestions in this link: http://support.microsoft.com/kb/320873 Jonathan Candee wrote: > Hello; > I am trying to upgrade a MSDE 8.0 SP3 to SQL Express. > I haven't been able to get the upgrade to work; when I select "default > instan...more >>

Re: 'Microsoft SQL Server Express Edition' redistribution rights.
Posted by Jonathan Psaila-Depasquale at 10/1/2007 12:00:00 AM
Hi Gokul, SQL Server 2005 Express Edition is indeed free to reditribute as you can see on this link - http://msdn2.microsoft.com/en-us/sql/Aa336346.aspx. Jonathan Gokul wrote: > Hi, > > I am Gokul, from Chennai - India. I have some queries on 'Microsoft SQL > Server Express Edi...more >>

Re: trouble Installing MSDE Rel A on Win Server 2003
Posted by Jonathan Psaila-Depasquale at 10/1/2007 12:00:00 AM
Hi Zonk, In my experience when MSDE installations go wrong it is really hard to get out of them. For this reason I would suggest that you go straight to uninstalling existing traces of unsuccessful installations by following the instructions on this link - http://support.microsoft.com/kb...more >>

Re: Importing tables from Access to SQL Server
Posted by Shane Jones at 9/28/2007 4:38:52 PM
Sounds Good -- thanks for your suggestion and help Andrew. "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:Od4CL7gAIHA.4200@TK2MSFTNGP04.phx.gbl... >I am not a SSIS expert and that is why I suggested the sites. I do see now >that you included among many other sites th...more >>

Re: Importing tables from Access to SQL Server
Posted by Andrew J. Kelly at 9/28/2007 4:33:11 PM
I am not a SSIS expert and that is why I suggested the sites. I do see now that you included among many other sites the DTS newsgroup but it doesn't look like the SSIS one. I suggest you post there (leaving out all the other ones that are not relevant) for more detailed answers. -- Andrew...more >>

Re: Importing tables from Access to SQL Server
Posted by Andrew J. Kelly at 9/28/2007 1:35:44 PM
You can use a SQL statement to import the data that has a RTRIM() in it for that column or you can use a custom conversion in the ETL package. Is this DTS or SSIS? www.sqldts.com www.sqlis.ocm -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Shane Jones" <doctorjones_md@yaho...more >>

Re: Importing tables from Access to SQL Server
Posted by Shane Jones at 9/28/2007 12:43:59 PM
Andrew -- if (for example) a particular table has numerous fields that require a RTRIM, how would I write this SQL statement. Would you point me in the right direction with a quick example or reference? Thanks again. Shane "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in mess...more >>

Re: Importing tables from Access to SQL Server
Posted by Shane Jones at 9/28/2007 12:40:07 PM
Thanks for the quick reply Andrew, It's SSIS ... "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message news:O%23LRAYfAIHA.5416@TK2MSFTNGP05.phx.gbl... > You can use a SQL statement to import the data that has a RTRIM() in it > for that column or you can use a custom conversio...more >>


DevelopmentNow Blog