Viewing 15 posts - 36,691 through 36,705 (of 39,771 total)
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
January 2, 2003 at 1:51 pm
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
January 2, 2003 at 1:46 pm
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...
January 2, 2003 at 1:40 pm
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...
January 2, 2003 at 10:22 am
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...
January 2, 2003 at 9:44 am
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...
January 2, 2003 at 9:31 am
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...
December 31, 2002 at 1:09 pm
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
December 31, 2002 at 12:12 pm
Use a blob or image column.
Steve Jones
December 30, 2002 at 4:15 pm
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...
December 30, 2002 at 10:01 am
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
December 30, 2002 at 10:00 am
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
December 30, 2002 at 9:11 am
There isn't anything like this in SQL Server.
Steve Jones
December 28, 2002 at 9:21 am
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...
December 27, 2002 at 9:54 am
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...
December 27, 2002 at 9:49 am
Viewing 15 posts - 36,691 through 36,705 (of 39,771 total)