|
|
|
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 ntext invalid for local variables Posted by Jim in Arizona at 9/14/2006 2:40:48 PM I got this error:
Msg 2739, Level 16, State 1, Line 1
The text, ntext, and image data types are invalid for local variables.
I wanted to create a stored procedure I could call from my web
application to insert data into a table. If I can't use ntext as a
variable for a stored procedure, the...more >>
Error 21002 when creating a new user Posted by jayharris NO[at]SPAM gmail.com at 9/14/2006 8:16:00 AM I'm trying to create a new user for my MSSQL database through the
Enterprise Manager. In the SQL Server Login Properties dialog box, I
type in for Name: "Ken", I choose SQL Server Authentication (Windows
Authentication won't work) and type in my password. For the default
Database, I choose "KenJ...more >>
Updating a Foreign Key Field Posted by Bob Weiner at 9/13/2006 4:36:53 PM I posted this a while back but without luck. I am just now getting back to
what I started last month and still have this question.
Basically, how do I add data to a field that is a foreign key?
Thanks,
bob
"Bob Weiner" <bob@engr.uconn.edu> wrote in message
news:EFC65156-1F16-47C8-B25C-A...more >>
Problem with a query Posted by Christoph at 9/12/2006 5:55:47 PM I have 2 tables. Simplified down to relevant fields.
Table 1
id
referenceName
currentStatus
Table 2
id
table1Id
transactionStatus
There is a many to 1 relationship between table 2 and table 1. Table 1
holds 1 reference record and Table 2 can have multiple records, each having ...more >>
Installing SQL with WinXP Media Edition 2004 Posted by AJB at 9/11/2006 12:18:01 PM I recently purchased Office 2003 professional that came with SQL, which I
understand is needd if I want to use MS Outlook contact management. When
attempting to install on my Dell PC, that came with XP Media Edition 2004
installed, the installation hangs up with two seconds to completion.
...more >>
Scheduled backups not working. Posted by Paul J Tackett at 9/10/2006 6:35:01 PM I am posting this in this group only because I don't see any other group that
is specific to the issue (i.e. Management or Backup).
Anywell, I have had three seperate maintenace plans set up on our SQL 2000
Standard box since we set it up in 2001. I am completely perplexed as to why
every ...more >>
UNION Statement Posted by Alejandro at 9/9/2006 12:54:52 PM I am trying to make an SQL UNION Statement, but I get this error:
Server: Msg 8163, Level 16, State 4, Line 1
The text, ntext, or image data type cannot be selected as DISTINCT.
This is my sql:
SELECT activities.activityid, activities.Actname,
activities.actdesc,activities.schdemailon, a...more >>
Can we remove SQL server now? Posted by Carmen Gauvin-O'Donnell at 9/9/2006 8:35:57 AM Hi there!
Our hotel accountant's computer used to use Great Plains for our hotel
accounting. We also have SQLserver installed, which I guess had something to
do with it... although I'm not sure
We are no longer using Great Plains... is it safe to remove SQL server, or
is it so intertwine...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |