Viewing 15 posts - 4,156 through 4,170 (of 6,216 total)
One way would be replication, either merge or transactional with updating/queued subscribers. Have to confirm that you can do that with MSDE. Not sure how it would scale.
You could code...
May 30, 2002 at 5:36 am
Does sound like permissions, which I'd say is the most common issue with Agent anyway. Runas is a useful way to test this, do "runas batchfilename" and run it under...
May 30, 2002 at 5:33 am
DBCC Checkdb on each db should do it, along with maybe a disk check by NT. Other than that I'd double check that backups are good and try to find...
May 30, 2002 at 5:30 am
As a fix you can change the location of your temp folder.
Andy
May 30, 2002 at 5:29 am
Not sure where to go from here. I'd start by profiling a session so you can see what Access is sending to SQL, maybe see if its using a lot...
May 29, 2002 at 8:20 pm
MDAC is the standard data access from Microsoft. Go to http://www.msdn.microsoft.com and search for MDAC to find the latest version. EM is Enterprise Manager. Have you indexed all your tables?...
May 29, 2002 at 2:10 pm
I've seen timeouts when there was heavy fragmentation - run your dbcc's recently?
Andy
May 29, 2002 at 2:07 pm
There's no magic, you can use either plain TSQL or DTS, for either you'll have to customize your inserts to match the structure of the table. Depending on whether those...
May 29, 2002 at 2:06 pm
Just ran this:
xp_cmdshell 'bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" queryout Authors.txt -c'
And got this:
Password:
NULL
Starting copy...
NULL
24 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.): total ...
May 29, 2002 at 12:08 pm
I think you need to provide the userid/password. When you do bcp from command line does it prompt you?
Andy
May 29, 2002 at 11:23 am
No error message, nothing in the maint plan history showing it tried to run?
Andy
May 29, 2002 at 10:44 am
Should be able to do it with an alter database statement - see BOL for the syntax. DMO also supports changing it with the recoverymodel property of the dboption2 object,...
May 29, 2002 at 10:42 am
Seems like if they were willing to do functions then views are bit less complicated, sort of. Ah well, what can you do!
Andy
May 29, 2002 at 9:16 am
Sometimes you'll benefit, sometimes not. Honestly I think you'll have to benchmark to see. I'd say the biggest point is whether you would gain performance by indexing temp tables, something...
May 29, 2002 at 9:02 am
Try manually specifying the password/login on the dtsrun command line.
Andy
May 29, 2002 at 8:30 am
Viewing 15 posts - 4,156 through 4,170 (of 6,216 total)