Nerdlinger/Microsoft Server Filter: Can SQL 2000 exist in a Windows 2008 Domain when installed on a Windows 2000 member server ? Before anyone says it, yes, yes I know it's old, outdated, unsupported, we should be using SQL 2005 or looking at SQL 2008 and that it can't be installed on a Windows 2008 server. BUT... does anyone know if SQL 2000 will work when installed on a Windows 2000 server that is a member of a Windows 2008 domain? I know that Windows 2000 servers can be members of a 2008 domain but Exchange 2000 won't work. Will SQL 2000?
posted by Man_in_staysis on Feb 25, 2009 - 13 answers

Can I connect to a SQL Server 2000 database using SQL Server 2005 Express? [more inside]
posted by Glendale on Nov 5, 2008 - 2 answers

How should I optimize a SQL Server 2000 table which will only ever be used for INSERTs? [more inside]
posted by ParsonWreck on Sep 15, 2008 - 9 answers

I'm working in Visual Basic (Access 2003, technically) with a SQL Server 2000 backend, and I believe I need to create a View dynamically... I am very familiar with creating QueryDef's and Stored Procedures on the fly, but have never attempted to create a View in this manner... My google-fu seems to be failing me at the moment.. [more inside]
posted by Glendale on Sep 2, 2008 - 2 answers

How does one get their head around OLAP? [more inside]
posted by SirStan on Feb 10, 2008 - 4 answers

Please help me understand what happens when I click the cancel query button in SQL Server Management Studio. [more inside]
posted by smithygreg on Nov 29, 2007 - 3 answers

SQL SERVER - I'm not a SQL script guy, but I've got a SQL script problem. [more inside]
posted by jpoulos on Sep 17, 2007 - 6 answers

SQLServer Express remote connection problems. Please hope me! [more inside]
posted by derbs on Nov 2, 2006 - 9 answers

SQLServerFilter: Quick question about views and using "NOT IN". [more inside]
posted by SoulOnIce on Oct 21, 2006 - 4 answers

I have a Windows-served website programmed in C# and connected to a SQL database. I'd like to move the whole thing to the Mac. [more inside]
posted by thejoshu on Feb 24, 2006 - 8 answers

What is the optimum way in an ASP.NET Web Application with SQL Server 2000 to perform the following data correlation? [more inside]
posted by kenaman on Jan 19, 2006 - 2 answers

I currently have a very low level of SQL knowledge (I can construct simple queries for multiple tables, but I start to fall apart on the difference between inner and outer joins). I need to learn to create multiple join SQL queries and Dynamic SQL/Stored Procedures on MS SQL Server 2000 in a short period of time. I'd also like to learn to use MS Query Analyzer more efficiently. Is there one book or online resource that is best for this? Additionally, are there alternatives to using MS Query Analyzer, or is that really *the* tool? [more inside]
posted by de void on Jul 12, 2005 - 12 answers

I am trying to implement SQL mail fonctionnality for monitoring purpose under win2k / sql2k, only problem is to be configurer properly it must first obtain its parameter from Microsoft Mail API (MAPI) thru an already configured mail account, these are production servers and i don't feel too good about installing Outlook or Outlook express just to get an account configured so i can use this fonctionnnality. is there a way around this ? I am aware of several monitoring solution offered by third parties and i accept proposition (please no astroturfin') but I want to get that build in feature to work first.. anyone ? Thanks Selfsck
posted by selfsck on Mar 15, 2005 - 4 answers

I am having a problem with our account app / server; I need to apply a hot fix to the sql db and the files are encrypted. When trying to decrypt the file, I get varied error messages. Any MCSE / encryption Guru's in the house? [more inside]
posted by AllesKlar on Mar 11, 2005 - 1 answer