Viewing 15 posts - 31,066 through 31,080 (of 39,754 total)
I think you're ok with memory as well, but with 8GB, you probably want to give 6-6.5 to SQL and see if performance improves
Make sure you have AWE on and...
October 7, 2007 at 9:28 pm
It doesn't always start itself. Might be more consistent in 2000, been awhile since I've worked with this, but I know it used to need to be started.
There are two...
October 7, 2007 at 9:23 pm
DBCC CHECKDB will check the consistency of a database.
There is no check for a server.
Do you know what you're trying to do? A "healthy" server could mean any...
October 7, 2007 at 9:20 pm
What is Integration SQL DB?
I'm not sure why the results would be different. Is there data that's greater than 4000 char and might be getting lost in an implicit conversion?
Also,...
October 7, 2007 at 9:19 pm
Clipped should be Fox 2.x or dBase IV if I remember. I'd think that any DBase driver would read it.
Use the Import Wizard in SQL Enterprise Manager and try some...
October 7, 2007 at 9:15 pm
I'm assuming this means that you solved the problem yourself?
Please post a followup that explains what worked so we know it's solved.
October 7, 2007 at 9:13 pm
You also need to provide a user/password in mixed mode. Without a domain, you would add a "SQL Server Authenticated" login to SQL Server, then use the same name/pwd in...
October 7, 2007 at 9:12 pm
I'd use ALZDBA's solution.
If that doesn't make sense, give us an idea of what the conditions are and we can help (tables/cols)
October 7, 2007 at 9:10 pm
The only thing that I've done in the past is check for a change to the user. When the user changes a password, the data in syslogins is updated (some...
October 7, 2007 at 9:09 pm
I believe because of the SID mapping in 2000 that you can only have one login in each db mapped to a user. So you'd need to make the changes...
October 7, 2007 at 9:07 pm
In 2005 you have all sorts of event triggers (look up Event Notifications) for logins and changes.
For data changes, you really should use Profiler with a server side trace. It...
October 7, 2007 at 9:05 pm
Can you provide some more information?
When you log in through ODBC, which login do you use and what are the rights?
When you create a table, how do you do it...
October 7, 2007 at 9:04 pm
What is in the package? This is definitely some type of network error. Are you sure you're checking the names referenced in the package? You might try saving it out...
October 7, 2007 at 9:02 pm
Viewing 15 posts - 31,066 through 31,080 (of 39,754 total)