Hi all.

I was pleased to get acquainted with all the present team

and I will be happy to share the same views with all

the discussion of regular tasks.

Sergey.

Hi all.

I was pleased to get acquainted with all the present team

and I will be happy to share the same views with all

the discussion of regular tasks.

Sergey.

Ask vendor 2nd version is entirely reasonable

would not create the impression

the client is trying to invade the server.

------------------------------------------------------

------------------------------------------------------

Hi all.

I was pleased to get acquainted with all the present...

Hi,Shaiju.

I see

"Column name or number of supplied values does not match table definition."

You can try a bit of a change in the procedure

-----------------------------------------------------------

CREATE PROCEDURE pDataGet

AS

BEGIN

...

This is the starting point for not only my possible developments

The codes perform properly

But I don't have links to the source of codes .

In the architecture this situation is usually called eclectic.

Took something, but something forgotten .Today worked....

Thank Ron for comprehensive reply.

This should help not only me to understand the next steps

that someone needs to be done.

Sergey

Hi,Ron.

Thanks.

I want to know a "neater" method to write a subroutine

to open any SQL 2000 database using VB 6 .

I have overlooked something about foreign key.

But what...

After running a query

-- To allow advanced options to be changed.

EXEC sp_configure 'show advanced options', 1

GO

-- To update the currently configured value for advanced options.

RECONFIGURE

GO

-- To enable the feature.

EXEC sp_configure...

this gives me :

SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system...

You probably encountered situations where the query returns

the correct result when one is the configuration database,

but with a different configuration gets completely incorrect results.

If you use the undocumented...

You probably encountered situations where the query returns

the correct result when one is the configuration database,

but with a different configuration gets completely incorrect results.

If you use the undocumented...

Hi.

Happy New Year 2010 to all.

Where I can search documents about undocumented ability ???

And I want to say about http://www.microsoft.com/Sqlserver/2005/en/us/express-down.aspx#SP3

that set1500<>set1700 and set1500<>set2010 and set1700<>set2010.

And immediately I...

I believe first understand OPENXML

I watch necessarily your article

As long as that found here is such a decision :

create table #customers (

id int,

customer varchar(50)

)

insert into #customers values (1,'John')

insert into #customers values (2,'Lyss')

insert into...