HI, from bol:

To create a view, the user must have CREATE VIEW permission along with SELECT permission on the tables, views, and table-valued functions being referenced in the view, and...

Hi, put the dts data in a temp table. Write some sp's to update from the temp table to the real table.

hi from bol:

In a fast local area network (LAN) environment, Transmission Control Protocol/Internet Protocol (TCP/IP) Sockets and Named Pipes clients are comparable in terms of performance. However, the performance difference...

try this http://www.microsoft.com/mobile/developer/technicalarticles/sqlserverce.asp

Hi make a new job step with the sp. In the flow logic refer to this step on failure.

Hi if you change a table you have to recreate the dts package, somehow the package does not recognize the new structure. (in sql 7 sp3)

Hi, did you put the blob fields at the end of the select statement?

Hi , in a trigger you can use the old and new value of a column, maybe this is of some help.

I use 3 to 4 fingers. If i use more then i have to use the backspace more often. I prefer the keybord instead of the mouse.

Hi joohan,

One thing we did for maintaing access clients is: Put the access client on a intra net web site so that users can download this. If the have a...

Hi, performance depends on several things. To get maximum performance using access and sql server you can do several things:

do not use linked tables because by opening or quering them...

select * from (select P.id, count(c.id) as numberofChilds from tblParent P inner join

tblchild C on p.id=c.id

group by p.id )T inner join tblParent P2 on T.id=p2.id

Hi, i tested it on :Microsoft SQL Server 2000 - 8.00.194 (Intel X86)

Aug 6 2000 00:57:48

Copyright (c) 1988-2000 Microsoft Corporation

Desktop Engine on Windows NT 4.0 (Build...

hi, is de H; drive mapped with the sql server account?

try this

declare @datStart datetime,

@datEnd datetime,

@datCheck datetime,

@intMonth integer

set @datStart='01/01/2001'

set @datEnd = '12/31/2002'

set @intMonth = (select DATEDIFF(m, @datStart, @datEnd))

select @intmonth

set @datCheck= dateadd(m,-@intMonth,@datEnd)

select @datCheck

if @datCheck > @datStart

set @intMonth = @intMonth +...