Please check with if the following will work.

assume that myScript.sql contains the stored procedure and

Exec pAddNewThemeScheme 4, 'Scheme2', 1, 'Scheme2' statement.

The an adminsitrator can run sqlcmd -S sqlservername\instanceName -i

myScript.sql...

Peso,

thank you so much. You taught me something. That works. The interesting part is my insert statement works in studio directly but not in the stored procedure. Don't know why.

I...

Hi all,

I rewrite to another one.

Create proc ExtractDataforProducer (@StartDate Datetime, @EndDate Datetime, @SubProducerFlag char(1), @TableName varchar(15), @AgentCode varchar(10))

As

Select * from @TableName tn

inner join tis_vs vs on tn.pnref=vs.pnref

and agentCode...

Lynn,

Thank you so much for the help. My mind is not here today.

Sincerely

Betty

sorry to bother you all.

I got it. I somehow add "column" key word. I removed and everything works fine.

Sincerely

Betty

Hi all,

I finally make it work, but I still need you help to explain something for me.

instead of using destination of import to be microsoft OLE DB provider for sql...

Hi all,

If I see this error message through one of my web page,

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'myServerName\IUSR_WINDOWS2003'

what does that mean?

Thanks.

Betty

hi all,

Now I do see the username I added in

select * from sys.sql_logins

select * from sys.syslogins

but I didn't see the username I added in this table.

select * from sys.sysusers

what...

Hi all,

I just added one userid and password to the sql server 2005.

Now how can I grant this user to a specific database and has a dbo role etc.

thank you

betty

thank you so much for your reply. I didn't this stored procedure. I did it.

I am very appreciated.

Betty

Hi Adam,

I got it. In Data Transformation Services-->local package->right click on it-->schedule package. then that's it.

Betty

Hi Adam,

I am trying to schedule a job.

enterprise manager-->management-->jobs-->new job.

on the general tab, on the drop down menu "category", I was able to pick up a DTS package I created...

all right, thanks you all for your suggestion. if I cannot get the admin access, I will definitely ask my administrator to run advisor for me.

Sincerely

Betty

Hi all,

Now I am able to analyze the remote database.

I analyze (eliminated Notification Services and Reporting Services since I don't have these two)

Sql server

Analysis Services

Integration Services (Data Transformation Services)

If...

thank you both for the replies. Yes I can view all the tables.

OK I will use full name to create a table.

The question is: is that possible, I change owner...