Hi,

This might be of use to you, http://www.microsoft.com/sql/editions/compact/default.mspx

Hi,

You don't necessarily need an activeX script in the Agent job. You can do it by using the xp_fileexists extended proc in T-SQL.

CREATE TABLE #exists (file_exist BIT, is_dir BIT, parent_dir...

You would need to (or get whoever set your ODBC connections up on your machine) get access to the SQL Server box and set up a new ODBC connection called...

Hi Neil,

I can't quite figure out, from what you've posted, what the question/problem is. You'll need to post a bit more information than the query. If you can post the...

Hi,

It sounds like you don't have the ODBC connection set up on the server that hosts SQL. When you run a DTS pacakge from Enterprise Mangler on your machine it...

I set up a test run for:

SELECT DocumentID, DocumentSummary

FROM Document

WHERE NOT CONTAINS (DocumentSummary, 'pedals OR wheel OR brake' )

And that gave me one row from:

id, Summary

1, bicycle, pedals

2, motorbike...

The following function should help you out:

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'fnDateCountBack' AND xtype IN ('FN', 'IF', 'TF'))

DROP FUNCTION fnDateCountBack

GO

CREATE FUNCTION fnDateCountBack(

@inputDate DATETIME

)

RETURNS @table TABLE (yr...

Hi,

This isn't a great response but I think it will work assuming that all of your descriptions have a space in them somewhere. I'm no Full Text Search expert but...

The COLAESCE statements for your numeric parameters with default values of 0 will return 0.

COALESCE(@DeptID,EmpDept.DeptID)

... will always return 0 when the default is used as it's the first non-null in...

DB_Newbie,

With hesitation....

I'd say that the @date isn't recognised as being declared because the parser doesn't understand the CREATE statement context and therefore the variable doesn't exist.

Possibly.... :crazy:

There's a good article on this site for checklists:

http://www.sqlservercentral.com/articles/Database+Administration/62480/

Google will also bring back some decent results if you search for DBA Checklist.

This was one of the links off of the...

Have you got an example of the data and your schema? You'll get better responses the more information you can provide.

For instance, what identifies a record as new? what identifiers...

The CREATE statement should be the first line in a batch.

You may wish to try:

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'GETMONTHEND' AND xtype IN ('FN', 'IF', 'TF'))

DROP...

It looks like the problem lies in the following statement:

and (Emp.EmpName = case when @EmpName != '' Then @EmpName Else EmpName End)

You're input parameter @EmpName, if not populated...

It's not a wildcard expression but you could use something like:

WHERE REPLACE(actualTime, '0', '') <> ''

or

WHERE CAST(actualTime AS INT) <> 0

The replace would result in any actualTime string containing only...