Viewing 15 posts - 1,426 through 1,440 (of 2,387 total)
Create linked server to Text file as example below.
exec sp_addlinkedserver
@server = 'Documents',
@provider = 'Microsoft.Jet.OLEDB.4.0',
@srvproduct = 'OLE DB Provider for Jet (Text IISAM)',
@datasrc = 'c:\temp\',
@provstr =...
July 23, 2003 at 12:46 pm
You should know the login created in old linked server. That is the login for you connect to the remote server. You can review the the login's database access and...
July 23, 2003 at 12:27 pm
First to run sp_spaceused @updateusage = true to find out spaces used by your database and sp_helpfile to get how large your MDF and LDF are. Then shrink them with...
July 23, 2003 at 10:02 am
I tested with pubs database without any problems. Can you try pubs database too?
July 23, 2003 at 9:59 am
It seems you are activating a sp that starts a job to restore the database in remote server. Is it? If not, can you describe more details about the whole...
July 23, 2003 at 7:52 am
quote:
Like counter logs, in Performance snap in? I wonder how can this help...This time I just seen it in System monitor,...
July 23, 2003 at 7:38 am
Do you have any performance log for last 10 minutes? Or have any performance monitor application (for example, BMC) running against this server?
July 23, 2003 at 7:03 am
Do you have ideas how long the restoration will take? Any error messages in SQL Server errorlog? Can you post the restoration statement?
July 23, 2003 at 6:59 am
How do you map local login in serverA to remote login in ServerB? Try to set the default database for remote login is 'master'.
July 23, 2003 at 6:31 am
Can you check whether dynamic queries use correct indexes to find records that need to be deleted? Do you delete them in a single batch or split the deletion into...
July 23, 2003 at 6:18 am
1. Create a share directory in TDA and allow SQL Server service account in PDA to be able to write to it.
2. Backup database pubs to disk = '\\TDAMachinename\ShareName\pubs_20030722.bak'. For...
July 22, 2003 at 8:16 am
Public Role does not have update permission to all tables by default unless you grant it the permission. Create a new Role with proper permissions to select/update your particular tables...
July 22, 2003 at 8:11 am
quote:
since all log backups are appended to the same file, this file is constantly growing. Even after full or differential backups it...
July 22, 2003 at 7:54 am
I mean register your virtual SQL Server in EM in both nodes.
July 21, 2003 at 3:24 pm
quote:
Msg 18456, Sev 14: Login failed for user '\'. [SQLSTATE 28000]
Who is the...
July 21, 2003 at 2:44 pm
Viewing 15 posts - 1,426 through 1,440 (of 2,387 total)