| 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 Running a stored Proc via ASP but don't wait for it to complete? Posted by Richard Morey at 1/21/2004 4:43:04 PM Hi..
I have written a stored procedure that take 5 - 8 minutes to fully execute..
I wrote this routine as a stored procedure because I started to create all
the functionality via ASP but I kept getting time out errors on my ASP page.
The problem is that when I call the stored procedure from t...more >>
Convert nvarchar to varchar Posted by Ron Hinds at 1/21/2004 3:08:40 PM Is there a way to do this with DTS or another tool? I have an Access 97 app
and I'm converting the BE to SQL2K. The upsize tools all want to convert my
Access Text fields to nvarchar, but when I link them back to A97 this causes
problems. I manually changed a field to varchar and the problem disa...more >>
SQL code 10040 encounter attempting to connect to database KDM group Posted by KT at 1/20/2004 2:58:41 PM Any idea what is this error mean and how to troubleshoot
it? TIA
SQL code 10040 encounter attempting to connect to database
KDM group
Db-library network communications layer not loaded...more >>
SQL Server not found (annoying situation) Posted by Leonardo Bosi at 1/20/2004 12:52:09 PM Hello,
We are experiencing this severe problem with our software installed at a
customer's office. We've tried to diagnose the problem, but we couldn't find
the cause (and therefore couldn't find the solution either) that leads to
this undesired behavior. I'll expose the scenario and the probl...more >>
Output Posted by Noorali Issani at 1/19/2004 7:29:53 PM I have one procedure name generalinsert which are as follows :-
CREATE PROCEDURE generalInsert @tablename varchar(30) , @WhereString
varchar(4000) AS
BEGIN
declare @column varchar(50),@datatype varchar(50),@query
varchar(8000),@columnname varchar(8000),
@reccount int,@counter int
declar...more >>
Cannot connect to instance of database Posted by JerryK at 1/19/2004 10:39:08 AM Hi,
We have a SQL Server 2000 system with two instance of SQL Server. On one
system, and only on this one system, we cannot connect to one of the
instances of the database. We can connect to the other instance. When we
try to add the server instance to the server group we get the message:
...more >>
[ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied Posted by Scott Nasello at 1/18/2004 6:51:01 PM Hi - I need some help.
We have a SQL Server that has a stored procedure on it.
We also have some vb script inside of an excel workbook
that calls the stored procedure. It works like a charm
on my system ( I have SQL Server installed on my system).
While we were testing, we sent the wor...more >>
Help Posted by Noorali Issani at 1/16/2004 6:42:00 PM I have created on table like this
create table DateTest (DateChk datetime)
and insert values in that table like
insert into DateTest values ('01-01-1752')
It gave me error like
Server: Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Enterprise Manager Posted by Greg Molchan at 1/16/2004 12:25:37 PM Are their any known issues with running SQL 2000
enterprise manager on an NT 4.0 sp 6 workstation. The SQL
server is 2000 server, but enterprise manager is running
on the nt 4.0 box. It runs for a few days, but then stops
connecting to the sql server? Ideas?
TIA...more >>
FOR XML AUTO Posted by B.A. Baracus at 1/16/2004 8:51:13 AM I have created a stored procedure that creates xml output
via the FOR XML AUTO COMMAND. This stored procedure
creates 3 levels of data which can be decribed as
follows.
CLIENT (ALL CLIENTS)
-> DATE (WILL SHOW EVERY DATE FOR 5 WEEK)
---->APPOINTMENT TIME (APPTS ON THE DATE ABOVE)
I am ...more >>
Selcect text in a word-document Posted by Klaus at 1/16/2004 7:19:56 AM Hi
In a table I have an image-column in which I am storing
word-documents.
Is it somehow possible to select only the text contained
in the stored word-documents?
TIA
Klaus...more >>
how to make sql statement for this Posted by ganesh at 1/16/2004 6:42:14 AM i've a table like this
Field1 field2
1 1
1 2
1 3
1 4
1 5
2 1
2 2
2 3
now i want to select only top 2 first rows of field1
like this
1 1
1 2
2 1
2 2
is there any sql statment for this
Thanks...more >>
Syncronization problem Posted by Laurentiu at 1/15/2004 6:30:20 PM I have the following error when :
The process could not deliver insert(s) at the 'Publisher'.
I don't know anything about SQL.
I have SQL 2000 server with SP3a and SQL 2000 PE with SP3a and I use Merge
Replication.
Thank you
Laurentiu
...more >>
Win CE and SQL 2000 app Posted by Jas Singh at 1/15/2004 4:59:02 PM Hi,
I am trying to create an application for IPAQ (windoes CE) that can access
data from SQL 2000 server and send data back to that server. Can someone
tell me how can I do this.
Thanks,
...more >>
Enterprise Manger - exporting list of servers Posted by Silmar at 1/15/2004 11:10:31 AM Hi!
Is there any method to copy list of servers between Enterprise Managers?
Regards
Silmar
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |