No problem at all:

enjoy. Graham

/*

This Procedure takes all of my objects and converts them to dbo ownership and

grants access permissions...

I can't supply a list, but I can speak from experience. Our DBAs only allow the DDLAdmin and SecurityAdmin roles. They went to this route when they migrated from 6.5...

Not found a way with SQL Server's Tools. I only use them to create tables and to get a print, but when I do documentation, I end up using Visio,...

Turn on View Page breaks, which will help you see what you are doing.

Then In Page Setup, change the Zoom to something smaller and that wil have the desired effect....

This is what I use:

It works for Tables, Stored Procedures, Views and UDFs. It's not that elegant, but when builing a new database, it is usually the first thing I...

Doh!

Yes, I can see it now.... It's what comes of answering the question first thing in the morning before enough coffee has been consumed!

OK, so what did I miss here?

select @@version returns the following for one of my SQL Servers:

Microsoft SQL Server  7.00 - 7.00.842 (Intel X86)

 Mar  2 2000 06:49:37

 Copyright (c)...

That's also true and much of the application runs in batch. However, the source data has its data changes logged (SAP R/3) and the folder to which the data is...

Already got round that one. I have the application locked down fairly hard, such that no-one can make any changes except through the use of SPs and the SPs will...

Brilliant!. That does it. I can use that to store the relevant information

Thanks!

Hi,

Thanks for the quick response. Unfortunately, profiler is not an option. Firstly, as a developer, I do not have access to it in production (Getting it in development is difficult...

I had to do this a couple of years ago. I went for a slightly different solution.

I allowed the users to control the position in the list, by specifying the...

The attached SP will do it for you for tables, stored procedures, views and UDFs.

If you want to filter what you change, then adjust the query which feeds the temporary...

I've always tended to use a "minimalist" connection string. Usually, this will consist of the provider, the Data Source (or Server), and the Initial Catalog (or Database). Latterly, I've added...