From:

http://technet.microsoft.com/en-us/magazine/2007.02.sqlqa.aspx

Database Mirroring

Q I am using database mirroring and want to enable the READ_COMMITTED_SNAPSHOT database option. When I try to enable it after the mirroring has been set up, I...

chris.s.powell (1/25/2011)

---

What is the unused space within the db

select [FileSizeMB] = convert(numeric(10,2)

, round(a.size/128.,2))

,...

1. Your abstract does not identify to whom this is of the most interest.

How about including: As a DBA responsible for multiple servers ......

2.

This session will walk...

On the db side, we want to move to SQL Server so that we can transfer/load/integrate the data from our warehouse vendor into more meaningful, relevant data that we use...

With your data as given:

CREATE TABLE #Table1(empid INT, name VARCHAR(20), Date DATETIME)

INSERT INTO #Table1

SELECT 1,'name1','12/01/2011 8:00:00 am' UNION ALL

SELECT 1,'name1','12/01/2011 4:00:00 pm' UNION ALL

SELECT 1,'name1','12/02/2011 8:00:00 pm'...

Here is a tool writen by Jeff Moden and posted to SSC. It might be just what you need.

CREATE FUNCTION [dbo].[DelimitedSplit8K_old]

/***************************************************************************************************

Purpose:

Split a given string at a given...

Knowing that you stated you could not change the table(s), but in this examle I did, adding an Identity field (Row) to keep from going nuts when reviewing the results....

Suggest you start reading with this site

http://technet.microsoft.com/en-us/library/ms345368(SQL.90).aspx

Look at this product by REDGATE SOFTWARE

http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=google&utm_medium=cpc&utm_content=brand_aware&utm_campaign=sqlsourecontrol&gclid=CMT63JWCzqYCFYnd4AodK3UPGw

Will this example assist you?

CREATE TABLE [dbo].[TranTest](

[Col1] [int] NOT NULL,

[Col2] [int] NULL,

CONSTRAINT [PK_TranTest] PRIMARY KEY CLUSTERED

(

[Col1] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,...

Perhaps this example might help you undestand what Gsquared and Gilamonster have stated.

--This is your inner SP

CREATE PROCEDURE Tran_02

@Error INT OUTPUT

AS

DECLARE @E INT

...

LutzM (1/21/2011)

---

Unfortunately, a term like "mañana" seems not...

Since you did not supply the table structure or data, I made up my table and populated it with my data:

CREATE TABLE #T(Sales MONEY,DayofSale DATE)

INSERT INTO #T(Sales,DayofSale)

SELECT 100.10,'01-02-2009' UNION ALL

SELECT...

Luke L (1/20/2011)

---

Grant Fritchey (1/20/2011)

---

Steve Jones - SSC Editor (1/20/2011)

---

New forum for speakers. Critique abstracts and titles. I would love the feedback from people that actually go to sessions and...

Ninja's_RGR'us (1/20/2011)

---

Agreed here. There's no way out of this. You either pay for a license or pay for time.

The only question here is how much is the license...