| 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 to change the default languge of a database Posted by babbitt9 at 8/21/2005 12:00:00 AM I buy a programing book with source code.But the database only can use
English to input data.When I input Chinese,I read "??" from the database
table.
I need help,Thank you!
...more >>
versions: SQL Server 2005 Express / .NET Framework v2.0 Posted by Loane Sharp at 8/21/2005 12:00:00 AM Hi there
I've installed SQL Server 2005 Express Edition on my machine (version
9.00.1187, the "June 2005 CTP"). Do you know the precise version number for
the .NET Framework that must be installed with it?
(.NET Framework v2.0.50215.45, which is the latest version that I can find
on MSDN...more >>
Renaming a SQL 2000 Database Posted by Chip at 8/20/2005 1:00:01 PM Yup i am "newbie" to SQL and i need to rename a database so it will work with
a program we have istalled. The last DB administrator left the company
unexpectantly and the current database has 5.1 GB log file that I cannot get
to shrink and is filling up our harddrive. there is a dabase that ...more >>
indexes for different purposes Posted by Loane Sharp at 8/20/2005 11:42:01 AM Hi there
Do you know of a good reference, or alternatively a rough-and-ready rule of
thumb, about indexing for purposes of analysing a database? I take a
snapshot of a fairly large database and analyse it ... so I'm not concerned
with the index performance issues associated with, say, updatin...more >>
Another SQL Server Express 2005 question Posted by Steve at 8/20/2005 4:48:11 AM Would it be possible to install both sql server express 2005 and sql
server 2000 on the same server win2k machine?
...more >>
SQL / SQLCE Synchronisation Issue??Help Needed Please!!! Posted by steroche at 8/19/2005 2:57:41 PM Hi guys,
I have a problemo - basically i have one large SQL2000 DB. This is
edited / updated etc by users of the website i am developing. However i
also wasnt a SQLCE component as i want certain users to recieve
user-specific information from the database to their PPC's (I don't
have access to ...more >>
ALTER TABLE to create an IDENTITY Column Posted by Tom Vought at 8/19/2005 12:01:13 PM I'm trying to write a script that loads default data into new tables that
(will) have an integer identity column.
When creating the table I do not specify IDENTITY on any column in the
table. Then I use INSERT statements to load in the default data which
contains the IDs. Lastly I want to se...more >>
Non-Clustered Indexes on a Clustered Table Posted by foobar at 8/19/2005 8:06:41 AM Will someone give me an example of creating a 'Non-Clustered Index on a
Clustered Table', so that I can avoid inadvertently creating one?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Limitations to the Upsizing Wizard???? Posted by Ron Cenker at 8/19/2005 7:56:06 AM Are there any limitations to the Access Upsizing Wizard?? I cannot seem to
upsize a database containing a table of 1.5 million entries to an MSDE2000
database. When I reduce the table size to 800K entries, it works. And the
size is no where near the 2 Gig limit. Thanks in advance to anyone...more >>
SQL server Express 2005 compatible with asp Posted by Steve at 8/19/2005 5:27:58 AM Can I use asp 3.0 applications with SQL server Express 2005?
If yes, how easy is it to upgrade slq server 2000 databases to sql
server express 2005? (All the databases are under 4gb)
...more >>
How to export database role? Posted by Mesak at 8/19/2005 2:37:33 AM How to export/import database role?
How to export/import all user on all database?
Thanks...more >>
How many byes in a row Posted by rocky20 at 8/18/2005 1:17:23 PM How would I find out how many bytes are in row in a SQL Server 2000 table?
If there is a stored procedure to do this that would be great since I need
to figure this out for many tables.
Thanks
...more >>
Trans Log Drive Fail Posted by Ben at 8/18/2005 12:52:11 PM I've put my sql 2K transaction logs on a single drive off the raid 5.
I'm curious in what to do if that drive should fail ?
-will sql server start?
-will it recreate the logs somewhere else?
...more >>
Unknown Queries Posted by Mark A. Sam at 8/18/2005 7:15:54 AM Hello,
I have a project with a group of unknown queries (views). I don't recall
ever noticing them until a few days ago, but that doesn't mean they weren't
there. Here are a couple of the names:
dt_addtosourcecontrol (dbo)
dt_addtosourcecontrol_u (dbo)
dt_adduserobject (dbo)
Are these...more >>
Stored Procedure problem Posted by markw_lcc at 8/16/2005 6:48:11 AM Hi all
Hope someone can help on this - new to the area so here goes.
I've got an SQL stored procedure that checks a company name from an import
spreadsheet. If the first 35 characters of the company name are the same on
the spreadsheet as already in the database, it leaves the company name...more >>
SQL Server academic book for teaching? Posted by Jen at 8/15/2005 7:54:22 PM Does anyone know of a good book to use for a 16-week introductory
course to SQL (using SQL server as the platform preferably)? If not,
I can use two books: one for a quick "how-to" on SQL server, and then
one on SQL itself.
Ideally I'd like something with excercises at the end of each chapter...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |