That isn't quite clear. Can you be a little more specific in what you are looking for? Is this in insert statement you need help with or a select?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

You may have virtual log segments that are not empty and preventing the shrinking. Use this script to help:

http://www.sqlservercentral.com/scripts/contributions/26.asp

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Wow, someone agrees with me!

Use some secure protocols if you need them, definitely the stuff accepted in the industry is the best choice. Just be aware of...

2nd vote for disk backup. Look at Litespeed, reduced my backup file size from 40GB to 7GB with this product. My db size is 400GB, so check on the backup...

You have to assess your vulnerability and detemine how big a deal is this. Is someone more likely to social engineer a pwd for your system than try to crack...

Right click the database in Enterprise Manager, select Shrink. choose the "Files" button and select your log file(s) and shrink them.

Or look in our script library. There is a script...

That's probably what I would do. After looking at this more (and it's interesting), I think you need to chop from the right. Seems to work as long as you...

You could convert to char and then look for the first 0 after the decimal and use that as a limiting factor for your substring.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Use a blob or image column.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Wow, not a lot of fun, but a nice creative solution.

Thanks for the update and if you don't mind, can you post exactly what you had to run to clean...

For the first item, something like this would work for multiple rows:

UPDATE COAManyflats

SET Location=i.Location,Region_code=i.Region_code,Bedroom=i.Bedroom,Area=i.Area

from inserted i

WHERE Flatsno=i.Flatsno

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Let's back up slightly. What are you trying to accomplish? Why would an ASP page need to retrieve the row within a trigger?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

There isn't anything like this in SQL Server.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Crystal sucks. Haven't used it in about 18 months, but for 10 years I've hated it.

Excel is ok, if it's text report, try to send Excel sheets since I can...

How big is this? Is it sensitive data? could you send it? (Pls reply before sending).

I'm surprised you can't attach with no log file, usually works, though suspect status may...