Just making the links easier to use for others:

http://www.sqlservercentral.com/stairway/73776/

https://www.simple-talk.com/sql/database-administration/sql-server-transaction-log-fragmentation-a-primer/

http://www.sqlskills.com/blogs/kimberly/transaction-log-vlfs-too-many-or-too-few/

I put the data you provided into a table and ran the code I posted and it worked.

If it is failing for you, you are going to have to provide...

unmesh2903 (11/3/2014)

---

Hi,

There is a little change in the data..

124546: Kroll, Sam; 548464: Cooper, David; 546546: Hann, John

212132: Payne, Brendon; 545454: Samson, Sara'

212133: Charles; 687465: Anthony; 544654: James; 665465: Charles

123333: Matt,...

Also, each instance on the desktop system need to use different ports.

Noticed you are using nvarchar data type, so here is a change in my code plus another DelimitedSplit routine.

my...

Actually, the first answer provides all the ids, just as a single column result set. ...

Here is a solution for you, still uses the function I posted earlier:

select

*

from

dbo.TestData td

cross apply (select stuff((select ','...

Working on a solution based on your last post.

First, you may need the following function:

USE [Sandbox]

GO

/****** Object: UserDefinedFunction [dbo].[DelimitedSplit8K] Script Date: 11/3/2014 03:03:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[DelimitedSplit8K]

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

Purpose:

Split a...

Are the ID's all numeric and end with a colon (:)? What should the expected results look like? Do the names all end with a semicolon (;)?

Actually, the n is the number of the row to start with. If row...

Here is another solution with no while loop:

declare @SQLCmd nvarchar(max),

@TableName sysname = N'MyTable';

with eCTE as (

select top (300) row_number() over (order by...

Not enough information to really give you an answer. What are you trying to accomplish, for one.

MMartin1 (10/31/2014)

---

Vimal Lohani (8/17/2014)

---

I didn't find any error with the code :

DECLARE @i TABLE( mychar VARCHAR(50)

,deriv as SUBSTRING(mychar,1,3) --Use this

,newderiv as left(mychar,3));--Or use this

INSERT @i VALUES ('Steve'), ('Stephan'), ('Stephanie')

, ('Sterling'),...

How are you configuring mirroring?