Hi

What does the actual jobs history report? I am interested because perfos.dll is used to measure system performance for your MS OS. I don't know what "OTM Closed" is though.

Do these...

Hi Robert

Are your .ldf's physically on file?

I found this article on msdn, which does offers an interesting insight into a potential issue you may want to address with your connections:...

Hi Marc

I know that learning to program stored procs is different from a module based environment but try and do as much processing server side, sql is made for it.

If...

After absolutely no conflicts with my employers and managers I have previoulsy managed to implement type based naming conventions, until my last employer. They couldn't predict the practibility or cost savings with such a...

Hi Manish

What do the error messages say?

Cheers

Use the statement below to identify the undesirable collations for all columns in a db.

SELECT  TABLE_NAME, COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS

WHERE  NOT COLLATION_NAME IS NULL

AND  COLLATION_NAME <> 'insert...

Normally sql will determine the way a sql statement is executed but it doesn't always get it right, hints will allow you to "hard code" a method of how sql...

Hi Jim

I unfortunately do not work with asp.net but would recommend looking at http://www.microsoft.com/technet/default.mspx

If all else fails, chat to you provider and ask them to assign you a sysadmin...

Could someone have changed ownership of the table? What is the error message you are getting from DTS?

You could pop the data from your correlated (sub) query into a temp table on the local server and use that in your transaction instead. Keep in mind performance issues and the...

How are your access forms bound to your (presumed) adp project?

I would, anyway, recommend firing a stored procedure from access on the afterupdate event of both date fields on your...

This will explain named pipes a little better:

http://support.microsoft.com/default.aspx?scid=kb;en-us;101150

this aught to help explain what the ports are used for:

http://support.microsoft.com/default.aspx?scid=kb;en-us;150543

My impression over time of network protocols with SQL is that Named...

Check SQL Server "Books on line" for "named pipes" info, there's plenty of info there.

I suppose it depends on actions taking place i.e. are any of the aggregates dependant on the previous in the trigger?

If I can speculate as to what MrSQL is getting to, is...

As promised:

SELECT  FO.name AS FK, FC.Column_Name AS FC, FK.fkey, RO.name AS RK, RC.Column_Name AS RC, FK.rkey, CN.CONSTRAINT_NAME, RL.UPDATE_RULE, RL.DELETE_RULE

FROM  dbo.sysforeignkeys FK

 INNER JOIN dbo.__tmpTBLCOL FC ON FK.fkey = FC.Ordinal_Position

 INNER...