Ah that makes since. The pointer to the truncated table is saved and not the actuall data. I rememebr seeing this pointer in a table somewhere and that the poitner...

Take a look at these. One may fit your exact issue, but there are a few known causes.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q288095&

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q278421

http://support.microsoft.com/default.aspx?scid=KB;en-us;q306998

The last is SQL 2000 and the others are 7.

Yes, I discovered that thanks to rmarda (on this site) and I haven't been back since.

Hope it gives you what you need to get your results and heres to a better week from now on.

I am sure there are always new solutions to old problems and so on but most code and information is surely rehashed and updated.

The only thing I know for sure. Distributor should be upgraded first, then publisher and then subscriber. However, SQL2K

transactional replication supports 7.0 publisher and 2K subscriber.

I suggest checking indepth the...

Even with the reserved keyword list it may help to go ahead and wrap in brackets. Future upgrades may see additional keywords and they may exist in you database. Then...

I agree create you own account and don't use the default anonymous web account. The reason is a hacker will attempt to use that account to get at you SQL...

My thought, are you using the MS novell connector or have you installed the Novell client with IPX/SPX. If you did you should be able to remove IPX/SPX and the...

I am still trying to figure how this coversation went to 6 drives when he states

2-72GB drives in RAID0

3-72GB drives in RAID5

Barring the fact I let my Hardware information get...

One additional note. If you plan to add additional DBs to the same server down the road and do not want autoshrink turned on then set off in model DB...

I would suggest reporting to MS as a documentation error.

Here is the MS Licensing FAQ on MSDE http://www.microsoft.com/sql/howtobuy/msdeuse.asp

Are there a lot of transactions? This may work but I am not sure this is a good option and that I didn't miss something. And it will depend on...

I have been working on a piece that is not done. But to script out the sp_addlinkedserver I run a query like so:

select ('sp_addlinkedserver

@server = ''' + srvname +...