nikki123 (2/19/2010)

---

I know its a simple questions . i am breaking me head on this .

Msg 201, Level 16, State 4, Procedure SP_SOAC_REPORT_SUMMARY, Line 0

Procedure or function 'SP_SOAC_REPORT_SUMMARY' expects parameter...

I dont know if i am wrong but is there a easy way out for this.

May be if i say.

Partition function fx(10,20,30)

partition scheme sc on fx all to primary

Create...

Yes Thats right, That is not the complete story, Just saw on the internet that the Table Which is Partitioned should never be altered, there is the datapage corruption issue,...

The issue is not what we are thinking!.

Well to Explain it

--------------------------------------------------------------------------------------

Partition1 | Partition2 | ...

Let me Re - query the same,

The idea is to have 3 paritions for each month when we hit the limit then remove the last partition, Issue here is when...

Thank you, i was just looking at the SqlServer supported operating systems it had no mention of he Windows7 hence my question.

Many Thanks and will let you know.

how it works.

could you plese look at the sql scripts i belive the sql script will tell whats my issue. The issue is not with performence the issue is realy with the...

Sorry for bumping in to it again,

I belive the dba is going to do this work. this is one of the proc which we used to get the process...

do you want all the tables to be copied.

else do the following.

@sql = 'Select * ' + ' INTO ' + @TargetDb+'.'+@Schema+'.'+ @TableName + ' From '+...

No Reply ?

Thank you this is realy usefull.

you should have had a similar output. in both select statements. could you paste your code so that we can see the results of the execution.

Ok,

Thanks for you honest feedback, Well then do the following to test the theory dont do it on production database.

dbcc freeproccache

go

dbcc dropcleanbuffers

go

set statistics profile on

go

set statistics time on

go

[exec .......

Hi,

I see that its written there as newbibe, Ok

1) Views are a way to represent data from mutiple tables. the easy way to see that is you are having...

Couldnt realy follow it.

do you want to order by or some thing?

not clear.

is it a calculated col.

if you send some details like create table and insert into commands and then...