Yes... If u can pass XML its the best method.

Hi

can we use sp_executesql for all the procs/functions and put them inside a transaction.

also have a try/catch.

Gail , Chad

Superb explanation about indexes , especially Gails example.

Rob:

You said you dropped a index you had created to solve a time out issue and instead created the index suggested...

Sorry still not clear...

dont think so

Hi

A cursor or a while loop is the simplest choice here. I would prefer the while loop.

I have used sql_variant and have not faced any problems as yet. Mind you i did this thing recently. As you said conversion happens only in the Presentation layer...

I keep telling my HR mgr/Technical leads and others concerned (who decide the salary hikes) its not the number of hours but quality of work that counts.... but who...

what about using transactions ? then you can use GOTO .

Hi

Create a login for the newly created domain account.

use sp_change_users_login to connect this login the EXISTING db user account.

watch out for auto-parameterization. it can rebound

will it show a list of stored procs ?

Hi

Be very carefull before using schemabinding.

Better soultion to this would be give rights for modifying the tables only to the required people. Atleast they will know whether a table...

Hi

Well frankly i hv'nt understood ur query so iam not going to say anything on it. Some pointers though...

Are there many rows that need to be accessed . What is...

Hi

If u mean the Raiserror u hv in shown in ur code

use a GOTO whihc goes to the last line of your code.

How ever if u have other...