Help: Trouble Dropping Master Key

Apr 11, 2007

It could be trivial question.

I have trouble dropping master key. when i execute the following query..

open master key decryption by password = 'pass1234$'

alter master key drop encryption by password = 'pass1234$'

close master key

drop master key

go

I get the following result..

Msg 15558, Level 16, State 1, Line 3

Cannot drop encryption by password '********'.

Msg 15580, Level 16, State 1, Line 5

Cannot drop master key because certificate 'BackofficeServiceAccount' is encrypted by it.

But 'BackofficeServiceAccount' was already dropped.

Can any one help me how to drop master key?

I appreciate any input..

regards...

View 1 Replies

Trouble Dropping A Job

Mar 10, 2007

I have trouble dropping a job that was a maintence plan.

I get the following error. Is there a way around this?

TITLE: Microsoft SQL Server Management Studio
------------------------------

Drop failed for Job 'Maintenne Plan'. (Microsoft.SqlServer.Smo)

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_job_id". The conflict occurred in database "msdb", table "dbo.sysmaintplan_subplans", column 'job_id'.
The statement has been terminated. (Microsoft SQL Server, Error: 547)

View 3 Replies View Related

Trouble Dropping And Recreateing An Index

Sep 26, 2007

Hi,

I get a new payroll data file every two weeks. I have a DTS package that drops the table, creates a new table and then adds an index. The SQL task that checks for the exsistence of an index and then drops and creates a new one is failing. Here is the the SQL for the Execute SQL task

------------------------------------------------------------------------------------------------------------------------------------------

IF EXISTS (SELECT name FROM sysindexes
WHERE name = 'EmpPosTimePerEndDateIndex')
DROP INDEX dbo.EMP_POS_TIME_55_316_TBL.EmpPosTimePerEndDateIndex

GO

CREATE CLUSTERED INDEX EmpPosTimePerEndDateIndex
ON dbo.Payroll_TBL (PER_END_DATE)
GO

----------------------------------------------------------------------------------------------------------------------------------

This task fails and I get the error

Cannot drop the index 'dbo.EMP_POS_TIME_55_316_TBL.EmpPosTimePerEndDateIndex', because it does not exist in the system catalog.

But, SELECT name FROM sysindexes
WHERE name = 'EmpPosTimePerEndDateIndex' returns one record.???????

Maybe I created the index on a different table, but I don't know which one.

Any suggestions. How come sysindexes doesn't have a field for table to associate the index with?

Mike

View 2 Replies View Related

Need Help Dropping Master Key

Apr 11, 2007

I am having following issue recreating my service broker

This could be a trivial fix...

when i execute the following query..

open master key decryption by password = 'pass1234$'

alter master key drop encryption by password = 'pass1234$'

close master key

drop master key

go

I get the following result..

Msg 15558, Level 16, State 1, Line 3

Cannot drop encryption by password '********'.

Msg 15580, Level 16, State 1, Line 5

Cannot drop master key because certificate 'BackofficeServiceAccount' is encrypted by it.

But 'BackofficeServiceAccount' was already dropped.

Can any one help me how to drop master key?

I appreciate any input..

regards...

View 3 Replies View Related

Dropping User Created Tables From Master Db

Aug 25, 2006

Hi,
I have created a bunch of tables in the Master db by mistake.I want to drop those tables.Please tell me away to drop those.

Thanks!!

View 2 Replies View Related

Trouble Restoring Master DB

Dec 20, 2005

I am running through a Disaster Recovery scenerio and I am having trouble restoring the Master and msdb DBs to a recovery box.

My production is a default Instance on WIN2k Server - SQL Server is 2000 Standard, sp3a

The box I'm trying to recover to is a Named Instance on WIN2003 server - SQL Server 2000, sp3a

I stopped/restarted my recovery server with -m and -T3608 startup parameters but when I attempt to restore the master backup from my production box to the recovery box, I get an error - it's a blank dialog box with a big red X and it says: Microsoft SQL-DMO - ODBS SQL State - HY000

when I check the sql server log: it shows the Server started in single user then it says recovering master db then starting up master DB then it just hangs..

Server event viewer shows this: 18052:error 3151, severity 21, state 0

not much to go on.. does anyone know what I'm doing wrong???

View 5 Replies View Related

Master Information And Details: How Can I Get The Master ID?

Jun 19, 2007

I got a File with sales orders and their details.

Step 1. First I am filtering the Sales Order information and inserting it in my Sales Orders table.
Step 2.Then I am filtering the details from the sales Order and inserting them in the respective table.

My Problem is that the Sales Order File does not contain the Sales Order key (ID), this is generated by the SQL Server. How can get it in order to use it in the second step? I need it because it is a foreign key in the details table.

Any Idea?

View 4 Replies View Related

SQL Master/Detail (Master Query Based On Detail Values)

Mar 25, 2008

Hello,

I'm new to SQL and need help with a query. Not sure if this is the right place.

I have 2 tables, one MASTER and one DETAIL.

The MASTER table has a masterID, name and the DETAIL table has a detailID, masterID, and value columns.

I want to return a populated MASTER table with entries based on the DETAIL.value.

SELECT MASTER.*
FROM MASTER
WHERE DETAIL.value > 3

This is a simplified version of my problem. I can't figure out how to set the relationship between MASTER.masterID and DETAIL.masterID. If I do an INNER JOIN, the number of results are based on the number of DETAIL entries. I only want one entry per MASTER entry.

Hope this makes sense.

How can I do this?

GrkEngineer

View 9 Replies View Related

Dropping Tables

May 28, 2002

Is there a way we can prevent a object owner from dropping his tables. Example:

There is a user called 'tom' who is given create table permissions, 'tom' creates the table completes his dev and then the table is moved into production where 'tom' is still the owner. However, in production, 'tom' does not have the create table privs. Because 'tom' is the owner of the table, he is still able to drop the table in production. This is what I am trying to avoid. I would like to retain 'tom' as the owner and want to take away his create/drop privs.