You will need to use a wildcard statement like so

select * where exception LIKE '%WebL exception: [. "msg" = " function expects a page or piece as first argument", "type"...

It really is up to how much load you will deal with.

Ideally if you can afford to, put tempdb on a seperate raid from the transaction logs, this will...

After years of trying I prefer to perform a loop in my application to pass the data. It is safer, syntax issues are fewer and it performs at about the...

If you want to do just once a day then merge should fit your needs if you are poutting the databases in the same one at Home, if seperate ones...

To the best of my knowledge I know of no such setting to commit after N transactions.

1) Connect to the server and run the DTS package manually in the workflow desginer to see if this produces the same issue.

2) Do not schedule the packages so no...

Views or use full reference of database.schema.object when referencing the other databases. You only have to make sure the login has permissions in all databases to interact with the objects...

Usually dump them myself from the production environment.

Can they type the code or is it a visual builder you have created?

Using FileSystemObjects in an ActiveX script object you can check the file size and see if greater than 0 an determine what to do then, can be flow logic decision or...

Saw this, might be the answer [ http://www.mcse.ms/archive89-2004-3-509075.html ]

I'm wondering if you got the correct noise file. noise.eng is for British

English, noise.enu is for American English. Change the noise word...

Or better if you are using SQL 2000 or later download and install reporting services to build this type of report for you. Although you can do as described it...

First off you should be able to simplfy your function like so.

CREATE FUNCTION dbo.EmployeeName (@ID as smallint)

RETURNS varchar(50)

AS

BEGIN

    RETURN (SELECT [user_name]

    FROM Tbl_Employees

    WITH (NOLOCK)

    WHERE Emp_id = @ID)

END

Now as...

This is the method I use orignally was posted as a Stored Procedure by me here

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=259

but this is the Function version.

--You will need this table.--

CREATE TABLE NumNameTbl (

 [val] [int]...

I would prefer to know more about the table strucutre and what each field is for before I give an answer.