sql server programming: SQL Server 2005

How can I :

check to see if an existing table is partioned?
if not, partition it preserving data within it

preferably using a transaction.

First Question:

The table/properties window shows it.

Or

declare @tableName varchar(256)
select @tableName = 'Employee'
declare @returnValue int
select @returnValue = count(*)
from sys.partitions
where object_id = object_id(@tableName)

or a Select * From sys.partitions

Second question:??
I'm not sure.


[quoted text, click to view]