Viewing 15 posts - 36,991 through 37,005 (of 39,720 total)
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
If you can do it in SQL, you can do it in DTS. Use hte Execute SQL task.
It will take multiple steps, but could be done in a stored proc,...
October 2, 2002 at 10:08 am
Has the data set been growing? This can contribute. Is the log not set to autogrow?
Steve Jones
October 2, 2002 at 9:51 am
Isn't there a right click "Generate Scripts" somewhere in EM? I suspect DMO could be used as well.
If not, you could query msdb and probably figure it out.
Steve Jones
October 2, 2002 at 9:47 am
Viewing 15 posts - 36,991 through 37,005 (of 39,720 total)