don't forget the document name so you can restore it back from the image!

create table #ORStable (docname varchar(255), doclen bigint, doc varbinary(max))

Find and Replace for TEXT/NTEXT fields is a pain.

you have to be careful, of course, because the string you replace might be part of a larger string inside your article.

I...

Ive got a stored procedure which does it; is this what you want?

--we want the current trace folder

declare @path nvarchar(256)

--ie c:\Program Files\Microsoft SQL...

yasser.azeem (5/7/2009)

---

hi ,

i have two tables , Tags and Customer_Tags

Tags

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

TagID (int AutoNumber PK) , TagName (varchar (50)

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

Customer_Tags

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

CustomerID (int AutoNumber FK), TagId (int AutoNumber FK), Count (int)

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

i want to create an...

why can't you use a stored procedure instead of a function to get the data that you want?

you could execute a stored procedure and insert into your temp table, then...

it was quick just because I've already got an write-to-file example in my code snippets; i knew that worked, it was just calling it in a trigger instead of a...

ok the below works; someone else may have other ideas.

basically there is a function which calls SPOaCreate to make a file system object, to write/append to a file. that means...

if you can give me the CREATE TABLe statement for your table ([cust_Forms] ? maybe)

I'll play with making a trigger; this is kind of interesting.

this part doesn't make sense:

I'm assuming...

sounds like you only have the SQLExpress version and not Developer or full versions like Standard or Enterprise.

In that case, you can make a linked server, and then do a...

the import wizard will easily help you connect to an excel spreadsheet or any other data source, and automatically create a table with the same column names the excel spreadsheet...

can you provide a bit more information?

a trigger should do any work that is directly related to the data that is being inserted, Updated. or Deleted. it would fire one...

identity property is one of those items that needs to be done at table creation. to add it later, you can use the GUI to add it...it makes a temp...

yes...the IDENTITY property auto-increments the enxt value for your int column...technically it doesn't have to be your primary key, but it is very common for them to be the same;

here's...

not as easily;

xml is supposed to be self describing...so an xml element can contain the name, the data type, and the value; it can contain much more information than those...

Steve Jones - Editor (5/2/2009)

---

Lowell,

There isn't a better way right now. I periodically spend 10-20 minute killing off threads from my subscriptions.

I'm not clear, are you trying to find a...