- SQL Server
- SQL Azure
- SQLCMD
- SQL Server CE
- Adding Dates
- Create Database
- Creating and Using a Number Table
- Database Mail
- Linked Server
- SQL Server - Aggrigration of strings using TSQL
- SQL Server - IDENTITY
- SQL Server - MERGE Example
- SQL Server - Reading information from an XML document using OPENXML
- SQL Server - Resource governor
- SQL Server - User Defined Table Types
- SQL Server - Using Row Constructors
- SQL Server - Using the PIVOT operator
- SQL Server - Using the UNPIVOT Operator
- SQL Server - statistics
- SQL Server Backup
- SQL Server Common Table Expressions (CTEs)
- SQL Server DATE calculations
- SQL Server Mirroring
- SQL Server OPENDATASOURCE
- SQL Server OPENROWSET
- SQL Server Service Broker
- SQL Server Sparse Columns and Column Sets
- SQL Server Window Functions
- SQL Server XML Data Type Operations
- SQL Server XML Schema Collections
- Truncate TRN Log in SQL Server 2005/2000
SQL Server Service Broker
Enabling Service broker on AdventureWorks Database
ALTER DATABASE AdventureWorks SET ENABLE_BROKER WITH ROLLBACK IMMEDIATEDisabling Service broker on AdventureWorks Database
ALTER DATABASE AdventureWorks SET DISABLE_BROKER WITH ROLLBACK IMMEDIATE
Cant find the page you are looking for?
Help us to improve by adding the content that you are looking for.
Leave a feedback
We look forward to hear your comments and feedback.
Help us to improve by adding the content that you are looking for.
Leave a feedback
We look forward to hear your comments and feedback.
- 4227 reads
Syndicate
Popular content
Today's:
- Search for a cheat sheet
- Cant find what you are looking for?
- Retrieve User Preferences for Keyboard Settings
- SQL Server OPENDATASOURCE
- SQL Server - User Defined Table Types
- SQL Server Database Mirroring - Establishing a Database Mirroring Session
- Vb.NET - IsDate() to check for valid date input validation
- VB.NET - Working with Console Applications
- JavaScript - Input validation check for integer and float values
- VB.NET - Search a Directory for Files Recursively
- SQL Server OPENROWSET
- Working with GridView - Changing cell/row/text color based on condition
- VB.NET - Dynamic Exceptions Handling with the Message Box
- ASP.NET
- ASP.NET - Prevent webform from script injection attacks
- CS.NET - Convert an ArrayList to a DataTable
- Send email in VB.NET using SMTP client
- VB.NET - Convert multi dimentional ArrayList to DataTable
- WPF - Storing Connection String in App.xaml and Retrieving in Code
- ASP.NET - Download file to client browser
- Transform XML into HTML using XSLT in C#.NET
- SQL Server
- C#.NET - Read comma separated values from app.config
- VB.NET - Working with DateAdd()
- Implementing MemCache in ASP.NET
- VB.NET - LINQ query to get list of files and bind to DataGridView
- Working with PING in VB.NET
- Database Mail
- SQL Server - Reading information from a CSV file using OPENROWSET
- SQL Server Database Mirroring - Creating and using Mirror Endpoints in Principal, Mirror and Witness Servers
All time:
About the author
