I have a question regarding database design and size .
I am migrating from several DB2 databases to SQL server. I was going to
create different databases based on application dept or business units
(the way it has been in db2). But my application folks says, they
cannot connect to multiple datab...
more >>
Is it possible to limit a particular MS SQL 2000 user from using up all
available processor time?
Thank you,
Dustin...
more >>
I have a table that contains a column that collects discreet data (1 for on
and 0 for off, just those two values) and a date column which is a timestamp
containing a date and time. There are other columns in this table but they
are unimportant in this discussion.
A process inserts rows int...
more >>
Hi, I have a table as follows that i am tring to alter but getting
error message...
CREATE TABLE [dbo].[test111] (
[Lname] [varchar] (10) COLLATE SQL_Latin1_General_CP850_CI_AS NULL
) ON [PRIMARY]
GO
I am tring to alter column Lname to varchar(20) with following syntex..
alter table te...
more >>
Hi everyone,
I have a date field in my database. I like to issue a sql query to return
all the rows for the next 30 days from today. Can anyone help?
Thank you
Maz.
...
more >>