For the second table, only one Insert will take place.

CREATE TABLE dbo.Cuss2

(cid int NOT NULL, cut varchar(25) NOT NULL,

ph varchar(20) NOT NULL, adx varchar(50) NOT NULL,

CONSTRAINT...

Really many thanks.

CREATE TRIGGER [dbo].[trg_LogStatus]

ON [dbo].[Waybills]

AFTER INSERT,UPDATE

AS

BEGIN

SET NOCOUNT ON;

DECLARE @WaybillId int

DECLARE @ActionBy...

What is the version you are using?

The user granted "VIEW SERVER STATE", must always be able to query sysprocesses for ALL users.

Please double check that it's already granted it, and you are not mixing between users...

Just make sure that the SSMS's connected session is by the user granted the "VIEW SERVER STATE".

I beleive you need to explicitly grant View Server State permissions to each of the users.

"GRANT VIEW SERVER STATE TO user"

Try the OPENROWSET

SELECT * FROM OPENROWSET(BULK N'C:\image.gif', SINGLE_BLOB) AS MyImage;

Have u checked this:

http://blogs.technet.com/mdegre/archive/2009/12/25/apply-a-sql-server-2008-service-pack-or-hotfix-to-a-failover-cluster-instance.aspx?us

Well, the problem solved by conversion to the national character set,

SELECT UNISTR(My_Column), this to return NVARCHAR(2) data type which to be understood by the SQL Server.

Why do you need the row_num > 1?

Thanks Paul, apart from the storage is there any way to load HTML documents from the web like those exists for documents on local file system / network share?

SELECT *...

Really thanks Brain, a solution is detailed in the link.

Finally solved, many thanks

Has any one tried it on a named instance with a default one of 2005?

Thanks,

I did it exactly. Moreover, I repaired the installation and re enabled the configuration but still in vain. Any help please