Hello. Actually I'm using an UDF to retrive a simple string value. So in my procs I have some code like: declare @Ret varchar(30) select @Ret =...
Hi. I was trying run Maintenance Database Wizard, with the Rebuild Index option. The main objective is reduce fragmentation It is a 70GB database,...
But it is a SAP database, with more or less 40000 tables (this structure scrares me, in SQL 2000 just sysobjects is a 120000 lines in 35MB..), so I'm...
Hi. I'm doing some performance tests, and I need to split a 90gb database in 3 datafiles. I created the others datafiles, and of course they are...
I finished a SQL2000 to SQL2005 (in the same server) upgrade, but I noticed that my MASTER database is still in SQL2000 compatibilty level. MSDB,...
Hello. I put this topic in SQL2000 forum, but I'm planning upgrade SQL Server next month. Considering a database with 80GB (datafile), using a 1+0...
Hi. Considering a database with 80GB (datafile), using a 1+0 array: What the best configuration to a performance gain, use 2 files 40gb in the same...
Hi. My problem: Server01 (SQL Server 2000) and Server02 (SQL Server 2000) are diferent machines, but need talk together. I have some procs in...
OK, I enabled firewall, the Warning of Component Services appears. And I found another "problem". RPC security changed....
Hi. I've installed windows xp service pack 2 in a adm machine, since this I cant' see Componentes Services -> Transactions Statistics from a remote...
Recently I executed the MS Best Practices Analyzer in my test server, and the report analysis alerted to me to configure the following options for...
I have this problem when I change "Reserve physical memory" from Enterprise Managers (I'm using dynamically memory allocation), its ask me about...
OK, I alredy tried this, but if I change the query, the proc returns an error (xp_printstatements: error during statement retrieval and decoding), so...
Hi I need to buil a custom replication monitor, but there are some doubts: 1 - I know SQL Server 2000 store replicated text command in...
I will try. Need I install the SQL Server SP too? Esio Nunes
The error is: Internet Explorer script error: There is an error in this page. Line: 307 Char: 2 Error: error don't especified Code: 0 URL:...
The problem is on my station, at the server there is ok. I'm using IE 6.0 sp2 with XP Pro sp1. Esio Nunes
Hi. I'm geting a script error (like IE javascript error) when I put my databases setup-show to show in taskpad. Evertime I need to configure it to...
I have a table with a indentiy colum as primary key. There are anothers 2 indexes in others columns I will only insert data in that table. I'll never...
Satya, I can place the log file in a different disk. My question is, if I put one Tlog in each disk I have "a performace". But if I put many Tlogs in...
Separate names with a comma.
