I login with sa.is that enough?how to member of db_owner or db_owner?

but there is one problem

my string is parameter that fiil from one function and function returns '0,0,'',0,'',0'

now how do i do?

thanksssssssssssssssss

yes always

and when i want create account and profile with wizard get error:

this wizard will vlose becouse it encourected the following error:

object reference not set to an instance of an object(databasemailwizard)

hello.

I put script for insert in to tables that used in view.please first create tables and insert into its and then run view.please give me script of pivot for my...

hello cadavre.i put script of tables and insert into tables.please help me that rewrite my procedure with pivot by use view v_com_cdc.thanks

these are script and data that used in my procedure and i need to pivot view v_com_cdc and result of my procedure and my favorite resulat is attached.please help me...

I could download this zip file.please try again.thanks

Hi, please pivot V_COM_Cdc and use this data.

thanks very much 😀

Hi, these are scripts of my tables use in procedures and view.

thanks for your replies.

i want create ssis from export\import wizard not from business inteligence,how to pass input parameter to stor procedure dynamically?

i run this ssis with job and execute succesfully.and i use :

exec xp_cmdshell '"C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec.exe" /f C:\DbfExport.dtsx'

but get error :

Microsoft (R) SQL Server Execute Package...

thanks for your reply.please write script for me.i donot know where is use /X86?

I see.but how to run this package in 32 bit mode in script?