also, once you get everything straight from a SQL version and Windows version standpoint, you'll find that the most memory you'll use will be about 3.4 GB of physical memory...

try this:

insert into @table 

select * from fn_splitstring(@strings)

or

insert into @table (col1, col2,..., colN)

select src_col1, src_col2,..., src_colN from fn_splitstring(@strings)

i think if you just log on to the machine hosting the database as an administrator, logon using a trusted connection, you should be able to change the sa password...

I think if you include something like :

if not ((select count(*) from tnp where tnpdate=GetDate()) > 0)

raiserror('Count condition was not met.', 15,1)

--

..., enable retries on that step, and set...

you can turn on trace flag 3608, which will skip automatic recovery for all databases except the master database.

ref:

http://www.google.com/search?num=100&hl=en&lr=&ie=UTF-8&newwindow=1&safe=off&q=sql+trace+flag+3608+2000

Select * from TableABC where Difference(cast(ColumnABC as varchar(8000)),'test') = 4

there are a decent number of tsql functions that fail when fed a column of type text, which means that...

this is the best i was able to come up with in my own searches for that answer.....   this does a pretty good job of mirroring the information showed in the...