|
|
|
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 SQL Server 2005 Express - Is there a specific newsgroup? Posted by Stephen Gilkes at 12/28/2005 6:11:09 PM Hi there
Is there a specific newsgroup for SQL Server 2005 Express? Or is the
newsgroup to use?
Thanks
Stephen
...more >>
urgent help needed - space available 0.00 MB Posted by maxzsim via SQLMonster.com at 12/28/2005 8:32:00 AM Hi ,
I have this distribution database (created via replication setup).
I have set aside 200 MB for data file in E:\ drive & 20 MB in C:\ drive for
log file using simple mode recovery
on the properties --> General tab of distribition it shows
Size : 220.00 MB (from the data + log file)
...more >>
using DBCC dbreindex , indexdefrag Posted by maxzsim via SQLMonster.com at 12/28/2005 4:08:21 AM Hi,
I am running SQL Server 2000 sp3a , standard edtition.
I have ran a dbcc showcontig that shows the following :
DBCC SHOWCONTIG scanning 'tb_Options' table...
Table: 'tb_Options' (1079674894); index ID: 1, database ID: 6
TABLE level scan performed.
- Pages Scanned......................more >>
SQL Server 2005 Express SQL problem Posted by Andrew Chalk at 12/27/2005 7:57:46 PM In SQL Server 2005 Express the follwoing query produces the wrong result:
SELECT CHANNEL, DURATION, STARTTIME
FROM Recordings
WHERE (STARTTIME > '12/27/05 00:00:00') AND (DURATION > '5')
ORDER BY STARTTIME DESC
If I replace it with:
SELECT CHANNEL, DURATION, STARTTIME
...more >>
install service pack 3a from an Vb6 application. Posted by ssi8 at 12/27/2005 11:43:52 AM Hi,
I wrote an application in vb6 to install sql service pack 3a. I am running
this application from a cd. When I execute the setup from the application, I
get prompted to close the application that called the setup exe. Then, the
setup continues after I close the application, but the service...more >>
defrag system objects/tables Posted by maxzsim via SQLMonster.com at 12/27/2005 7:36:40 AM Hi,
I used the DBCC SHOWCONTIG on a database and it shows :
DBCC SHOWCONTIG scanning 'sysobjects' table...
Table: 'sysobjects' (1); index ID: 1, database ID: 8
TABLE level scan performed.
- Pages Scanned................................: 4
- Extents Scanned..............................: 4...more >>
Applications without install SQL Server Posted by Abood_aa at 12/27/2005 1:44:42 AM Hello all
I write a program that use sqlclient to connect to SQL Server 2005 Database
so how can i run this program on a computer that SQL Server 2005 is not
installed on it
cause it's too much for the customers to install SQL Server 2005 express
edition it takes too much time and space
i t...more >>
SQLServer2005 and SQLDMO Posted by Marc Meribi at 12/27/2005 1:19:02 AM Hello all,
I connect to SQL server using SQLDMO to update the database and make many
Other tasks. I installed SqlServer2005 on a test server and I got an error
using the connect method of SQLDMO.
Is SQL Server 2005 is 100% compatible with old SQLDMO?
How to make it working with the SQLDMO, re...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to ... Posted by Jacek Jurkowski at 12/23/2005 9:00:11 AM Administer SQL Server express?
I installed it and now what? How
to view/browse/create databases?
Any visual tools?
...more >>
selecting latest statement date per customer inner joined with customer table Posted by steve at 12/22/2005 4:39:39 PM Hi All
I have a statement table which stores customers latest statement details and
I retrieve them with the code below
I am using MSDE 2000
maxmonth, maxfn, maxweek are calculated dates
sql = "Select * from [stheader] inner join [customer] on
customer.[cust_code] = stheader.[cust_code...more >>
selecting latest statement date per customer inner joined with customer table Posted by steve at 12/22/2005 4:38:21 PM Hi All
I have a statement table which stores customers latest statement details and
I retrieve them with the code below
maxmonth, maxfn, maxweek are calculated dates
sql = "Select * from [stheader] inner join [customer] on
customer.[cust_code] = stheader.[cust_code]" & _
" wher...more >>
MS SQL Server 2005 Express Edition Posted by Dhiren Chhapgar at 12/22/2005 8:43:01 AM I installed MS SQL Server 2005 Express edition. But couldnt find
SQLServerAgnet Service....
Dhiren
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |