I have this T-SQL which seems to work against SQL 2000 databases running on
SQL 2005.
ALTER DATABASE mydb SET SINGLE_USER;
EXEC sp_dbcmptlevel mydb, 90;

I would like to move [backup  an SQL 2000 user database and restore it
on an SQL 2005 server] , the database is located on different drives
on the 2 servers. Are there any special considerations to take into
account, should I upgrade SQL 2000 to 2005 first?

I need to temporary drop indexes then truncate and reload data into a table.
when I run a drop index command on a table, it will drop the indexes and the
recreate an index.
I'm not sure want index it creates, there are no indexes listed on the table

We have a system that was written with a few scalar UDF's.
These seem to perform very poorly, in that they get run per-row rather than
set based (which is fine, and if it were up to me i would not use them).
But what i was hoping for is a way to find operations in profiler that ...

Any pointers on how the sql engine process LIKE expressions, especially on
cases like '%searchkey%'.
Thanks

I'm running a program called ChefTec that uses a local SQL database to store
all the information.  I recently tried to open the program and am now getting
the following error:
[DBNETLIB][ConnectionOpen (Connnect().]SQL Server does not exist or access

I cannot execute a backup maintenance plan. I get a 15404 error,
stating that it "could not get information on Windows NT group/user
'DOMAIN\user'.
SQL Server Agent is set to use Local System Account logon permissions.

I have data partitioning setup in place (1 table, divided to 16 partitions),
and I noticed that new partitions are much larger GB wise than the old ones
(switched out). However, number of rows in all partitions is pretty much the
same. I suspect this might be because XML column ...

I'd like to install SQL Server 2005 Developer Edition on my F: drive,
but the installation procedure doesn't seem to give me that option. Is
it possible to do? If so, how?
Thanks for your help!

I have a table 1 with postcodes and a flag field that indicates whether it
is welsh.
I have another table (table 2) which has a list of just the first 5
characters of welsh postcodes that I want to use as a lookup table and if

I'm not very good at SQL.  I have three jobs that were created on the old SQL
server and they are pointing to the old server.  In fact they're jobs for a
database that doesn't even exist any longer, but they're throwing a lot of
SYSLOG errors.  How do I delete these jobs?  I keep ...

 I restored my database from the backup file, which is working fine but it
is not showing the database diagram in SQL server management studio. What do
I need to do for that?
Thanks.

What user do you recomend as "default" database owner. I want to avoid it
beeing owned by a "real" person. Is it common to create a local server user
or domain user dedicated to only be a DBO?
Kind regards

I have little experience with SQL Server when it's filled with lots
and lots of data. In fact I'm not really that sure what would be
considered a lot of data!
Basically I am involved with a system which will be accumulating at

I am trying to create a query against a SQL 2000 database to see if a job is currently running.  I cannot cancel the job that I am monitoring.  Shortly after it completes, I need to notify some people and do some additional work.  Unfortunately I forgot to change the job to ...