| 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 Windows Server 2003 + SQL Server Yukon Scenario Posted by Martin R-L at 11/14/2003 3:11:46 PM Subject: Windows Server 2003 + SQL Server Yukon Scenario
We're going to deploy a solution in two years time, where WinForm clients
are accessing a SQL Server Yukon directly. The server OS will be some
version of Windows Server 2003.
The database will be used by 32 clients during normal offic...more >>
Need Help From SQL Experts Posted by Amit at 11/14/2003 2:22:35 PM Hi there,
we are having an application running on sql server. on client side there is
an a setting for the internet (to run internet on each machine) in which
they have assigned the ip address in the gateways. this setting creating
problem in which application not going on local server it goes...more >>
Save it into File Posted by Noorali Issani at 11/14/2003 11:47:42 AM Dear Professional
Is there any possiblity that I can save the result of any query into file
automatically.
Like I want to save the result of the following query into the mention file
name.
Select * from Emp.
I want to save that result into c:\emp.sql
Note:
I just execute...more >>
Dynamic Stored Procedure Posted by Noorali Issani at 11/14/2003 11:27:11 AM Dear Professional !
How can I create dynamic stored procedure in which it will take table name
and field name as a input critaria and Insert into the table but one thing
is very important that before inserting it should check that specific record
is exist or not. Can any body let me know how I...more >>
What type of OS can i install sql server 7 on? Posted by jp at 11/14/2003 10:30:46 AM We have an application that requires SQL server. We want to set up a pc to
show a 'run time' version of the application.
We wanted to install SQL server 7 on the pc and run the application locally.
Can i insall SQL server on any OS or only NT Server?
thanks
...more >>
all but one client connects Posted by Anthony at 11/14/2003 7:23:58 AM Hi,
Recently upgraded an application from access to
msde...install and ran sql client on 5 XP and 1 win2k pro
machines...only the win2k box cannot access the database...
When I try to point to the data base it says it installed
them but will not connect to them...checking the sql
server DS...more >>
BUG: SET FMTONLY not working on SQL Server 2000 Posted by Bulent Biyikoglu, MCSD at 11/13/2003 9:56:08 PM Hello
I have reported this bug previosly, but Microsoft has so far not responded yet, so I am reporting it again. Basicly, SET FMTONLY is NOT working correctly with SQL Server 2000. Because of this bug I still have to use SQL Server 7.0 for my campuswide student information system application, alt...more >>
ADODB Connections Posted by Brian P. Hammer at 11/13/2003 1:32:38 PM All,
I have a MDI application with 15 or so different forms. Each form connects
to the same SQL database via adodb. My question is, is it better to:
1. Just open the connection upon startup, then just reference the connection
throughout each form opening
2. Open and close each connection ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Procedures name with their paramaters Posted by Noorali Issani at 11/13/2003 9:50:20 AM Dear Professional
I just wanna know about all procedures name with their parameter via single
query !, how ?
Waiting for your reply
NOOR
...more >>
sql server 2000 clent connection problem Posted by des_jdags NO[at]SPAM mail.kar.nic.in at 11/12/2003 9:45:48 PM dear sir
recently we have purchsed standard edition of sql server
2000, at the time of installation clent access to sql
server was ok, bacause of the virus problem system in
clients were corrupted, we have reloaded the system and
sql server 2000 for client (client option) only .
throu...more >>
Without using SQL Client to connect to SQL Server? Posted by Anand at 11/12/2003 7:53:20 PM Hi
Is there any way that I can connect to a SQL Server from
one of my PC without having SQL Client tools. I can
install some minimal dll or any exe so that I need to
connect to the SQL Server.
If any solution please let me know.
Thanks in advance.
Anand...more >>
Query Question Posted by skc at 11/12/2003 8:02:43 AM I am trying to export data out of a table that contains
text field types.
Here is the SQL:
SELECT 1, 2, First(3) as First_Date, Last(4) as Last_date,
SUM(val([5])) as Sum_Qty
FROM Results
Group By 1, 2
Field 3 and 4 contain dates in the format date/time but
are in a text datatype....more >>
insert tab character to a string Posted by haliluya at 11/11/2003 5:16:07 PM how can I insert a 'tab' character into a string data type? I tried char(9) in the help and it replaced by a single space when displayed. thanks....more >>
SQL Client password Posted by David Bujnovsky at 11/11/2003 3:55:54 PM The SQL database / application that I am using does not have any
functionallity to change the users password. It also does not use Windows
security (I have to set up the users in SQL.)
Is there a simple utility that would allow users to change their own SQL
password? Could I create a script?
...more >>
Get ID of New Inserted Record Posted by Brian P. Hammer at 11/10/2003 8:22:51 PM All,
I am inserting a new record into SQL and need to return the assigned
IDNumber (autonumber) to my app or be able to get the ID.
Dim sqlUpdate As String = "INSERT INTO tblCompanyInformation(CompanyCode,
CompanyName, CompanyAddress1, CompanyAddress2, ProjectDetails, CompanyCity,
CompanySt...more >>
Timeout when displaying tables in Enterprise Mgr & VS .NET Posted by Brad navarro at 11/10/2003 6:23:04 PM Hi,
I'm running into an annoyance that I can't figure out how to fix. For SQL
Server 2000, in both Enterprise Manager and MS Visual Studio .NET Enterprise
Architect Edition, if I display rowsets for a table and the results are more
than a page long, I eventually (~5 mins) get a popup message ...more >>
Database from server Posted by Sylvain at 11/10/2003 9:47:54 AM Hi, i would like to list all database from a server using ado. Does anyone
know how to do this.
Thanks
Sylvain
...more >>
Slow connection to sql server Posted by anonymous NO[at]SPAM discussions.microsoft.com at 11/10/2003 8:14:08 AM The workstations in our office take approx 3 minutes to
connect to the sql server program we use. Any
suggestions where to begin searching for the problem?...more >>
Linux Client Posted by David at 11/10/2003 3:01:49 AM Can somebody tell me whats the best way to connect to SQL
server from Linux using C/C++.
Has this ever been done in commercial projects?
...more >>
Join SQL Server Posted by Roma at 11/8/2003 11:20:41 PM hi
i can't join sql server from client why ???
thank's
...more >>
Space Used Char V/s varchar Posted by Abraham at 11/8/2003 4:37:53 PM I know char uses more space than varchar since it right pad all data.
But below example suprises me .
Any ideas ??
------------------------------------------------------------------------
create table TEST_TABLE(
recno int,
F_1 char(55),
F_2 char(55),
F_3 char(55),
F_4 char(55))
go
declar...more >>
70-300 Posted by rajesh at 11/8/2003 3:30:47 AM can anubod tell me some online guide for this exam...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |