|
|
|
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 |
Microsoft SQL Server Reporting Services Posted by mattias_torngren NO[at]SPAM hotmail.com at 1/28/2004 2:31:39 AM Hi all!
I have downloaded the new realese of SQL Server Reporting Services
(the real release, not the Beta 2) and gets the following error
whenever I try to build, deploy or preview a report. I even got it
when I try to shut down the Microsoft .Net IDE. Does anyone have a
clue?
I have used...more >>
calculated a field in a view Posted by barbara.mccormick NO[at]SPAM cph-inc.com at 1/27/2004 3:47:08 PM I have a SQLServer2000 database in which I have created a view. I want
to add a column to the view called PHASE. One of my columns in the
view is called CONST_PHASE. I want to populated the new column PHASE
with the word 'Direct' if (CONST_Phase >=29 and CONST_Phase <=59) else
I want to populate...more >>
Client-Side Enterprise Manager Installation... Posted by dwilkin NO[at]SPAM ushwy1.com at 1/23/2004 12:22:16 PM I installed the Client Tools of SQL Server and have a
running installation of MSDE 2000.
Everything works now, except for the Enterprise Manager.
I get a confronting error message for which I have to
kill the process.
Error message details:
caption: MMC.exe - Entrypoint not found
deta...more >>
VB ADO error after upgrading to SQL Server 2000 Posted by des_crocker NO[at]SPAM harcourt.com at 1/22/2004 8:51:26 AM Hi all,
I have a VB 6 application that has been running for 6 years on SQL v7.
I'm testing it on a SQL v2K box and it fails when issuing an ADO
update statement for the second time with the 80040e38 error - 'Row
cannot be located for updating. Some values may have been changed
since it was la...more >>
Access with SQL Posted by Ernie Adsett at 1/21/2004 7:55:27 PM We would like to have SQL connect with an Access database over a WAN.
Is the best way to use MSDE and allow SQL to connect directly to the
Access database or to convert this database every so often to SQL?
Thanks!
Ernie Adsett
...more >>
Network Question Posted by Ernie Adsett at 1/21/2004 7:25:10 PM We are developing with SQL 7 Developer Edition and planning to install
MSDE with the VB application. We received the following question from
the IT dept. of our client:
"Does your version of SQLServer database work well across a frame
relay wide area network?"
Should there be any problem...more >>
Passing a parameter into a LIKE command in a stored procedure... Posted by Fabio Papa at 1/20/2004 8:11:48 PM Hi All,
I am having quite a bit of trouble getting a certain stored procedure to
work properly. In my web page I have a list of checkboxes that post to the
url. When I retrieve the value for the "beds" checkbox list from the url it
looks something like "1,3,5,7". Now I want to pass this int...more >>
Access migration to SQL/MySQL? Posted by Steve at 1/18/2004 9:54:00 PM Hello
I am looking for some advice about regarding the pros and cons for the
following.
We currently have several MS Access databases with the data held on
our local file server and each workstation holding it's own Access
front-end linking to those tables. We also have a website hosted
re...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Server 7 Trace Flags Posted by TWiSTeD ViBE at 1/16/2004 10:58:39 AM Hi folks,
Does anyone have a comprehensive list of the Trace Flags for SQL Server?
More out of interest than anything as some of their features are extremely
useful!
Thanks in advance...
Rob
...more >>
SQL 7 stored procedure & Windows XP?? Posted by Damon at 1/15/2004 10:29:12 AM Hi,
I have a stored procedure within my app which works perfectly when running
my VB6 app from Windows NT, however I have now had to move my project over
to Windows XP. When it gets to a certain point where it needs to open up a
recordset relating to this certain stored procedure it just exit...more >>
String / Variable Problem - Dynamic Table Name Posted by Martin Feuersteiner at 1/14/2004 5:44:54 PM Hi
I'm grateful for any light you can shed on this!!
I've to admit, it's an unusual design but I've multiple contact tables named
e.g. i2b_ash_contact or i2b_ted_contact.
'i2b_' and '_contact' are static but the middle part is dynamic.
Storing all contacts in one table with an identifier ...more >>
UPDATE SET evaluation order Posted by mlikharev NO[at]SPAM aurigin.com at 1/12/2004 6:47:48 PM Hi,
Just bumped into something and I do not know whether my assumption is
correct.
Here is my select,
DECLARE @POS INT
DECLARE @ID INT
SELECT @POS= -1, @ID = -1
UPDATE [TABLE] SET [position] = @POS,
@POS = CASE WHEN @ID <> [oid] THEN 0 ELSE @POS + 1 END, @ID = [oid]
.....
As y...more >>
SQL Server developers edition on XP Pro? Posted by Gene Frassetto at 1/2/2004 7:05:20 PM I just bought a copy of SQL Server 2000 (with service pack 3a) that I
intended to install and run on XP Pro. My concern is that the requirements
list on the box do not include XP or XP Pro. Will SQL Server 2000 developer
edition run on XP Pro?
...more >>
Adding a new user. Posted by Kris at 1/2/2004 1:47:59 AM In Ms SQL 2000, I want to be able to share my database with another user but
I only want them to be able to look at the database and not be able to
change anything.
Does anyone know how I go about doing this?
...more >>
Can't add a new SQL record using Access? Posted by Steve P at 1/1/2004 3:06:02 PM Please forgive this basic question but I am just getting started. I am using
an Access project file connected to an SQL table. I used the Enterprise
Manager to create a simple table with only 3 fields. When I open the
database from the Tables section in Access it will not let me add a new
record...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |