Viewing 15 posts - 37,036 through 37,050 (of 39,769 total)
I avoid it. Easy to forget when you rebuild a server or install a new one. Try to set things up in a DBA database that I attach to all...
October 4, 2002 at 3:20 pm
Dislike the agent backups. Prefer to keep the KISS principle in place. Plus in an emergency (and I've had a few), I'd rather go to disk if I can before...
October 4, 2002 at 3:17 pm
Interesting. I get the same thing.
I'll try to dig into this.
Steve Jones
October 4, 2002 at 3:16 pm
use combination of charindex, and subtring and replace
Get the substring of hte numbers and do the replace on these. Then contactenate that with the substring of the rest of the...
October 4, 2002 at 10:10 am
You may never know the "why". If someone did this, you would have to ask them.
To get them back, I think you could drop this as "sa". Maybe need to...
October 4, 2002 at 10:01 am
Not sure either. I know when you install SQL 2000, it wipes out the registrations. There is a Q article that says this is by design and you need to...
October 4, 2002 at 9:58 am
Do you get this in QA or in an app? In QA, there is a 255 limit, which might be reduced to 128 for N' strings.
Steve Jones
October 4, 2002 at 9:45 am
You can do it here and keep copyright. We just want an exlcusive for a few months.
SQL Server Mag takes copyright and it takes some time to get published. They...
October 3, 2002 at 10:48 am
Personally I'd use an Active X task to do this. Read line by line and parse them to determine what to do. This would be complicated since you would load...
October 3, 2002 at 10:45 am
Ken's guide is great. I also used "Programming T-SQL" by Kline.
Here are some reviews on this site:http://www.sqlservercentral.com/articles/articleList.asp?categoryid=75
Steve Jones
October 3, 2002 at 10:32 am
I'd follow some of this advice and start out small and do some proof of concept, even if it's one query. Maybe do a few different ways (web with sql,...
October 3, 2002 at 10:28 am
I've got this as one of my worst practices and I often argue with Vendors. I went through this with Great Plains (prior to MS). Told them to shove it...
October 3, 2002 at 10:07 am
Try select db_name() and be sure of your context.
Steve Jones
October 3, 2002 at 9:55 am
VSS isn't a freebie AFAIK. But it is included with Visual Studio and it fits nicely in a MS shop. CVS is a free tool and there is a windows...
October 3, 2002 at 9:53 am
There was a good article on this I read recently, can't remember the URL now. Basically since the float is an imprecise value, you are better off using decimals or...
October 2, 2002 at 10:42 am
Viewing 15 posts - 37,036 through 37,050 (of 39,769 total)