Query error when using application role with ADO connection
I am developing an application with an ADO connection. I need to run a query on two different databases on the same server using an application role. When I run the query I get an error \domainusername does not have a logon on database (referring to the second database). Is there any way around it?...
View Answer
| May 7 2008 3:24 PM GMT
| asked by
SQL Server Ask the Experts
ERROR MESSAGE, Application development, ADO
Design a SQL Server trigger to calculate column averages and return them to another table
I'm quite new to SQL Server and I’m struggling to design a trigger. I need this trigger to execute daily and calculate averages of columns and return them to another table.
View Answer
| Mar 16 2008 10:25 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server performance, SQL Server development, Triggers
29 Feb incorrect in DateAdd and GetDate command
Hi, Does anyone know Why the day of date different ?when i used : select GetDate() --> It's Return 2008-02-29 11:01:45.310 and then when used :select DateAdd(yyyy,543,GetDate() ) ---> It's return 2551-02-28 11:01:45.310My SQL Server is MS SQL Standard Edittion VERSION 6.5Anyone have...
View Answer
| Feb 29 2008 4:53 AM GMT
| asked by
2830360
SQL Server 2000, SQL Server development
