Viewing 15 posts - 37,726 through 37,740 (of 39,818 total)
June 18, 2002 at 2:49 pm
Agree with above. Best to try and "rethink" the problem as a positive rather than a negative.
Steve Jones
June 18, 2002 at 1:26 pm
If you use SQL-DMO, there is a method to look for SQL installations. Note that this may not work, especially if you are subnetted.
Check the MSDN docs
Steve Jones
June 17, 2002 at 1:40 pm
It is a straightforward change. I don't think there are any new keywords. If there are, you can always set the databases to run as sql 7 compatible.
Steve Jones
June 17, 2002 at 1:35 pm
Check in the control panel for the MSSQL service account. Likely it was an account in the old domain. Set it to a new account in this domain.
Steve Jones
June 17, 2002 at 1:33 pm
Not a SQL error. you have an error with the IIS account loading the DLL. Track that down first. The "knowing where the server is" is stricly a location item....
June 14, 2002 at 3:27 pm
Can you double check the PK on the table? Also , try importing a small batch with duplicate and non-duplicates to verify it works.
Steve Jones
June 14, 2002 at 3:23 pm
If DBCC does not work, check the script library. there is a script I posted that will help you. This has to do with virtual log files within your one...
June 14, 2002 at 3:22 pm
You'll find some threads here, but I'd backup to disk and then to tape. Use NT permissions (on NTFS drives) to manage the security and lock it down based on...
June 14, 2002 at 12:41 pm
June 14, 2002 at 12:39 pm
June 14, 2002 at 12:34 pm
I wrote a loop that looked for duplcates (using COUNT and HAVING COUNT(*) > 1) by name or other criteria. Then issue a SET ROWCOUNT 1 and a DELETE for...
June 14, 2002 at 12:31 pm
Not surprising. They ran lots of internal stuff(payroll, accounting, etc.) on an AS/400 for a long time. Supposed to be converting to 2000 with Great Plains.
I suspect there are still...
June 14, 2002 at 12:29 pm
No, started building one, but it was a pain. Not sold on Extended properties yet, maybe in Yukon.
Steve Jones
June 14, 2002 at 12:27 pm
I use the same account for server and Agent. Cuts down on errors related to security and config. However, I use different accounts on each server/instance. Named to conform to...
June 14, 2002 at 12:24 pm
Viewing 15 posts - 37,726 through 37,740 (of 39,818 total)