How can i catch errors like "Incorrect syntax near..." when i execute dynamic sql ?
@@ERROR isn't helping me in this case.
I cheked and I didn't find objects on the filegroup.
from ( select name ,
( SELECT s.groupname FROM dbo.sysfilegroups s,...
The version of SQL : SQL Server 2000 Enterprise Edition (sp3)
I added 'GO' after the DBCC statement and it still doesn't work (same error).
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) ?
I will try to tune the DB/Server according yours replies,
and I will inform you about actions taken and results.
Thanks you all,
This is an example for connection string with Application Name:<br /><br />Provider=SQLOLEDB.1;Integrated Security=SSPI<img...
The service pack on SQL is SP3 and same for OS.
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....
After I killed the installation before I installed it again (without choose AUTOSTART services for MSSQLServer & MSSQLAgent) I unistalled it.
3) I installed SQL 2000 Enterprise Edition and when it stick:
b) Kill installation via Task Manager.
The rest exasctly as you write (LuisMatin and...
Thanks you all,
I didn't get error message during the installtion.
I didn't find erorrs in SQLSTP.LOG
The installation was stucked in (because it tried to...
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...
Thanks you all
You can use the NEWID function (return type: uniqueidentifier),
more details in BOL.
Which services must be started when installing SQL Server 2000 ?
A backup databse contain all objects in the database including user level previlages,
After restored On Machine 2, fix the matching between users and...
Separate names with a comma.