.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Check if my sql server is not functioning properly

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server
 

hello,

how can i know how my sql server is performing and how to know if it is freezing or is not functioning properly

thxs in advance




View Complete Post


More Related Resource Links

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.

  

I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?


How can i check if record already exist in sql-server database ...

  
How can i check if record already exist in sql-server database ...

How to check effective permissions for a user or group for a SQL server object or whole server?

  
Guys, How do I see effective permissions for a user or group for a SQL server object or whole server? For example, a user is not listed in security/logins, but he is a member of few groups and some of them have assigned permissions on SQL server (again either directly or through membership in other groups) Even when I select an object (a table), check properties/permission – it doesn’t let me select any principal, except those listed on security/logins… Anyway, what is the right way to see effective permissions for a user or group? Sorry for asking such a simple question, I’ve searched but found nothing relevant.

Check In / Check Out not working properly

  
At various points during the day, I check back in the master and CSS files I've been working on.  However, it doesn't show them as checked in ... they are still flagged with green check in SP Designer.   And what is more confusing, sometimes I can't save anything because it says that it is checked out.  But I'm the one who checked it out.  And it thinks it is checked in.  So I try to check it out again, and it won't let me check it out. The only way I got around this yesterday was to rename the master file.  Then rename it back to it's original name. Suggestions?

why is SQL server 2008 not installing properly?

  
I am installing SQL server 2008 for the first time and I am having difficulies with the Server Setup... I have installed SQL server 2008 on another PC and it works perfect... Why? [Error Message]The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service. [Details]Microsoft.SqlServer.Configuration.Agent.InputValidationException: The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service.================================================================================  

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential cau

  
Attempting to upgrade from SQL 2005 EE to SQL 2008 EE on Vmware ESX 3.5 virtual server. below is info from Detail.txt related to successful install with failures... 2010-09-02 13:50:46 Slp: Sco: Attempting to check if file 'D:\Data\MSSQL.1\MSSQL\LOG\ERRORLOG' exists 2010-09-02 13:50:46 Slp: Sco: Returning security descriptor O:BAG:SYD:AI(A;ID;FA;;;S-1-5-21-3788118842-658835432-3441893140-1006)(A;ID;FA;;;S-1-5-21-3788118842-658835432-3441893140-1007)(A;ID;FA;;;BA)(A;ID;FA;;;SY)S:AI(AU;IDFA;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;WD) 2010-09-02 13:50:46 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC. 2010-09-02 13:50:46 Slp: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. 2010-09-02 13:50:46 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC. 2010-09-02 13:50:46 Slp: Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes. 2010-09-02 13:50:46 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceBase.WaitSqlServerStart(Process processSql) 2010-09-02 13:50:46 Slp:    at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StartSqlServer(St

Maintenance Cleanup task not functioning properly???

  
Using SQL Server 2005 Management Studio and backing up databases. When I add the task Maintenance Cleanup to remove database backups older then 1 day the task fails???What part of this TSQL code does SQL Server 2005 Management Studio not understand?EXECUTE master.dbo.xp_delete_file 0,N'\\pdxsql03\SQL Backup\POSSQL_Server',N'.bak',N'05/15/2006 08:09:37'The database file backup extension is .bak and the file is older than one day which was specified.It is just not deleting the file.We have deleted the maintenance task and recreated it with no effect and this has been happening for over a month.Any help here would be greatly appreciated.Carlcarlt@gicw.org

Error Message: The attempt to connect to the report server failed. Check your connection informatio

  
I have a web page that contains a ReportViewer control.  I am trying to display a report, which is an .rdl file located on the SSRS server, in this ReportViewer control.  I have set the ReportPath and ReportServerUrl correctly.  I am getting an error message. Am I suppose to use an .rdlc file rather than a .rdl file?  Does the web server configuration need to use a certain account?  I am getting the following error message: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. The request failed with HTTP status 404: Not Found.

How To Check SQL SERVER Uptime Through T-SQL

  
logon to SQL Server management studio and connect to the master database instance   The after that you run this script against the master database instance only...   Highlighted Below:   SQLScript: SET NOCOUNT ONDECLARE @crdate DATETIME, @hr VARCHAR(50), @min VARCHAR(5)SELECT @crdate=crdate FROM sysdatabases WHERE NAME='tempdb'SELECT @hr=(DATEDIFF ( mi, @crdate,GETDATE()))/60IF ((DATEDIFF ( mi, @crdate,GETDATE()))/60)=0SELECT @min=(DATEDIFF ( mi, @crdate,GETDATE()))ELSESELECT @min=(DATEDIFF ( mi, @crdate,GETDATE()))-((DATEDIFF( mi, @crdate,GETDATE()))/60)*60PRINT 'SQL Server "' + CONVERT(VARCHAR(20),SERVERPROPERTY('SERVERNAME'))+'" is Online for the past '+@hr+' hours & '+@min+' minutes'IF NOT EXISTS (SELECT 1 FROM master.dbo.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher')BEGINPRINT 'SQL Server is running but SQL Server Agent <<NOT>> running'ENDELSE BEGINPRINT 'SQL Server and SQL Server Agent both are running'END

SQL Server 2008 R2 Setup fails to install properly

  

Hello, I am not able to install 2008 R2 on my laptop. I have 2005 and 2008 installed previously. It says in one of the attached screenshots that the OLAP service cannot be started. I have attached the errors in screenshots and also my summary log, please advise thank you.

Edit: I am able to manually startup the SQL 2008 R2 service, and can login as "sa" without a password... but strangely I did select mix mode authentication and did supply a password during the installation wizard too..

 

Overall summary:
  Final result:                  SQL Server installation failed. To continue, investigate the

reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server

Setup.
  Exit code (Decimal):           -733426222
  Exit facility code:         &nbs

How to uninstall properly SQL Server 2008 ?

  

Hello !

I want to uninstall properly SQL Server 2008 with a command line

Is there a good documentation on how to uninstall it without forget things (before / after) ?

There are a lot of remaining folder, components, registry key .....


Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2

SQL Server 2005 - Check if Trace Flag is enabled?

  

Hi all,

never encountered trace flags before, but due to a problem in one of our applications I was asked if we activated a hotfix by enabling two trace flags.

Is there a possibility to check, if the trace flags are enabled?

I don't have the permission to execute anything on our SQL Server so I cannot run the DBCC TRACEON command.

Other question: by enabling a trace flag is there any risk to it? We have a productive environment and at the end of the month there are lots of reports running, so I don't want to do any changes to the system that might cause a problem.

Thanks for your suggestions

Gáski


connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly

  

hello,

i've installed SQL server 2005 express and Visual web developper 2005 express.

when i whant to create a database in VWD the following error occures:

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=49251

i searched the internet but can't find the solution, i already reinstalled my complete workstation but the problem stays.

please help!


How to check for file exists on remote server in ssrs 2008?

  
I have a report that needs to display images that are stored on a remote web server. The problem is that I also need to check if the file exists first otherwise I get those annoying image not found red X's.

I tried entering the code at the bottom in the custom code section of the report which works if I run it on my local machine however it doesn't work in SSRS 2008. After doing a little trial and error I found it seems to be failing on the first line in the function,

Dim request = System.Net.WebRequest.Create(New Uri (fileURL))

Is there some specific permissions or configuration change needed on the SSRS2008 server for this code to work? Or is there a better way to do this?

Thanks,
Robert


Public Function CheckRemoteURL(ByVal fileURL As String) As String
Dim request = System.Net.WebRequest.Create(New Uri (fileURL))
request.Method = "HEAD"

Dim returnURL = ""

Try
Dim response = request.GetResponse()
returnURL = fileURL
Catch ex As Exception
returnURL =""
End Try

Return returnURL
End Function

Romanian Texts( a a A  âÎ îS s T t) are not stored properly in SQl Server database

  
Hi,
In my application im using romanian language texts also. but these romanian text(a a A   âÎ îS s T t) are not stored properly in the SQL database.
Im using the data type for that field as nvarchar and the collation as SQL_Latin1_General_CP1_CI_AS.

Can anyone help me to resolve this issue.

Thanks,
Mohan

CHeck to see if file exists on Server before backup

  

Hello,

  I want to check first to see ifthe xyz.bak file exsits before I perform a backup.

 

Thanks


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend