If you're just performing selects ... from ... without saving the results to variables or into another table, you sp will return it as a rowset.

- check the command if parameters exist (hen you've been there already), just alter their values. Avoid the clear.

cmd.Parameters(

"@PIN").Value = pin.number

... "The user account I am using is member of the domain admins group, so this user should have access to it." ...

that is not the case if you removed...

if you're not providing values for all columns (except for identities) of a table, you should tell it which columns you're providing (values-order must match columnorder in the column-list ).

insert

did you add/alter the registry-key ?

Be carefull when messing with the registry !!! (backup before !)

-- HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server 2003 

-- 

- keep in mind that if the clustered index gets dropped, your data will move back to the filegroup defined at "create table"-time.

- so if you can, create the table...

Builtin\Adminstrator is the group of local administrators of the server and accounts like local system / local service.

If you remove it, be sure you'r running the sqlserver service using a...

did you configure MSDTC ? dcomcnfg.exe

Great. Sometimes, just sitting and reflecting the problem helps

Can you share the pittfall ?

maybe you should have a look at http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

this name gets published through the cluster service. So the name will get published at sql-instance-install time.

BOL has more regarding "install a cluster"

- also with that kind of size, consider using filegroups !(check BOL)

Especialy if you are planning on migrating to sql2005 where you can perform piecemeal restores so you actualy get...

you will need helper objects (#temptb) to solve this tree in sqlserver2000.

With sql2005 you would use a CTE.

Search SSC for "tree" and you'll find some options.

in adition to Aaron's reply ..

New with sql2005 is the "execute as .." for sp's.

check out "Using EXECUTE AS to Create Custom...

just script the full database. Create a new database and run the script.

You can use enterprise manager Rightclick the databasename \generate script. Be sure to select all things you want...