this is kind of hard to do; i use an extended stored procedure in order to strip RTF or HTML tags;

see this post for the details, other examples, etc:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=242853#bm243180

you can't truncate a table that has a foreign key reference.

also, if you delete from the tables out of order, you'll end up with errors as well.

another thing to consider...

i think the only way to do this is to use a function, and have the function return ONE column with all the values in a comma delimited format:

CREATE FUNCTION...

without using e3nterprise manager, here is a copy and paste solution:

declare

 @isql varchar(2000),

 @procname varchar(64)

        create table #procResults(procid int identity(1,1) primary key,ProcText varchar(4000) )

 declare c1 cursor for select name from...

dumb question from someone less experienced....if you have a small database, say 300 meg...your server most likely has multiple gigs of ram...couldn't you pin every table and achieve a performance...

http://groups.google.com/groups?sourceid=navclient&ie=UTF-8&rls=GGLG,GGLG:2005-36,GGLG:en&q=%22The%20description%20for%20Event%20ID%20(%200%20)%20in%20Source%20(%20SQL%20Server%20ODBC%20driver%20support%20error%20)%20cannot%20be%20found.%22&sa=N&tab=wg

folowing some of the links there that have answers says that your MDAC is out of date and that you may be missing a .rll file.

HTH

\

did you just post real client data credit cards on a forum? i hope the data you pasted is fake developer data.

edit the post and remove the data right away.

it's ridiculously easy....use the exact same script, but rename the output to .xls when you save it.

excel will automatically translate HTML to the proper format when it opens the file.

[post...

SQLRecon is excellent for this:

http://www.specialopssecurity.com/labs/sqlrecon/

it finds all SQL Server instances by scanning all sorts of methods in order to give a comprehensive list. it's also free.

can you use an outer procedure to determine which database to use?

ie

CREATE procedure pr_dbSwitch as(@dbname) as

declare @sql varchar(2000)

select @isql='USE @dbname pr_yourprocedure'

  select @isql = replace(@isql,'@dbname',@dbname)

  print @isql

  exec(@isql)

that way your proc is not dynamic,...

i've seen programs which generate code based on user selections build queries like this....i would guess just running it thru query analyzer and having the show plan on would let...

We had a similar kind of situation with a database software package; the vendor does not want clients to alter the database schema, and the knee jerk reaction was replication...

like Mike says, it depends on your tolerance for differences between the two database....log shipping is free, but your backup database is out of sync by the xminutes you have...

additionally, even though two connections might create a temp table witht he same name, #temp, they are actually stored as two different sysobjects in the tempdb database;

here's an example for...

the case returns one of two values, 0 or the calculation.

you could replace it with the same functionality:

column1=isnull(SUM(ABS(t.Amount)*c.CalcInvestedAmount) ,0)

a little less verbose, but with the same results.