SELECT COUNT(COLUMN_NAME)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = 'DbName' AND TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = 'TableName'
Robert Dannelly blog, Over the internet you can find me by "robert dannelly blog". The blog is an ongoing blog of my software engineering over technologies C#, VB.NET, Java, React, JavaScript, .NET Core Current, SQL Server 7 - Current Version, GIT, GitHub, Jira, Azure, AWS and HTML5. “I have not failed. I've just found 10,000 ways that won't work.” Thomas A. Edison, please click on all links to help support this blog. Thank you. “As an Amazon Associate, I earn from qualifying purchases.”
Thursday, February 23, 2017
Thursday, February 16, 2017
IIS App Pool Recycle Logs
If you need to view information about application pool recycle set a custom view in Windows Event Viewer.
1. Start Search Event Viewer
2. Select Custom Views > Actions: Create Custom View
3. Logged what ever time you need
4. Select all event levels
5. By Source (WAS) Very Important
Click OK.
1. Start Search Event Viewer
2. Select Custom Views > Actions: Create Custom View
3. Logged what ever time you need
4. Select all event levels
5. By Source (WAS) Very Important
Click OK.
Thursday, February 02, 2017
SQL Tips
http://sqlhints.com/2012/05/03/how-to-set-default-database-in-sql-server-mangement-studio-a-time-saving-tip/
Great new site I found above.
Captain SQL Jason also taught this old dawg some new tricks. He told me I am not allowed to share them. They help us Veterans in the field keep our jobs. :)
Great new site I found above.
Captain SQL Jason also taught this old dawg some new tricks. He told me I am not allowed to share them. They help us Veterans in the field keep our jobs. :)
Subscribe to:
Posts (Atom)