use this way. But Iam not sure.

Use system_function_schema

go

GRANT SELECT

ON fn_trace_getinfo

TO Audit

If Audit is a nt group users, you need to specify the domain name also.

Thanks,

Ganesh

Try this way

select convert(varchar(25),getdate(),21)

Thanks,

Ganesh

Did you run index tuning wizard. If you would have run that and in the meanwhile if it got interrupted. It would have created hypothetical indexes pertaining to your table.

sp_helpinex...

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ

GO

BEGIN TRANSACTION

--

--

...

COMMIT TRANSACTION

Really, Iam not sure it will throw an error. Send the code segment also.

I doubt the data type is not compatible. Better use bigint.

If you are not going to manipulate...

SET TRANSACTION ISOLATION LEVEL REPEATABLE READ

set the isolation leve either REPEATABLE READ or SERIALIZABLE. So that you don't worry about the locking hint. The basic...

Check whether you have initialized the variable "id".

As the visual studio environment has a rich facility for debugging. check the variable you are assigning

is not null and so on.

Thanks,

Ganesh

SET DATEFORMAT mdy

GO

DECLARE @datevar datetime

SET @datevar = '12/31/98'

SELECT @datevar

GO

set the format and proceed.

Thanks,

Ganesh

Please follow this link

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=112074&edit=failed

It's works for me in a different database as I don't have northwinds in my sqlserver box.

Check the data exists

SELECT     OrderID, CustomerID, EmployeeID, OrderDate

FROM         Orders

WHERE     CustomerID IN ('VINET', 'TOMSP' ,...

SELECT     [Customer Change No], [PIA Material No], [Due date], [Adj Due Date])  AS Expr1

FROM         dbo.[tblPPAP Notification Detail]

where ([Adj Due Date]) is null

Thanks,

Ganesh

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

Instead of giving the @cnnAccess try giving @ConnectionString

EXEC @hr = sp_OASetProperty @cmd, 'ActiveConnection', @ConnectionString

Thanks,

Ganesh

The class string you are using is perfect. Please attach the error too, so that it will become easy for everyone to help you.