Maybe your privledges on the table when the Dynamic SQL is executed. Try this (No dynamic SQL), hope I followed you right.

CREATE PROCEDURE [sProfLogActiveSDGs]

(

@LogID_1 [int],

@Profile_3 [int],

@Note_10 [varchar](8000)

)

AS

SET NOCOUNT ON

SET @Note_10...

The major advantage of SP's is their ability to use stored execution plans to quickly make logic decisions when access the database and all you have to do is grants...

Ok first is the machine you manually excuting from the same as the location the DTS package is running as scheduled? If not then try running manually fom the server...

Sent in email:

quote:

---

There are many various factors that you must consider with a database to get an idea of what can help...

I have not come across any tool and never had an issue with our upgrades (we were not using FKs thou). Can you post an example trigger built like this...

Well, I guess we still learn something everyday. After what levi said about the registry entry I got to looking and the best match I found was MaxUserPort (sorry I...

Also can you post a snippet of the code to give us a better idea of what happens and we can try to duplicate and resolve on our test environments.

"Don't...

Not sure there. Getting outside what I have done so I would have to find time to test and see if there is some way. Robert Marda wrote several articles...

So let me ask this. Are you needing to do this per transaction or timed. If timed then you might want to look at DTS with a schedule anyway, but...

No it is now permanently set to TRUE until you turn it off by doing

sp_dboption 'dbname', 'select into/bulkcopy', 'FALSE'

instead.

You can do

sp_dboption 'dbname', 'select into/bulkcopy'

which will return the current...

Sorry, did not understand this and that answer is no.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Both have their bennifits and yes the coalesce method will allow a saved execution plan to be used but that execution plan may not cause it to outperform a dynamically...

Basically this represents the rows returned thru that operator based on thru datatypes and I believe a header of some kind. Anyway these are the notes I have made in...

Run

sp_dboption 'dbname', 'select into/bulkcopy', 'TRUE'

Or in EM right click the database and do properties. You will find it on the Options tab (? don't have an EM in front...

1) You can use master..xp_cmdshell 'bcp strings here', but look at BULK INSERT instead as it does the same thing but lives in SQL, no shelling needed.

2) If you can...