I have a Dell Inspiron Laptop 866Mhz with 384MB Ram running Win2k SP3 home network LAN'ed because of fixed IP ADSL ISP Router that acts as firewall DHCP DNS etc on 192.168.254.254 so I have set thi...
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/2000/Q_20793680.htm...
Zones:
Windows 2000Date Answered: 11/13/2003 Rating: 6.2 Views: 0
Hi
Does anyone know whether it is possible to search 2 tables at once using FREETEXTTABLE as I receive the following error on the code below.
Error Message: Server: Msg 156, Level 15, State 1, ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20860336.html
Zones:
MS SQL ServerDate Answered: 01/25/2004 Rating: 9.2 Views: 0
getting the following error
CREATE TABLE [dbo].[Department] (
[DepartmentId] [int] IDENTITY (1, 1) NOT NULL ,
[DepartmentName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20989863.html
Zones:
MS SQL ServerDate Answered: 05/14/2004 Rating: 9.4 Views: 0
This is a pretty wierd situation, I created the sproc as following, when I click the syntax check button, it says 'Syntax check successful!', then I click the bottom OK button try to save this spro...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21091573.html
Zones:
DatabasesDate Answered: 08/12/2004 Rating: 7.6 Views: 0
I have 2 SQL database on a server each database has its own username and password. I want to select data from a table in database1 and insert it into database2.
How do I do this? I have tried ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21193247.html
Zones:
MS SQL ServerDate Answered: 11/07/2004 Rating: 7.4 Views: 0
I have been looking at my code for 20 minutes and cannnot figure out why I am getting this error. It is stating that it is happening on the execution of strSQL:
Sub DenyRequest
Dim strDenie...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21194010.htm...
Zones:
ASPDate Answered: 11/03/2004 Rating: 8.8 Views: 0
This is the initial error i get
Microsoft OLE DB Provider for SQL Server error 80040e07
Disallowed implicit conversion from data type varchar to data type money, table Corpweb.dbo.GoldsNum...
http://www.experts-exchange.com/Programming/Misc/Q_21204978.html
Zones:
ProgrammingDate Answered: 11/18/2004 Rating: 8.2 Views: 4
I am running sql server desktop edition (MSDE 2000).
I need a count of a union:
select count (*) from ( select id from member union select id from dropoffpoint )
Running the above in the...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21365078.html
Zones:
MS SQL ServerDate Answered: 03/25/2005 Rating: 9.4 Views: 0
I have a query below where I want to delete rows from a table
delete
from orders
where rundate = 09/06/2005 14:44:00
I get the error incorrect syntax near 14, can someone show me the corre...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21455759.html
Zones:
MS SQL ServerDate Answered: 06/15/2005 Rating: 7.8 Views: 0
Hello Experts,
i have some errors with my script and i need to fix it for me please...
all i want to do is to have listed all albums that have any songs for a requested id (artist)
which i mean ...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21516213.htm...
Zones:
ASPDate Answered: 08/05/2005 Rating: 5.0 Views: 0