Charles Kincaid (3/30/2012)

---

I agree that there are lots of good tools on the market. What makes me so tired, and sad, is hearing from my clents that they have...

You can set CommandTimeout property to 0 and then SQLCommand will wait for statement's completion indefinitely.

There are two more reasons for not using SMO for this type of project:

1) Microsoft tends to change them with every next version of SQL Server, thus...

Chong Yuan (1/7/2008)

---

objCMD.CommandText = "{? = call Calculate_BW_Dslam(?, ?, ?, ?, ?, ?)}"

objCMD.CommandType = 4 'adCmdStoredProc

objCMD.Parameters.Append objCMD.CreateParameter("New_BW", adSingle, adParamReturnValue)

objCMD.Parameters.Append objCMD.CreateParameter("BW_Down",adInteger,adParamInput,objAdoRs("BW_Down"))

objCMD.Parameters.Append objCMD.CreateParameter("AccessArea_ID",adInteger,adParamInput,objAdoRs("AA_ID"))

objCMD.Parameters.Append objCMD.CreateParameter("Order_ID",adInteger,adParamInput,objAdoRs("ID"))

objCMD.Parameters.Append objCMD.CreateParameter("QoS_ID",adInteger,adParamInput,objAdoRs("QoS_ID"))

objCMD.Parameters.Append objCMD.CreateParameter("Current_BW",adInteger,adParamInput,objAdoRs("Current_BW"))

objCMD.Parameters.Append objCMD.CreateParameter("Num_Dslam_AA",adInteger,adParamInput,objAdoRs("Number_DSLAMs"))

objCMD.Execute

----------------------------------------------------------------------------------------------

CREATE PROCEDURE dbo.Calculate_BW_Dslam

@IntBW_Down Integer,

@IntAccessArea_ID...

For importing and parsing delimited text files you can try to use ODBC Microsoft Text Driver or OLEDB Microsoft Jet 4.0 provider in text mode.

As a result you will see...

Proven...

In our case it was Lyris ListManager which had direct...

If an application has embedded SQL statements and they are referencing system tables directly that may be the case of application being compatible only with a particular SQL Server version...

Jim,

There also is a misuse of @@ERROR function - it's value is reset by ANY next statement executed including conditional statements (in your example it is IF statement). If you...

In order to shrink log file when database is in FULL recovery mode you need to perform two consecutive actions:

1. Backup transaction log.

2. Immediately after step 1 run...

Jason Striker said:

"Is there any way to access/modify a row like a variable? Or does SQL Server have array variables?"

T-SQL doesn't have array variables and it is not possible...

There is very simple and fast way without using any temporary table or subquery. Steps to implement it:

1. Alter table to add an additional column for sequence numbers.

2. Update this...