Skip to main content

ZMira

Search This Blog

How to know any table/function is used any query

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

select * from sys.sql_modules where definition like '%tablename/funName%'

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

Post a Comment

Popular Posts

The database owner SID recorded in the master database differs from the database owner SID recorded in database 'AdventureWorks2008R2'. You should correct this situation by resetting the owner of database 'AdventureWorks2008R2' using the ALTER AUTHORIZATION statement.

--To get owner SID recorded in the master database for the current database SELECT owner_sid FROM sys.databases WHERE database_id=DB_ID() --To get the owner SID recorded for the current database owner SELECT sid FROM sys.database_principals WHERE name=N'dbo' They should return you same SID values in the format of a GUID. Now if the two SID's differ which they did in my case it means that you need to reset the database owner so that both values are the same. To do this you can run another ALTER statement and pass in the owner value you want to use e.g use AdventureWorks2008R2 ALTER AUTHORIZATION ON Database::AdventureWorks2008R2 TO sa or DECLARE @Command VARCHAR(MAX) = 'ALTER AUTHORIZATION ON DATABASE::<<DatabaseName>> TO [<<LoginName>>]' SELECT @Command = REPLACE(REPLACE(@Command,'<<DatabaseName>>',SD.Name), '<<LoginName>>', SL.Name) FROM master..sysdatabases SD JOIN master..syslogins SL ON SD.SID = SL

Context Has Changed Since the Database Was Created

This article describes and provides the solutions of a common error in Entity Framework: " Context has changed since the database was created, Model backing a DB Context has changed, Model backing the context has changed since the database was created. " This is the most frequent error in Entity Framework. This type of error occurred when the model and the database cannot be mapped correctly. That means there is a modification or changed in the database. We made any type of schema change on the table or database after including Entity Data Model in the project or solutions. To solve this error write the following code in Application_Start() Method in Global.asax.cs file. Database.SetInitializer<CustomerDBContext>(null); That means we need to bind our DB context class with a null value. If the database schema is changed, it is mandatory to updates the .edmx file.

CONVERT IP ADDRESS INTO URL IN C#

To convert an IP (Internet protocol) address into corresponding Url (Uniform Resource Locator) in C#, ASP.NET you need a help of IPHostEntry and IPAddress class. Make an object of this call and call the Dns.GetHostEntry() class to find the HostName against the Url. IPAddress addr = IPAddress.Parse("195.175.254.2"); IPHostEntry entry = Dns.GetHostEntry(addr); Response.Write(entry.HostName.ToString()); entry.HostName.ToString() will return the host name of the IP address.

Powered by Blogger