Hi

thanks for your replies - I set the STATUS column to 12 on the sysdatabases entry for the database and it worked. I was then able to carry out a...

Anybody???

Hi Sohrab,

you do not specify if you are SQL2K or 2K5 and if you are 2K, whether you have to stay at that level. If you don't or are at ...

Hi,

try selecting max(len(ntextcolumn)) and then declaring a varchar variable at that length

Declare @ntext varchar(x)

then select @ntext = the ntext column

select @ntext = ntextcolumn from TABLE where X= XXX etc.

you might...

Hi,

not as far as I know outside of Microsoft. They did run one on SQL Server on W2K Clusters, but this was two years ago. Don't know what your relationship...

Hi,

Should imagine this is more to do with the time window for backups - and also the amount of storage required to back up VLDB's - if you have a...