Hi srv

Is the job failing at the same stage every time - ie is the failure linked to elapsed time, or to a particular T-SQL instruction/batch?

Do you know that the...

And this is how I do it:

select cast(floor(cast(getdate() as float)) as datetime)

... same principle as ikorenbl.

Something like this should work:

DECLARE @server as varchar(100), @sqltext as varchar(100)

SET @server = 'stageServer1'

set @sqltext = 'select top 10 * from ' + @server + '.[databasename].[owner].[tablename]'

exec(@sqltext)

Regards

Phil

MSDE is cut-down SQL Server and I'm therefore sure that you should use that if you can. Moving to Access will create a lot of rework - eg stored...

Not sure about Reporting Services, but IsNull() as a T-SQL function takes two arguments:

ISNULL (check_expression, replacement_value )

So it might be worth starting there. Check BOL for more details.

Regards

Phil

Yes, just use

select substring([textfield],1,100)

Regards

Phil

Changing the db to Oracle??? You won't find that suggestion here!

If you are working on a month-by-month basis, can't you just run a...

Not sure, should happen automatically. Are you correctly terminating the connection from the VB app to SQL Server? (Set connection = null etc).

Regards

Phil

David, please clarify what you're trying to do. I cannot think of a situation where you would need to create a stored procedure as part of a function call,...

This is pretty bad news! Is there any way that you can get a complete list of all city names into a separate SQL Server table?

You could then traverse...

Excellent, never used that before. Far better than my suggestion.

If you re-read the original post, you will see why the straightforward 'top 10' method will not work in this case.

I think the way to do this is to find the top 10 'counts' and then to return all the records that have these counts.

So, if your table is called...

Assuming that you are using Enterprise Manager ...

When you perform the restore, the default paths for the restored files (database and transaction log) will be the same as they were...

You could also leave Profiler running and analyse the resulting trace around the 'slow' times to see whether you can identify what is causing the slowness (and therefore whether you...