Viewing 15 posts - 37,051 through 37,065 (of 39,769 total)
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
Actually, we do not rely on the tape. We keep 2 days worth of full backups. Since the tape only runs at night, we are copying the local disk T-Log...
September 30, 2002 at 11:11 am
Profiler in real time. If someone is stuck, dbcc inputbuffer
Steve Jones
September 30, 2002 at 10:59 am
No issues on SQL 2K or SQL 7. W2K is sooo much better than NT4. Terminal Services alone are worth it.
Steve Jones
September 30, 2002 at 10:12 am
Viewing 15 posts - 37,051 through 37,065 (of 39,769 total)