Viewing 15 posts - 37,006 through 37,020 (of 39,720 total)
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
I believe in memory. If it's large, it might be in tempdb, but I do not think it would be accessable by you.
Steve Jones
September 30, 2002 at 9:58 am
Dedicated server - no capping (unless > 2GB and AWE not enabled. MS says don't try to let it run above 2GB.
Shared Server - Probably need to cap it otherwise...
September 30, 2002 at 9:56 am
detach/attach (as noted above) is the easiest way to do this.
Steve Jones
September 30, 2002 at 9:53 am
The SQL command works well, but this particular process wasn't running on a SQL server. Instead it was a backup of another database (Btrieve).
Steve Jones
September 30, 2002 at 9:36 am
Viewing 15 posts - 37,006 through 37,020 (of 39,720 total)