Its a matter of preference, and also depends.

I always have 1 insert for each table.

Then I build a "Wapper" procedure that calls the individual insert procs in the order required.

The...

Please post the actual message received on insert.

Are there triggers on the table inserting/updating/selecting on other tables that the user does not have permissions to?

you should have done that on your restore, with move option.

or in em in the options tab.

but for now, I think you can detach the existing db.

Rename the files, and...

yep RS handles time just like sql server does.

if time is not entered then it defaults to 12:00 AM.

you insert a value that does not already exist.

Can you please post an example of your table definition, and what your trying to accomplish, the way your question is worded...

you did not denote what the regular amount field is.

YOu cannot use the As "Broked" within the case statement

select terms.key,

CASE

    when  plan.desc like 'Lendered%'  then terms.amt

    else RegularAmount

end...

Sql server is a rdbms system. Not a document management system.

You can certainly use sql to store your images/pdfs. it works fine. But there are some inherent issues. its...

You can the data type is image, Please read up on it in books online. Find books that talke about this. It works fine, but not an ideal file management...

And I think I'm indicating you cannot do it without using a cursor, temporary object or some other looping procedure.

you cannot inline query some rows to concatenate, and others not.

I get worried when post after post I continue to see tables designed this way.

Take a look at normalizing databases,

and the Case operator

select case column1 when 'Address' then column2 end...

Well it depends on your roll. Are you an administration dba in charge of backups, recovery, availability, security?

or are you a development dba that is in charge of creating objects...

As part of your disaster recovery?

The log file is an integral part of the database.

If you have a live server and the drive the log is on fails, then you are...

DBO is tied to a role in sql server.

Do the objects say dbo.storedprocedurename?

Or do they say username.storedprocedurename?

if they say the user name, then they are not assigned to dbo.

if it...

Do it like sp_helptext does it.

It uses a cursor.

do a

use master

sp_helptext 'SP_HELPTEXT'

and it will show you how sp_helptext concatenates the two+ rows.

You asked what was going on behind the hood with sp_executesql.

Hence my answer, but your really trying to find the sproc/batch that is calling the sp_executesql?

the only problem is you...