What's the privileges you have assigned to the Login for which the Credential is created?

I have a similar issue and I am successful so far, only by giving sysadmin...

great examples!

If only duplicates need to be removed the ROW_NUMBER() may not be needed.

WITH cteEmployeeOrderedByMyRank AS

(SELECT RANK() OVER (PARTITION BY EMPID,FNAME,LNAME ORDER BY REFDATE ASC) AS PartitionRank

, *

FROM...

Is the MERGE INTO .. there at all in the released version???

I searched the whole Books Online, it's nowhere to be found. Besides I tried executing the example given for this...

If the Database compatibility level is 80 or less the following query returns the same output

select

* from a,b...

Really nice article. How about an article on "Going for First Job"?

Thanks

Balaji

I had a similar situation when I needed to transfer the binary data from one server to other. Finall, I used Access file to transfer the binary data and than...

It could be because of the Authentication. Try using the same Windows Logon as you were using in TS for the QueryAnalyzer.

bm

For Trigger:

SELECT OBJECT_NAME(a.[ID]) TriggerName, b.[Text] TriggerCode FROM SysObjects a INNER JOIN SysComments b ON a.[ID] = b.[ID]

WHERE a.Type = 'TR'

For Procedure:

replace the Type with 'P'

You can also find the Procedure...

Use COALESCE. e.g., 

declare @IDList as varchar(8000)

SELECT @IDList = COALESCE(@IDList + ', ', '') +

   CAST([ID] AS varchar(5))

FROM IDTable

SELECT @IDList

Happy programming

I don't know about Windows 2003, but in Windows 2000 Professional, it needed the latest Service Pack 4 for windows and the Service pack 3a for SQL 2000. 

I had faced earlier a similar situation and asked the Programmer to build a XML doc and pass it to a SP. In the sp using something like this

EXEC

You can have a round about using table vairable to store the text data e.g.,

DECLARE @tt TABLE(

 TextData text

)

INSERT INTO @tt VALUES('Sample Test')

You can use TEXTCOPY utility to do it. It should be in the folder

C:\Program Files\Microsoft SQL Server\MSSQL\Binn 

Char is for Fixed length, so Trim functions(LTRIM, RTRIM) has no role to play. mbarrentine has given the right suggestion.

bm21