Try this

quote:

---

1.

CREATE PROCEDURE dbo.getModuleTitle

@ModuleID int OUTPUT

AS

blah...blah...

---

quote:

---

create...

No, you can run it from any sort of front-end the same you would any other stored procedure or SQL statement. You could set it up in a batch file,...

quote:

---

quote:

---

I generally put in some text that allows me to get past the assistants...

If you declare multiple variables you can use then in the EXEC statment like this,

EXEC (@sql1 + @sql2 + etc...)

Just make sure that the concatenated string makes a valid sql...

Actually I like Links the cat. I'd like it to be a bit more active though and hang around even when I'm not using an MS Office App.

And if I...

OK, is this a routine thing or one-off. What is the resulting table used for.

You can run a short VBScript that uses the filesystem object to iterate through a folder...

quote:

---

I blame the practice on Access database users. Access allows this practice and then if the Access database has to be...

add to this, avoiding the use of non-alphanumeric characters, wildcards, etc...

eg: tblName%

Arrrgghh!!!!

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

Sounds like it may be a COM/DLL issue. Maybe try re-installing EM.

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

A better option than providing a shortcut to execute the DTS package, would be to setup the pacakge as a scheduled job without a schedule. Then use sp_start_job to execute...

Do you need the contents of the files, or the filnames themselves? What "file" do you want to save the result to?

If you need to read the contents of multiple...

How are you importing the data in DTS, Bulk-Insert, Datapump??

Hope this helps

Phill Carter

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

Colt 45 - the original point and click interface

quote:

---

quote:

---

We appear to have found the problem - in spite of the published information...

quote:

---

What problem did you have with the 10GB table?

---

Try running a reindex and have it...

Running a trace will capture as much, or as little, information as you specify. From what SQL statements were sent to the server to the goings on caused by routine...