Start by reading Books On Line (BOL)

URL for linked servers is:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/6ef578bf-8da7-46e0-88b5-e310fc908bb0.htm

The application role and control of same has changed from 2000 in 2005.

Sample code from BOL

DECLARE @cookie varbinary(8000);

EXEC sp_setapprole 'Sales11', 'fdsd896#gfdbfdkjgh700mM'

, @fCreateCookie = true, @cookie =...

Try this:

SELECT Name, MAX(Subsqno),SerialNo FROM TbL01 GROUP BY NAME,SerialNo HAVING COUNT(Name) = 1

UNION

SELECT Name, MAX(Subsqno), SerialNo FROM TbL01 GROUP BY NAME,SerialNo HAVING COUNT(Name) >...

SultanKahut

I have experienced the same error message, starting a week ago, it occurs around 9:30 PM. Shut the machine down and was notified that an automatic update was...

Created the function using copy / paste / execute - no reported error then tested using the following:

DECLARE @Bdays AS INT

SET @Bdays = dbo.fn_GetBusinessDays('07/06/2008','07/27/2008')

SELECT @Bdays

Result returned 14 ..

Now counting...

Using OpenRowset as:

INSERT INTO myTestOrder

SELECT Col1, Col2, Col3, SUBSTRING(Col4,1,3)

FROM OPENROWSET(BULK 'C:\myTestOrder-c.txt',

FORMATFILE='C:\myTestOrder.fmt'

...

Steve thanks for a good question. It introduced myself and I imagine many others to a new or little know facet of SQL Server 2008 and in that way...

I too have been asked (directed) to improve my softskills, since I have the unskilled propensity to tell the truth. The request of me to improve frequently occurs right...

What defines the latest ones?

Is it the column SUB-SEQNO value

or

Serial No values

or

some combination...

May I ask you a question. Why upgrading to SQL 2000, particulary the most expensive version? This will still leave you 8 years behind the existing technology. ...

You do not say if amongst these 100 user tables when created or later altered have been defined with

[ FOREIGN KEY ]

...

ANJAN.ASHOK try reading this from BOL:

Getting Started with Full-Text Search

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/1fa628ba-0ee4-4d8f-b086-c4e52962ca4a.htm

It gives an example using the AdventureWorks database. It is reasonably detailed enough so to get you going.

You...

Aveerabadra

I am not that familiar with SSIS but I see you are using

have you tried using DT_DBDATE instead of DT_DBTIMESTAMP...

Aveerabadran are you sure that the column data type is timestamp. and not a datetime data type.

From BOL

Is a data type that exposes automatically generated, unique binary numbers within...

You should take into consideration the danger of using dynamic SQL statements, in that they provide a path through database security for injection attacks, and unauthorized data access.