Is the RETURN command above the INSERT line part of your testing?

There is a RETURN above the line "if (@IsCliEnabled=1) --check whether true" stopping the procedure from going any further. This could be from your testing.

From BoL:

"By placing the database offline, users are prevented from accessing the database, and no modifications to the database can be made until the database is placed online."

May I ask,...

More parameters means more ?'s. For example, if sp_Bob had two input parameters you would write:

sp_Bob ?, ?

Then you can map the parameters to GlobalVariables in the same way. In...

Hi. That query would return all the rows where there is data in BOTH lookup tables. Consider using LEFT JOIN; check out the difference by running the below:

CREATE TABLE #parent (parentPK...

Changing the INNER JOIN to a FULL OUTER JOIN yields the same result from the test data.

I use a script similar to this to create the ActiveX transformation script for unknown columns:

Function Main()

 Dim fso, f

 Dim inLine

 Dim outLine

 Dim sourceName

 Dim colNumber

 SET fso = CreateObject("Scripting.FileSystemObject")

 SET f = fso.openTextFile("c:\trial.csv")

 inLine =...

With the small amount of data that you provided, this:

SELECT  Company.company_name AS compName,

 Company.Company_ID AS Company_ID,

 Company.Reference_Id AS RefID,

 Company.Employee_Count AS EmpsSetup,

 COUNT(Leave.Leave_No) as CountLeaves,

 COUNT(Employee.Employee_No) AS EmpsSystem

FROM    Company  

LEFT JOIN Employee

 ON Employee.Company_ID =...

Yes you're on the right track.

You'll have to change the CREATE TRIGGER statement to FOR INSERT, UPDATE, DELETE.  You can then have...

Something like...

SELECT so.name as TableName, sp.value AS description, sc.name as ColumnName, UPPER(st.name) as DataType, sc.length, CASE sc.isnullable WHEN 1 THEN NULL ELSE '' END AS isnullable, CASE WHEN scom.text IS...

I would recommend a database per application as the roll-out of new databases in-line with new application versions is simplified. A backup strategy for all databases is simple enough to...

You may have to use the SQL Server version of BETWEEN:

select * from VENDOR where BETWEEN DATEADD(dd, -7, GETDATE()) AND GETDATE()

This will give everything in the last 7 days.

Hi Helen,

Try the following script. The function provides the concatenation you require (I think).  Any Q's, just post back.

-- Create...

Have a look at CREATE INDEX in bol.

You should be able to do something like:

CREATE INDEX ix_myIndex ON myTable( myCol1, myCol2, myCol3....)

after your CREATE TABLE statement.

The only thing I can think of at the moment is, have you checked the Max Error Count setting on the Options Tab of the task properties?