Viewing 15 posts - 256 through 270 (of 485 total)
Not possible unless you have profiling setup
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 11, 2002 at 4:18 pm
CONTAINS cannot use variables for the search condition.
You would need to build the string and execute it.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 11, 2002 at 4:16 pm
If you use any function on a column then an index cannot be used.
You have 2 options
create an computed column on the table and index that.
create an indexed view...
November 11, 2002 at 4:14 pm
You can have col1 in my example as an identity. try it
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 11, 2002 at 4:07 pm
How are you logging into Query Analyser. This could be that if you are logging into using a domain user then your user account is being impersonated.
How is your asp...
November 11, 2002 at 4:05 pm
Errors are handled direct by VB, when the error message is sent. You cannot raise and error like you have you need to not use RAISERROR, of if so handle...
November 11, 2002 at 4:01 pm
Most offer a controller for the back plane and a controller for the main storage area. You can then add another controller and attach a storage box. If you need...
November 11, 2002 at 3:58 pm
user defined functions
computed columns
indexed views
table variables
bigint datatypes
These are some of the things that are new to 2000 from sql7.
The database would have to be created in sql7 as databases are...
November 11, 2002 at 3:49 pm
Most servers use xeon processors. There are no problems
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 11, 2002 at 3:46 pm
No. If you want a table to be available in a sub procedure you need to use temporary tables
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 11, 2002 at 3:42 pm
is it an domain user name. They get access through a domain group.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 11, 2002 at 3:40 pm
Full recovery is does not map to sql 7 truncate log on checkpoint.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 10, 2002 at 9:20 am
Tried posting this yesterday but never got round to it. For a SQL Server solution use xp_fixeddrives. You will need linked servers setup or use OPENDATASOURCE or similar.
AS Brain days...
November 10, 2002 at 9:17 am
SELECT first, last
FROM table1
WHERE NOT EXISTS (SELECT 1 FROM table2
WHERE table2.first = table1.first and
...
November 9, 2002 at 12:38 pm
You could have a dummy record with a pk of -1 and use -1 as a default value.
create table simon(col1 int not null primary key, col2 int not null default...
November 8, 2002 at 10:28 am
Viewing 15 posts - 256 through 270 (of 485 total)