|
|
|
January 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 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 does not allow remote connections. Posted by aCe at 10/7/2007 12:08:26 PM Hi all,
i'm using MSSQL Server 2005 Standart Edition.
i created ASP.NET application without MSSQL Server 2005 Express.
every time i Run my app always show these errors :
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may b...more >>
Full Text Index Posted by Sharif Islam at 10/6/2007 2:45:23 PM Could Full Index option only be configured during installation? When I
try sp_fulltext_table on a table, I get the message that full text is
not enabled for the system.
--sharif...more >>
migrating MSSQL databases to MySQL Posted by agnesroz NO[at]SPAM gmail.com at 10/5/2007 2:09:46 PM Hi all,
I want to migrate databases in microsoft sql server 2005 express
edition to mysql, please anyone can tell me how can i do this.. i
tried installing mysql migration toolkit, but i am getting error,
please can anybody tell is there any prior software to be installed to
work with migrati...more >>
Problem with object owner not dbo Posted by Teresa Masino at 10/5/2007 10:46:34 AM I'm probably forgetting something basic, but right now I'm stumped.
We are moving a database to a new server. bcp'd out the login
accounts and bcp'd them into the new server. Restored the database
backup and everything was working fine yesterday testing out the
application -- this is a 3rd par...more >>
Dynamic Tables Names and Temporary Tables Options Posted by brstowe at 10/5/2007 7:57:48 AM Firstly I consider myself quite an experienced SQL Server user, and
am
now using SQL Server 2005 Express for the main backend of my
software.
My problem is thus: The boss needs to run reports; I have designed
these reports as SQL procedures, to be executed through an ASP
application. Basic, ...more >>
Retrieve next lowest number in mixed set Posted by Zamdrist at 10/4/2007 7:17:28 PM Let's say I have a result set (records) containing numbers such as:
0
1
2
3
9
16
21
45
100
101
102
103
104
105
106
How might someone write a procedure to get the next lowest number in
this sequence? In this case it would be: 4. Some combination of
Select, Min & When, I am sure,...more >>
SQL2005 database backup files Posted by barbara.plume NO[at]SPAM otda.state.ny.us at 10/4/2007 10:45:30 AM We are in the early (development test) stages of upgrading from SQL200
to SQL2005. We have noticed that our backups, created with the append
option, are not stored as individual .bak files when viewed through
Windows Explorer. From time to time, we have to create disk space by
deleting backup ...more >>
negate RESULT SET, all inactive client Posted by Mike at 10/3/2007 10:00:29 PM I' d like to list all inactive clients.
Inactive client is a client who hasn't had invoice for 2 months.
I use INNER JOIN to join invoice view (vwDok4FSFZGrid) and clients
addresses table (adr_Nazwa). I skip empty values (adr_Ewid.adr_Nazwa !
=''). I select only invoices with date after the in...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Timeout Errors - Can Anyone Help? Posted by at 10/3/2007 1:42:57 PM I have a client who has been receiving hundreds of SQL timeout error
messages in their error logs. Specifically, the message looks like
this:
MESSAGE : System.Data.SqlClient.SqlException: Timeout
expired. The timeout period elapsed prior to completion of the
operation or the ser...more >>
ms sql 2005 developer edition Posted by HandersonVA at 10/3/2007 7:39:49 AM is it possible to install ms sql 2005 developer edition databse server
on window XP professional version 2002 with SP2 or just allows install
client version?
...more >>
SQL 2005 Ambiguous column name Posted by rdraider at 10/2/2007 8:12:36 PM I have a strange issue and was hoping somebody could explain. The below
query gives an ambiquous column name error on an install of SQL 2005
Standard, sp2. This same query works fine on another install of SQL 2000
Standard sp4 and SQL 2005 Workgroup. The order by clause is causing the
err...more >>
replication or mirroring Posted by mmark751969 NO[at]SPAM yahoo.com at 10/2/2007 2:24:03 PM We have a sql server 2000 sp3 server on a win2k3 server standard
edition. This is on dell hardware with a dell scsi dasd enclosure
directly attached. We want to duplicate the hardware and replicate or
mirror the database to the backup server and do a manual or automatic
failover in case of out...more >>
Exporting a MS-SQL database Posted by bsagal NO[at]SPAM gmail.com at 10/2/2007 10:36:56 AM I have an asp site connected to an MS-SQL database, I need to export
the database and import it in to a MySQL database? How would I be able
to do this? My only way of communicating with the MS-SQL database is
via asp scripts.
Thank You
Ben Sagal
PS. i have no problem fixing the SQL code ma...more >>
Finding common joins Posted by Cindy at 10/1/2007 6:35:23 PM At the risk of asking a stupid question -
Is anyone familiar with either a query against the systables or maybe
an outside tool that will provide a list of the most common joins that
have been made in user created views? I'm not talking about table
relationships that are established at the data...more >>
Simple recovery model affect performance? Posted by rdraider at 10/1/2007 5:03:55 PM Do you get any performance improvement by using a Simple recovery model?
Full backup run each night, loss of 1 days data is acceptable.
This is an ERP app (accounting, inventory, order entry, etc) so a mix of
reads and writes, 20 users.
SQL 2000 Standard, Windows 2000 sp4, 2gig ram, RAID1 for O...more >>
Alternate to cursors Posted by srirangam.seshadri NO[at]SPAM gmail.com at 10/1/2007 12:12:22 AM Hi,
I have a situation where I am loading data into a staging
table for multiple data sources. My next step is to pick up the
records from the staging table and compare with the data in the
database and based on the certain conditions, decide whether to insert
the data into the database...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |