create a table data type and use that as the parameters data type for the procedure.

something like

create type abcd table ( columns and definitions)

grant the execute permission on the...

use the where clause to specify the particular id your looking for .....

you code and sample output would be useful , also since the editor formats the spaces u can try replaceing them with dots just so that we see what ur...

try using ctes

Please refer the below article it would give you a better idea about how to go about dealing with files and filegroups.

It might we worth considering splitting different database on...

Change the database recovery model to bulk logged when performing the operation.

http://msdn.microsoft.com/en-us/library/aa173529%28v=sql.80%29.aspx

Would it make a difference if the windows account was impersonated ?

Assuming your the developer and wouldn't have access to the live system , i don't know any dba who would execute this proc on the developers behalf with the xml...

Nested transactions

http://msdn.microsoft.com/en-us/library/ms189336.aspx

Your right 😀 , it depends.

Whats wrong with using sp_help 'proc name' ?

Is the RAM utilization high all the time , or only during particular times during the day? 4 Gb usually works well for most OLTP systems hosting few databases of...

I cant think of any severe issues with filling drives to capacity esp if they are not going to grow and no index rebuild etc are gonna happen, and the...

unique contraint will create a key and hence has a limit of 900 byte. you can still create an unique contraint with nvarchar(4000) but chances are your inserts will fail....

If your planning to take this live please remember that the NIC 2 may be used by the cluster and the impact of having merge replication needs to be accounted...