Forum Replies Created
Viewing 14 posts - 1 through 14 (of 14 total)
-
RE: sql service/agent account
http://support.microsoft.com/kb/283811
The account needs to be sysadmin in the SQL instance, but you do not want to add it to the local administrators group on the server.
-
RE: VB App on SQL Server 7 machine cannot connect to SQL Server 2000 Database
As stated, you can update the MDAC on your SQL 7.0 machine to MDAC 2.6 or you could create an alias for your SQL 2000 instance on your SQL...
-
RE: VB App on SQL Server 7 machine cannot connect to SQL Server 2000 Database
As stated, you can update the MDAC on your SQL 7.0 machine to MDAC 2.6 or you could create an alias for your SQL 2000 instance on your SQL 7.0...
-
RE: DTS Restore
If you don't have a backup of the msdb database, but you do have the .mdf and .ldf files, you can "restore" the old msdb by:
1. Shut down SQL Server.
2....
-
RE: Clustered SQL2K5 instances on cluster with SQL2K instances
Have you had any problems with MDAC? Our service provider is saying that MDAC becomes a problem with the multiple versions.
Thanks for the reply!
-
RE: How to Change Login Name
You can also use the stored procedure 'sp_changedbowner' to accomplish the same thing without the detach/reattach.
use yourdb
exec sp_changedbowner 'mydatabaseuser'
-
RE: Silly question...
1. double click on AUTORUN.EXE.
2. on the next screen, click on SQL SERVER 2000 COMPONENTS
October 27, 2005 at 8:05 am
-
RE: Unable to access the Analysis Services Processing task
It's not clear from your problem description whether or not you are modifying the DTS package using the client tools on the server where you installed AS2K or on another client...
-
RE: Regarding Update Query......
The embedded select statement in your update DML returns 6 values (658,628,678,648,688,698). The update will only work if the select statement returns ONE value.
-
RE: Linked server connections fail on clustered database.
Have you verified that the Oracle client is installed on all nodes of the cluster? Is the client the same version? Are the TNSNames.ora and SQLNet.ora files the same on all...
-
RE: help needed for parsing the error log file
From your post:
chk = mid(strLinetoParse, 30,9) - to get first five chars of the description
Arguments for the mid function are (string, start, length). It looks to me like...
-
RE: Roles and DTS Packages (Problem created versions)
You definitely should NOT update system tables directly (see previous post regarding sysdtspackages).
If this is a one-time thing, you can transfer ownership of the package using the following undocumented...
-
RE: Truncate and Delete
One more small difference... You can grant an account delete permissions, but you cannot grant truncate.
New Information - SQL Server 2000 SP3.Viewing 14 posts - 1 through 14 (of 14 total)