This will work:

Select substring(ship_to_addr_3, 1, CHARINDEX(',', ship_to_addr_3,1)-1)

from tablename

There is only one user other than DBO. All objects are owned by DBO except temp tables under discussion which are NOW owned by this user say ABC.

Application uses...

Mromm! Thanks it really works.. You guys are great.

Making table owner other than DBO works when we execute procedure thru query analyser and within crystal reports but somehow it does'nt work when we call crystal report viewer within...

Great response!! thanks Andy.

In fact we have few tables that are being used as temporary tables within the production DB instead of tempdb as scope of the these tables are...

Another related thread!

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8540&FORUM_ID=24&CAT_ID=1&Topic_Title=Backup+Individual+Client+Data&Forum_Title=Backups

By going with option 2, we can have following additional benefits:

a. Each customer’s data is being physically stored on separate DB and privacy and secrecy of customer’s data can be...

Have Fun!!

Q. How many Microsoft Certified Professionals (MCPs) are there worldwide?

A. There are currently 843,940 MCPs worldwide.

Q. Of those MCPs, how many are Microsoft Certified Database Administrators (MCDBAs) for...

Antares/Steve: Thanks

Options 2 is 100% secure as well.

Antares, can you please further explain how can we access multiple DB's using single DSN?? It will make our lives much easier...

Following script will re-build all existing indexes, can be usefull as well.

USE DATABASE_NAME --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR

SELECT table_name FROM...

To display in report, Crystal Reports needs images stored in the DB . Does anybody has a solution to store images in DB so that crystal report can access images...

SQL Server Books says::

Long-Running Transactions

The active portion of the log must include every part of all uncommitted transactions. An application that starts a transaction and does not commit it or...

Yes, I have applied the same solution. Changed the mode to full, took the backup of transaction log and then shrunk the database, it works but this is temporary solution...

Not having primary key/cluster index is a bad practice, but not having FK/relationships is disaster. It is the main ingredient to maintain data integrity and Data integrity is vital part...