I can back up SQL Server on the mission critical measure. We run our factory floor production system on SQL 7.0 on Marathon Endurance Server. We process up to 100,000...

There are better things to do in a pub then argue about the relative merits of Oracle and SQL Server.

The CONVERT function is the way I do would do it in production.

Assign getdate to a variable.

Use the variable in your update.

Use the same varibale in your select, you should get the rows returned.

It is possible to get a wide variety of skills and with a certain depth of knowledge but its a double edged sword.

In the past 5 years I have worked...

Run DBCC loginfo and check through the rows returned for status ID that are not zero(probably = 2).

If the non zero values are near the end of the log file...

Detaching to shrink the log file is totally unnecessary.

Truncate the log on a regular basis either by doing a transaction log backup or setting 'truncate log on checkpoint' to true...

The thing is, I am almost certain that you are mistaken in thinking that you get a resultset as the output from DBCC SHOW_STATISTICS (<table>, <index>).

If you take a...

We use Marathon Endurance server so that everything is mirrored and backup locally and later to tape. does anyone else use this and if so , any issues?

Log onto the server as the account that the SQL Server Agent service runs under.

Then open up Outlook and try to send a test email to the same email address....

Why don't you put the query into a SQL Stored Procedure (with parameters if necessary) and call the stored procedure from Crystal Reports. That way you don;t have to worry...

but even when I run it from Query Analyser it is slower if the statements are not run

sigularly or in small groups.

Just in case you want to go ahead and try doing it for yourself

sysdbmaintplan_databases, sysdbmaintplans, sysdbmaintplan_history, and sysdbmaintplan_jobs

are the tables you need to take a look at, I may even...

..but when I run them individually one at a time there is no problem and if I run groups of them, where I know each will take a very short...

Thanks people,

I was able to return what I needed (Just the product ids + name for those that matched my criteria) using just the Select and group by but I...