"...with a little less drama..."

Humph - you take all the fun out of being a DBA

Yes, but the issue is protect it from what?

I've seen several posts from developers worried about people stealing the schema and not buying their product - this is covered by...

I see - it is the most comprehensive way to achieve your goal though.

You can then search the script for the particular object you want to recreate.

Be aware that you...

If a table has a foreign key referencing it, it can't be dropped.

(Effectively the other tables are populated with data in the table you are trying to drop, hence it's...

The databases can now be configured with seperate collation settings independantly of the server.

ALTER DATABASE database_name COLLATE collation_name

COLLATE collation_name

Specifies the collation for the database. collation_name can be either a...

"too wild"?

A full backup includes the schema, why do you want no data?

It's been common knowledge for some time actually.

Database mirroring was marked as an unsupported feature back in June. When did you upgrade?

It is expected to be supported after a June...

"In SQL Server 2000, the identification of the server connection endpoints was performed by the SQL Server service. SQL Server 2005 replaces that function with the SQL Server Browser service....

A local administrator has full control over that machine, you cannot get away from that fact.

You can encrypt the contents of the data, but rather than try to limit full-control,...

But in any case;

First you need to create a job (sp_add_job), create a step in the job that executes your procedure (sp_app_job_schedule) - you'll need to put input parameters in...

Hi,

The point is that if you schedule this stored procedure to run every hour what will happen? Nothing. It's got no input for the paramters.

J

Here's a helpful explanation:

In Excel, a worksheet or range is the equivalent of a table or view. The lists of available tables in the Excel Source and Destination editors display...

To specify where the data needs to go in the workbook, your package will need some sort of reference to point the data at.

If you open the spreadsheet choose where...

Continuing from my example table:

SELECT DISTINCT colour FROM dbo.objects

What happens when your is reordered?

You need to normalize the data.