|
|
|
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 re: SQL Server and Access Reports Posted by Arman at 12/7/2004 7:38:05 PM I was trying to run my Access Report using Link Tables from SQL Server. It
is very strange that i am recieving ODBC-call failed when executing a
query.
RIGHT JOIN = Error
INNER JOIN = Ok.
dbo.TableName does not match with a table name or alias name used in the
query #107..
How can i fi...more >>
Need to interface MS SQL in C++... Posted by acoquinar at 12/7/2004 2:24:16 PM Greetings !
We need to find if MS SQL has an API for connecting C++ components to it.
We don't know if "extended stored procedure (xp)" is the way to go.
Why do we need that ?
We must implement a synchronization software layer to make sure an ODBMS has
the same values as tho...more >>
Alerts - SQL Server Agent Posted by Ignacio Hernandez at 12/7/2004 12:06:37 PM Hi,
I'm trying to find a sample on how to set-up (or trigger) a SQL Server event
alert of Severity 009- User Defined.
Thanks in advance,
Ignacio
...more >>
SQL 2000 and SQL Lite Posted by Mike Lawrence at 12/7/2004 10:45:06 AM I have an application that uses SQL and another that we will be upgrading
soon. The application we are upgrading has the option to use SQL or SQL
Lite. I'm assuming SQL Lite means MSDE. I was wondering if it is possible
to run SQL and SQL Lite on the same server for two different applicatio...more >>
Enterprise Manager Error Message Posted by bashar at 12/7/2004 9:39:18 AM everytime i want to (Open Table-->Show All Rows), this error message comes up
(( The query cannot be executed because some files are either missing or not
registered.
Run setup agian to make sure the required files are registered. ))
Then a windows comes up with an empty table. No data and no ...more >>
Connection Pooling Posted by Julie at 12/7/2004 9:37:03 AM Can someone tell me how to enable or disable connection pooling for SQL server?...more >>
How to dynamically name a #temp table in sql server 2000 ? Posted by Karl XII at 12/7/2004 4:49:03 AM Hi all!
I am having problem with a stored procedure in which I have an input
parameter that is dynamic. I want to use that parameter - in this case the
sessionid for the current user - to execute an SQL Query and store the result
in a temp table named as the sessionid.
For example...
...more >>
Question about upgrading SQL Server to newer version Posted by dupat at 12/6/2004 5:54:02 PM If I am running SQL Server 6.5 and own 25 licenses and I wish to upgrade =
to 2000 or 2003, are my licenses any good on the newer version?
I expect an upgrade fee but do I need all new licenses?...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to create a SQL database Posted by Arvind at 12/6/2004 4:21:03 PM dear all, I am new to sql, I have purchased a web hosting service which is
supported to SQL7 can you please tell me how to create a database on that
webserver, I have created a database in my local systems also let me know how
to export that database to my website server.
Your answer is ver...more >>
foreign key problem with SQL Server MSDE 2000 Posted by Amadej at 12/6/2004 3:48:47 PM Hello everyone,
I'm working on a project for which I would like to enable support for
MS SQL/MSDE but I am experiencing problems with some foreign key
constrains (I'm new to MS SQL). Hopefully someone can clarify what I
am doing wrong. The puzzling thing is the same SQL works fine with
Fire...more >>
Same fields in multiple indexes Posted by SQL Newbie at 12/6/2004 3:12:41 PM Given an example table of:
customer, order, product, dollar, note, yadda1, yadda2, yadda3
Given an index of
customer+order+product
Isn't it completely redundant to have an index of:
customer
or an index of
customer+order
Where querying based on customer+order (or customer alone), would...more >>
UNIQUE index but ignoring NULLs Posted by Evan Camilleri at 12/6/2004 2:58:01 PM I would like to create a UNIQUE index but ignoring NULLs.
i.e. the field can contain a unique passport number or else nothing if the
user does not know it.
Is it possible?
...more >>
More on SQL Server Developer Edition Posted by Kevin at 12/6/2004 9:11:04 AM I just purchased SQL Server 2000 Developer Edition and want to use it to
connect via TCP/IP to a SQL Server database located on a web host server.
The application has the Client Network Utility and allows me to go about
connecting, but I get a timeout error when I try to register to the remot...more >>
reporting tool Posted by seeker53 at 12/6/2004 8:23:03 AM Doesn't sql server 2000 have a reporting tool other than crystal within its
application?...more >>
IIF function wont work Posted by Nickl at 12/5/2004 7:09:01 PM I have a problem using the IIF function in an Access Project. I am trying to
use it in a view/function, in the column grid of the designer, but I get the
error "ADO error: iif is not a recognised function name" when I try to save
the View/function.
THe expression I am attempting to use is;
...more >>
Software Assurance Posted by Richard at 12/5/2004 1:13:04 PM We are about to purchase server software - SQL 2000. However there is also
an option of software assurance that provides 3 years free updates (I think),
including SQL server 2005 but this is around 40% more expensive. I find it
hard to justify this additional cost given the premium and there...more >>
Delete stored proc called from cls Posted by David Clifford at 12/5/2004 11:35:00 AM Hello.
I am re-writing a very large Jet 4.0 database into SQL Server 7.
I am pretty new to SQL Server 7 and I am struggling a little with syntax to
put a variable into a stored procedure via a class function.
I want to delete all the data from a table. However, the table may not be
the sa...more >>
Restore sql6.5 database to different server? Posted by Brian PIerce at 12/5/2004 10:25:03 AM I have tried everything I can not get the "Restore Now" button to show up
once i select the file i want restored. I got the SP_HELP_REVDATABASE output
to help me I was unable to get the master db please help
12/05/2004...more >>
SQL Server Reporting Services Limitations Posted by M. Derbashi at 12/5/2004 2:45:02 AM What are the limitations for the SQL server 2000 Reporting services,
and can I use reporting services for Enterprise solutions?...more >>
stored procedure executed successfully but did not return records Posted by Nickl at 12/4/2004 3:55:02 AM When I run a stored procedure from an Access Project I get the above message,
and I don't my users will like it. Does anyone know why this message appears
and how I can get rid of it? It happens with or without the "Set NoCount On"
line
This is how the Proc looks via Access:
ALTER PROCED...more >>
Real data type Posted by David Clifford at 12/3/2004 11:18:50 AM Hello .
I have just migrated a rather large QA database to SQL server 7..the one
that came free with VB6 pro. I am really quite new to SQL Server.
My question is:
Many fields contain laboratory results for analytes that were stored as
single data types in Jet 4.0 Typically the results would b...more >>
sql server analyser Posted by zehraoui at 12/3/2004 11:13:07 AM Dear Team members;
currently, I am working on clustering for my MSc thesis for a Bank in
Italy. I will be so grateful if you could send me more information
about:
1- the architecture of the Microsoft SQL 2000,
2- the exact algorithms used in cluster analysis and decision tree
model,
3- what a...more >>
Sort order changes on each run Posted by Stan Reckard at 12/3/2004 10:49:13 AM I have a SQL query that when run in SQL Query Analyzer gives a different
ordering of records on each execution. This happens on SQL Server 2000 Ver
8.00.760 (SP3). We have the exact same database on another SQL Server where
the same query executes consistently each time. Since the two versi...more >>
what is developer version of SQL Server 2000 for ? Posted by Jeff at 12/3/2004 9:59:03 AM What is developer version of SQL Server 2000 for ? Does it mean that I can
be running XP locally , connecting to the SQL Server 2000 in another company
and manage the whole SQL Server 2000? like running SQL Server Enterprise
Manager at my end?
Thanks
Jeff...more >>
Installing sql 2000 on SBS 2003 Standard Posted by Harald at 12/3/2004 5:39:04 AM Hi.
I'm trying to install SQL server 2000 Enterprise edition on a Small Business
Server 2003 Standard Edition.
When trying to install I first get this message;"SQL server 2000 SP2 and
below is not supportet by this version of windows".
The options cointinue, cancel and details are shown
...more >>
SQL 2000 on Win 2003 standard server --- slow response time Posted by Simon at 12/2/2004 8:49:02 PM Hello,
server --- P-4 3.2gb w/ 1gb RAM, SCSI Mirror on C:, SCSI Mirror on D:
Win2003 --- on C:
Application --- on D:, Solomon w/ SQL 2000.
number of users on LAN --- 10, normal speed
number of Solomon users --- 4, very slow
response time from Win2000 Prof workstations are very slow.
Help, any...more >>
how do I ensure data integrity between tables... Posted by lewi0168 at 12/2/2004 5:43:01 PM Not sure if this is the correct group to place this question.
I am new to managing/ developing for SQL servers, it has been three years
since uni database systems. I just want to know what is the best way to
ensure data integrity between tables. Just started working with this company,
alrea...more >>
sql 2000, email messaging for job-controlling Posted by Frank Prendel at 12/2/2004 12:39:37 PM hello forum,
first of all, my english is a bit bad, so dont worry about my bad text.
i want to set up an email-notification, if a job from the agent works
perfektly, and even if not.
i have some thinks i need for:
first, my smtp server is 10.250.something.something
second is, the names ...more >>
xp home and sql 2000 standard Posted by Cicciolina at 12/2/2004 10:43:02 AM Please help! I need to install SQL Server 2000 on my machine which run XP
Home (I hate this OS). I understand SQL Server's supported platforms are NT
4.0 & Windows 2000. Can XP [downgrade] to Windows 2000? Or is there an easier
way??...more >>
Running Stored Procedure within DTS Posted by Jay at 12/2/2004 10:07:04 AM Hi
I'm running a stored procedure from DTS. The SP has got a WHILE LOOP that
should execute 3 times. When I execute it from QUERY ANALYSER it executes 3
times. However, when I execute it from DTS it only executes once. The SP
procedure doesn't take any parameters.
S/W: SQL Server ...more >>
Migrating from Access regarding image storage Posted by jpresley at 12/2/2004 9:03:01 AM We currently have a 2 mg Access db with images and are having lots of
problems. I have been told that using SQL server would solve those issues.
Would the same issues exist with Access as the front-end? What else can you
suggest? Is anyone storing images in volume? Any suggestions would b...more >>
SQL Server 2000 and Win2k3 Ent Ed Posted by Alexb at 12/1/2004 1:17:03 PM What is the max memory supported by SQL Server 2000? Will this change in Sql
Svr 2005?
Thanks in advance...more >>
W2003 server and SQL server 2000 Posted by Tavio at 12/1/2004 12:41:08 PM Hello,
I did all that you wrote me and nothing.
I did the same test in Windows 2000 server and it worked without problem.
The NAT address are working OK.
I think the problem Windows 2003 and SQL server combination .
Can you help me ?
Regards.
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |