Thanks for the update!

Should not be NULL as you have already used NVARCHAR.

What's the difference in the header row and the data row?Is that also comma separated?

Can you please send the sample input...

Please go through this article: http://www.sqlteam.com/article/introduction-to-locking-in-sql-server

Also spend some time in msdn article on Locking. Please post your specific questions then, would be great to discuss then.

I think SET @vouchertype = LTRIM(RIGHT(@vouchertype,LEN(@vouchertype)-CHARINDEX(' ',@vouchertype,1))); is actually changing the value for vouchertype.

You may want to include an ELSE as well within your CASE statement.

Have you checked this multiple times, are the results same all the time?

There would be transactions/ changes that were in progress when you took the backup and needs to be...

Thanks! Probably I misunderstood. thanks for clarification.

If its really needed to shrink I would use below:

backup log dbname to disk ='..\log.trn'

dbcc shrinkfile(filename)

I would also follow below if above doesn't help

- Backup DB

- Change the recovery model...

You may want to read more regarding ROWLOCK.

What I have read is: Row locks are not taken unless ROWLOCK is combined with other table hints that require locks, such...

Couple of Ways you can try:

SELECT LEFT(COLNAME,1)+LEFT(LTRIM(RIGHT(COLNAME,LEN(COLNAME)-CHARINDEX(' ',COLNAME,1))),1) FROM TESTCOL

SELECT LEFT(COLNAME,1)+SUBSTRING(COLNAME,CHARINDEX(' ',COLNAME,1)+1,1) FROM TESTCOL

You may want to play further with the functions 🙂

Do you mean Shrinking the Transaction Log? What is the recovery model of the database?

If its Full, please take a tlog backup and then try to Shrink.

You may...

Well, you need to review a lot of things and also business decisions needs to be kept in mind. Few Pointers:

1. One bad database can cause issue with the entire...

I liked this series, if you would like to check: http://www.youtube.com/watch?v=o5Pf5FHJHyU

Did you check the perfmon counter total server memory?

I also wanted something similar recently and used this article to get the list!

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=172689

You may want to set a filter in the at the end as: loginname='<required user>'

Hope this helps!

As far as I have seen, it still needs some space in the directory where OS is installed to copy the required binaries, so I think you would need to...