Forum Replies Created
Viewing 15 posts - 36,631 through 36,645 (of 39,717 total)
-
RE: ERwin and SQL Server 2000
ER/Studio does, I believe.
alternative, setup a local server, make the changes to that and then script them. run the script using Windows Auth.Kludgy, but secure.
Steve Jones
-
RE: session/process id concept
the SPID is what you need, but you may need to store this along with some other identifier of the individual.
We used to do something similar in that we would...
-
RE: Execute DTS with Visual Basic
Are you loading from the same server in both cases? Perhaps the server side package is not accessing the same package. Are you hard coding the server name? Is it...
-
RE: Sqlserver error log msg
Did you install Windows SP3? I think this happened to us recently. I didn't work the case, but I know that we had to call PSS and work with them...
-
RE: Version Control - Dealing with Code
Boy it's been a long time since I did any Visual Studio integration with SQL Server. As far as I remember, it was only for stored procedures.
Other than that, there...
-
RE: Suppress Trailing Zeros?
Intersting script. Not sure I'd do it that way, but it's a great solution.
2nd vote also for explicit conversions. Better to do it yourself and be sure you don't get...
-
RE: query help
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
-
RE: Transaction logs increased up to 16 GB
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
-
RE: Password encryption: Best Practice ?
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...
-
RE: Can I schedule my db full backup to take it on tap
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...
-
RE: Password encryption: Best Practice ?
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...
-
RE: Transaction logs increased up to 16 GB
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...
-
RE: Suppress Trailing Zeros?
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...
-
RE: Suppress Trailing Zeros?
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
-
RE: How to store images in SQL table
Use a blob or image column.
Steve Jones
Viewing 15 posts - 36,631 through 36,645 (of 39,717 total)