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


Post New Web Links

dateformat on server level

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

Hi, 

 

  I want to change the dateformat on the sql server , I tired the following way but no luck SP_HELPLANGUAGE;SP_DEFAULTLANGUAGE @loginame = 'LoginName', @LANGUAGE = 'Language' ... even after restarting the server , it did not work? can anybody help.

Thanks,




View Complete Post


More Related Resource Links

What is the default isolation level (SQL Server 2008)

  
Hi, My database settings are: SET ALLOW_SNAPSHOT_ISOLATION ON READ_COMMITTED_SNAPSHOT ON Does this mean I don't have to explicitly have: Set Transaction Isolation Level Read Committed for each proc, i.e. because I have the two settings at the database level there is no need set the Transaction Isolation Level in each proc or does this need to be done as well as the database level settings. Cheer, Peter  

Msg 8624, Level 16, State 13 - Internal SQL Server error.

  
Hi, I have a weird T-SQL 80 query full of nested subqueries full of aggregations tha thas been embedded in a view. if I do select * from the view I get: Server: Msg 8624, Level 16, State 13 Internal SQL Error.  If I run the same block of code from the query analyzer it runs fine. Also if I wrap exactly the same code in a SP it runs fine. I'm running this on a SQL Server 2000 Standard Edition SP4 8.00.2282. + I turned on the following Trace Flags: 3614, 9052, 9054, 9056, 9057, 9185, 9256. If I restore the same DB on a SQL Server 2005 and do the same select * it runs fine. So I'm getting the Error 8624 only on my SQL 2000 Standard edition  SP4 8.00.2282. Another thing I dont understand is also: why I can compile the view but if I try to visualize even the query plan I get the same error?!? Any suggestion will be appreciated. Thank you. Regards, Marco    

Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not e

  
Hi All, When we try to connect to a sql server 2000 using SQL server authentication, we are facing the below mentioned error msg. "Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied" But, once we connect to server using Windows NT login from the client machine, i.e., execute the below command in the run prompt and provide the credentials for windows login, we are able to connect to the server using sql server authentication(user name: sa) \\server_ipaddress\c$ When we went though some of the msdn links, found that windows firewall was the major cause. But, in the server 1. Windows Firewall is turned off 2. TCP/IP and NamedPipes are enabled 3. Default Port Number is 1433 Any user, who wants to connect to the SQL Server using SSMS, first have to perform a Windows NT login and then connect using SQL authentication.  Due to the above error, the DTS packages which are executing in a different server are getting failed. NOTE: Even after connecting to the server using Remote Desktop connection in a local machine, SQL authentication fails. Its manadatory to run the command \\server_ipaddress\c$ in each of the local machine. Any suggestion to resolve the above error is very much appreciated.   Thanks in advance, Raksha Hegde       

SQL Server + .Net | Transaction | Can Transaction level be esclated

  
Hi We are facing a unique problem which ends up causing deadlocks. We have found that We have a very heavy load OLTP Sql server 2008. In .net code we set the Transaction isolation level to Read commited while executing a SP. We find deadlocks and in the dead lock details it is explictly called out that the SP in question was executing in transaction level serializable. Lets call this SP1 The only other thing we can say is that there are some other unrelated stored procedures which access the same tables as SP1 and are executing in isolation level serializable. Is it possible for one SP to escalate isolation level like locks are escalated? We found the following links which hint this, by saying that isolation level is just a hint. http://msdn.microsoft.com/en-us/library/ms229978(v=VS.90).aspx http://technet.microsoft.com/en-us/magazine/2008.04.blocking.aspx?pr=blog http://msdn.microsoft.com/en-us/library/ms189857.aspx http://aartemiou.blogspot.com/2009/01/table-level-locking-hints-in-sql-server.html Any help in this regard will be great.

SQL Server Force Parameter at the database level?

  
If you do opt for force parameter at the database level, as I read SQL Server rebuilds plan cache but my questions is does that mean it rebuilds data cache also? Any things to watch out and your experiences dealing with force parameter at the db level..

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider

  

Hi all,

I use Asp.Net 2.0 and SQL server 2000 and I get the above error in my site.I went through the other posts and reply.It is said to clear the connection pools.So i need a clear view what that will do.When should i actually clear it.Will Clearing the pools introduce any other problem or is there any othere solution for this. Please help me in solving this.

Thanks,

Joseph


ADO NET A transport-level error has occurred when sending the request to the server. (provider: TCP

  

When i fill my sql adapter      daAuthors.Fill(dsPubs, "MyTable")

sometime i get

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) 

What can couse the trouble thanks


Will full or differential backup break LSN chain if compatibility level = 80 in SQL Server 2005/2008

  
My understanding is that full or differential backup will not break LSN chain starting in SQL Server 2005.  However, I'm not sure whether this applies to databases with compatibility level 80 in SQL Server 2005/2008 or not.

A transport-level error has occurred when receiving results from the server.(provider:TCP Provider,e

  

Hi,

I am using SQL Server 2005,

while trying to retrieve data from the database; I am getting the following error:

 A transport-level error has occurred when receiving results from the server. (Provider: TCP Provider, error: 0 - The handle is invalid.)

 But I am getting this error randomly.

 Can some one help me out?
 Waiting for your response

 Sudhakar


Row level access control in sql server

  

Hi All,

I'm looking for some opinions on implementing row level access control to a SQL Server confidential data table.

Only certain rows can be accessed (select, update, delete....) by certain users.  

I've searched around and so far what I have found points to the following scheme:

- define users, groups of users, roles with actions, and row membership categories, in an access control table

- add a membership category column to the confidential data table, and populate it with content that specifies what access control membership category it belongs to

- allow users to use stored procedures (probably via a web front end) to access the data they are entitled to, using a view with a where clause.  The where clause would check the user id against the access control table to see what row membership categories that user was entitled to access, and use this to restrict the rows being returned.

So to summarise the requirement, there are many rows in the table.  There are many users.  Some users can access all rows.  Some users can only access rows that fall into a particular category.  The category is stored with each row.  

Any comments appreciated....

 

Regards,

Dave.

 


what is compatibility level in sql server

  
compatibility levels in sql server is used to enforce the sql server engine to work as a different version. we can also make the sql server 2008 to behave like a sql server 2005 using compatibility level. you can learn more about compatibility level of sql server in detail

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.
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