I am running Developer Edition Beta 2. No such configuration option.

Yelena

I agree with Peter. I answered "correctly", but I don't really agree with the "correct" answer. The reports may vary by the CPU and Memory used. It could be 100...

Hi Joe,

This message is most probably Firewall. Please ask your infrastructure support to verify that the Firewall is open from your IP address. They usually open it from a particual...

Saulo,

When you use DTS you first fill out the Wizard, then click Run Immediately on the last page of the Wizard, then it says: "Create Table" (if you DTS into new...

Hi,

The original question was not clear, do you want to share across profiles on one server (this could be guessed by the topic title) or you would like to...

Heather,

Backup and Restore or Detach/Attach are the safest ways agree with all other opinions

Here are 2 things to watch if you are using different techniques:

- If you use DTS Import...

Hi,

I am not sure it will work accross different servers but try this:

Suppose all your registered servers are in one group SQL Server Group (if not, adjust accordingly)

Export a registry...

I don't think Select Into configures indexes and keys.

You may want to script the table first with all keys and indexes but WITHOUT Drop Table option so you would not...

Steve,

May it be that their log file is with no growth? I am not sure at what point the destination database options are overwritten with the database-to-be-restored options.

You may want...

While we do get "With Move" errors when using different paths on the source and destination servers when not changing locations appropriately I don't remember seeing errors related to Expanding...

For example you may use an ASP page that queries MSDB connected as a read-only user for MSDB. The script should query sysjobs and sysjobhistory and return a job name, step name...

I think that what DBA should be watching is what the developers are  up to in between watching the Red Sox games.

All other time should be dedicated to writing scripts according...

Totally agree. Just had a similar task. I used multiplying by 1.00 and then used Convert to make the output look nice for the report

Convert(decimal(7,3),Orders*1.00/mytotal)

Yelena