poor performance

Hello all,

I recently pick up a SQL-Server Client-Server application system and I saw very poor performance.

for example, if I was doing some join from 3 or 4 tables, our data entry staff can not do anything, the front end VB application would just hang. There are 10 users at maximum logging on the system concurrently.

I am not sql server dba but like to improve it, where should I begin to check? detailed steps are appreciated.

Thanks,

Jane

what version of sql server are you using?

If the VB application hangs, how do you know it's SQL Server that's the problem?

|||

Profiler is the first step.
Identify the long running queries and check out their query plan.

poor performance

Hello all,

I recently pick up a SQL-Server Client-Server application system and I saw very poor performance.

for example, if I was doing some join from 3 or 4 tables, our data entry staff can not do anything, the front end VB application would just hang. There are 10 users at maximum logging on the system concurrently.

I am not sql server dba but like to improve it, where should I begin to check? detailed steps are appreciated.

Thanks,

Jane

what version of sql server are you using?

If the VB application hangs, how do you know it's SQL Server that's the problem?

|||

Profiler is the first step.
Identify the long running queries and check out their query plan.

sql

Point-In-Time Restoration Issue

Hello,

I'm testing "Point In Time" restoration for my system using both Database & Log backup files. (Database backup once a day; Log backup every 4 hours)

When I use T-SQL to perfrom the restoration, I can specify one .BAK file with numerous .TRN files and restore to any 'point of time' with no issue.

However, if I use EM to perform the same restoration, I can only specify one .BAK file with a maximum of two .TRN files (although I can see all the .TRN files) in order to restore the database properly. If I specify more .TRN files, after restoration, my DB will be in 'LOADING' status and can't be used.

Does anyone encounter the same problem before and know what is going on?

Thank You.When restoring a database with Enterprise Manager, make sure the 'Leave Database Operational' is checked.|||you can also always switch the database from "Loading" to "operational" modes with simple tsql command

restore database <Dbname> with recovery

simas|||hi guys,

thanks for the replies. I'll look into it.

btw, I did found out some documentation that closely describe my problem, it's "Microsoft Knowledge Base Article - 319697, FIX: SQL Enterprise Manager Restore to Point in Time Does Not Stop at Requested Time and the Database is Left in a Loading State"

Seems like it's not something new...

Thank You.

Pocket PC database connection

Hi,

I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas? Thanks a lot.

Imports System.IO

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports System.Drawing

Imports System

Public Class Form1

Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks"

Dim strQuery As String

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Label1.Text = "Hello, Clicking after."

ReadOrderData()

End Sub

Private Sub ReadOrderData()

Dim queryString As String = "select * from Person.Address where AddressID < '10'"

Using connection As New SqlConnection(strConnection)

Dim command As New SqlCommand(queryString, connection)

connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While

reader.Close()

End Using

End Sub

End Class

Please see this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=184007&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=235638&SiteID=1

If it still does not work after you fixed your 'localhost' issue:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=270532&SiteID=1

Also, we have forum dedicated to SQL Mobile. Please post to it should you have any SQL or SQL Mobile related questions:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1

|||

Thanks for your reply.

I would like to install vxUtil, and I have already read the readme.txt file. But I still have some questions about that. Should vxUtil be installed on my personal PC or the Pocket PC(PPC)? If it should be installed in the PPC, how can I install? In the readme.txt, I get the following information:

Open the appropriate folder on the hard drive then double-click
on the InstallCE icon to start the install process for the correct device.

From this information, I feel that vxUtil should be installed in my personal PC. Is it correct?

Could you please answer me about that?

Thanks a lot.

|||

vxUtil should be ultimately installed on device. However, like pretty much all Pocket PC products, it goes through desktop and Active Sync. You install/unzip application on to desktop, then you (or desktop installer) execute something which would push it to device via AS. As a developer you would have to do the same for your application eventually. In some cases there's no desktop installer, just a device CAB file. In that case simply copy CAB to device and click on it from device's file explorer.

|||

Dear Ilya Tumanov,

Your answer is so great. I have already installed it into the PPC, and it scanned the ports in my desktop PC. From the result, the ports 25, 80, 135, 139, 443, 445, 990 and1025 are all open. But the program that I posted yesterday and listed above can not still work. What do I need in the next step?

Moreover, I have changed the connection string to

Dim strConnection As String = "Server=Server1;Integrated Security=SSPI;database=AdventureWorks"

Thanks a lot.

|||

Hi,

I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied."

I have already installed vxUtil into the PPC, and Ping is OK. I use it to scan the ports in my desktop PC. From the result, the ports 25, 80, 135, 139, 443, 445, 990 and1025 are all open. But the program can not still work.

Any ideas? Thanks a lot.

Imports System.IO

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports System.Drawing

Imports System

Public Class Form1

Dim strConnection As String = "Server=server1;Integrated Security=SSPI;database=AdventureWorks"

Dim strQuery As String

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Label1.Text = "Hello, Clicking after."

ReadOrderData()

End Sub

Private Sub ReadOrderData()

Dim queryString As String = "select * from Person.Address where AddressID < '10'"

Using connection As New SqlConnection(strConnection)

Dim command As New SqlCommand(queryString, connection)

connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While

reader.Close()

End Using

End Sub

End Class

|||

Default SQL Server port is 1433 which is not opened so it's not going to work until your SQL Server is properly configured. Also you have to provide credential in connection string, this string is not going to work.

I'm moving this thread to appropriate forum.

|||

Hi,

Thanks for your answer, and right now 1433 port is open. I would like to use windows authentication protocol. Could you please provide a sample for the connection string? Thanks a lot.

|||

Hi,

Thanks for your answer, and right now 1433 port is open. I would like to use windows authentication protocol. Could you please provide a sample for the connection string? Thanks a lot.

|||

This should work:

"Server=YourServerHere,1433;Initial Catalog=YourDataBaseHere;User ID=YourLoginHere;Password=YourPasswordHere;Integrated Security=SSPI;"

Note you have to provide login and password even though windows authentication will be used. That's because there's no login procedure on devices.

|||

Dear Ilya Tumanov,

Thanks a lot for your so many helps, and it works.

|||

so..It must have a password?is it same with windows user's password?what if blank?

if I'm not wrong, if we set the windows password, we should change the SQL password too right?

|||

you should check this link http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=709129&SiteID=1&mode=1

It works for me after a loooooonggg time testing

Pocket PC database connection

Hi,

I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas? Thanks a lot.

Imports System.IO

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports System.Drawing

Imports System

Public Class Form1

Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks"

Dim strQuery As String

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Label1.Text = "Hello, Clicking after."

ReadOrderData()

End Sub

Private Sub ReadOrderData()

Dim queryString As String = "select * from Person.Address where AddressID < '10'"

Using connection As New SqlConnection(strConnection)

Dim command As New SqlCommand(queryString, connection)

connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While

reader.Close()

End Using

End Sub

End Class

Please see this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=184007&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=235638&SiteID=1

If it still does not work after you fixed your 'localhost' issue:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=270532&SiteID=1

Also, we have forum dedicated to SQL Mobile. Please post to it should you have any SQL or SQL Mobile related questions:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1

|||

Thanks for your reply.

I would like to install vxUtil, and I have already read the readme.txt file. But I still have some questions about that. Should vxUtil be installed on my personal PC or the Pocket PC(PPC)? If it should be installed in the PPC, how can I install? In the readme.txt, I get the following information:

Open the appropriate folder on the hard drive then double-click
on the InstallCE icon to start the install process for the correct device.

From this information, I feel that vxUtil should be installed in my personal PC. Is it correct?

Could you please answer me about that?

Thanks a lot.

|||

vxUtil should be ultimately installed on device. However, like pretty much all Pocket PC products, it goes through desktop and Active Sync. You install/unzip application on to desktop, then you (or desktop installer) execute something which would push it to device via AS. As a developer you would have to do the same for your application eventually. In some cases there's no desktop installer, just a device CAB file. In that case simply copy CAB to device and click on it from device's file explorer.

|||

Dear Ilya Tumanov,

Your answer is so great. I have already installed it into the PPC, and it scanned the ports in my desktop PC. From the result, the ports 25, 80, 135, 139, 443, 445, 990 and1025 are all open. But the program that I posted yesterday and listed above can not still work. What do I need in the next step?

Moreover, I have changed the connection string to

Dim strConnection As String = "Server=Server1;Integrated Security=SSPI;database=AdventureWorks"

Thanks a lot.

|||

Hi,

I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied."

I have already installed vxUtil into the PPC, and Ping is OK. I use it to scan the ports in my desktop PC. From the result, the ports 25, 80, 135, 139, 443, 445, 990 and1025 are all open. But the program can not still work.

Any ideas? Thanks a lot.

Imports System.IO

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports System.Drawing

Imports System

Public Class Form1

Dim strConnection As String = "Server=server1;Integrated Security=SSPI;database=AdventureWorks"

Dim strQuery As String

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Label1.Text = "Hello, Clicking after."

ReadOrderData()

End Sub

Private Sub ReadOrderData()

Dim queryString As String = "select * from Person.Address where AddressID < '10'"

Using connection As New SqlConnection(strConnection)

Dim command As New SqlCommand(queryString, connection)

connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While

reader.Close()

End Using

End Sub

End Class

|||

Default SQL Server port is 1433 which is not opened so it's not going to work until your SQL Server is properly configured. Also you have to provide credential in connection string, this string is not going to work.

I'm moving this thread to appropriate forum.

|||

Hi,

Thanks for your answer, and right now 1433 port is open. I would like to use windows authentication protocol. Could you please provide a sample for the connection string? Thanks a lot.

|||

Hi,

Thanks for your answer, and right now 1433 port is open. I would like to use windows authentication protocol. Could you please provide a sample for the connection string? Thanks a lot.

|||

This should work:

"Server=YourServerHere,1433;Initial Catalog=YourDataBaseHere;User ID=YourLoginHere;Password=YourPasswordHere;Integrated Security=SSPI;"

Note you have to provide login and password even though windows authentication will be used. That's because there's no login procedure on devices.

|||

Dear Ilya Tumanov,

Thanks a lot for your so many helps, and it works.

|||

so..It must have a password?is it same with windows user's password?what if blank?

if I'm not wrong, if we set the windows password, we should change the SQL password too right?

|||

you should check this link http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=709129&SiteID=1&mode=1

It works for me after a loooooonggg time testing

Pocket PC database connection

Hi,

I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas? Thanks a lot.

Imports System.IO

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports System.Drawing

Imports System

Public Class Form1

Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks"

Dim strQuery As String

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Label1.Text = "Hello, Clicking after."

ReadOrderData()

End Sub

Private Sub ReadOrderData()

Dim queryString As String = "select * from Person.Address where AddressID < '10'"

Using connection As New SqlConnection(strConnection)

Dim command As New SqlCommand(queryString, connection)

connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While

reader.Close()

End Using

End Sub

End Class

Please see this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=184007&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=235638&SiteID=1

If it still does not work after you fixed your 'localhost' issue:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=270532&SiteID=1

Also, we have forum dedicated to SQL Mobile. Please post to it should you have any SQL or SQL Mobile related questions:

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1

|||

Thanks for your reply.

I would like to install vxUtil, and I have already read the readme.txt file. But I still have some questions about that. Should vxUtil be installed on my personal PC or the Pocket PC(PPC)? If it should be installed in the PPC, how can I install? In the readme.txt, I get the following information:

Open the appropriate folder on the hard drive then double-click
on the InstallCE icon to start the install process for the correct device.

From this information, I feel that vxUtil should be installed in my personal PC. Is it correct?

Could you please answer me about that?

Thanks a lot.

|||

vxUtil should be ultimately installed on device. However, like pretty much all Pocket PC products, it goes through desktop and Active Sync. You install/unzip application on to desktop, then you (or desktop installer) execute something which would push it to device via AS. As a developer you would have to do the same for your application eventually. In some cases there's no desktop installer, just a device CAB file. In that case simply copy CAB to device and click on it from device's file explorer.

|||

Dear Ilya Tumanov,

Your answer is so great. I have already installed it into the PPC, and it scanned the ports in my desktop PC. From the result, the ports 25, 80, 135, 139, 443, 445, 990 and1025 are all open. But the program that I posted yesterday and listed above can not still work. What do I need in the next step?

Moreover, I have changed the connection string to

Dim strConnection As String = "Server=Server1;Integrated Security=SSPI;database=AdventureWorks"

Thanks a lot.

|||

Hi,

I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied."

I have already installed vxUtil into the PPC, and Ping is OK. I use it to scan the ports in my desktop PC. From the result, the ports 25, 80, 135, 139, 443, 445, 990 and1025 are all open. But the program can not still work.

Any ideas? Thanks a lot.

Imports System.IO

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports System.Drawing

Imports System

Public Class Form1

Dim strConnection As String = "Server=server1;Integrated Security=SSPI;database=AdventureWorks"

Dim strQuery As String

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Label1.Text = "Hello, Clicking after."

ReadOrderData()

End Sub

Private Sub ReadOrderData()

Dim queryString As String = "select * from Person.Address where AddressID < '10'"

Using connection As New SqlConnection(strConnection)

Dim command As New SqlCommand(queryString, connection)

connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While

reader.Close()

End Using

End Sub

End Class

|||

Default SQL Server port is 1433 which is not opened so it's not going to work until your SQL Server is properly configured. Also you have to provide credential in connection string, this string is not going to work.

I'm moving this thread to appropriate forum.

|||

Hi,

Thanks for your answer, and right now 1433 port is open. I would like to use windows authentication protocol. Could you please provide a sample for the connection string? Thanks a lot.

|||

Hi,

Thanks for your answer, and right now 1433 port is open. I would like to use windows authentication protocol. Could you please provide a sample for the connection string? Thanks a lot.

|||

This should work:

"Server=YourServerHere,1433;Initial Catalog=YourDataBaseHere;User ID=YourLoginHere;Password=YourPasswordHere;Integrated Security=SSPI;"

Note you have to provide login and password even though windows authentication will be used. That's because there's no login procedure on devices.

|||

Dear Ilya Tumanov,

Thanks a lot for your so many helps, and it works.

|||

so..It must have a password?is it same with windows user's password?what if blank?

if I'm not wrong, if we set the windows password, we should change the SQL password too right?

|||

you should check this link http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=709129&SiteID=1&mode=1

It works for me after a loooooonggg time testing

sql

Plz help me In reports

Hi,Im Designed a Webpage .It consosts of a Button, whenever i click onButton report must generated.When the report is in my system reportgenerated successfully.when I try to access a report from othersystem.I cudnot able to access report.Can any1 hlp me inthis aspect.any procedure in order to access the report of other system.wht shudbe url for Reportserverurl and reportpath

With regards,

mahender

mahender,

Have you tried

http://server/reportserver/reportdirectory/reportname.rdl

Take note that

- "reportserver"is a virtual directory named during the reporting services install, so your could be something different, the default from memory is reprotserver

- I am assuming you created the directory the report resides in some replace "reportdirectory"with this

- you can pass any parameters thru this method also

- this is url access into reporting services, you can also utlise the web services to access your reports

If this doesnt work check out what type of security the other system uses. What user is your web app connecting as and does this user have access

An error msg would also be helpful

Please post setup and installation questions in the Setup forum

Earlier versions of SQL had an icon in the system tray - which was very useful. I cannot seem to find how you activate this in 2005.

Also you could schedule a job MSDE 2000 to, say, backup a database. I can't find how you do this in SQL Express.

The system tray feature is no longer a component of SQL Server, Express contains no scheduler, please use the windows task scheduler to call sqlcmd instead.|||

While SQL 2005 no longer provides a system tray icon for the previous Server Manager applet, here is a link to a .NET application created as a replacement. (Usual craveats implied...)

SQL Server 2005 Service Manager Alternative
http://www.sqldbatips.com/showarticle.asp?ID=46

Also, SQL 2005 Express does not include the SQL Agent Job Scheduling service. You can verify at this version comparision:

SQL Server 2005 Features, Version Comparison
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

However, you could combine the use of Windows Scheduler and SQLCmd.exe to create a replacement and similar functionality with SQL 2005 Express.

Please help...can not connect to sql server 2005

I used to work on sql server 2005 on hosted on virtual pc 2004 with windows
2000 server as guest operating system on Windows XP professional as host
operating system.
No matter how much ram I threw at it, it was very slow.
I decided to wipe out the notebook and install Windows 2000 with service
pack 4.
Then I installed sql server 2005. Rebooted the machine and I am getting the
following error.
After googling, I went into sql server configuration manager and double
checked that tcp/ip was enabled under sql native client
configurationn/client protocols.
I am the admin on this computer.
I tried to run the sql server surface configuration and I get the following
error:
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
BUTTONS:
OK
--
My Machine configuration is as follows:
==================
mobile intel pentium 4 cpu 2.8 ghz
at/at compatible
2 gig ram
===============
Inside sql server management studio, When I try to connect to sql server I
get the following error message
error message:
TITLE: Connect to Server
--
Cannot connect to mars.
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: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 2)
For help, click:
http://go.microsoft.com/fwlink?Prod...=2&LinkId=20476
BUTTONS:
OK
--BTW... this has to do with November RTM release as follows Version: 9.00.139
9
Executable x86.
Please help and I thank you in advance.
"sqlster" wrote:

> I used to work on sql server 2005 on hosted on virtual pc 2004 with window
s
> 2000 server as guest operating system on Windows XP professional as host
> operating system.
> No matter how much ram I threw at it, it was very slow.
> I decided to wipe out the notebook and install Windows 2000 with service
> pack 4.
> Then I installed sql server 2005. Rebooted the machine and I am getting th
e
> following error.
> After googling, I went into sql server configuration manager and double
> checked that tcp/ip was enabled under sql native client
> configurationn/client protocols.
> I am the admin on this computer.
> I tried to run the sql server surface configuration and I get the followin
g
> error:
> TITLE: Surface Area Configuration
> --
> No SQL Server 2005 components were found on the specified computer. Either
> no components are installed, or you are not an administrator on this
> computer. (SQLSAC)
> --
> BUTTONS:
> OK
> --
>
> My Machine configuration is as follows:
> ==================
> mobile intel pentium 4 cpu 2.8 ghz
> at/at compatible
> 2 gig ram
> ===============
> Inside sql server management studio, When I try to connect to sql server I
> get the following error message
> error message:
> TITLE: Connect to Server
> --
> Cannot connect to mars.
> --
> 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: Named Pipes Provider, error: 40 - Could not open a connection
to
> SQL Server) (Microsoft SQL Server, Error: 2)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...=2&LinkId=20476
> --
> BUTTONS:
> OK
> --
>|||I forgot to mention that this is a Microsoft SQL Server 2005 Enterprise
Evaluation Edition
Please help...
"sqlster" wrote:
> BTW... this has to do with November RTM release as follows Version: 9.00.1
399
> Executable x86.
> Please help and I thank you in advance.
>
> "sqlster" wrote:
>|||sqlster (nospam@.nospam.com) writes:
> After googling, I went into sql server configuration manager and double
> checked that tcp/ip was enabled under sql native client
> configurationn/client protocols.
> I am the admin on this computer.
> I tried to run the sql server surface configuration and I get the
> following error:
> TITLE: Surface Area Configuration
> --
> No SQL Server 2005 components were found on the specified computer. Either
> no components are installed, or you are not an administrator on this
> computer. (SQLSAC)
So, you can see the service in SQL Configuration Manager, but not
in Surface Area Configuration?
Very strange, and I have no idea of how this situation may have occurred.

> Inside sql server management studio, When I try to connect to sql server I
> get the following error message
Are you running Mgmt Studio from the same machine SQL Server 2005 is on,
or from a remote machine?
The only thing that I can suggest is to verify that SQL Server is actually
running. If it is, restart the service, so that any protocol changes takes
effect.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Please help, urgent...Some question for SQL compact edition.

My client has a system and a IBM db to store the data. I try to build sub-system window mobile application for data entery. But my client do not want to install active sync.

So our team figure a way out of this case. We create a web program to get data from IBM db, then create a .sdf file for the PDA. In the PDA, we install a software to make it become USB mass storage. The web program will copy the sdf file to PDA.

I want to know, is this a possible solution? If so, how to creat that web program to get those data and create .sdf file?

Use middleware from IBM to get the data from the IBM DB, and the SqlCeClient objects to create and populate the SDF file. You can do this with asp.net. You must also create a desktop program to download the sdf file from the web server and copy to the USB mass strorage.
What are your requirements for submitting data the other way - it will be difficult without network connectivity from the device ?|||I want to use the middleware to do the same thing which allow to get data and submitting data. Is that possible?...

Please Help!...Hanging DBREINDEX Job

I have a scheduled job on my SQL Server 2000 that runs a DBREINDEX job on all the tables in my database. For some reason the system just hangs for hours now when it reaches one particular table. Can somebody please help me to correct the problem. Thank you all in advance.how do you know it is hanging. How large is the table and how big are the indices on the table? Sometimes this can take a long time on big tables.

you may consider putting your database in bulk-logged recovery or changing your approach.

on large databases it is often impractical and not necessary to expect to reindex the whole database at once. a more refined approach is to check for the fragmentation of the indexes and to reindex the individual tables when only necessary, say when fragmentation reaches 10 to 15% (DBCC SHOWCONTIG in SQL2K).

you may also want to change your approach by using drop and create index on the clustered index on the table because if you drop and recreate the clustered the nonclustered ones are automatically recreated.

and I forget whether the tempDB has any roll in this operation but you may want to monitor it's growth and make sure it is not auto growing and that it has enough room during this operation.

this may be my most substantial post in months.|||I've had this happen occasionally if my script is trying to reindex a system table (which may be used in the reindexing process...), or it tries to reindex a table where I was storing output or results of the reindexing job itself.
Strangely, the issue only occurred occasionally.