|
|
|
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 |
Filter by week: 1 2 3 4 5 How to get from smalldatetime -field only date? Posted by Mika M at 11/28/2005 2:29:22 PM Hi!
I'm using MSDE 2000 SP4. I need to get only date from smalldatetime
using SQL statement like "SELECT MyDate FROM MyTable.".
Like this way I'll get MyDate as "27.11.2005 0:00:00" when using finnish
regional settings, but how to get just "27.11.2005" without that empty time?
I think t...more >>
Has anybody installed MSDE using AD Group policy? Posted by P at 11/28/2005 12:00:00 AM I took the SP4 MSDE and tried to publish sql2000.msi to active directory but
it failed.
When I ran the MSI file interactively it complained about not finding the
default instance. Obviously setup.exe must set this property?
Anyway I used ORCA to edit the SQL2000.MSI and added an INSTANCENA...more >>
Starting and stopping database servie Posted by Erik Visser at 11/25/2005 1:14:02 PM Hi all,
I try to start and stop specific instances of MSDE using SCM.EXE
This works for the default Server, but not for a specific one.
This works:
SCM -Action 6 -Service MSSQLServer
works ok
SCM -Action 6 -Service MSSQLServer -Server Desktop\Myinstance
gives an error: The RPC Server is n...more >>
Can't add stored procedure to SQL Express Posted by BLiTZWiNG at 11/23/2005 3:26:03 PM I select New Stored Procedure from the context menu of the stored procedure
tab in my database, and it procedes to makes a file called SQLQuery1.sql and
saves it as a file, but doesn't add it to the list of my stored procedures...
How do I add it? What am I doing wrong? I see no method of imp...more >>
Cant install MSDE Rel A Posted by MEI Admin at 11/22/2005 2:11:02 PM I am trying to install MSDE Rel A on a Windows XP SP2 machine with no luck no
matter what I try. I am typing the following at the command line.
setup.exe /L*v C:\MSDElog.txt SAPWD="password" SECURITYMODE=SQL
Below are the portions of the error log that contain RETURN VALUE 3,
including se...more >>
any installation no-no's? Posted by John Brown at 11/22/2005 1:17:01 PM We are installing MS Win Server 2003 and my old version (7?) of MSDE is not
supported. So I will download MSDE 2000 and install it. I do not have a lot
of experience installing MSDE. I installed it a few times years ago and, with
a few exceptions, it has run just fine since then.
I vaguely re...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |