We can use sp_depends, sp_depends displays information about database object dependencies, such as the views and procedures that depend on a table or view, and the tables and views that are depended on by the view or procedure
But some times sp_depends does not always return accurate results.
Here is how you can get accurate results by using this query’s below
SELECT DISTINCT o.name, o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%TableName%'
Now open your query window and write you query and execute. On the results window right click and select "save results as" and then save to CSV file which I can open in excel. Some times you might want to know what are the triggers available across your database. Here is how you can know by using the below query.
-- Displays all Triggers in a Database
SELECT
[Table] = OBJECT_NAME(o.parent_obj),
[Trigger] = o.[name],
[Type] = CASE WHEN
(
SELECT cmptlevel
FROM master.dbo.sysdatabases
WHERE [name] = DB_NAME()
) = 80 THEN
CASE WHEN
OBJECTPROPERTY(o.[id],
'ExecIsInsteadOfTrigger') = 1 THEN
'Instead Of'
ELSE
'After'
END
ELSE
'After'
END,
[Insert] = CASE WHEN
OBJECTPROPERTY(o.[id],
'ExecIsInsertTrigger') = 1 THEN
'Yes'
ELSE
'No'
END,
[Update] = CASE WHEN
OBJECTPROPERTY(o.[id],
'ExecIsUpdateTrigger') = 1 THEN
'Yes'
ELSE
'No'
END,
[Delete] = CASE WHEN
OBJECTPROPERTY(o.[id],
'ExecIsDeleteTrigger') = 1 THEN
'Yes'
ELSE
'No'
END,
[Enabled?] = CASE WHEN
OBJECTPROPERTY(o.[id],
'ExecIsTriggerDisabled') = 0 THEN
'Enabled'
ELSE
'Disabled'
END
FROM sysobjects o
WHERE OBJECTPROPERTY(o.[id], 'IsTrigger') = 1
-- Comment out the following clause if you need to
-- include system triggers, e.g. those in MSDB
AND OBJECTPROPERTY(o.[id], 'IsMSShipped') = 0
ORDER BY 1,2
It is believed that lord Krishna possesses 64 kinds of arts called "Chausath Kalas". Kala means performing an art. Here are the list of 64 అర్ట్స్
Disclaimer : The above details are sent on behalf of IRCTC to their customers. I have coped the same email in this blog to make it available for all the public whom it might be useful for quick reference.
Here is sample code snippet that I have used to get username from the email address. You can use MailAddress Class to get few built in properties for our use.
1: string FromEmail = ConfigurationManager.AppSettings["NotifyEmail"].ToString();
2: MailAddress FromAddress = new MailAddress(FromEmail);
3: objEmail.From = FromAddress; 4: 5: NetworkCredential NetworkCredential = new NetworkCredential(FromAddress.Address, "XXXXXXX");
6: smtpclient.Credentials = NetworkCredential; 7: 8: // Alternately you want you can try few different properties from MailAddress class.
9: 10: Debug.WriteLine("DisplayName: " + FromAddress.DisplayName);
11: Debug.WriteLine("Host: " + FromAddress.Host);
This worked for my scenario. Happy coding.
Many of us tend to forget our own mother tongue with growing globalization or with the dominance of English being more used as communication medium. Here is what I thought should be useful for at least people like me to remember our own alphabets during the course of time.
I have captured from one of Facebook page where I thought sharing would help few of us
Here are the Telugu alphabets
PS: I have copied this for the sake of my own repository. No offence or what so ever.
Microsoft has announced its most awaited version of SQL SERVER 2014 for Community Preview. The availability of the first public Community Technology Preview (CTP) of SQL Server 2014.
Here are key features of SQL Server 2014:
You can find more information from Microsoft blog here.
Are you working on SQL Server 2005 or 2008 servers. Here is SQL Server 2012 Express version for download
Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications.
