|
|
|
SSC-Dedicated
           
Group: Administrators
Last Login: Today @ 4:46 PM
Points: 31,433,
Visits: 13,745
|
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:21 PM
Points: 1,389,
Visits: 417
|
|
I would like to install the 2k8 ctp on a vista machine; I have already a 2k5 developer (named) instance installed. I've read that the 2k8 ctp does not work yet with many instances; can I install it as a 2nd instance on this machine? I would not want to break the sql 2k5 installation. Thank you in advance.
|
|
|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Saturday, November 10, 2012 8:18 AM
Points: 3,461,
Visits: 346
|
|
The following side-by-side conditions are not supported in this release: - Side-by-side Tools - Presence of SQL Server 2005 Management Tools or BI Development Studio will block installation of SQL Server "Katmai" Management Tools and BI Development Studio.
- Side-by-side with SQL Server 2000 - An instance of SQL Server 2000, including MSDE, will block installation of this release of SQL Server "Katmai".
- Side-by-side with SQL Server "Katmai" CTP1 - An instance of SQL Server "Katmai" CTP1 will block installation of this release of SQL Server "Katmai".
- Side-by-side instances of SQL Server "Katmai" CTP3 - Multiple instances of this release of SQL Server "Katmai" are not supported on a single computer.
This is from BOL of SQL 2008.
Cheers, Sugeshkumar Rajendran SQL Server MVP http://sugeshkr.blogspot.com
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:21 PM
Points: 1,389,
Visits: 417
|
|
Thank you. It's great to know.
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Friday, September 10, 2010 4:08 PM
Points: 2,
Visits: 18
|
|
I'm actually pretty excited about the baked in spatial support in Katmai.
http://www.directionsmag.com/article.php?article_id=2477&trv=1
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Friday, November 30, 2012 12:17 AM
Points: 86,
Visits: 252
|
|
Consider using virtual server's - install a virtual server, andd then on the cirtual server you *should* be able to install Katmai anyone doing this yet? I'm waiting to get virtual server on a machine that can handle it...
|
|
|
|
|
UDP Broadcaster
      
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:45 AM
Points: 1,441,
Visits: 2,485
|
|
Here's a bit of trivia - Katmai was Intel's code name for the original Pentium III processor. You'd think that somebody at MS would have known that
|
|
|
|
|
Mr or Mrs. 500
      
Group: General Forum Members
Last Login: Monday, September 17, 2007 8:55 AM
Points: 563,
Visits: 1
|
|
I have always wanted Microsoft to incorporate an ability to see who are the active users and the complete sql they are running as Oracle enterprise manager lets you do(more information than sp_who2 provides)
Mike
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Friday, November 30, 2012 12:17 AM
Points: 86,
Visits: 252
|
|
In SQL 2000, use the function ::fn_get_sql (X'sqh handle') where SQL_handle is the sql_handle column from sysprocesses. In SQL 2005, have a look at sys.dm_exec_sql_text(sql_handle), getting sql_handle from sys.sysprocesses HTH
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Tuesday, January 13, 2009 5:31 PM
Points: 8,
Visits: 34
|
|
Intellisense would be nice, but only if they incorporate it into Visual Studio too. I have to believe the majority of SQL developers use VS and not EM/SSMS.
I also think Red-Gate has missed a golden opportunity by having SQL Prompt only hocked into SSMS. From what I've read, it was a challenge for them, since SSMS doesn't expose a plug-in architecture. VS already exposes this architecture, so you would think it would be fairly easy for them to adapt their existing SQL Prompt code over to VS.
I could be wrong and perhaps that's one of the reasons Red-Gate is publishing this software and I'm not.
Thoughts ?
Thanks, Don
|
|
|
|