Viewing 15 posts - 36,991 through 37,005 (of 39,717 total)
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
Haven't seen this. What SQL Version/SP?
I suspect a bad install. Or perhaps rights. Under what account does SQLAgnet run?
Steve Jones
October 2, 2002 at 9:41 am
Tough question. I always set passwords and in this current job, we use NT Auth whereever possible.
In addition we use roles as much as possible, apply patches, firewall off the...
October 2, 2002 at 9:39 am
Wouldn't you still need permissions to load the temp table?
Steve Jones
October 2, 2002 at 9:36 am
Viewing 15 posts - 36,991 through 37,005 (of 39,717 total)