Viewing 15 posts - 37,366 through 37,380 (of 39,456 total)
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
I use Andy's solution to "loosely couple" steps together from different jobs. Allows them to be linked, but not at a success or failure level.
Steve Jones
June 14, 2002 at 12:22 pm
Haven't used it. Tested, but haven't found a good reason to do it. It's mainly for desktop installs (why it was developed). I tend to try to build things that...
June 14, 2002 at 12:20 pm
Viewing 15 posts - 37,366 through 37,380 (of 39,456 total)