I am unable to run scheduled jobs that contain ActiveX steps. Jobs that
contain only SQL excute successfully.
The error in the job scheduler history is:
Error creating security descriptor for shared objects (reason: No mapping

How do I determine the schema own by a user, remove them and drop the user?
I am trying to drop a user and I get the following error message:
The database principal owns a schema in the database, and cannot be dropped.
Thanks.

why rowmodctr in sysindexes table shows negative values instead of zero after
a index rebuild in sql 2000 ?
Thanks,
Ranga

I have a table which contains several integer columns that represent
similiar date related information. ie
RenewalMonthDay,HomeMonthDay,MotorMonthDay etc.
I need a view of the table where these different columns have been merged

I have been designing a website for our fishing club and I need help
with one of my queries because I'm not to good at it yet.
The table has FishID, Angler, RecordDate, Species, Length, Photo for
columns.

I have a question on licensing. I have SQL 2005. The architecture I am going
to follow for one  application is like this;
SQL 2005 database (backe-end), Mid layer also there will be SQL and the same
also with a Front- Layer and the clients will be talking to the SQL servers

Not sure which forum to post this in.
Our application (VB.NET 2.0 framework) uses SQL 2000/2005 for the
database. We have an Access DB that has some static data, such as the
menu, the report names and queries, and all of the definations for all

Is it possible creating two databases in same instance of SQL Server
when one of them case sensitive and another insensitive?
Thanks

this is my  DDL:
CREATE TABLE [dbo].[Table1] (
[Code] [int] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

I am currently trying to model a database and have great difficulty in
determining the correct structure.
General Subject -  Aircraft Flights.
Table - Flight ( FlightID = PK, FlightNumber, ClientNumber etc..... ))

I got the following after trying to connect to SQLEXPRESS
from a remote computer:
Code:
SQLCMD -E -S 192.168.0.10\SQLEXPRESS,2708

hi..
the sql 2005 workgroup edition lists 2 cpus
the sql 2005 standard edition lists up to 4 cpus
is this a physical processor limit or does this include hyperthreading

I posted this same question a few months ago but still have not received a
helpful response.
As a certified DBA in 2000 I've done hundreds of views in Enterprise
manager. I've just started to get my teeth into 2005.

I have a SQL Server 2005 (build 9.0.3050) database with tables belonging to
different schemas. I am in the process of developing a Windows Mobile 5.0
application that will work against this database, and I’m planning to use
Remote Data Access with SQL Server 2005 CE to synch data ...

I want to drop a schema but it shows Fail to drop schema - Error 15150.
I found that there is no object under the schema.  Any idea?  Thanks in
advnace