You can use the sp_rename stored procedure.

You can use the script on the link below to shrink your database data file in small increments. It will take a while to shrink it, but it will...

The software version is recorded in the database backup file.

You can display it with this command. Look for the following columns:

SoftwareVersionMajor

SoftwareVersionMinor

SoftwareVersionBuild

restore HeaderOnly

from disk = 'X:\MSSQL\backup\msdb_db_200804061122.BAK'

The issue of scaling out was solved years ago by DEC with VMS clusters and the RDB database (RDB is now owned by Oracle and VMS is owned by HP)....

This is a much simpler way to get everyone out of the database:

-- Get rid of all DB users

use master

alter database MyDatabase set offline with rollback immediate

-- Bring DB...

You can use this utility.

DTSBackup 2000

http://www.sqldts.com/242.aspx

Not with the information you provided.

In practice, it is quite rare for even the most incompetent doctor, lawyer, or engineer to lose their license, unless they commit a crime. Their professional standards serve chiefly...

Use an actual join condition in your join:

select

b.emp_nbr,

a.begin_rng,

a.end_rng

from

range a

join

emp b

on b.emp_nbr between a.begin_rng and a.end_rng

How many would you estimate meet both conditions?

You heard it first here: Intel's next generation processor will have SQL Server 2008 on the chip.

I have also heard rumors of a port of SQL Server to the Sony...

How many rows in your table would you estimate meet the following condition?

where ID = 1 and ID != 1

The only real solution would be to offer your product only as a hosted solution where the users do not have direct access to the database.

If protection of your trade...

You should ask for what you need the first time, instead of posting a question, getting a reply, and then saying that what you really need is something else.

You can...

That is not true.

You need to read the "Shrinking the Transaction Log" topic in...