SQL Server Express Forum

Full-text Index Hang

Sat, 21 Nov 2009 09:04:22 Z

Hi guys,

I am beginner in supporting SQL server so please guide me along. I have one strange problem in my SQL server. My SQL Server edition is Express Edition with Advanced Services SP3 - 9.00.4035.00.

I am querying a table with full-text index on it. The table contains approximately 3 million records with the size of 1.5 GB.

The problem is that SQL server hangs (CPU 100%) if the WHERE criteria contains both the date range as well as full-text index. I can only fix this either by restarting SQL server services or by killing the msftesql.exe manually via Task Manager.

Please refer to the SQL below to the problem.

Any comments on this? This is driving me nuts.

Thanks
David

-- this works fine and return result 

select count(1)

from product_pass

where (CONTAINS(CUSTOMER, '"*test*"') OR CONTAINS(SAM_DESC, '"*test*"'))

 

-- this hangs!!!

select count(1)

from product_pass

where result_approved_dt >= CONVERT(DATETIME, '11/01/09', 1) 

AND   result_approved_dt <= CONVERT(DATETIME, '11/01/09', 1) 

AND (CONTAINS(CUSTOMER, '"*test*"') OR CONTAINS(SAM_DESC, '"*test*"'))

 

-- change the year to 2008, this is working fine

select count(1)

from product_pass

where result_approved_dt >= CONVERT(DATETIME, '11/01/08', 1) 

AND   result_approved_dt <= CONVERT(DATETIME, '11/01/08', 1) 

AND (CONTAINS(CUSTOMER, '"*test*"') OR CONTAINS(SAM_DESC, '"*test*"'))

 

-- this also works fine

select count(1)

from product_pass

where result_approved_dt >= CONVERT(DATETIME, '11/01/09', 1) 

AND   result_approved_dt <= CONVERT(DATETIME, '11/01/09', 1)

java.lang.classnotfoundexception:com.microsoft.sqlserver.jdbc.sqlserverdriver urgent

Mon, 30 Nov 2009 07:51:08 Z

Hi,

I been trying to connect remotely from windows xp computer A to windows xp computer B with sqlserver 2005 express.
and get this error:
java.lang.classnotfoundexception:com.microsoft.sqlserver.jdbc.sqlserverdriver

Actually when setting the classpath, I dont find any sqljdbc in my Ms SQL 2005 server installation ? I have to download separately the sqljdbc 1.2 jar file.

Then, have tried to set the classpath in computer A or B or both A and B
CLASSPATH .;C:\Program Files\Microsoft SQL Server\sqljdbc_1.2\enu\sqljdbc.jar or
CLASSPATH C:\Program Files\Microsoft SQL Server\sqljdbc_1.2\enu\sqljdbc.jar

But in vain still getting the same error. Pls help urgent, I have been trying to find solution for 1 month.

Thanks

Login as 'sa' in SQL Server Authentication mode

Thu, 26 Nov 2009 04:07:52 Z

I install SQL Server 2008 Express edition and Management Studio. It creates a user as 'sa' and the password. But the password as 'sa' is unknown. I login in Widnows Authentication mode and change the password for 'sa', but when login as 'sa' in SQL Server Authentication mode there's an error - "Login failed for user 'sa'." Why? Thanks, ybc

object reference not set to an instance of an object

Thu, 26 Nov 2009 04:10:42 Z

I'm trying to create a asp web site, but i keep gettings this error when I put sqldatasource on the page, I'v tried vs2008, wwd 2008 and vwd2010 beta 2 ,sql server 2008 express on a vista 64 home edition. I create the same thing on a xp sp3 machine with the vs2008, and sql server 2008 installed and everything works as expected, I'm at a loss why I can't get is to work with my vista 64

Please advise

thanks in advance

Config Manager gives error "The specified module could not be found. [0x8007007e]"

Thu, 24 Sep 2009 05:53:53 Z

I've been using SQL Server 2008 Express Edition on my development pc for several months now. It has recently started giving me an error when I attempt to run the SQL Server Configuration Manager (SQLServerManager10.msc). I have uninstalled completely and reinstalled twice which has not solved the problem. I can run the Management Studio just fine and everything works, I just can't run the Configuration Manager which is an issue.

Full error message is as follows:

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
The specified module could not be found. [0x8007007e]

I have tried the workaround listed here: https://connect.microsoft.com/SQLServer/feedback/Workaround.aspx?FeedbackID=443459 however I did not have a sqlmgmproviderxpsp2up.mof file in my local install. I copied the one from my production installation and ran the mofcomp.exe program successfully but it did not solve the issue.

remote servicing suite honeywell version 2.14

Sun, 29 Nov 2009 09:14:39 Z

hi,
have problems installing Galaxy Rs software(remote servicing suite honeywell). I think it's a 32 bit version.Works with sql server 2005 express.Have following reply during installation
"
TITLE: Microsoft SQL Server 2005 Setup
------------------------------

SQL Server 2005 Setup cannot continue because the installation package could not be opened. The installation package has a missing file, or you are running a 32-bit only Setup program on a 64-bit computer. To continue, verify the SQL Server 2005 package you are running is supported on WOW64. If you are certain that you are running a supported SQL Server 2005 package, and you continue to see this message, contact the application vendor."

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=50000&EvtType=setup%5csqlsetupactions.cpp%40PerformSCCAction2%40sqls%3a%3aPerformSCCAction%3a%3aperform%400x1119f

------------------------------
BUTTONS:

OK
------------------------------
Strange but with another software(NET2 from paxton(works also with sql 2005 express) don't have any problem.

Anywhone an idea?
regrads
pat

Restore user-defined filegroups

Thu, 26 Nov 2009 14:15:26 Z

Hello Everyone,

Here is my sql from backup filegroup to restore filegroup.

--set database to full recovery
USE master;
ALTER DATABASE NetTrustOSK SET RECOVERY FULL;

--create new filegroup and file
USE master;
GO
ALTER DATABASE NetTrustOSK
ADD FILEGROUP Secondary;
GO

ALTER DATABASE NetTrustOSK
ADD FILE
(
NAME = Secondary2,
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Secondary.ndf',
SIZE = 5MB,
MAXSIZE = 100MB,
FILEGROWTH = 5MB
)
TO FILEGROUP Secondary;
GO

ALTER DATABASE NetTrustOSK
MODIFY FILEGROUP Secondary DEFAULT;
GO

--create table in secondary filegroup
USE NetTrustOSK;
CREATE TABLE MyTable
( cola int PRIMARY KEY,
colb char(8) )
ON Secondary;
GO

USE NetTrustOSK;
insert into MyTable (cola,colb) values ('1','A')
insert into MyTable (cola,colb) values ('2','B')
insert into MyTable (cola,colb) values ('3','C')
insert into MyTable (cola,colb) values ('4','D')
insert into MyTable (cola,colb) values ('5','E')

--backup secondary filegroup in database
USE master
GO
BACKUP DATABASE NetTrustOSK TO
DISK='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Secondary.bak'
WITH INIT;
GO

--USE NetTrustOSK
--select * from usergroup

USE NetTrustOSK
delete from MyTable where colb='E'

BACKUP LOG NetTrustOSK TO DISK='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Secondary.bak'
WITH NOINIT;

--backup tail of the log
BACKUP LOG NetTrustOSK TO DISK='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Secondary.bak'
WITH NOINIT, NORECOVERY;

--restore secondary filegroup in database
RESTORE DATABASE NetTrustOSK FILEGROUP='Secondary'
FROM DISK='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Secondary.bak'
WITH PARTIAL,NORECOVERY;
GO
RESTORE LOG NetTrustOSK
FROM DISK='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Secondary.bak'
WITH FILE=1,NORECOVERY;
GO
RESTORE LOG NetTrustOSK
FROM DISK='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Secondary.bak'
WITH FILE=2,NORECOVERY;
GO
RESTORE LOG NetTrustOSK
FROM DISK='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Secondary.bak'
WITH FILE=3,RECOVERY;

Now the problem is when I do a restore, the data inside the MyTable table is still the same. Initially I have 5 records in MyTable and I deleted one record. After I restore, I still get 4 records and not 5 records. What exactly have I do wrong there? Thanks in advance.

Importing CSV files

Fri, 27 Nov 2009 11:25:05 Z

Spent way too much time on this already pouring through books, forums, etc., more than 12 solid hours.
Time to ask for help?
Resources: VB.net Express 2008 & SQL Server 2008 Express from web platform installer on Vista Ultimate.
Dataset has table named "Stores" with fields that match the CSV located on the desktop, which is a space delimited file created by Excel 2007.

I tried cut and paste to the table data. The file shows up properly parsed, but there are errors. The cut and paste worked on one of my tables in another project (maybe a different version and a different type of install of SQL), but does not work in this project. Access has a handy dandy table import wizard, but that is not the API I'm using for this project. The connection is standard .\SQLExpress;AttachDbFilename=etc. to my.mdf. Owner: MyNet\User.

Also, is the SQL 2005 Express toolkit generally usable with 2008? Also, there was SQL Server Management Studio Express in 2005. Is that useable? Is there a toolkit for 2008? I haven't found one.

This 'usually simple' task is holding up the project. I've seen several solutions in VB.net, ADO, and SQL Server, but so far I'm getting nothing but errors. One error fired on MyNet\User authentication. What works?

SQL Express 2008 Adventure works DB

Wed, 11 Nov 2009 08:58:37 Z

Hi,

I was trying to install Adventure works DB for SQL Express 2008 using the zip file method as suggested on the codeplex website. I got the following error. But before that some background - i double the prerequisites and i think all three are in place.. I have Vista SP2 64 bit computer. Please let me know if there is another way to get it installed.

*** Dropping Database

*** Enabling FileStream
Configuration option 'filestream access level' changed from 2 to 2. Run the RECONFIGURE statement to install.

*** Creating Database
Msg 5133, Level 16, State 1, Line 2
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008_Data.mdf" failed with the operating system error 3(The system cannot find the path specified.).
Msg 1802, Level 16, State 1, Line 2
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
** An error was encountered during execution

How to create SQL Express 2008 instance after installing management studio 2008

Sun, 29 Nov 2009 00:44:11 Z

I've read all complaints about installation of SQL server 2008 express studio. According to them, it seems that installing the management studio actually installs database engine of sql server 2008 express as well. So knowing that, I proceeded to install the management studio and expected additional database engine and its instance of ss 2008 express. But after its 800MB installation, I can't find any instance of 2008 express? So my natural question is this. How can I create database instance of 2008 express engine at this point?

Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)

Sat, 28 Nov 2009 16:09:24 Z

I have attempted to load Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) several timese but it just comes back and says it failed. Any ideas what is wrong. I am running XP SP3

Remote Database Application

Sat, 28 Nov 2009 14:13:22 Z

Hi,

I have developed a small wpf application with sql server 2008 and published it on my local system named rahul and a shortcut is created by the publishing wizard in program menu to run the application. The application is running fine on my machine.

Now I want to install and run this on to client machine considering that database will be access/initiated from my machine.
what should I do for this?
Would I have to create a deployment project? and how ?
If yes than how it will access my machine from client machine? What are the all type of requirement to do this?

Please help.

Thanks

Rahul

Sql Server Management Studio 2008 (MSSQL 2008) problem.

Mon, 23 Nov 2009 14:55:33 Z

I have a problem with SQL Database and managing of them. I have a VS2010 VWD EE (Beta 2). And SQL Server Express Edition 2008. Now I have a problem with this:

TITLE: Registered Servers

------------------------------

Unable to read the list of previously registered servers on this system. Re-register your servers in the 'Registered Servers' 

window.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1312.2+((dac_stab2).090829-0704+)

&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

Deserialization operation on /RegisteredServersStore/ServerGroup/DatabaseEngineServerGroup has failed. 

(Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1312.2+((dac_stab2).090829-0704+)

&LinkId=20476

------------------------------

There is an error in XML document (0, 0). (System.Xml)

------------------------------

The type initializer for 'System.Xml.Serialization.XmlSerializationReader' threw an exception. (System.Xml)

------------------------------

Configuration system failed to initialize (System.Configuration)

------------------------------

Unrecognized configuration section system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config 

line 136) (System.Configuration)

------------------------------

BUTTONS:

OK

------------------------------

When I press Ok button it shows me another dialog:

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializationException: Serialization operation on ServerGroup[@Name='DatabaseEngineServerGroup'] has failed. ---> System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize ---> System.Configuration.ConfigurationErrorsException: Unrecognized configuration section system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line 136)
   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
   at System.Configuration.BaseConfigurationRecord.ThrowIfParseErrors(ConfigurationSchemaErrors schemaErrors)
   at System.Configuration.BaseConfigurationRecord.ThrowIfInitErrors()
   at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey)
   --- End of inner exception stack trace ---
   at System.Configuration.ConfigurationManager.PrepareConfigSystem()
   at System.Configuration.ConfigurationManager.GetSection(String sectionName)
   at System.Configuration.PrivilegedConfigurationManager.GetSection(String sectionName)
   at System.Diagnostics.DiagnosticsConfiguration.GetConfigSection()
   at System.Diagnostics.DiagnosticsConfiguration.Initialize()
   at System.Diagnostics.DiagnosticsConfiguration.get_SwitchSettings()
   at System.Diagnostics.Switch.InitializeConfigSettings()
   at System.Diagnostics.Switch.InitializeWithStatus()
   at System.Diagnostics.Switch.get_SwitchSetting()
   at System.Diagnostics.BooleanSwitch.get_Enabled()
   at System.Xml.Serialization.TempAssembly.LoadGeneratedAssembly(Type type, String defaultNamespace, XmlSerializerImplementation& contract)
   at System.Xml.Serialization.XmlSerializer..ctor(Type type, String defaultNamespace)
   at System.Xml.Serialization.XmlSerializer..ctor(Type type)
   at Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.WriteInternal(XmlWriter instanceWriter, Object instance, Dictionary`2 namespaces)
   at Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.Write(XmlWriter instanceWriter, Object instance, Dictionary`2 namespaces)
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.Write(XmlWriter instanceWriter, Object instance, Dictionary`2 namespaces)
   at Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.WriteAllInstances()
   at Microsoft.SqlServer.Management.Sdk.Sfc.SfcSerializer.Write(XmlWriter xmlWriter)
   at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServersStore.Serialize()
   at Microsoft.SqlServer.Management.RegisteredServers.ServerGroup.Create()
   at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServersStore.get_DatabaseEngineServerGroup()
   at Microsoft.SqlServer.Management.RegisteredServers.RegisteredServerControl.RegisteredServerControl_Load(Object sender, EventArgs e)
   at System.Windows.Forms.UserControl.OnLoad(EventArgs e)
   at System.Windows.Forms.UserControl.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.UserControl.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
AppIDPackage
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Microsoft.SqlServer.SqlTools.VSIntegration
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
----------------------------------------
Microsoft.VisualStudio.Shell.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.10.6071
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
----------------------------------------
Microsoft.VisualStudio.OLE.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.10.6070
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
SqlWorkbench.Interfaces
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
----------------------------------------
Microsoft.SqlServer.SqlTDiagM
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1312.2 ((dac_stab2).090829-0704 )
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
----------------------------------------
Microsoft.SqlServer.Instapi
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
----------------------------------------
Microsoft.VisualStudio.Shell
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.1826 (QFE.050727-1800)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Shell/2.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.dll
----------------------------------------
Microsoft.VisualStudio.Shell.Interop.8.0
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.1826 (QFE.050727-1800)
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop.8.0/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.8.0.dll
----------------------------------------
Microsoft.SqlServer.Management.SDK.SqlStudio
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.SDK.SqlStudio.DLL
----------------------------------------
SQLEditors
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL
----------------------------------------
Microsoft.VisualStudio.TextManager.Interop
    Assembly Version: 7.1.40304.0
    Win32 Version: 7.10.6070
    CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll
----------------------------------------
SqlMgmt
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
----------------------------------------
Microsoft.SqlServer.Management.UserSettings
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.UserSettings.DLL
----------------------------------------
Microsoft.SqlServer.Management.Sdk.Sfc
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1312.2 ((dac_stab2).090829-0704 )
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Management.Sdk.Sfc/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.Sdk.Sfc.dll
----------------------------------------
Microsoft.SqlServer.Management.Reports
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Reports.DLL
----------------------------------------
Microsoft.SqlServer.Management.RegisteredServersUI
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.RegisteredServersUI.DLL
----------------------------------------
Microsoft.SqlServer.Management.Controls
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Management.Controls.DLL
----------------------------------------
System.Design
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
Microsoft.SqlServer.Management.RegisteredServers
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1312.2 ((dac_stab2).090829-0704 )
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Management.RegisteredServers/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.Management.RegisteredServers.dll
----------------------------------------
Microsoft.SqlServer.ConnectionInfo
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1312.2 ((dac_stab2).090829-0704 )
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
----------------------------------------
ConnectionDlg
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.1600.22 ((SQL_PreRelease).080709-1414 )
    CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/100/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Microsoft.SqlServer.SqlClrProvider
    Assembly Version: 10.0.0.0
    Win32 Version: 10.50.1312.2 ((dac_stab2).090829-0704 )
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlClrProvider/10.0.0.0__89845dcd8080cc91/Microsoft.SqlServer.SqlClrProvider.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
Microsoft.NetEnterpriseServers.ExceptionMessageBox
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015 )
    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/10.0.0.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
----------------------------------------
System.Web
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

And in Label it's shows:
"Serialization operation on
ServerGroup[@Name='DatabaseEngineServerGroup'] has failed.
Then I can Log-In into database, and do just half work.

I have installed: MS Framework 2.0, 3.5, 4.0. I am using MS Windows XP SP2. It makes me crazy. Everything running okay but just this application have problems.

Cannot Connect to Server - Error 26 / Error -1.

Sun, 30 Nov 2008 17:01:10 Z

I am attempting to connect to SQL Server 2005 Express, at the 'Connect to Server' form.

When I click the 'Connect' button, I obtain the following error box:

TITLE: Connect to Server
------------------------------

Cannot connect to DAVID\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

My installation is ok, as I used to be able to connect just fine. It has been about six months since I've attempted to go into SQL Server Express. I don't know what on my PC might have changed in the last six months. I am running under Windows XP SP 2.

Sql Stored procedure Issue

Fri, 27 Nov 2009 05:27:56 Z

I have query with lot of inner joins and left joins with some conditions.

If excute this query in my query analyzer, i am getting the answer with in few sec.

but if i put this query inside procedure its taking long time to around 9 min.
what can i do to get the performance.

regards Vinoth

sql question with VB

Thu, 26 Nov 2009 17:51:08 Z

Hiya folks, im very new to the sql server 2008 express edition along side VB 2008 express edition so i havent a clue. i might be going about this the wrong way so if you have any other ideas, would love to hear them.

ive got it working sr, sw readwriter stuff reading to and from text files, but im going to end up with shed loads of files, i could do without.

ive created a tested database, called lindberg_test.
Ive done the drag and drop stuff, so all the auto bindings are on screen on my VB2008 express page. Thats where im up to.

i can click next, put new data in and all that but i need to go a bit further.

ive got my data in 12 columns.column 1 is my primary key, stroke my data point i need to refrence to call the data back from the entire row and sow it in the relevent text boxs on another page.

i was wondering can i use column 1 to recall the data from so lets say for example.

think about it in a musical way.

band name is in column 1
all the stuff about the album is in the other 11 columns.

so on page 1.VB i enter the band name click search and on page 2.vb the data from the 11 columns show in the relevent text boxes.

Also i think i read somewhere you put put pictures in sql sever, how do i do that for recall to a picturebox from the server so the picture pulled will be in relation to the rest of the info recalled.

If i posted this to the wrong place very sorry. think of me virtually slapped, for making the mistake. let me know where to post it/move it to.

thanks in advance.
regard
rimlesskid

SqlServer auto restarts in single-user-mode everyday

Sat, 14 Nov 2009 03:48:14 Z

Dear All,
       My SQL Server wroks well for 1 year, recently,some applicaiton were failed to login. It claim that the sql server was started in Single User mode, How can I fix it ?

        In the error log files, I found the time that the logs start are all 3am for everyday.

1-28 03:00:53.03 Server      Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) 

	Oct 14 2005 00:33:37 

	Copyright (c) 1988-2005 Microsoft Corporation

	Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2)



2009-11-28 03:00:53.03 Server      (c) 2005 Microsoft Corporation.

2009-11-28 03:00:53.03 Server      All rights reserved.

2009-11-28 03:00:53.03 Server      Server process ID is 3796.

2009-11-28 03:00:53.03 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.

2009-11-28 03:00:53.03 Server      This instance of SQL Server last reported using a process ID of 3640 at 28/11/2009 3:00:16 (local) 27/11/2009 19:00:16 (UTC). This is an informational message only; no user action is required.

2009-11-28 03:00:53.03 Server      Registry startup parameters:

2009-11-28 03:00:53.03 Server      	 -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf

2009-11-28 03:00:53.03 Server      	 -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG

2009-11-28 03:00:53.03 Server      	 -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf

2009-11-28 03:00:53.03 Server      Command Line Startup Parameters:

2009-11-28 03:00:53.03 Server      	 -m SqlSetup

2009-11-28 03:00:53.03 Server      	 SqlSetup

Thanks

Regards,
Bill

KB970892 Sql server will not insall

Thu, 15 Oct 2009 16:08:33 Z

SQL update will not install KB970892 error code 0x663. Now I can not open any of my programs that need sql. I have been on hold with microsoft on and off for two hours now. ANY HELP

Named pipes error

Fri, 27 Nov 2009 17:03:27 Z

Hey guys! I have an ASP application and we want it to point to the mirror when the main server fail. We made a test today and we got a nmaed pipes error when we caused the failover.

This is the connection string:

"Provider=SQLNCLI10;;Server=xxx.xxx.x.xx;Failover Partner=yyy.yyy.y.yy;Database=dbname; Uid=user;Pwd=password;"

The error I got was :

Microsoft SQL Server Native Client 10.0 error '80004005'
Named pipes provider. could not open a connection to sql server [53]

The named pipes on both Servers are enabled.

Anny sugetions?

First Time SQL Server but cannot save data

Fri, 27 Nov 2009 16:56:54 Z

Hi
I made a sql database comprised of two fields as a test. I am able to add data to the fields. I have the navigator linked.
The navigator allows me to page thru the fields. That seems to be working.
How do I save the changes I`ve made to the database file. The navigator has a save button...is that were the code must be.
PS...I have looked for videos on this but never seem to find the info that applies to my current problem.
Please don`t be hard on me for this very basic question ...just starting to learn

SQL Server [&Express] 2008 fails to install correctly

Sat, 21 Nov 2009 22:24:12 Z

Can anyone help? I am a [very] mature IT student and need to have SQL Server Express 2008 & Management Studio available to do coursework. I have loaded both without a problem on my laptop, but on my pc the installation doesn't work. Although I answer the setup questions the same as for the laptop, I get error messages. I tried loading from the MS web-site [various different options] and from SQLEXPRWT_x86_ENU.exe and from SQLManagementStudio_x86_ENU.exe - I either get an error message with a code like 17113 or 17058 and a web-site prompt that displays a message that "no further information is available, but thanks for letting us know", or, when I actually load Management Studio, I can't connect to SQL Express and finish up with SQL Compact instead [which is not what I need!]. One time, I got a message that SQL Server failed to install because of Invalid ID, whatever that is supposed to mean, and also "The following error has occurred:The specified user '\Everyone' does not exist." Another time, "couldn't find the file", and WMI Provider Error [call to WMI Provider returned error code 0x8007452a2]. When I look up that error on the web, I get sites that list many WMI error codes, but not that one. When I try to load Express, I have had "connection timed out", and messages about pipes, etc., and "cannot find the user". Many times I just get "SQL Server installed with failures". Each time installation failed, I have tried to rectify using info from web-site message boards - to no avail, and then had to uninstall all SQL apps and delete all files, run a registry checker and re-boot. Going on 4 days now, and I am very frustrated at the lack of information to rectify and install properly. I am running a Vista Home Premium setup, the same as my laptop, on which it is all correctly installed first time. I have also run the Windows Install Clean Up to get rid of previous SQL Server installation setup files.

Today, before I try to install yet again tomorrow [if I had any hair, I would by now have torn it all out!], I also went through the whole registry, and deleted every key with a reference to SQL Server or Express or Management Studio [Yes, I know it's dangerous, but I'm desperate!] And why doesn't uninstall remove all these keys? I found more than a dozen keys for SQL10.Express !!!!

Why is this so complicated - and why do I get messages without suggested rectifying solutions? It's a good job it's free - If I'd paid for it, I'd be in the small claims court right now. Is there a screen-by-screen installation guide out there somewhere that I haven't yet found?

Any help to a speedy resolution would be appreciated.
Dave B.

Database Wizard in VB Express?

Fri, 27 Nov 2009 07:01:21 Z

Does anyone know what happened to the database wizard? Because apparently, it does most of the work for you. I have been struggling to connect my VB application to my SQL database. I did eventually achieve this in code, but I am told that ,with the wizard, everything is just a click away.

Please, I don't need code, I just need to find out where to find this wizard.(To use this wizard in VB 2003,you just add it as a new item.)

Set MS SQL Express listening on localhost/loopback only

Fri, 27 Nov 2009 07:43:08 Z

Hello,
Is there any possibility of setting SQL server instance to listen on localhost loopback only? (So that no remote application can access it). The best solution would be to have this possibility as a CMD line command (we need this to do in installer and it is able to run CMD commands not clicking in windows). Thank you.
(I'm using MS SQL Express 2005 and it accept remote connections by default)

Best regards,
Jozef

Error when opening node databases in SQL server management studio

Tue, 24 Nov 2009 18:12:31 Z

Hi,

I recive the following error message when I try to expand the node databases in SQL server management studio. I have SQLexpress2008 installed and alle my databases seem to work just fine. I even moved some of the databases to a different computer and had no trouble opening them there. But why can't I open them on my own machine???

Local enviroment:

Vista Business 64 bit
SQLexpress2008
VS2008 + SQL2005

Errormessage:

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItemBuilder.<ReadData>d__0.MoveNext()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItemBuilder.BuildDynamicItemWithQuery(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren(IGetChildrenRequest request)
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren(WaitHandle quitEvent)

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand)
   at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String query)
   at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
   at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
   at Microsoft.SqlServer.Management.Smo.ExecuteSql.ExecuteWithResults(StringCollection query, Object con, StatementBuilder sb)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.GetData(EnumResult erParent)
   at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
   at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
   at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
   at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)

===================================

Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=926&LinkId=20476

------------------------------
Server Name: BOSSEN-PC1\SQLEXPRESS2008
Error Number: 926
Severity: 14
State: 1
Line Number: 3

------------------------------
Program Location:

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand)

Please help :-)

SQL Server 2008 Express edition install issue.

Tue, 24 Nov 2009 16:36:51 Z

Ok, i've been looking around forums for a while now and have not found a post similar to this one or one that offers a solution; so here it goes.

I'm trying to install management studio and in the web platform installer i keep getting this error:
"You must install visual C++ 2008 SP1 before you can install SQL server 2008 Express with tools"

I managed to get the install to "work", but it didn't actually install the studio app. So heres my questions:

Firstly...why? i've installed this before and not had any issues at all, so why the sudden need for C++?

Secondly, does anyone have any insight into my problem and how i cant actually install it?

The only real difference between this install and previous installs is that i'm not running it on vista home premium 64-bit (previously 32-bit).

I tried installing visual C++ express, but that didn't work.

Thank you in advance and for giving up your time to read this.

sql 2008 question

Wed, 25 Nov 2009 16:35:19 Z

Hiya folks, im very new to the sql server 2008 express edition so i havent a clue. i might be going about this the wrong way so if you have any other ideas, would love to hear them.

ive created a tested database, called lindberg_test.
Ive done the drag and drop stuff, so all the auto bindings are on screen on my VB2008 express page. Thats where im up to.

i can click next, put new data in and all that but i need to go a bit further.

ive got my data in 12 columns.column 1 is my primary key, stroke my data point i need to refrence to call the data back from the entire row and sow it in the relevent text boxs on another page.

i was wondering can i use column 1 to recall the data from so lets say for example.

think about it in a musical way.

band name is in column 1
all the stuff about the album is in the other 11 columns.

so on page 1.VB i enter the band name, on page 2.vb the data from the 11 columns show in the relevent text boxes.

Also i think i read somewhere you put put pictures in sql sever, how do i do that for recall to a picturebox.

If i posted this to the wrong place very sorry. think of me virtually slapped, for making the mistake. let me know where to post it/move it to.

thanks in advance.
regard
rimlesskid

SQL Server Modeling Services

Wed, 18 Nov 2009 20:17:23 Z

Does anyone know in what SQL server edition the new SQL Server Modeling Services will be included, e.g. will it be available in Express edition?

Syncing Sql Server Express

Thu, 26 Nov 2009 08:17:48 Z

Hi!

I have a .net application which communicates with a webbased server database provided by SQL Server Express 2005.

This databse has to be synchronized a couple times a day with a local database server (als sql sever express).

I started looking at replication, but since sql server express cannot be a publisher, this will not be an option...

I have looked into Microsoft Sync Framework, but I am not sure this is the best way, since it doesnt work that well with express (or this is what I read)

So my question is: Do you have any tips / tricks / examples / howto's??

Cannot connect from client to SQL Server 2005 Express

Tue, 24 Nov 2009 15:21:49 Z

Resently I installed SQL Server 2005 Express on a system with windows server 2008. Kindly help me to establish connection from a client with XP Professional with sp2. Do I have to install any s/w or drivers to do this.
Secondly how do i get connected from vb6. what connection string will do.
Thanks,

SQL Express connectivity issue on Vista Home Premium

Tue, 24 Nov 2009 14:33:20 Z

Two Vista Home Premium machines setup. SQL Express 2005 is successfully installed on the first machine along with our application. Our application is able to browse and connectthe SQL Express. However, the other machine is unable to browse or see the SQL Server. What could be the issue??

Another thing, in order to test the connection, I tried creating a UDL file on the machine that wont connect.And it does not recognize the .udl extension. Why so?

Kindly help.

I need to know how i can Deal with Database on Different computer ???

Wed, 25 Nov 2009 23:35:02 Z

if i have 2 computers and one of them is install sql server express on it and have DB on it and i want insert or make anything i want from the remote computer that didnt have sql ,,, as you know a remote connection i want to know where from i can learn about that ,,, i need to know how i can do it in my connection string to connect through network and this things ?

check size of database

Tue, 24 Nov 2009 18:31:07 Z

Hi,

Is there a query I can use to check the size of a database from a vb.net app

Distributing SQL Server 2008 Smos / SDK with an application

Fri, 14 Nov 2008 09:28:26 Z

This is somewhat related to this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3871856&SiteID=1 but regarding the SDK rather than SQL Server 2008 Express proper.

Our issue is that we have issues with dependencies, specifically VS2008 SP1 is not detecting all the dependencies for the installer merge modules: Microsoft.SqlServer.BatchParser and ..BatchParserClient are missing from the target install. What IS being correctly detected are Smos, SmoEnums and ConnectionInformation (amongst a few other things)

During testing of the install routine on a clean system we had to manually install the Native Client + SDK, CLR Types and Management Objects first to get the app to install.

I'm fairly certain that installing SQL Server 2008 express + sdk resolves all the dependencies but that itself brought in two caveats:

1. If SQL Server 2008 Express is installed it will simply create an instance instead of installing - but the SDK will not be installed if it was not there already

2. We dont want to neccesarily inclue Express just to get the SDK

3. We want a merge module - we do not want to rely on a net connection to bootstrap as this is a plastic-disc based product

Basically we'd be happy with a single "all in one" "SDK only" msi we can run silently, any clues?

SQL Server 7.0 SP3

Wed, 25 Nov 2009 16:37:33 Z

I specifically need Service Pack 3 (not SP4) for MSDE (1.0). Can anyone point me to a location where I can download it from?

Thanks.

Glen

KB970892 Will Not Install.

Fri, 16 Oct 2009 02:17:36 Z

When I booted my XP SP3 machine Tuesday night (10/13), the many MS updates loaded.

I then let them all install.

All updates installed except for one.

I am getting the following message, for KB970892:

The following updates were not installed.
  Security Update for SQL Server 2005 Service Pack 3 (KB970892)

I am running SQL Server Express 2005:

Microsoft SQL Server Management Studio Express      9.00.4035.00
Microsoft Data Access Components (MDAC)      2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML      2.6 3.0 4.0 5.0 6.0 
Microsoft Internet Explorer      7.0.5730.11
Microsoft .NET Framework      2.0.50727.3603
Operating System      5.1.2600

No Server is listed in the "Server Name" box after launching Managment Studio Express.

Wed, 25 Nov 2009 01:02:02 Z

I installed SQL SERVER 2008 express and management studio express successfully in window7 home premium x64. but when I start the Management studio, there is no Server listed in the "Server Name Box, I can't connect any servers in database Engine. I try several times for download and setup, The results are same. Is any one know what I miss?

Select Max problem ?

Tue, 24 Nov 2009 18:00:40 Z

Hello
i have coulum of Table. Datatype is nvarchar(50). and Coulumname is x_kod.
For Example My coulum have below records.
100
101
102
100.001
100.002
102.01.001
102.01.002
zthisort001
zthisort002
ambrella001
ambrella002

I have one textbox and one button.
Firstly When i doesnt enter to Textbox and i click button, how can i get 102 ?
Secondly When i enter 100. to Textbox and i click button, how can i get 100.002 ?
3. When i enter 102.01. to Textbox and i click button, how can i get 102.01.002 ?
4. When i enter zthisort to Textbox and i click button, how can i get zthisort002 ?
5. When i enter ambrella to Textbox and i click button, how can i get ambrella 002 ?
Note: My result should be max value of related group of records.
Thanks

Import/Export Data using Management Studio Express?

Wed, 25 Nov 2009 03:09:25 Z

I need to import data from a table in one SQL Database into the same tables of another SQL Database. I am using SQL 2005 Express Edition and Management Studio Express. Is there an import/export tool to use with this version?

While installing SQL Server 2005 Express edition my computer restarts multiple times

Mon, 23 Nov 2009 13:14:24 Z

Hi all,

     I have downloaded fresh copy of SQL Server 2005 Express Edition from Microsoft Website and started installing. In last step when installation wizard automatically starts the SQL Service at that moment my computer restarts. And after restarts, atleast after 1 minute my system restarts again without any notification. This continues for several times.
     Is this due to some problem with windows? But I have formatted and installed windows xp 2 too.

     Please anyone comeout with some solution I would really appreciate.

Regards

Asif...

Cannot connect to SQL 2008 Express from VB 2008 Express

Wed, 26 Nov 2008 03:07:25 Z

I installed VB 2008 Express with SP1 and SQL 2008 Express. However, I cannot link to SQL 2008 Express from VB 2008 Express. Please Help.

Since I'm new to this environment, I may not even be asking the right question. A brief background: I did some minimal work with VB 2008 Express - creating an sdf database and some forms that interacted with the database. I also did some minimal work with SQL 2008 Express, running some queries against the AdventureWorks Database. When I tried to create a form in VB 2008 Express that accessed the AdventureWorks Database in SQL 2008 Express, I have been unable to figure out how to create the needed connection.