Frankly speaking I am not aware of that? can u suggest me, how to implement this after data is logged into table

Stored procedures

Thanks for your Input..

I got some input from my coleagues. This is what they suggested.

grant control on db0.personsto "SQLCentral\ptom"

It allowed to truncate that specified tables.. Does this has any...

Thanks Gail,

If you dont mind can you please provide me sample script that should be ran every year. so that i can compare the differences and understand it. sorry for...

Thanks for the reply IgorMi

I came across these links, as per my understanding sliding window does archiving or dropping of the old partition, but i dont want to implement that....

Can someone help me on this.. Any input is appreciated

Are Service packs are seperate for SQL Server 2000 server and AS Server ? When i googled some forums says...

One more similar Question.

I can connect to SQL Server by RDP to that server but not with my management studio. what i am missing here ?

Thanks!

I can see SQL Server instances in "SERVICES" but not in configuration manager.

I tried reatrting the instance, the status is still white in color.

Thanks everyone for looking into this

Thank you Both!

Why do we need to open port TCP 1433 and TCP 1434, while the instance is listening on 1477.

Also is this is mandatory to opem UDP port 1434...

Thanks Paul for your time.

If i have data for Eg from

2009

2010

2011

2012

2013

How should i plan the partitioning for unexpected data where the date is like 1988 or 2050

Please advise

Are those tables partitioned on the Oracle implementation?

If the answer is yes... how are they partitioned?

If the answer is no... why are you thinking on partitioning?

---Yes these table are partitioned...

declare @min-2 numeric(18,0)

declare @max-2 numeric(18,0)

declare @parts numeric(18,0)

select @min-2 = 102201011472463 ,

@max-2 = 102201354392808,

@parts = 3480

declare @increment int = (@max - @min-2) / @parts while @max-2 >= @min-2

begin ...

Let us know

Thank u

SQL Server 2012 installation fails in a VMware environment that is running Windows Server 2012

http://support.microsoft.com/kb/2799534?wa=wsignin1.0

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1012225

Update

I dint change anything , now the Test connection is succesful thru Oracle Connection manager in BIDS , but i am getting the same error while i am executing...