Second try, apparently my last post got eaten...

You might try using a File System Task to copy the file to a static file name and point your connection object to...

When you create the job step, set the Type drop-down box to "SQL Server Integration Services Package".

Then you should be able to specify the server and package to execute.

I'd actually loop over INFORMATION_SCHEMA.TABLES to find your list, it's going to always be up to date whereas AppClient might not be.

DECLARE @sql NVARCHAR ( 4000 )

SET @sql =...

It sounds like you're trying to log in with a default database that has been dropped or you're specifying a database that no longer exists when you log in.

I would use a case statement as semesters tend to be variable based on the educational institution.

SELECT CASE

WHEN GETDATE() BETWEEN '2006-01-01' AND '2006-03-01' THEN 'Winter'

WHEN...

Do you mean column-level encryption or network communication encryption?

Tim-

I showed a technique for handling this situation in the following article. Adapt to your needs:

http://www.sqlservercentral.com/columnists/aingold/workingaround2005maintenanceplans.asp

Hope this helps.

Yeah, SQL Server is pretty good about identifying functions which need to evaluate and produce a single result per line (NEWID, ISNULL) and a function which will produce a static...

The IIS and SQL Server are on the same machine

Ouch. I'd change that first. You really don't want to have any SQL Server sitting on a box that...

They query processor won't invoke GETDATE() for each record. It will do it once. The bigger problem is the DATEDIFF function which forces math to be done between...

SELECT DATEPART(mm, Date_occur) AS Month, COUNT(*) as NumberOfTransaction

FROM tblTransaction

GROUP BY DATEPART(mm, Date_occur)

ORDER BY DATEPART(mm, Date_occur) ASC

That should do it...

Yeah, the GETDATE() comparison is problemmatic, but not because it repeatedly executes GETDATE(). The problem is it does a DATEDIFF against Process_Date... for each value. The better approach...

Yeah, the GETDATE() comparison is problemmatic, but not because it repeatedly executes GETDATE(). The problem is it does a DATEDIFF against Process_Date... for each value. The better approach...

I think he means ROWCOUNT, not the @@ROWCOUNT system variable. To get the top 10 rows you'd do:

SET ROWCOUNT 10

EXEC sp_CommunityStoreList

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

Oh, it's also generally bad format to use "sp_"...

Use a left outer join... and for good measure always reference your tables. I'm assuming couCourseID is your primary key.

INSERT INTO tblBackupCourses

SELECTtc.*

FROMtblCourses tc

JOINtblGrades tg

ON tc.couCourseID = tg.graCourseID

LEFT JOIN...