Tried 2GB and 4GB total. Not sure about anything in between. Having 1GB for the OS is a nice cushion for paging, swapping, drivers, etc. Not sure if 4 is...

What if you had 3 rows for the civic? Or are you just looking for the lat two rows?

select  max(date)

  , car, type

 from tableA

 group by car, type

will give you the...

I wish I had an answer, but I don't. The client access linked server from SQL has been flaky for me in the past as well.

DTS should be fine if the server names are the same.

sp_help_revlogin is available on MSDN (msdn.microsoft.com).

The above advice should work for you, but practice a few times.

select

    case when version = 'sql2k' then srvname

 end 'sql2k'

,

    case when version = 'sql70' then srvname

 end 'sql70'

,

    case when version = 'sql65' then srvname

 end 'sql65'

http://www.winnetmag.com/Article/ArticleID/21176/21176.html

There must be something else. There is no reason that a user needs SysAdmin to write to a table. Have you checked that there are not overriding "DENY" permissions somewhere...

It's some internal error. If this is a critical server then call MS

Agree. You'd ideally separate OS, pagefile, data, log, and tempdb. If you can't, then separate put OS and pagefile together. IF you still can't do that, put tempdb with data...

You need to go to EM, select the server, right click, properties. On the Security tab, select mixed (SQL and Windows) auth.

Then restart and you should be ok. DO NOT...

Do you have AWE set? I'm not sure 1GB is enough for the OS at this point. I know at 8GB, almost 1GB is used for swap space between the...

RAID 10 should perform better with 4 drives, but it's less space. 2 drives are used to backup the other 2. It's what I'd recomend if you can.

Otherwise use...

if you get things out of order, (the above technique works), you can connect from the console of the server to "(local)" or "." to get back in and change...

Apologies. I'll take a look and see if I can find that bug.

Steve

The real issue is that the product can be installed without valid licensing for the server. Product IDs are not required to be unique on the network (unlike Netware). And...