Viewing 15 posts - 36,241 through 36,255 (of 38,961 total)
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
Make a table. Holidays are such fickle things, change from company to company.
Or set a reminder in Outlook to disable the job.
Steve Jones
October 1, 2002 at 10:48 am
Are you sending a user name? What's the connection string?
Steve Jones
October 1, 2002 at 10:44 am
Excel defaulst to sheet$, which is a valid identifier in SQL (with brackets), so SQL creates a table and uses this name.
If you want a different name, create the table,...
October 1, 2002 at 10:28 am
Actually, this works with servers of all sizes. Large servers might have issues, but it's a bandwidth issue.
We aren't simulating log shipping. Instead, this is merely a way to protect...
October 1, 2002 at 10:22 am
I could, but we have been using Maintance Plans and I dislike tinkering with the jobs that are setup.
This will change as we are looking at going to Diffs...
September 30, 2002 at 5:14 pm
Viewing 15 posts - 36,241 through 36,255 (of 38,961 total)