yeah a double reverse will work here; i broke it into a couple of steps to make it a bit more obvious:

declare @filename varchar(1000)

set @filename = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyFile.txt'

select...

damn that is interesting...my first instinct was that the len() function would work on a varchar(max), but it just returns 8000 if it is too big: I'll look some more.....

create...

Rama (11/14/2007)

I have a delete procedure that has to check a dependent table (t2) for records before deleting from the main table (t1). If there is records the procedure has...

if your other SQL server has a dynamic IP, and you need a real hostname for it, look at the free services at dyndns.org.

you run a service on your remote...

I also have no problem with sponsored articles...a lot of the time,regardless of the source,they have a valueable lesson or tidbit of knowledge in them.

As long as it's technical, it'd...

I have a very similar situation: we use virtual machines for testing our application. the virtual machines can connect to dozens of sql servers on our network with no problem.

...

well i found that SQL2005 has a stored proc to mark a specific object as system, instead of an on/off switch, so I'm still looking:

-- SS2k5 provides a stored procedure...

Thanks Theo; I really need to test that myself , as I clearly don't make enough triggers; I should have known that...i assumed that the tables would only be populated...

as i remember it, parameters may not be constructed inline; they have to be built and then passed:

exec @res = sp_OASetProperty @oMail, 'TextBody', 'This is a reminder to let you...

pretty sure this is what happened:

somebody ran this command:

--Turn system object marking on

EXEC master.dbo.sp_MS_upd_sysobj_category 1

after that is run, all commands that create objects in SQL 2000 are system objects. this...

here's something i use, and i'm sure i'm stating the obvious and what you already did tog et back up and running, but you'd be best off doing a back...

SET @execSQL = 'DECLARE @BeforeValue sql_variant, @AfterValue sql_variant '+

'SELECT @BeforeValue = D.['+@ColumnName+'], '+

...

Jeff I feel really bad...

unless you have the database recovery Model property set to Full instead of Simple, there is no way to determine this without adding features yourself.

if the database is set to...

ok how about this:

get all the tables in FK hierarchy order; truncate tables with no FK, and for teh rest of the tables that feature foreign keys delete ...