Viewing 15 posts - 34,501 through 34,515 (of 39,726 total)
Most likely it will continue for the next 5-6 years. SQL Server 7 is still supported (although that's about to end) and it was released on 99.
October 12, 2004 at 10:34 am
What does the process do? Perhaps the data has changed. Be sure you run update statistics on the tables involved, also check dbcc showcontig for fragmentation. If it's drastically changed,...
October 12, 2004 at 10:33 am
If you have a steady enough workload, i.e., not too many ad hoc queries, then this will work. It typically hasn't been an issue with my systems, but we have...
October 12, 2004 at 10:32 am
Or you just give them rights to select from the view or underlying table with granting insert, update, or delete.
October 12, 2004 at 10:21 am
What is the package doing when it is hanging? Try running it interactively from the designer to see.
The waittype means that the OLEDB conenction is waiting on something.
October 12, 2004 at 10:19 am
Be sure that this login has rights to connect to SQL Server. Test logging in yourself as this account.
October 12, 2004 at 10:17 am
The issue with having slow IO and causing the page latches is something you'd fix with hardware changes. You are accumulating latches (lightweight locks) because it is taking too long...
October 12, 2004 at 10:16 am
In SQL Server 2000, you can have collation set at the column level, so each column could be different. You can set a default for the db and change it...
October 12, 2004 at 10:12 am
October 12, 2004 at 10:11 am
It boots sqlsrvr.exe in the windows priority against other applications. It might get you slightly better performance, but if there are other processes on the box that might need resources,...
October 12, 2004 at 10:10 am
October 11, 2004 at 10:11 am
I've heard good things about Protegrity, but hanve't used it.
October 11, 2004 at 10:10 am
Does it do this if you run it interactively? Can you double click the failed item and get an error?
Most likely it's a data problem. Try changing the first and...
October 11, 2004 at 10:08 am
I believe 6.5 only had Std and Enterprise editions. If select @@version doesn't return it, I'd look through the registry keys (HKLM/Software/MS/SQL Server) for it or properties of the server...
October 11, 2004 at 10:06 am
Must be some bug somewhere. I'll take a look.
October 11, 2004 at 10:00 am
Viewing 15 posts - 34,501 through 34,515 (of 39,726 total)