Viewing 15 posts - 211 through 225 (of 596 total)
Yes, that's what I would do next. Uninstall then reinstall. Also, make sure to run the appropriate service pack on your workstation after you reinstall to update the client tools to...
May 16, 2006 at 8:44 am
From what I am able to ascertain, an object that is used to create the diagrams is not registered with Windows (e.g. a COM class ID (CLSID) or a ProgID). That...
May 16, 2006 at 8:15 am
Unless the process needs to be fully automated, I would follow Prasad Bhogadi's advice and use Enterprise Manager. Drill down to thew database, right click on the database name, and...
May 16, 2006 at 5:42 am
Are there other workstations that can connect to SQL Server? If so, can you logon to one of them using your domain userid and then try to connect using QA?...
May 16, 2006 at 5:27 am
If you are trying to log into a SQL Server from your workstation, and you receive the error "Login failed for user '(null)'. Reason: Not associated with a trusted SQL...
May 15, 2006 at 12:53 pm
You mentioned that you can log in as the administrator. I assume you mean as 'sa' use SQL Server authentication. Since you are logging in successfully to your domain (of which...
May 12, 2006 at 12:02 pm
Why do you use a LEFT OUTER JOIN here:
LEFT OUTER JOIN src_tbl_rental ON src_terrier.siteref
May 12, 2006 at 7:43 am
I just tested this (SQL Server 2000 SP4). If the specified data type is too small, you should get an arithmetic overflow error.
What version of SQL Server are you running...
May 12, 2006 at 7:07 am
If you are already using VB.net, you could read and format the file in your VB program, then do all the inserts from there. BCP with a format file would...
May 11, 2006 at 9:42 am
If you can get it to work programmatically, as with the VB solution, I would do that. If that doesn't work, here are a few other possibilities:
1. Run the statement using...
May 9, 2006 at 6:42 am
An audit file indicate that c2 audit mode (a security setting I would guess is not used much) is enabled. If it's not required, you can turn it off with...
May 5, 2006 at 6:02 am
It sounds as if the FTP process is separate from the DTS package. Why not add FTP tasks to the beginning of the DTS package? That way, it will be a...
May 4, 2006 at 7:59 am
As David mentioned (via the link to the other discussion), as long as you add 'NT Authority\System' as a Windows login, assigned to the sysadmin role, you shouldn't have any...
May 4, 2006 at 6:00 am
On SQL Server 2000, the Full Text Search service is called Microsoft Search. You can look in the SQL Server Service Manager (there is usually an icon in the system...
May 3, 2006 at 8:29 am
Viewing 15 posts - 211 through 225 (of 596 total)