David Webb-200187 (6/6/2012)

---

There are lots of things that can change the order in which data is retrieved. The only way to guarantee a certain retrieval order is with an...

I have to ask, why are you using SQL Server to stop and start a windows service?

Eric M Russell (6/6/2012)

---

Steve Jones - SSC Editor (6/6/2012)

---

Revenant (6/6/2012)

---

Automation of server management is one of the major Microsoft's thrusts. MS AutoPilot allows 5 or 6 admins manage the entire...

To answer the original question for this thread, it must be yes.

blampe (6/6/2012)

---

Thank you all for your responses ..... I was able to get the procedure to run, but now...

blampe (6/6/2012)

---

Thank you all for your responses ..... I was able to get the procedure to run, but now when I call the procedure it gives me an error. It's...

Slightly confused here, did you find this info on the link I...

Nope.

You'd be better off asking this on an Oracle forum, then, since this is...

The following code runs successfully on my system:

create table encrypt_table

(

table_id int identity,

sch_name varchar(50),

table_name varchar(50),

active BIT

)

create table encrypt_table_columns

(

table_id int,

column_name varchar(50),

active BIT

)

GO

create procedure insert_table_column(@schema_name varchar(128), @table_name varchar(128), @column_name varchar(128), @active BIT)

as

declare @id...

Also, looks like your insert into the first table won't really work either.

blampe (6/6/2012)

---

Thank you for the help, I really appreciate it. I have updated my code, but I am still receiving the error regarding the select statement towards the end of...

TravisDBA (6/6/2012)

---

Jeff, I wasn't referring to anyone being a "dillweed". I was referring to the secret society which he belonged to which could possibly explain his secretive and "covert" behavior....

Longest Day

bpowers (6/6/2012)

---

I was refferring to the latter and your code worked great with the exception of the Order By clause, which I can live without. Returned an multi-part identifier error.

What...

Look over the following. One thing you needed was to separate the table creation from the creation of the procedure by inserting GO before the CREATE PROCEDURE. I...