Good Afternoon All,

I am a nubie at SQL, and SQL below was written by someone else, while I can work with SQL to a limited degree. SQL like...

Thank you Gail,

I am new to SQL and all of the internals of "how", I guess my question is how are these files created? And why are they not backed...

Is it possible to attach the DB even though it is looking for three NDF files?

Regards,

Paul.

Thank you Lynn for your reply,

We have a daily backup routine that runs each day, on the active DBs

Regards,

Paul

Good Morning,

The problem seems to be an active directory authentication issue. The server in question does not have a object in the AD for it under computers. ...

Hi Seth,

Thank you for your reply. Yes, I am running the backup with administrator credentials. The problem seems to be a setting on the "server" that...

Thank you to all who gave a hand today. I am sure I'll be back again, as I am working through a dozen or so stored procedures.

Regards,

Paul...

Thank you Seth for the advice.

Regards,

Paul

Thank you Seth,

That solved the issue.

Regards,

Paul

Thanks Chris and Garadin,

That worked,

As I said, I am relatively new at using SQL and stored procedures.

Thanks Guys,

I appreciate it!! 🙂

Regards,

Paul

Hi Chris,

This is what I have done.

IF EXISTS(SELECT ObjectID FROM @tmp_subjects t1

INNER JOIN tkObjects o ON t1.ObjectID=o.ObjectID

and

IF EXISTS(SELECT ObjectID FROM @tmp_objects t2

...

Hi Chris,

Yes, I am using the alias to referance the column in question .

Regards,

Paul

IF EXISTS(SELECT ObjectID FROM @tmp_subjects t1

INNER JOIN tkObjects o ON t1.ObjectID=o.ObjectID

IF...

Hi Chris,

I already tried to alias the Table Variables. When I do I am getting an ambigious referrance to the ObjectID in both tables. ...

Hi Chris,

Here is the entire code. But what I gave you is the revelent section casuing the issues.

Regards,

Paul

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

/****** Object: Stored Procedure dbo.tkspCreateRelation2...