|
|
|
January 2003 March 2003 April 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 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 July 2007 August 2007 September 2007 October 2007 |
Can I carry my existing DB users to a new server and restore??? Posted by SD at 4/27/2004 1:30:32 PM Hi,
Quick question, I have about 20 users in my local server and database. We
are looking to restore that database to a new server in a new network and
still be able to retain the database users.
We have created all 20 logins in the new server (exact names) but when we
restore the database ...more >>
SQL Server Collation Posted by kusmuk NO[at]SPAM reflected.org at 4/26/2004 11:26:37 PM Hi All;
We have a database which is designed in Turkish collation. Widely,
its designed for that language and there is no way to turn it back.
But, remote database had been installed in English collation; which
collates all turkish characters with english ones. I have no idea
Windows Coll...more >>
MSDE 2000 SP3 Connection Problem Posted by Mark Miles at 4/20/2004 11:41:00 PM I am have a problem which has only just started happening while trying to
connect (locally) to MSDE 2000 (SP3a) which also prevents me from using
VS.NET Server Explorer.
When I try OSQL -E -S mimpc\NetSDK (this use to work) I get the following
error
[Named Pipes]SQL Server does not exist...more >>
web host transaction log problem Posted by dude at 4/20/2004 9:32:35 PM Hello,
I am having a problem with my web host handling a MS SQL problem that I am
having.
--- ERROR ---
Microsoft OLE DB Provider for SQL Server error '80040e14'
The log file for database 'DATABASENAME' is full. Back up the transaction
log for the database to free up some log space.
...more >>
SQLServer 2000 Installation Posted by Christopher J. Stephens at 4/19/2004 3:16:50 PM Hi,
I am just installing SQL Server 2000 on my desktop running Windows XP Pro
and intend to install the Client tools onto my laptop and do my access from
the laptop.
When I install the latest service patch, will I also need to install it on
the laptop as well for the Client tools?
I am ...more >>
change (local) to localhost and what's the difference Posted by who at 4/18/2004 12:54:20 AM Two questions
Once sql server has been installed how to change from (local) to
localhost or the other way arround from (local) to localhost? (currently
set (local) and want to change to localhost.
Secondly, what the hell is the difference between them. On development
machines I have install...more >>
How do I speed up this query ? (1.7M table entries) Posted by Alan Silver at 4/14/2004 6:32:17 PM Hello,
I have a table containing position data for all of the postcodes in the
UK. There are around 1.7 million of these. I would like to be able to
query the table and pull out all postcodes within a specified distance
of a given one. The code I have at the moment takes about 20 seconds to...more >>
Monitoring a Read/Write access to a DB Posted by moharss NO[at]SPAM auburn.edu at 4/13/2004 12:00:09 PM Hello,
I am trying to write a VB.NET application to do this:
1. Count the number of Read/Write accesses to a DB on the server and,
2. Get the last access time of the DB since its creation.
Tried looking it over at MSDN...tried googling....but have failed. Any
inputs would be more than valuabl...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SELECT & number of line Posted by myname at 4/5/2004 12:21:37 PM Hello,
I'm using SQL Server 2000.
I would like each line of my SELECT to contain a column
giving the number of the current line.
It seems the only way to do that is something like:
INSERT identity(int,1,1) as lineNumber,* INTO newTable FROM oldTable
But oldTable as an identity column...more >>
Finding and inserting consecutive pairs Posted by myname at 4/5/2004 11:12:42 AM Hello,
I'm trying to insert into a table consecutive pairs from another table.
Right now, I'm using a cursor but I wonder if there's a faster way.
Example:
My table1 contains a column of integers: 1, 20, 3, 45, 12
I want to obtain this in a two columns table Table2 :
(1;3) (3;12) (12...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |