We have SQL 2005 installed on a temporary server that has run out of space on
the partition where the databases are installed.  I was able to move some
databases to another partition by detaching, copying the files, and then
re-attaching the databases.  I also changed the default ...

We will be moving our Main Sql database on to a new system in the autumn (the
fall). A fairly big bang for us as we intend to move from 32 bit SQL 2000 sp4
to 64 bit SQL 2005 with 32GB or 64GB ram depending on final budget. We are
fairly happy with our testing on 2005. The only ...

My MS SQL 2005 very slowly response for every first query after few minutes
of servers inactivity. It doesn’t matter if query is very simple or not, if
return many rows or not, etc. Even simple SELECT on table that contains only
few records takes about 15 seconds.

I made a network drive mapping to a NFS volume on a Linux server and it
works fine in Windows Explorer since I can create files on it.
Unfortunately, I'm not able to access it in SQL Server, neither backing up
data to it, nor browsing it in creating a backup device. While using ...

having sql2005, cursor built on ordered query, like:
...
declare cur1 cursor for
select fld1 from tab1

We have tried to upgrade some clients from msde 1 to msde 2000 and although
they seem succeed when we start the application this fails.
We then tried to rollback the application by using an XP restore point and
reinstating the .MDF and .LDF files. On reboot the system appears to ...

Folks,
SQL Version 2000 SP3
Database Name: DB1
Recently I restored a database to a different physical location in order to

if i want to convert the value for character to datetime value is there any
function in sql server 2000
thanx in advance
with regards

I have a set of users claiming that the DateDiff function is wrong because
it returns 49 for the number of days inbetween
select DateDiff(day,'2/7/2008','3/27/2008'). They claim it should be 50. Has
anyone else encountered this issue? I tried telling 'em that this is

I'd like to give different customers access to their own instance of SQL
Server 2005. Basically they should be granted sa permissions to their own
instance. I would however like to remove the ability to change the amount of
RAM used and the option to specify CPU kernel(s). This ...

windows server 2003, sql server 2005
Is there a way in Windows or SQL Server to tell what process has a
hold of a particular file?
I have a backup file that I'm trying to delete, but the error message

I've got a database that no one is supposed to be using. I would like to
take it offline but I'd like to verify first that noone is actually using
it. Is there any way, other than SQL Profiler, to see who is/has used the
database recently?

I added a join table which was left out of the structure.  In order to
populate it with the key fields of the company and car tables this is
the SQL I arrived at.  My question is this right?
INSERT INTO Company_Car_jn(car_id,comp_id)

My TempDB database have autogrowing active to increase 100MB when necessary,
and I need to know everytime this action happens. What is the best way to
know?
Thank you,

I had just a quick question....
I am working with a sql2005  server and recently have been experiencing some
odd problems with connectivity.
I have 4 drive for the sql sql server