SQL Server: a Maintenance Plan from a renamed server

Bosko — Tue, 24 Jun 2008 12:49:00 GMT

Abstract:

This solution was given by JanetB in the following forum: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98114

1. Select the ID with the select statement
select * from sysmaintplan_plans

2. Replace with the selected ID and run the delete statements
delete from sysmaintplan_log where plan_id = ''

delete from sysmaintplan_subplans where plan_id = ''

delete from sysmaintplan_plans where id = ''

3. Delete the SQL Server Jobs with the Management Studio

SQL Server: Parse a Delimited String Into a Temp Table

Bosko — Mon, 08 Oct 2007 13:05:00 GMT

Abstract:

You can use the information below to quickly parse out a delimited string through T-SQL into a temp table.

This informaton was modeled after a solution you will find if you follow the link in the

External Links section of this article.

You can use the information below to quickly parse out a delimited string through T-SQL.

To make the resulting data useful, you may want to put it in a temp table instead of printing it

to the Messages pane, but this will at least get you started.

EXEC sp_configure 'show advanced options' , 1

RECONFIGURE

EXEC sp_configure 'Agent XPs',1

RECONFIGURE

JavaScript: Check if a user is leaving a page or closing the browser

Bosko — Wed, 27 Jun 2007 22:06:00 GMT

Abstract:

<!--

The code below (placed in the <HEAD> tag) will execute when the user

attempts to leave the page that they are on. The code will execute when:

- Clicking a link

- Clicking the back button

- Clicking the forward button

- Closing the browser

JavaScript: Prevent entry

Bosko — Wed, 27 Jun 2007 19:34:00 GMT

Abstract:

// JavaScript Function
function PreventEntry()
{
// Dispose the key
window.event.returnValue = null;
}

// HTML Code
<input type="text" name="[ControlName]" onkeypress="PreventEntry()" />

C#: Get the date of the beginning of the week

Bosko — Fri, 08 Jun 2007 14:59:00 GMT

Abstract:

//Populate dtSpecifiedDate with the date for which you are trying to find the beginning of week for

DateTime dtSpecifiedDate = DateTime.Now;

//Get the day of the week of the specified date,

//cast it as an integer (giving you a 0-based value starting with Sunday)

//and subtract it from the specified date
DateTime dtBeginningOfWeek = dtSpecifiedDate.AddD

C#: Check to see if the user is browsing from a mobile device

Bosko — Mon, 04 Jun 2007 16:40:00 GMT

Abstract:

//The following line of code will return a boolean value letting you know if the user is browsing with a mobile device (true) or not (false)

Request.Browser.IsMobileDevice

C#: Use cookies for login authentication

Bosko — Sat, 26 May 2007 07:29:00 GMT

Abstract:

This example describes the usage of cookies for login authentication. The code below is broken up in the HTML markup and CodeBehind so you can easily copy and paste the information to give you a head-start in working with cookies.

====================HTML====================

<table>

<tr>

&nbs

C#: Implement a conditional operator

Bosko — Fri, 25 May 2007 18:31:00 GMT

Abstract:

int x = 1;

int y = 2;

//The format of the conditional operator is:

// condition ? value to return if condition is true : value to return if the condition is false

string ConditionalOperatorResult = x == y ? "Yes" : "No";

protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e) {
// Get the number of records that were bound to the SqlDataSource
this.lblRecordsFound.Text = "(" + e.AffectedRows.ToString() + " records returned)";
}

C#: Evoke a javascript ''Confirm'' dialog box from a GridView button

Dale — Tue, 15 May 2007 11:30:00 GMT

Abstract:

Objective: To pop-up a javascript Confirm box when the user clicks a LinkButton in a GridView control.

// The following javascript must be added to the aspx (html) page. It can be placed just above the
// opening “<body>” tag:
<script type="text/javascript">
function confirm_delete(){

if (confirm("Are you sure you want to delete this rule?")==true)

return true;

else

TFS: Delete a Team System workspace from the command line

Bosko — Tue, 08 May 2007 19:43:00 GMT

Abstract:

In order to delete a Team System workspace from a command line you can use the following process from a Team System client machine.

The executable is located in C:\Program Files\Microsoft Visual Studio 8\Common7\IDE

From the command line (once you are in the directory above) you would execute the following:

tf workspace /delete WorkspaceName;WorkspaceOwner

Note: You will need to be connected to the Team Foundation Server before executing the command

TFS: View all workspaces, owners and computers

Bosko — Tue, 08 May 2007 19:41:00 GMT

Abstract:

In order to view all Team System workspaces, owners and computers you can utilize a command line utility from a Team System client machine.

The executable is located in C:\Program Files\Microsoft Visual Studio 8\Common7\IDE

From the command line (once you are in the directory above) you would execute the following:

tf workspaces /s:http://ServerName:8080 /owner:* /computer:*"

Note: You will need to be connected to the Team Foundation Server before executing the command

C#: Working with a CheckBoxList

Dale — Mon, 07 May 2007 12:52:00 GMT

Abstract:

// How to populate a CheckBoxList from a DataTable

private void PopulateCheckboxList(CheckBoxList chkList) {

ProdConfigSupport pcs = new ProdConfigSupport();

DataTable dt = pcs.GetProductList();

if (dt !=

C#: Free up Crystal Report resources

Dale — Wed, 02 May 2007 12:50:00 GMT

Abstract:

When using the Crystal reports report generator, it is important to dispose of the ReportDocument object in order to avoid the following error message when running multiple reports:

System.Runtime.Interop.Services.COMException (0x80041016): The maximum report processing jobs limit configured by your system administrator has been reached
at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open .....

The ReportDocument should be closed and disposed in the forms Page_Unload () method as follows:

// Declare an instance of the ReportDocument at the form level
CrystalDecisions.CrystalReports.Engine.ReportDocument oRpt = null;

protected void Page_Unload(object sender, EventArgs e)

{

try

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE

From the command line (once you are in the directory above) you would execute the following:

TFSDeleteProject /server:ServerName ProjectName

Additional Information

You will need to be connected to the Team Foundation Server before executing the command
You will have to enclose the Project Name in quotes if it contains spaces
You will have to enclose the Server Name in quotes if it contains spaces

C#: Pop-up JavaScript window from code-behind

Bosko — Tue, 24 Apr 2007 20:07:00 GMT

Abstract:

string s = "<" + "script language='javascript'>window.open('NewMessageNotification.htm','CustomPopUP','width=200,height=150,menubar=yes,resizable=yes,toolbars=yes')<" + "/script>"; ClientScript.RegisterStartupScript(GetType(), "focus", s);

SQL Server: Check version, service pack level and type of the instance

Bosko — Tue, 24 Apr 2007 10:52:00 GMT

Abstract:

SELECT
SERVERPROPERTY('productversion') AS Version,
SERVERPROPERTY ('productlevel') AS ServicePack,
SERVERPROPERTY ('edition') AS Edition

C#: Stream a file back to the browser

Bosko — Fri, 20 Apr 2007 22:46:00 GMT

Abstract:

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.IO;

using System.Text;

C#: Open a page in a NEW Browser window from code-behind

Bosko — Fri, 20 Apr 2007 22:44:00 GMT

Abstract:

// Here's how to send the user to another page,

// and have that page open up in a new browser window

String sTargetURL = "MyNewPage.aspx";

//Note: the word "script" must be broken up, because the compiler/process

// will otherwise try to evaluate it

C#: Using javascript Alert and Confirm dialog boxes from code-behind

Bosko — Fri, 20 Apr 2007 22:43:00 GMT

Abstract:

// The following code is usually placed in the Form_Load() event handler

// so that it is executed when the form first loads.

// We are adding an "onclick" attribute to a server button, and assigning

// javascript code to be executed when the user clicks the button.

// Presents a warming message with just an "OK" button. After the button is clicked, no furthe

SQL Server: Change the owner of an object

Bosko — Fri, 20 Apr 2007 15:05:00 GMT

Abstract:

exec sp_changeobjectowner 'CurrentObjectOwner.ObjectName', 'NewObjectOwner'

HTML: Implement META tags

Bosko — Fri, 13 Apr 2007 14:17:00 GMT

Abstract:

<head>
<title>Page Title</title>

C#: Populate a DataTable from a parameterized query

Bosko — Thu, 12 Apr 2007 17:47:00 GMT

Abstract: using System.Data.SqlClient;
using System.Text;

//Instantiate a StringBuilder object to hold the SQL statement
StringBuilder sbSQL = new StringBuilder();

//Instantiate a DataTable object to hold the query results
DataTable dt = new DataTable();

//Set up the SQL Connection. Make sure to replace "YourConnectionString"
//with the SQL Connection string to your database
using (SqlConnection conn = new SqlConnection("YourConnectionString"))
{
//Set up the SQL Command using the connection and SQL statement

C#: Populate a DataSet from a parameterized query

Bosko — Thu, 12 Apr 2007 17:47:00 GMT

Abstract:

using System.Data.SqlClient;
using System.Text;

//Instantiate a StringBuilder object to hold the SQL statement
StringBuilder sbSQL = new StringBuilder();

//Instantiate a DataSet object to hold the query results
DataSet ds = new DataSet();

//Build the SQL statement. Preface each item you would like to replace with a value
//with an "@". You will be populating the values in these parameters.
sbSQL.Append("SELECT * FROM [TableName] WHERE [Field1] = @Field1");
//In INSERT or UPDATE queries you can also use the parameter fields when setting the values
// (ex: UPDATE [TableName] SET Field1 = @Field1 WHERE Field2 = @Field2)

//Set up the SQL Connection. Make sure to replace "YourConnectionString"
//with the SQL Connection string to your database
using (SqlConnection conn = new SqlConnection(

C#: Populate a SqlDataReader from a parameterized query

Bosko — Wed, 11 Apr 2007 17:31:00 GMT

Abstract:

using System.Data.SqlClient;
using System.Text;

//Instantiate a StringBuilder object to hold the SQL statement
StringBuilder sbSQL = new StringBuilder();

JavaScript: Print an HTML page from a link

Bosko — Tue, 10 Apr 2007 13:58:00 GMT

Abstract:

<a href="#" onclick="window.print(); return false;">Click here to print this page</a>

JavaScript: Print an HTML page from a button

Bosko — Tue, 10 Apr 2007 13:58:00 GMT

Abstract:

C#: META Tags For Pages That Include a Master Page

Bosko — Mon, 09 Apr 2007 18:53:00 GMT

Abstract:

Below is a code sample of how to add meta tags dynamicaly to an ASP.NET website that uses MASTER PAGES.

//Create the page TITLE
this.Page.Title = "TITLE of page here";

//Create the META KEYWORDS TAG
HtmlMeta metaKeywords = new HtmlMeta();
metaKeywords.Name = "keywords";
metaKeywords.Content = "Place KEYWORDS of page here";
Header.Controls.Add(metaKeywords);

//Create the META DESCRIPTION TAG
HtmlMeta metaDescription = new HtmlMeta();
metaDescription.Name = "description";
metaDescription.Content = "Place DESCRIPTION of page here";
Header.Controls.Add(metaDescription);

JavaScript: Allow entry of only numeric characters

Bosko — Mon, 09 Apr 2007 14:30:00 GMT

Abstract:

// JavaScript Function
function AllowOnlyNumeric()
{
// Get the ASCII value of the key that the user entered
var key = window.event.keyCode;

// Verify if the key entered was a numeric character (0-9) or a decimal (.)
if ( (key > 47 && key < 58) || key == 46 )
// If it was, then allow the entry to continue
return;
else
// If it was not, then dispose the key and continue with entry
window.event.returnValue = null;
}

// HTML Code
<input type="text" name="[ControlName]" onkeypress="AllowOnlyNumeric()"

JavaScript: Allow entry of only uppercase characters

Bosko — Mon, 09 Apr 2007 14:29:00 GMT

Abstract:

// JavaScript Function
function AllowOnlyUpperCase()
{
// Get the ASCII value of the key that the user entered
var key = window.event.keyCode;

// Verify if the key entered was an uppercase character (A-Z)
if ( key > 64 && key < 91)
// If it was, then allow the entry to continue
return;
else
// If it was not, then dispose the key and continue with entry
window.event.returnValue = null;
}

// HTML Code
<input type="text" name="[ControlName]" onkeypress="AllowOnlyUpperCase()" <

JavaScript: Allow entry of only lowercase characters

Bosko — Mon, 09 Apr 2007 14:27:00 GMT

Abstract:

// JavaScript Function
function AllowOnlyLowerCase()
{
// Get the ASCII value of the key that the user entered
var key = window.event.keyCode;

// Verify if the key entered was an lowercase character (a-z)
if ( key > 96 && key < 123)
// If it was, then allow the entry to continue
return;
else
// If it was not, then dispose the key and continue with entry
window.event.returnValue = null;
}

// HTML Code
<input type="text" name="[ControlName]" onkeypress="AllowOnlyLowerCase()" /&

C#: Display the current screen resolution in ASP.Net

Bosko — Mon, 09 Apr 2007 14:03:00 GMT

Abstract:

protected void Page_Load(object sender, EventArgs e)
{
//The line of code below displays the screen resolution in an <ASP:Label> by registering a JavaScript command on the Page Load
//The "typeof()" setting lets the application know which type of control the results will be going into (Label in this case)
//Replace [ASP:LabelID] with the ID of the label you are populating the screen resolution with
ClientScript.RegisterStartupScript(typeof(Label), "initLabel", "<script>document.all['" + [ASP:LabelID].ClientID + "'].innerText=window.screen.width + ' x ' + window.screen.height;</script>");
}

C#: Declare and use a simple Hashtable

Bosko — Mon, 09 Apr 2007 14:03:00 GMT

Abstract:

//Declare a Hashtable
Hashtable ht = new Hashtable();

//Populate the hashtable with values
ht["Key1"] = "Value1"; //"Key1" is a unique string value that will be used to retrieve the data
ht["Key2"] = "Value2"; //"Value2" is the value that will be returned from the Hashtable when accessed with "Key2"
ht["Key3"] = "Value3";

//Retrieve a value using a specific key
string strHashTableValue = ht["Key2"]; //strHashTableValue will be populated with "Value2"

C#: Make an HTTP Request

Bosko — Mon, 09 Apr 2007 14:03:00 GMT

Abstract:

using System.Net;

using System.Text;

using System.IO;

private string HTTPRequest()

{

string strURL = "[www.WebAddressYouWishToPostTo.com]";

--Declare variables to hold cursor information
DECLARE @[Field1] AS VarChar(50)
DECLARE @[Field2] AS VarChar(50)

--Declare cursor and associate a SQL statement with it
DECLARE [CursorName] CURSOR FOR
SELECT [Field1], [Field2] FROM [DatabaseName]

--Open the cursor
OPEN [CursorName]

--Get the first row of data from the cursor.
-- NOTE: The ORDER of the Fields in the following 'FETCH NEXT ...' must exactly match the
-- the order of the fields in the above 'SELECT' statement.
FETCH

GeekyCodeSamples.com

"The operation could not be completed." when opening .dbml (LINQ) file in Visual Studio 2008

SQL Server: a Maintenance Plan from a renamed server

SQL Server: Parse a Delimited String Into a Temp Table

JavaScript: Check if a user is leaving a page or closing the browser

JavaScript: Prevent entry

C#: Get the date of the beginning of the week

C#: Check to see if the user is browsing from a mobile device

C#: Use cookies for login authentication

C#: Implement a conditional operator

C#: Evoke a javascript ''Confirm'' dialog box from a GridView button

TFS: Delete a Team System workspace from the command line

TFS: View all workspaces, owners and computers

C#: Working with a CheckBoxList

C#: Free up Crystal Report resources

C#: Pop-up JavaScript window from code-behind

SQL Server: Check version, service pack level and type of the instance

C#: Stream a file back to the browser

C#: Open a page in a NEW Browser window from code-behind

C#: Using javascript Alert and Confirm dialog boxes from code-behind

SQL Server: Change the owner of an object

HTML: Implement META tags

C#: Populate a DataTable from a parameterized query

C#: Populate a DataSet from a parameterized query

C#: Populate a SqlDataReader from a parameterized query

JavaScript: Print an HTML page from a link

JavaScript: Print an HTML page from a button

C#: META Tags For Pages That Include a Master Page

JavaScript: Allow entry of only numeric characters

JavaScript: Allow entry of only uppercase characters

JavaScript: Allow entry of only lowercase characters

C#: Display the current screen resolution in ASP.Net

C#: Declare and use a simple Hashtable

C#: Make an HTTP Request