it's simply

ALTER DATABASE Yourdbname SET RECOVERY SIMPLE

or

ALTER DATABASE Yourdbname SET RECOVERY FULL

glad you found it Dom;

this site has a Ton of really useful scripts. enjoy.

i cleaned up my original post, since the update to the CODE window made HTML font info...

yes and no.

you can create a table with the a primary key and the list of possible values.

then in the main table, you store the key from that table as...

i did it the same way as Phil, just too slow to post.... i compared the value to the floor of itself:

select

mynum,

case

...

good point; i have a handfull of big functions that cross the 4000 char limit, i wonder just where exactly they split in the code....

definition of the view?

the more info you give us, the more we can help.

what did you try so far? does the base table have a column with an updatedtime in...

this finds any object that references a specific string...just limit it to procedures int he where statement:

DECLARE @PhraseToFind varchar(250)

SET @PhraseToFind='syscolumns'

select obj.name,obj.xtype,

case obj.xtype

when 'TR' then 'Trigger'

when 'P' then 'Procedure'

...

also, depending on the business model, you might not want to DELETE rows that contain a reference to some parent record, but simply set the value to NULL in the...

most connectivity issues I've run into has more to do with server name resolution or DNS than anything else;

for the connection string, are they using the machine name, an IP...

recursion has it's place, of course, but it does not serve string manipulation...

yeah, i think you'll need to use a loop from 1 to datalength(@inputstring), and appending the char in reverse order.

recursively calling a string that fiddles with one or two...

a unique index is just that: a constraint and index that prevents duplicate values.

unique means you can't have 2 nulls in the table., one NULL max.

it is up to you...

Grant's advice is important: bad statistics = bad execution plan.

update your statistics on your SQL2005, and see if your old query performs better.

if your UDF is doing the same code...

valuable info Grant; i did not know that about linked servers vs openquery... Thanks

i'd need the real data to test, anything I say from here out is speculation.

ok we know the server is trying to compare BIBAC to ACCOUNTNUM;

we know that the server...