How can i catch errors like "Incorrect syntax near..." when i execute dynamic sql ?
@@ERROR isn't helping me in this case.
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...
How can I tell by registry key (Not by Query)
what is the sql server version on server (Enterprise or Standard Edition) ?
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....
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
I tried to install SQL Server 2000 (Ent' Edition)
on Dell Machine with Windows Advance Server.
The installation failed until I changed during...
Which services must be started when installing SQL Server 2000 ?
My MSSQLServerOLAPServiceis (sp3) crashing and than restarted again, and so forth.
I sucsessed to find one of my cube that make the above...
I read about sqldumper.exe utilty (userdump file ???)
There is someone that can explain me clearly about it?
Thanks in advance,
I have Advance Server with 4 GB of Phisical Memory,
How much (max) memory I need to allocate to the sql server (Enterprise Edition) ?
I am using Veritas Netbackup 4.5 to (remote) backup my databases,
sometimes, I have backup problems...
The veritas people didn't find...
How can I get the space used on specific filegroup?
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.
Separate names with a comma.