I have a SQL 2000 Server that is still functioning however within
Enterprise Manager there are "no items" listed under databases. Nothing
in management or replication either.

What's wrong with the following code? Please help. I am using MS SQL
2000.
create table one (
a float NOT NULL,

What's wrong with the following code? Please help. I am using MS SQL
2000.
create table one (
a float NOT NULL,

select convert(bigint,21568194 * 100)
Server: Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.
Why does this happen, How do I fix?

I am trying to restore a DB which i have from on of my e-book. The DB
format is .dat format. I am trying to restore this in the SQL server
Express edition 2005 when i do that i am getting below error.
TITLE: Microsoft SQL Server Management Studio Express

Hello.  I'm trying to update some 'text' data directly through SQL Server
Management Studio (2005) on a table and have been encountering the following
error popup:
Microsoft SQL Server Management Studio

In SQL Express 2005 needed to create 2 tiggers.. I noticed that the option
to create was not working on the Database Tiggers folder in MStudio.  I hand
coded them and they are working.. I can see them in sysobjects.. .but they do
not display in MStudio.. Is the is bug ?

Getting a linked server error.  The way SQLServer 7.0 linked to 2000 allowed
us to have both the ability to login under a given security context as well
as specify individual logins.  The linked server also contains the provision
for impersonation in 2005.   If possible, I would ...

When I execute the following statement in the query analyzer on a msSQL2000
database...
delete from DVD_I_Have where id in(select top 1 id from DVD_I_Have where
Userid=78 and DVDID=8 and onhold=0);

I would to create a backup file dynamically (the filename will contain
the hostname of the DB).
any idea how can I use a variable for that?
(a variable is easy to use for a regular database backup, but not for

I am trying to restore a database from a device, added a file and then
when i press ok
I receive the following error message:
TITLE: Microsoft SQL Server Management Studio

I have ~100 text files need to be loaded into ~100 different tables. These
files need to be loaded only once. What is the best and quickest way to load
this data ?
SQL Server 2000 SP3a

Hi there -- I'm a developer who mostly uses SQL Server from that
perspective, not a DBA, and I had a client ask me a question recently that I
couldn't answer.
My client has a database that is updated constantly.  A few weeks ago, he

Hi, All,
I tried to stop sql 2005 service from Sql Server Management Studio via right
click sql server name, but the stop option is not highlighted (means it
doesn't allow to stop sql service), anyone knows why  and how to fix that?

Hey all,
I was about to move my SQL Server from a box that's about four years
old to a current box.  The new box should be faster for everything ...
more RAM, faster CPU, faster disks...  but the performance of repeated