Viewing 15 posts - 36,631 through 36,645 (of 39,717 total)
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
January 3, 2003 at 12:38 pm
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...
January 3, 2003 at 9:57 am
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...
January 3, 2003 at 9:45 am
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...
January 3, 2003 at 9:42 am
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...
January 3, 2003 at 9:40 am
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...
January 2, 2003 at 2:10 pm
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
Viewing 15 posts - 36,631 through 36,645 (of 39,717 total)