Hello,

Another method, assuming that you don’t have masses of data in your DB is to use SSMS to copy the DB (Right Click on the DB and select Tasks, Copy...

Hello,

To remove partitioning form a table you need to drop the relevant constraint. If you want also to remove any dependency on the Partition Scheme (so you can drop that...

Hello Adam,

Thanks for the update. I'm (very) glad to hear that it worked out in the end.

Cheers,

John

Good Morning,

Did Ivanna Noh's post help?

If not, your statement "He was just a contractor anyway, with limited rights", gave me a clue. May be the view definitions permission that I...

Hello again,

For that particular case I think you would have to drop and re-create the Login (probably not what you want to do).

Unfortunately SQL Server 2005 makes it hard to...

Good Afternoon,

I'm fairly sure that the reason why you can’t delete the Login is because it previously granted permissions to other users. The problem is identifying what permissions "HERMES\bennetp" has...

Good Morning,

Is it possible that the user has in the past been granting Server Level Permissions to other users?

Are the 5 records in your last post all that were returned,...

Hello,

Sorry if it's a low level question for you, but have you checked there are no DB Mappings left? (In SSMS Object Explorer, select Security, Logins, right click on HERMES\bennetp,...

Hello,

Try running this query to see if the Login still has any Server level permissions:

Select *

From sys.server_permissions

Where grantee_principal_id = (Select principal_id From sys.server_principals Where Name = N'HERMES\bennetp')

Regards,

John Marsh

Hello,

No problem to add a Where clause to the SQL statement. It would then be along the lines of: "Select * From Contractor C Left Join ContactorWorkExp CWE On C.ContractorId...

Hello,

Instead of having two separate Tables in your DataSet, use just one which joins the two Database Tables together e.g. Select * From Contractor C Left Join ContactorWorkExp CWE On...

Hello,

Although not exactly what you are after, this article might be an interesting quick read, as background information on Database locking: http://www.devx.com/gethelpon/10MinuteSolution/16488/0/page/1

Regards,

John Marsh

Hi,

Assuming you don’t want to set up your Access DB as a Linked-Server, you can use SQL 2005's Import wizard to perform a one off data load. The wizard then...