Server Configuration

SQL server book - 2005 or 2008?
I need a refresher book on SQL server. Our short-term application will use 2005 but I'm seeing DBA books on Amazon for 2008. Can I get a 2008 book and assume that most of it is also applicable to 2005 - or are there major differences between the two? Thanks in advance - Jack ... 22 Apr 2010 09:18

ANN: New version of Database Workbench, the multi-DBMS IDE now available!
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: " Database Workbench 4.0 Pro" With this version we're reached a milestone: Database Workbench is now fully Unicode enabled and offers new tools to increase your productivity. There h... 22 Apr 2010 06:11

Query General
Hi. I have two tables Table1 Name Serial Date John 01-01-2010 Tony 11-02-2010 Table2 Name Serial Date John 05-04-2009 John 06-08-2009 John 01-01-2010 Tony 11-02-2010 Tony 11-02-2010 I want is to assign the serial against each name starting from 1 in table2 according to d... 23 Apr 2010 18:12

SQL2008 SSMS loses custom serttings
I'm using the SQL 2008 SSMS for several SQL servers (SQL2000, SQL2005, & SQL2008) and have set up some custom scripts to run with keyboard shortcuts (from the menu Tools, Options, Environment, Keyboard). Every once in a while I lose all the shortcuts I had saved. When this happens I also lose the location of ... 21 Apr 2010 14:40

Retaining CDC History
I have no solution to this..but I was wondering if you ever came up with a solution. I have read in a few places that you need to make a second capture instance for the table. Then you will have the history in one table and the new history in the new capture instance table that you create. The first capture instance wi... 21 Apr 2010 10:31

How to compare two dataset?
In myapp, I can create two datasets: [dstServer1] and [dstServer2]. They are coming from two tables which are in two different SQL server: [Order1] (in server1) and [Order2] (in server2). These two tables have the same data structure. How to code to compare two dataset and then insert difference into another tab... 23 Apr 2010 15:00

Command Within SQL to get Windows login Name
is there a way we can know whats the windows login accountname using a command within sql (just like select suser_name() ) , if he is still accessing the SQL server with a SQL account like 'sa' any sys table maps this info and stores ? ... 21 Apr 2010 11:33

SQL Server version on DPM 2010
Hello, i would like to ask that, do i have to use sql server 2008 to install Data protection manager 2010? Does DPM 2010 not support sql server 2005? There are no DPM discussion title on this site so i asked from here. thanks. ... 21 Apr 2010 08:26

I can not connect to a SQL Server 2005 after installing Vista Serv
Hi I've have a program that connects to a SQL Server 2005 running on a Vista computer. After installing service pack 2, the program can not any longer connect to the database. The same program still works on XP machines. What happended? ... 21 Apr 2010 10:31

Unexpected “Long running transaction” performance counter behaviou
Hi All, I have a SQL Server 2008 SP1 x64 Standard instance running on Windows Server 2008 R2. I am observing unexpected behaviour in connection with the "MSSQL$SQLInstanceName:Transactions\Longest Transaction Running Time" performance counter. According to BOL, this counter measures "The length of time (in... 21 Apr 2010 04:18