Call the SP with a Pass-Through query in access. If it still gives you headaches, then call the Pass-Through query from another query (i.e.. SELECT * FROM <pass-through query>)...

Stefan,

Good question, I am not sure of an easy way to do it other then looping through each DB on the SQL Server.

I believe there is a way...

I believe your DTS is erroring out because it comes across a user that already has been set up which kicks out a error. This error then stops the...

I got my start via MS Access 2.0 and 95. While going to school, I did very well working with Access in my classes that my professors found me...

We have a bunch of routine reports where I work that we send out as email. I have a scheduled job in SQL Server that creates the report and...

What about moving your audit code to just after the transaction. This way you it is not rolled back if a problem arises. But, on a different track,...

I agree with Paul's solution except if your date falls on the exact start or end of a quarter. To fix this you have to do two things. ...

I forgot that you can have the DTS write to an error log if there are any issues. This can be done in SQL 2000, I do not remember...

AlphaIndex,

You state: "One of the problems with xp_cmdshell 'DTSRUN.EXE etc is you can't tell if the DTS package ran successfully or not, so I would look at Phil Carters...

How about:

RIGHT('00000000000000000' + <variable>, <Number of chars in field>)

This is provided the telephone numbers are character fields and not numeric fields.

sxg6023,

Try this update statement:

update ItemCosts

set AvgCost = (SELECT SUM(Cost) FROM ItemCosts b WHERE b.Item = ItemCosts.Item AND b.CostDate <= ItemCosts.CostDate) /

(SELECT COUNT(Item) FROM ItemCosts c WHERE c.Item = ItemCosts.Item...

hankrearden2002 & Frank

Try this script. I have modified Gabor's script to add the associated column that go with the index.

SELECT LEFT(t.name, 40) as TableName,

LEFT(i.name, 40) as IndexName,

LEFT(c.name, 40) as...

Khalidhussain,

I do not know why the BA's lost there access, when they should be the same as the Users in permission. The only difference that I could see from...

Given your situation, I would set up NT Groups on the server that your SQL Server is on versus individual window logins. Then set up the four seperate groups...

sairah,

on your first update statement:

update companyfact_staging

set company_key =T.company_code

from companyfact_staging F INNER JOIN company_staging T on

T.company_code=F.company_key

WHERE F.company_key='MISSING' Go

I believe your problem can be fixed by changing the join to...