Hello, How can i catch errors like "Incorrect syntax near..." when i execute dynamic sql ? @@ERROR isn't helping me in this case. Thanks in...
Hello, I try to remove a filegroup from my database, before that I removed all objects from the filegroup and then I executed the script in blue and...
Hello, How can I tell by registry key (Not by Query) what is the sql server version on server (Enterprise or Standard Edition) ? Thanks, Oryan
Hello This is what I found in my Errorlog (MSSQL2000(sp3)-WINSRV2000): WARNING: EC 2e181550, 0 waited 300 sec. on latch 19cfc0f4. Not a Buf latch....
Hello I have a table with 14,000,000 rows (80 GB) and I would like to add one column with datatype image. ALTER TABLE TableName ADD...
I tried to install SQL Server 2000 (Ent' Edition) on Dell Machine with Windows Advance Server. The installation failed until I changed during...
Hello Which services must be started when installing SQL Server 2000 ? Oryan
Hello My MSSQLServerOLAPServiceis (sp3) crashing and than restarted again, and so forth. I sucsessed to find one of my cube that make the above...
Hello, I read about sqldumper.exe utilty (userdump file ???) There is someone that can explain me clearly about it? Thanks in advance, Oryan
Hello, I have Advance Server with 4 GB of Phisical Memory, How much (max) memory I need to allocate to the sql server (Enterprise Edition) ? and How...
Hello, I am using Veritas Netbackup 4.5 to (remote) backup my databases, sometimes, I have backup problems... The veritas people didn't find...
Hello, How can I get the space used on specific filegroup? Thanks, Oryan
Hello, I have table with 122GB space used and I need to execute DBCC DBREINDEX on the table, the table stored in filegroup with size of 124GB. There...
Separate names with a comma.
