Search results for query: *

alter table timPPInvtValLstWrk drop column ItemClassKey

Thanks for the reply Bill. I already tried that and I get the following error: Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near 'ItemClassKey'.

Hello, I can't delete columns I created in table(s) and get the following error in Enterprise Manager: ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 'timPPInvtValLstWrk' table - Unable to modify table. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect...

Cannot insert duplicate key row in object 'tarInvoiceLog' with unique index 'XAK1tarInvoiceLog'. The statement has been terminated. I get this error when I run insert statement within cursor ( I need to do line by line processing). I checked for duplicates, there are none. If I run single...

Couldn't describe it in the title, but here's problem I'm having. I have a VBScript that gets ItemID from 3rd party App and puts it into temp table and executes VB executable with Wait option like this: Set objWSH = CreateObject("WScript.Shell") objWSH.Run...

hmckillop", That's exactly what I needed. Thanks a whole bunch and star for you. Steve

Hello, I'm wondering if there's a way to programmatically find a name of stored procedure that contains "SET QUOTED_IDENTIFIER ON" line? I looked in sysobjects table, but there's nothing beside procedure name. Any ideas? Thanks much. Steve

Thanks for the reply "vbkris". I corrected code but still get Null when read cookie.

Hello All, Sorry to ask very basic question but I'm a little bit rusty at the moment on JavaScript as used it 2 something years ago. I tried some different functions from different posts, but no luck. I have a project where I need to read a value from URL, set cookie on one page and when user...

Thanks for the reply, MDXer. I did most of the error handling on server side and as well as detailed error logging. I was looking for a way to suppress non-fatal errors from SQL server, so I don't have to duplicate extensvie error handling on client app.

Hi, I don't think it's possible, but I might be wrong. Is there a way to suppress SQL server (non fatal) error messages, so they don't propagate to client. I'm building an VB app that will be scheduled on server. I'm looping through 5-6 servers and do data transfers. So, if there any SQL...

Thanks Denny, That works like a charm.

Hello there, I need to programmatically create linked server and drop it in stored procedure. I'm doing it using sp_addlinkedserver and sp_dropserver, but I get an error if there's already linked server with that name. How do I check if linked server already exist, so I don't try to add it...

Thanks MDXer I was trying to have as few steps as I could, but seems that I'll have to add Activex script to each SQL task. My tasks just multiply from there. 10 SQL tasks + 10 Activex task + 10 SQL tasks to do log table update. Do you have any links/info on workflow conditions? It seems to...

I found solution. Apparently to do that, one has to loop through steps collection and filter step that failed. Here's the code in case somebody will be looking for something simular: Function Main() Dim oPkg, oTask, oStep Set oPkg = DTSGlobalVariables.Parent For Each oStep in oPkg.Steps...

Hello, I'm trying to read previous SQL task description in Activex script and having problem figuring out correct syntax. I can read package name, but can't get to the task level. Here's what I'm trying to accomplish by doing that: My package has 10 SQL tasks and each individual task does data...

Thanks for the reply nigelrivett, however I can't use this solution as it works only with stored procedures, and I can't user sprocs. What I'm trying to do is this: I have a server where my packages are. From this server I need to transfer data to 5 different servers and only data that doesn't...

Hello there, I need to be able to retrieve global variable value in Execute SQL task. I went through few books but didn't find anything that would point me in right direction. Thank you for your help Steve

Sorry, That was to get table stats.

sp_help <tablename> But this returns an Array of recordsets, so you need to retrieve one you need using something like this Dim Array() As Object Dim myRs AS ADODB.Recordset Array() = call_your_sproc_here(<tableName>) Set myRs = Array(1) Hope this helps