FYI: sp_MakeWebTask is deprecated in 2005 and supposedly removed in 2008 (I haven't checked this). BOL recommends using Reporting Services for this(?).

This view works, and provides a lot more information as well:

http://www.sqlservercentral.com/scripts/tables/62545/

Well if your title is really correct, then you want something like this"

Declare @str NVarchar(MAX)

Set @str = ''

Select @str = @str + fielda

From TableName

rinu philip (7/20/2008)

---

This could be achieved ny giving specific permissions to the customers....

FYI, although I would not advise it, this can be done.

What you would need to do is to add a "handle" argument to your function, and then find a way...

INSERT into TargetDB.dbo.OutTable

SELECT * From SourceDB.dbo.InTable

I'm just curious Brandie, why do you think that you need the Foreign Key in your Data Warehouse?

A Staging table will work. ...

Jacob:

Hopefully a few more answers for you:

0) Your users just login to Windows as they normally do, then run the app. For bad apps, they will also...

rbarryyoung (7/13/2008)

---

There is also a massive project planning document free from Microsoft on this very thing. You can find it here: http://www.microsoft.com/sql/techinfo/whitepapers/MigrOracleSQL2005.mspx

And of course, there are many consultants here...

This is the only clear reference that I can find to this specific error message and how to debug it:http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=356938&SiteID=1

Try the easy answer first: Any reason that you cannot use "Generate Scripts" from SSMS?

Ummm... I cannot figure out what this is supposed to do? For instance, what is "sps"?

Mike Good (7/17/2008)

---

Darn. Well at least 2 of us have come to same conclusion.

When we start using "WITHOUT LOGIN" users we're going to have to abandon notion of...

Can you post the actual messages?