ALTER DATABASE [db_name] SET READ_WRITE

GO

This looks like a bad experience. The trick with using VMs is to treat them - logically speaking - as real machines. Then the next question would be: why would...

It's a fairly easy select to be run, no need for sps;

use yourdb

go

select dp.NAME AS principal_name,dp.type_desc AS principal_type_desc,

o.NAME AS...

There is nothing wrong happening with your sql instance; in sql 2005, the query duration is reported in microseconds (it was milliseconds in sql 2000) However, the profiler is still...

unlike create database, restore is not a ddl statement with server scope; read BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/a3d3c1a5-6ca0-465b-b1d4-f197dd2b682d.htm

You can run queries accross >= two databases only if those dbs are in the same instance. In order to do this you have to qualify each table in your...

Steve is a bit modest with what he said. I would say that this is "the...

"Hanging" could have many meanings; it looks like your DTS process(es) is blocked by something else. If this happens every day at the same time then you may check for...

I believe my answer comes a bit late, however first thing should be done when a db is marked as suspect is to run sp_resetstatus followed by a service restart....

You may want to find out that MS not only changed the name of DTS, but changed it from scratch.

You cannot do transforms under a workgroup edition.

For a better understanding...

Here is a script for backing up a db while attaching the date/time of the backup. This can be a sql agent job step.

Declare

@vDBNameVarchar(255),

@vFileNameVarchar(100),

@vNewPathVarchar(1000),

@vBackupStringVarchar(1000)

Set @vDBName='YOURDB'

Set @vNewPath='D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\' --FILL...

The scope_identity function usage is well explained in BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/eef24670-059b-4f10-91d4-a67bc1ed12ab.htm

This behaviour is expected when PK-FK constraints are not defined correctly.

ALTER DATABASE [your_db] SET ALLOW_SNAPSHOT_ISOLATION ON

GO

The db should have no user connected when enabling or disabling row versioning.

Test it first as this is at the db level; watch tempdb...

When installing more than a sql instance on the same machine, only one may be default and that listen on port 1433, all the others being named instances - other...

If you want to take backups over the network then you have to use a domain account. The usual practice is to take backups locally then to move them to...