| Groups | Blog | Home |
|
March 2003 May 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 November 2007 |
Filter by week: 1 2 3 4 5 Enterprise manager - databases - "No items" Posted by George at 4/21/2004 2:15:10 PM Hi all,
I'm using Enterprise Manager to connect to several remote SQL Server
Databases (in different locations).
It works fine for all servers except the one that shows "No items" when I
click on "databases". After "refresh" it successfully receives list of
databases but after a few hours...
...more >>
SQL date format Posted by Martin at 4/21/2004 2:10:50 PM Hi everyone,
I'm using Access adp and I would like to know how to format the date anyway
I like.
The problem is this:
My SQL server is configured to use the mm/dd/yyyy format, the network server
also uses this format.
The problem is that some workstations are configured to use the dd/m...more >>
Slow access from client M/c to Sql server 2000 Posted by mustafa at 4/20/2004 10:26:23 PM Dear Sir,
I had install application on client computer which is made
in vb6.0 and sqlserver 2000 & Crystal 8.5. While I am
trying to access the data for employee table it takes very
long time to display the data in combo box. The client
computer is far away from the server.
I.e. it is c...more >>
BDE 5.01 not connecting to SQL2K after patching Posted by contiguous1 at 4/20/2004 10:26:04 PM Hello All
I am experiencing unusual behaviour with a number of desktops (3 of 20) running the BDE and the SQL connectivity option from the sql cd. For reasons unknown the BDE suddenly stops connecting to the database and cant be fixed without a reimage. Appears to be a key or dll that is causing ...more >>
Minimum client connectivity requirement Posted by Mark at 4/20/2004 11:35:13 AM I have Win9x clients. For them to be able to write to a
SQL database (2000), I think I would need to install
MDAC. However, many of these clients are connected with
an extremely slow WAN connection (56K) which makes MDAC
install via login script difficult or impossible. I don't
need the co...more >>
Row and Table Level Locking Posted by ss at 4/19/2004 5:08:25 PM When we do Insert or Update How SQL optimizer when optimizer lock the table
and
when optimizer lock the row?
I know we can force these using Hints.
TIA
...more >>
Problem after restarting DNS Posted by clint at 4/19/2004 10:10:45 AM Hi,
i have problem. When I restart DNS server I also have to restart
my application becouse it can't fint MS SQL server. I connect to
MS SQL via TCP/IP with IP number. What is wrong?
Is it clients bug?
Regards,
clint
...more >>
Enterprise manager - Prevent Users from seeing other databases Posted by Arijit Upadhyay at 4/17/2004 8:34:21 AM Is there someway to prevent SQL2000 users seeing other databases in the
list, when they connect using enterprising manager. The login-security
prevents them from modifying other db & tables, but is there some way list
only the database the user has access too. Somewhat like this utility at
http:...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Using CURSOR Insert data into Table Posted by vikash.verma at 4/16/2004 5:33:50 PM Hi All,
I am selecting a table and getting some data from it.
Then by using Cursor i try to Insert it into a new table(The new table =
is already created).
But it says Error while Insert
The Code is written below.
////////// 1st Approach////////////////
DECLARE cursor1 CURSOR=20
For Se...more >>
syntax question: N Posted by Brad White at 4/16/2004 2:37:43 PM in the queries
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name =
N'OldDatabase)
DROP DATABASE [OldDatabase]
exec sp_dboption N'DatabaseName', N'single', N'false'
What is the N for?
Thanks,
Brad.
...more >>
SQL Tuning Posted by ss at 4/16/2004 9:17:01 AM SQL Server 2000
I have one temp table which has Start_date and this temp table has
around 5000 rows. I am joining this temp table with view in following query
Select l.*
from table_1 l
,#Temp Table t
where t.employee_number = isNull(employee_number1,employee_number2)
and l.end_...more >>
Copying database files Posted by Paul Dussault at 4/16/2004 9:16:42 AM Hi all,
I need to give remote access to a SQL Server 2000 (MSDE) dabatase, meaning
that a developer must be able to upload/dowload via FTP the mdf and ldf
files.
This isn't a production database, so there is no active connection to it
except for the said developer.
The system doesn't eve...more >>
help Posted by Noorali Issani at 4/15/2004 9:49:09 PM id name
1 Noor
1 Ali
2 Hamsan
2 Guy
I want the data like this.
1 Noor Ali
2 Hamsan Guy
Can any body tell me
thanks
NOOR
...more >>
SQL Server 7 Client for SQL Server 2000 Posted by Laura at 4/15/2004 7:51:00 AM We upgraded some of our SQL Server 7 machines to 2000.
Some users still have SQL 7 client (Enterprise Manager,
etc.) on their machine.
Should this cause a problem when viewing a SQL 2000 Server
through a 7.0 client? Or is it better to upgrade the
client to 2000 and then have to view t...more >>
SQL transforme les dates en secondes / SQL modify dates in secondes value Posted by fabrice.com NO[at]SPAM free.fr at 4/15/2004 2:52:10 AM Je travail sur une base SQL dont je ne suis qu'utilisateur.
Le problème est que l'ensemble des dates ont été transformées en
valeur représentant des secondes par rapport à une date d'origine qui
est le 01/01/1970 00:00:00.
Je ne parvient pas avec SQL à trouver comment faire se calcul !? si
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |