| Groups | Blog | Home |
|
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 November 2007 |
Filter by week: 1 2 3 4 5 How do I centralize sql server database Posted by rhaazy at 7/13/2007 12:00:00 AM I am developing around sql server express 2005, and I have a database
that I, and a few other people work on. Right now whenever someone
needs to make changes, they need to go to where the database is on the
server, copy it locally, attatch it, make changes, detatch, and copy
it back over to th...more >>
SQL 2005 WMI Performance Counters Posted by David Gibbons at 7/12/2007 5:12:39 PM Hello all,
I'm new to SQL2005 and I seem to be missing something when it comes to
performance counters and the WMI interface. Back in the day of SQL 2000
there was a set of WMI objects that I could access with performance
information located in the CIMV2 namespace
Win32_PerfFormattedDat...more >>
Importing a dbf Posted by Carlos Sosa Albert at 7/12/2007 4:07:17 PM Hi guys,
I have to import a .dbf to a SQL 2005 Server.
Since SQL2005 doesn't support importing dbf, I tried to first open it using
Excel or Access, but the problem is that the database has about 11.000.000
records... so Excel is not enough and Access seems to crash.
I've been able to "l...more >>
Count distinct date query - column containts datetime values Posted by itsyash NO[at]SPAM gmail.com at 7/12/2007 6:14:56 AM I want to use this simple query:
select distinct(date) from mytable.
However, the database column contains date and the time associated
hence returns me multiple records for the same date. Is there a
function or some other way in which I can filter out the time and use
the query only on t...more >>
Import JPEG file into db Posted by Adriano at 7/12/2007 12:00:00 AM Hello!
I have the following table:
CREATE TABLE [dbo].[image] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[tn] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1251_CI_AS NULL ,
[img] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Can anyone help me to...more >>
Query help please Posted by Sid Price at 7/11/2007 3:28:35 PM I have three tables of data. Table "A" is for filenames (and attributes),
TABLE "B" is a keyword table that has entries for filename and keyword
pairs, TABLE "C" has entries for secondary file keywords and filename pairs.
I need to be able to search these tables to produce a dataset. The quer...more >>
3gb for SQL Workgroup Posted by Al Franz at 7/11/2007 2:27:30 PM Is that right that 3gb is the minimum for SQL Workgroup version running on a
Win 32bit Server? Or is that the limited amount of memory it can use, see
attached chart. Confused since higher versions say limited to OS max.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
...more >>
store count into a variable Posted by SAC at 7/11/2007 12:00:00 AM How would I store a count into a variable> I tried
intCount = Select Count(*) from sometable
but this doesn't work.
How can I do this?
Thanks.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
What is Windows on Windows? Posted by Al Franz at 7/10/2007 6:05:58 PM Looking at the differences from SQL Server Workgroup and Standard. The
Workgroup states Windows on Windows for 64 bit support, the Standards says
YES. What does that mean?
...more >>
SQL 2005 and Microsoft search Posted by Alex at 7/9/2007 7:47:24 PM Hi, Hope someone can help me.
I currently use an SBS2003R2 server which has SQL2000 SP4 (Build 8.0.2039)
installed.
We use SQL in Exchange plus Brightstore Backup.
Today we have come across a sitiation that for some reason our Microsoft
Serach Service will not start, no matter what we do. ...more >>
> Not recognized Posted by SAC at 7/8/2007 4:47:06 PM I have this line in a select statement in a view:
IIf([PriceExt]>0,[GP]/[PriceExt],0) AS [GP%]
I get an error message saying that > is not recognized.
I also have ! in the select statement -- I'm converting from MS Access --
and it says it does't recognize it either.
What do I need to...more >>
Web over Local Area Network Posted by Shakeel Ahmad at 7/8/2007 12:00:00 AM My computer is on a Local Area Network. This network has more than 200
connection. I want to host a web site on my personal computer which should
be visible over this network.
I want to use Access and SQL but i know nothing about SQL. Fromewhere should
i start... please guide me or give me ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |