Thanks for the feedback. The solutions mentioned rely on a consistent and incremental primary key value which I do not have. The table will have...
Does anyone have any scripts for randomising data within a table? I have a table of client names and I want to randomly swap them about to prevent...
Yes, I could see those correctly, permissions looked fine and the content of them appeared fine also.
Yes that entry is in the sqlctr.ini file. Software is: Windows 2000 SP3 SQL Server 2000 SP3a I'm thinking of reinstalling SQL Server and seeing if...
Where should I be seeing 'sqlctr.ini<img src='/community/emoticons/emotion-2.gif' alt=':d' />rivername=MSSQLServer'?
Yes, all instances are the same SP. I have tried stopping and restarting the services but that did not work. How do you know when the...
I know this question has been asked before but maybe someone has some new experience of it now. I have lost my SQL Server performance monitor...
Don't use OR if you can help it. SQL Server is not the best at optimising queries to use the best selection of indexes with OR statements in them. We...
We have ben forced to adopt changing the recovery model immediately before running our DBReindex jobs. We back up logs immediately before changing...
Having all DBs on the same instance will give us problems with managing user access to specific databases. Our support people do not want all the...
If I hard wire each instance to its own processor do you think that would alleviate the issue with the O/S continually switching processes? Or do...
Does anyone know of any issues when running multiple istances of SQL2k on WIN2K? We are defining a deployment that will be as follows: Hardware...
I have had something similar in a job that Microsoft recommended to monitor blocking. In the end I had to run the exact same job that created the...
The job step is documented by SQL Enterprise manager as follows: EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 1,...
There are no nvarchar or nchar columns in the job
I do not have access to the job but having spoken to the guy that developed it the job is based around a single step. This step calls a stored...
Latin1_General_Cl_AS Thanks
When running a job through SQL Agent I am outputting the results to a file by setting an output file for the individual job step. By default SQL...
No I did not see any locking on either database. I have found that it appears to spawn 4 threads of execution regardless of what processors are...
Has anyone else experienced anything like this? I am attempting to import an Oracle database into SQL2K using DTS. I am running SQL2K sp3 and the...
Separate names with a comma.
