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...
I cheked and I didn't find objects on the filegroup. select name,FG 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). Oryan
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
I will try to tune the DB/Server according yours replies, and I will inform you about actions taken and results. Thanks you all, Oryan
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. 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....
After I killed the installation before I installed it again (without choose AUTOSTART services for MSSQLServer & MSSQLAgent) I unistalled it. I...
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, Oryan
Hello 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...
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...
New installation. Oryan
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
Hi You can use the NEWID function (return type: uniqueidentifier), more details in BOL. Oryan
Hello Which services must be started when installing SQL Server 2000 ? Oryan
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.
