BI Studio 2005 not getting installed in VISTA
Sun, 28 Sep 2008 08:12:01 -0700
Hi,
We are installing SQL Server 2005 Developer edition(x86) in a Windows VISTA
machine having Visual Studio 2005 Professional Edition with SQL Server
Express Edition 2005.We have the latest service packs for Visual Studio and
SQL Sever.The problem is that we are not able to install Business
Intelligence S ...
|
PAGEIOLATCH_SH occupies a long time.
Sat, 27 Sep 2008 23:07:00 -0700
Hi experts,
I have run a sql in SQL Server 2005. I run this sql very fast (about 1~3
seconds) in other db servers, but in one db server, it runs very slow, even
it cannot complete in 15 minutes.
I have checked the db activity, I found this sql is suppened because of
PAGEIOLATCH_SH.
Using Performance m ...
|
Retore a single table in SQL Server 2005
Sat, 27 Sep 2008 16:12:09 +0100
Hello all
This question has probably been asked before, but I can't find an answer.
Simple question: How do I go about backing up an SQL Server 2005 database,
and then restore a SINGLE table from that back up?
Thanks in advance for any help.
Regards
David
...
|
Help with query.. group needed, but can't be used.
Sat, 27 Sep 2008 02:49:29 -0700 (PDT)
I have a few tables that store data about a remote control aircraft.
These tables that I am working on now contact the components that are
on a specific aircraft. If the user decides to change some components,
they basically create a new configuration, and then store the new
components. A component can be used o ...
|
ss05 dev edition limits on db size ?
Fri, 26 Sep 2008 18:01:09 -0700
Does SQL Server 2005 Developer Edition place any limits on database size ?
...
|
Re: 2005 features not working
Fri, 26 Sep 2008 17:05:16 -0700 (PDT)
On Sep 21, 11:56 pm, Jacob Kipkangor <Jacob
Kipkan...@discussions.microsoft.com> wrote:
> Sorry for intruding.
> I know this is gonna be easy for you guys.
> I have a Windows XP SP2 system and when installing SQL Server 2005 Standard
> Edition i get this error "Service 'SQL ServerActiveDirectoryHelper' could
> ...
|
How to remove notification service from SQL Server Configuration Manager
Fri, 26 Sep 2008 16:30:59 -0500
One of our server has Notification Service installed and uninstalled. But
the notification server NS$FlightInstance, NS$RealtorInstance etc are still
exists in SQL Server Configuration Manager services list view. Can anybody
tell me how to remove them?
Thanks,
Lijun
...
|
|
|
Best practices for sql server 2005 with SAN DISK SPACE
Fri, 26 Sep 2008 14:14:06 -0700
Hi All,
We are trying to setup new sql server 2005 servers for our new production
environment.
we have 10 databases of size ranging from 5GB to 500GB .These databases used
by different applications. some are inhouse applications and some are third
party applications.
All these databases,applications are ...
|
How to make a new database in SQL SERVER 2008
Fri, 26 Sep 2008 13:42:11 -0400
I have a script that configures a database as I need it.
Here is a little bit of it:
CREATE TABLE [Albums] (
[AlbumID] [int] IDENTITY (1, 1) NOT NULL ,
[Caption] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[IsPublic] [bit] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [Photos] (
[Photo ...
|
Disconnecting SMO objects in SQLPS 2008
Fri, 26 Sep 2008 08:57:01 -0700
After connecting to an object in SQLPS, I would like to force the connection
to logoff. Two specific measurable outcomes indicating success would be:
* The session no longer exists on the SQL Server in sys.dm_exec_sessions.
* In SQLPS, the server name should disappear from SQLServers:\SQL\ (or at
least ...
|
