another reason to switch to a more intelligent solution in stead of a maintenance plan.

there are a couple of alternatives at SSC.

Ola Hallengren has a very nice one at http://ola.hallengren.com/

What about servername, instance name for your standalone server ?

Are they equal to the original servername ?

If not, you may have some issues with msdb (sqlagent), and master sysservers

have a...

with numeric data, leading zeroes do not play a significant role, so don't worry.

If you want leading zeroes in your result, handle that in your presentation layer (gui, report, ...)

And a darned good one too, may I say ! :w00t:

As Jason stated, the query I provided should cover your quest.

Oh indeed. I forgot to mention this:

Test it, Test IT !

- the trc files you see are the ones generated because the default trace is active (+_ 20MB each, wright ?) I presume.

( please let it be active. It can...

Because you're only using inner joins, just let the sql engine determine at which step in the process it will handle your where clause.

(It will take indexes and statistics into...

Maybe this can be an option too

Declare @SeriesStartDate datetime

Declare @SeriesEndDate datetime

Select @SeriesStartDate = '2010-11-01'

, @SeriesEndDate = DATEADD(mm, 4, @SeriesStartDate)

Declare @DynamicPivot varchar(1000)

declare @Separator char(1)

Select @DynamicPivot = ''

, @Separator = ''

Select @DynamicPivot=@DynamicPivot...

I would first look for things that may cause your kind of corruption:

A good starter is : http://sqlskills.com/BLOGS/PAUL/post/Example-20002005-corrupt-databases-and-some-more-info-on-backup-restore-page-checksums-and-IO-errors.aspx

You'll find more corruption/checksum related blogs on that site.

http://www.sqlservercentral.com/articles/Corruption/65804/ also contains very helpful...

you could try to investigate its execution count

select qs.execution_count

FROM sys.dm_exec_query_stats qs

cross apply sys.dm_exec_query_plan(qs.plan_handle) QP

that's one of the advantages you get when switching to dbmail 🙂

Thank you for the feedback !

Others will benefit from it.

Is this a single shot migration ?

Did you have a look at the SSMA for access (freeware by MS )?

( SQLServer Migration assistant for access )

Can this help out ?

insert into @sku values ('12345000'),

('32134000'),

('21340000'),

--It was not working for skus like

('1234567'),

('1234012'),

('1234500')

Select sku

, SUBSTRING ( sku , 1, datalength(sku) - patindex('%[^0]%',reverse(sku)) +1) as newsku

--, patindex('%[^0]%',reverse(sku)) as pos

from...

manju3606 (1/4/2012)

Hi ALZDBA,

can i ask question here,i am using bellow qurey to get all relationship tables and i am getting all the relation ship tables also now what i...