InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 08 Nov 2009 01:09:58 GMT20http://www.sqlservercentral.com/Forums/Topic815477-146-1.aspxDear all,We have just been given a 64bits server for our db and web site with 4 processors and 8Gbs mem!Amazing stuff to us...However, I just noticed that the sql server installed is 32 bits and does not use AWE to allocate memory.On a 32bits OS, this would limit our sql server to a 2Gbs footprint (unless we boot with the /3Gbs flag).What about a 64bits OS??? Are we still limited to that 2Gbs footprint? Or are we limited to 3 or 4Gbs unless we use AWE?Looking into Task Manager, it looks like our Sql Server process uses 3 700 000Mbs...Obviously, I'd like to use more memory. Is it simply a case of setting up the Max Server Memory to something like 5500 (since we share the box with the web server) and switching the AWE flag on?ThanksEricSat, 07 Nov 2009 14:45:26 GMTEric Mamethttp://www.sqlservercentral.com/Forums/Topic815522-146-1.aspxHI All sql 2005 service pack2. once i have restored the db from backup file, after while accessing the analysis service the error displayed like below*error occuerrd in olap storation (files'mdinfo.cpp' function mdinfo::init)*...indexes*...tblsales...plz anyone rectify the error.Thanks & RegardsMicheal.Sat, 07 Nov 2009 22:55:51 GMTantomichealhttp://www.sqlservercentral.com/Forums/Topic815348-146-1.aspxHi,From BOL,[quote]Performing the initial role changeTo set up a failover to the secondary database, perform the following steps:Disable the log shipping backup job on the original primary server.Disable the copy and restore jobs on the original secondary server.Perform a manual failover from the primary database to the secondary database.Use SQL Server Management Studio to configure log shipping on your new primary server and log ship to the remaining secondary servers. When doing so, you must ensure the following:[b]Use the same share for creating backups as that of the original primary server.[/b]Use the original primary database name when adding the secondary database in the Secondary Database Settings dialog box.Select the No, The Secondary Database Is Initialized option in the Secondary Database Settings dialog box[/quote]In above, what happens if we do NOT have the same share for creating backups as that of the original primary server? Is it MANDATORY for a role change?Because, we have the back share local to the primary server..and I cannot use the same backup share while initialize Log shipping from Secondary to Primary in process of role change. Instead I can use another backup share on secondary & configure log shipping But I want to know is that supported or not?[quote]Changing server rolesYou can change the roles of the primary database and the secondary database by performing the following steps:1)Bring the secondary database online after making a backup of the transaction log on the primary server by using the NORECOVERY option.2)Disable the log shipping backup job on the original primary server.3)Disable the copy and restore jobs on the original secondary server.4)Restore the backup on the secondary server by using the RECOVERY option.5)Enable the log shipping backup job on the new primary server.5)Enable the copy and restore jobs on the new secondary server.[/quote]In above, the backup taken at step1(tail backup of primary) should be applied at step4 right?thanksSat, 07 Nov 2009 01:05:11 GMTMani-584606http://www.sqlservercentral.com/Forums/Topic815302-146-1.aspxif the logfile is 100 percent full and there is no harddisk space,in this time is it possible to shrink the logfile?if it is not possible how can we resolve this problem?Regards,KiranKumar PFri, 06 Nov 2009 21:36:28 GMTkiranmca24http://www.sqlservercentral.com/Forums/Topic815394-146-1.aspxHello, I am running the following: sp_msforeachdb @command1= "PRINT '?' EXEC ?.dbo.sp_helprolemember db_owner" this is providing me the correct results but I am unable to get it to display the database name with the result set? I would like to have something showing the Database name above then the permissions below each name for each result. DatabaseName DbRole MemberName MemberSID db_owner dbo 0x01 My issue is I need to generate a report for Auditing that shows every DB with each user that has DBO rights to that DB. If I can get that in a single report that would be even better. Thanks,Sat, 07 Nov 2009 06:13:11 GMTJ.Colehttp://www.sqlservercentral.com/Forums/Topic809786-146-1.aspxHi,I have Maintenance plan created on the database server which basically takes a backup daily and deletes the previous days backup file.Also, the log files are getting generated in D:\Program Files\Microsoft SQL Server\MSSQL\LOG folder.I can see all the log files which are getting generated .I have pasted the log file which has generated on 10/27/2009 and 10/28/2009.IF you see at the end of log1 , it clearly says unable to delete the backup files.Similarly, if you see the end of log2 , it says the old file is deleted successfully.The problem is, every alternate day the job is getting failed and we are getting and receiving an email saying that the backup has failed, but the actually the backup is being done successfully but was unable to delete the preivous day backup (RETENTION PERIOD = 1 DAY).How to trouble shoot this issue. One its working fine able to delete the prvious day bkp, but on the next it is unable to delete the previous day backup!!!!! Can anyone figure out why it is happening so. Also, find the attached screen shot for RETENTION period of 1 day.In the Notification section/TAB of the job, we are logging into Windows Event viewer incase of job failure.But i cannot see any log entry in the Event Viewer. This is obvious, because the job contains three 3 steps ,and it is getting Failed at step1 which fails at deleting the backup and goes to step3 which sends an Email saying "backup failed" ====================================log1 generated on 10/27/2009====================================Starting maintenance plan 'All Application DBs' on 10/27/2009 9:30:00 PM[1] Database ActionOI_CDI: Database Backup... Destination: [E:\SQLDUMP\CDI_db_200910272130.BAK] ** Execution Time: 0 hrs, 0 mins, 1 secs **[2] Database ActionOI_CDI: Verifying Backup... ** Execution Time: 0 hrs, 0 mins, 1 secs **[3] Database ActionOI_CG: Database Backup... Destination: [E:\SQLDUMP\CDI_db_200910272130.BAK] ** Execution Time: 0 hrs, 1 mins, 37 secs **[4] Database ActionOI_CG: Verifying Backup... ** Execution Time: 0 hrs, 0 mins, 38 secs **[15] Database ActionOI_Template: Delete Old Backup Files... Unable to delete file E:\SQLDUMP\CDI_db_200910262132.BAK. 0 file(s) deleted.Deleting old text reports... 1 file(s) deleted.End of maintenance plan 'All Application DBs' on 10/27/2009 9:42:28 PMSQLMAINT.EXE Process Exit Code: 1 (Failed)================================log2 generated on 10/28/2009===============================[11] Database ActionOI_CDI: Delete Old Backup Files... 1 file(s) deleted.[12] Database ActionOI_CG: Delete Old Backup Files... 1 file(s) deleted.[13] Database ActionOI_Queue: Delete Old Backup Files... 1 file(s) deleted.[14] Database ActionOI_RptLog: Delete Old Backup Files... 1 file(s) deleted.[15] Database ActionOI_Template: Delete Old Backup Files... 1 file(s) deleted.Deleting old text reports... 1 file(s) deleted.End of maintenance plan 'All Application DBs' on 10/28/2009 3:00:09 AMSQLMAINT.EXE Process Exit Code: 0 (Success)Below is the script which i have generated from GUI DECLARE @JobID BINARY(16) DECLARE @ReturnCode INT SELECT @ReturnCode = 0 IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'Database Maintenance') < 1 EXECUTE msdb.dbo.sp_add_category @name = N'Database Maintenance' -- Delete the job with the same name (if it exists) SELECT @JobID = job_id FROM msdb.dbo.sysjobs WHERE (name = N'DB Backup Job for DB Maintenance Plan ''DB Maintenance Plan ActionOI_Template''') IF (@JobID IS NOT NULL) BEGIN -- Check if the job is a multi-server job IF (EXISTS (SELECT * FROM msdb.dbo.sysjobservers WHERE (job_id = @JobID) AND (server_id <> 0))) BEGIN -- There is, so abort the script RAISERROR (N'Unable to import job ''DB Backup Job for DB Maintenance Plan ''DB Maintenance Plan ActionOI_Template'''' since there is already a multi-server job with this name.', 16, 1) GOTO QuitWithRollback END ELSE -- Delete the [local] job EXECUTE msdb.dbo.sp_delete_job @job_name = N'DB Backup Job for DB Maintenance Plan ''DB Maintenance Plan ActionOI_Template''' SELECT @JobID = NULL END BEGIN -- Add the job EXECUTE @ReturnCode = msdb.dbo.sp_add_job @job_id = @JobID OUTPUT , @job_name = N'DB Backup Job for DB Maintenance Plan ''DB Maintenance Plan ActionOI_Template''', @owner_login_name = N'sa', @description = N'No description available.', @category_name = N'Database Maintenance', @enabled = 1, @notify_level_email = 0, @notify_level_page = 0, @notify_level_netsend = 0, @notify_level_eventlog = 2, @delete_level= 0 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback -- Add the job steps EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 1, @step_name = N'Step 1', @command = N'EXECUTE master.dbo.xp_sqlmaint N''-PlanID FC8F5D33-E6BD-4E61-BEAD-6BD563620322 -Rpt "d:\Program Files\Microsoft SQL Server\MSSQL\LOG\All Application DBs4.txt" -DelTxtRpt 4DAYS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "E:\SQLDUMP" -DelBkUps 1DAYS -CrBkSubDir -BkExt "BAK"''', @database_name = N'master', @server = N'', @database_user_name = N'', @subsystem = N'TSQL', @cmdexec_success_code = 0, @flags = 4, @retry_attempts = 0, @retry_interval = 0, @output_file_name = N'', @on_success_step_id = 2, @on_success_action = 4, @on_fail_step_id = 3, @on_fail_action = 4 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 2, @step_name = N'SendSuccess', @command = N'sendemail -f healthcare.prod@ABC.com -t babu@ABC.com;RAM@ABC.COM -cc XYZ@abc.com;traj@abc.com -u Backup Succeeded on DBSERVER01 -m Backup has been completed successfully -s 192.168.1.103', @database_name = N'', @server = N'', @database_user_name = N'', @subsystem = N'CmdExec', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id = 3, @step_name = N'SendFailed', @command = N'sendemail -f healthcare.prod@ABC.com -t babu@ABC.com;RAM@ABC.COM -cc XYZ@abc.com;traj@abc.com -u Backup Failed on DBSERVER01 -m Backup job failed please check -s 192.168.1.103', @database_name = N'', @server = N'', @database_user_name = N'', @subsystem = N'CmdExec', @cmdexec_success_code = 0, @flags = 0, @retry_attempts = 0, @retry_interval = 1, @output_file_name = N'', @on_success_step_id = 0, @on_success_action = 1, @on_fail_step_id = 0, @on_fail_action = 2 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback -- Add the job schedules EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id = @JobID, @name = N'Schedule 1', @enabled = 1, @freq_type = 8, @active_start_date = 20060410, @active_start_time = 213000, @freq_interval = 126, @freq_subday_type = 1, @freq_subday_interval = 0, @freq_relative_interval = 0, @freq_recurrence_factor = 1, @active_end_date = 99991231, @active_end_time = 235959 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback -- Add the Target Servers EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @JobID, @server_name = N'(local)' IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback ENDCOMMIT TRANSACTION GOTO EndSave QuitWithRollback: IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION EndSave: Thanks in advanceWed, 28 Oct 2009 04:09:26 GMTmahesh.vsphttp://www.sqlservercentral.com/Forums/Topic815367-146-1.aspxHi,We have SQL Server 2005 EE 62 bit with SP3. I'm trying to find out how our production database indexes are getting fragmented. Until now I'm using the Maintenance Plan Index rebuild task to rebuild all indexes for all databases on weekly basis. But, reading from SSC forums & Articles I came to know that first we need to find out what database,what tables & what indexes are getting fragmented and based on that we can use better scripts to rebuild/reorganize indexes instead of blindly using Maintenance Plan Index rebuild task.I have executed the below query to check the Index fragmentation:SELECT avg_fragmentation_in_percent, page_count FROM sys.dm_db_index_physical_stats (5, NULL, NULL, NULL, NULL)where avg_fragmentation_in_percent>30 AND page_count>1000Results:avg_fragmentation_in_percent [i]page_count[/i]92.4914675767918 [i]2292[/i]94.9044585987261 [i]2480[/i]98.8165680473373 [i]1318[/i]97.7777777777778 [i]1028[/i]44.8773448773449 [i]16612 [/i] And then I used the below Script(found in BOL), to defragment the Index[quote]-- Ensure a USE statement has been executed first.SET NOCOUNT ON;DECLARE @objectid int;DECLARE @indexid int;DECLARE @partitioncount bigint;DECLARE @schemaname nvarchar(130);DECLARE @objectname nvarchar(130);DECLARE @indexname nvarchar(130);DECLARE @partitionnum bigint;DECLARE @partitions bigint;DECLARE @frag float;DECLARE @command nvarchar(4000);-- Conditionally select tables and indexes from the sys.dm_db_index_physical_stats function-- and convert object and index IDs to names.SELECT object_id AS objectid, index_id AS indexid, partition_number AS partitionnum, avg_fragmentation_in_percent AS fragINTO #work_to_doFROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'LIMITED')WHERE avg_fragmentation_in_percent > 10.0 AND index_id > 0;-- Declare the cursor for the list of partitions to be processed.DECLARE partitions CURSOR FOR SELECT * FROM #work_to_do;-- Open the cursor.OPEN partitions;-- Loop through the partitions.WHILE (1=1) BEGIN; FETCH NEXT FROM partitions INTO @objectid, @indexid, @partitionnum, @frag; IF @@FETCH_STATUS < 0 BREAK; SELECT @objectname = QUOTENAME(o.name), @schemaname = QUOTENAME(s.name) FROM sys.objects AS o JOIN sys.schemas as s ON s.schema_id = o.schema_id WHERE o.object_id = @objectid; SELECT @indexname = QUOTENAME(name) FROM sys.indexes WHERE object_id = @objectid AND index_id = @indexid; SELECT @partitioncount = count (*) FROM sys.partitions WHERE object_id = @objectid AND index_id = @indexid;-- 30 is an arbitrary decision point at which to switch between reorganizing and rebuilding. IF @frag < 30.0 SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REORGANIZE'; IF @frag >= 30.0 SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD'; IF @partitioncount > 1 SET @command = @command + N' PARTITION=' + CAST(@partitionnum AS nvarchar(10)); EXEC (@command); PRINT N'Executed: ' + @command; END;-- Close and deallocate the cursor.CLOSE partitions;DEALLOCATE partitions;-- Drop the temporary table.DROP TABLE #work_to_do;GO[/quote]After running the above script, I ran the below query to make sure the Indexes were defragmented. But I'm getting the same results as before running the Above Index defragment scriptSELECT avg_fragmentation_in_percent, page_count FROM sys.dm_db_index_physical_stats (5, NULL, NULL, NULL, NULL)where avg_fragmentation_in_percent>30 AND page_count>1000Results:avg_fragmentation_in_percent [i]page_count[/i]92.4914675767918 [i]2292[/i]94.9044585987261 [i]2480[/i]98.8165680473373 [i]1318[/i]97.7777777777778 [i]1028[/i]44.8773448773449 [i]16612 [/i] Why after running the Index defragment script, the indexes were NOT defragmented? Please advice me?many thanksSat, 07 Nov 2009 03:05:31 GMTMani-584606http://www.sqlservercentral.com/Forums/Topic815386-146-1.aspxHi, The sql server 2005 performance is very slow between 2 to 4 PM even there are very limited users. The client screens loading time taking long. It is working regularly at other times and after restarting the server . The server is IBM server X-226 series (Xeon Procesor 3 GHZ(dual),2 GM RAM,140 GB Hard disk). It will be helpful if you suggest any solution to the above problem.Thanking You,S. Govindaraj.Sat, 07 Nov 2009 04:37:38 GMTsgrajhttp://www.sqlservercentral.com/Forums/Topic814132-146-1.aspxi need the substring from a column in such a way that i should get the string from 9th to 16th.below qury is throwing error.pls adviseSELECT SUBSTRing(description,select charindex ('[', description)from PublishItem,--9select charindex (']', description)from PublishItem--16)FROM PublishItemWHERE description like '%Doc No%'Thu, 05 Nov 2009 05:08:27 GMTshanila_minnuhttp://www.sqlservercentral.com/Forums/Topic815038-146-1.aspxHi all, is there a way to tell when the recovery model of a database was changed and by whom?ThanksFri, 06 Nov 2009 09:50:39 GMTKwisatz78http://www.sqlservercentral.com/Forums/Topic815258-146-1.aspxHi everybody. I have a problem I am connecting to Database with user 'rpp' and when execute this code: EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Administrator', @recipients = 'lisset.arce@ewong.com', @file_attachments = 'D:\SQLoutput\OLD_cobranza.txt', @subject = 'Prueba RIMAC - Detalle de Cobranza' Show the follow error:Servidor: mensaje 22051, nivel 16, estado 1, línea 0The client connection security context could not be impersonated. Attaching files require an integrated client loginThe user rpp have the el role DatabaseMailUserRole.Maybe I have to activate something?Thanks for your helpFri, 06 Nov 2009 16:42:42 GMTLissethttp://www.sqlservercentral.com/Forums/Topic815304-146-1.aspxWhat is the use of Import and Export?Fri, 06 Nov 2009 21:37:30 GMTkiranmca24http://www.sqlservercentral.com/Forums/Topic815301-146-1.aspxhow to move masterdatabase ldf and mdf files from one drive to another drive.so plz send me document by using steps.Regards,kirankumar pFri, 06 Nov 2009 21:34:28 GMTkiranmca24http://www.sqlservercentral.com/Forums/Topic811677-146-1.aspxHi All, I need your opinion in this matter. I have a table with 200Millions of records. We dont need to read the data in production. We only run reports for the last 90 days.I was thinking in do Partitions, but since we dont need the old data and my Server has only 2 drives. I think it wont be a performance if i try to do some queries in that particular table.I created an archiving process to Insert/Delete per trimester, so I can run the reports that I need. I created a new database called ArchiveDB. This ArchiveDB has tables per trimester and I have a Job that runs every 3 months to insert/Delete the data.Questions:1) Do you think this is a good way to Archive data?2) Is there any faster process to Insert/Delete data? My process take 1 hour approx to do this. I know it runs every 3 months at midnight, but I dont want the process to take that long. The process is simple, I identify the month to be processed and it will storage everything in the right table. Then the process will delete the data from the original table.3) what is the best way to query the archive data. The union statement??I appreciate your advicesRegards,Fri, 30 Oct 2009 09:17:54 GMTMTY-1082557http://www.sqlservercentral.com/Forums/Topic815022-146-1.aspx Need to be able to display Polish special characters - ż ł ś ę ź etc - I'm told that Proper display of such characters requires UTF-8 encoding. Where or how do I get a list of what the availbale Database collations are ?Fri, 06 Nov 2009 09:38:43 GMTJpotucekhttp://www.sqlservercentral.com/Forums/Topic814585-146-1.aspxBIDS Tx. Jobs task doesn't work as maint plans don't get tx. to the target MSDB db. I have had issues in importing packages to the target server, Is there any other way, I have got 4 servers where I need to tx. them to, & thought if there is a easier way.Thu, 05 Nov 2009 14:50:32 GMTSQLRockerhttp://www.sqlservercentral.com/Forums/Topic814982-146-1.aspxI have been reading every articule regarding partitioning and I havent seen anything about create filegroups, files, partition function for "future storage".I mean. I would like to know if I can create filegroups, files and partition function from now to 6 months in advance. So the data will storage in the proper filegroup. Is this posible and good for SQL ? so i dont have to split/merge every monthFri, 06 Nov 2009 09:09:23 GMTMTY-1082557http://www.sqlservercentral.com/Forums/Topic799622-146-1.aspxMy company are virtualising EVERYTHING. Anyway long story short - we have a piece of hardware running 2 virtualised servers. Lets call them A and B. When a stored procedure runs on A it KILLS B literally to the point it grinds to a halt. Very intensive stored proc I must admit.Our network guys looked on the vmware console and tried to blame the sql config as the CPU useage (quad core) was not even and each core was at a different %.I want them to set it so that if A needs resources it will get all but x amount so that it doesn't actually kill the server!Anyway away from that - Its SQL 2K5 Enterprise 64 bit. I have not set a max memory. I don't think its running with "Lock pages in memory" set. Do you think these 2 settings would help?Wed, 07 Oct 2009 17:25:00 GMTShark Energyhttp://www.sqlservercentral.com/Forums/Topic814120-146-1.aspxOn MS SQL Server 2000 EE (SP4), we have 4 SQL Server instances configured. On One instance (having 18 databases) we are facing this problem:- A few configured scheduled backup jobs got failed in last two days with message : "Downgrading backup buffers from 960K to 64K"On checking, it was found that Full backup step got succeeded and only transactional backup step got failed.Now, as per suggestions on MS KB Link at http://support.microsoft.com/kb/904804/en-uI have tried to take the Transactional backup using following query, by reducing Maxtransfersize to 128KB, but failed with message "nsufficient Memory to run this query". backup log Dirman to disk='D:\LatestBkp\Dirman.trn'with maxtransfersize=131072Note: It has 19 backup devices (for Trn and BAK) defined for this instance. Please guide in this regard.With regards,AnkurThu, 05 Nov 2009 04:33:03 GMTankur_librahttp://www.sqlservercentral.com/Forums/Topic815013-146-1.aspxOk, our company just went through an external audit and I got flagged for not having my SQL log files locked. They said that I need to have each log file protected, so they can not be altered by anyone. I know the initial 'errorlog' is locked while it is being used, but what is the best route for locking the other log files; errorlog.1 -> errorlog.6. Is there an application that I can run that would keep these files from being edited until they are deleted? Is there a setting in SQL I do not know about? I don't want to get into a manual process, as that would be a maintenance nightmare with so many servers. I am not sure where to begin on this, so I thought I would ask what you guys are doing and how you protect your sql log files. Thanks in Advance!Fri, 06 Nov 2009 09:33:24 GMTmontgomerybrothershttp://www.sqlservercentral.com/Forums/Topic814969-146-1.aspxHi,is it possible to pass the servername as parameter to SQLCMD.For eg: SQLCMD -E -S %servername% -i <input file> -o <output file>servername is the parameter which i wish to pass..This is basically to get some information from mulitple servers using SQLCMDany help is appreciated!!!Thanks!!!Fri, 06 Nov 2009 08:49:57 GMTkarthik -450760http://www.sqlservercentral.com/Forums/Topic815043-146-1.aspxHello Rooms,I have a table that will only storage information as follows: • Project • Non-ProjectIf Project was selected, it should link to Project tables.If Non-Project selected, it should link to DocumentType table.Can someone give me some hints how to design on ER?Many thanks.EdwinFri, 06 Nov 2009 09:57:42 GMTEdwin-376531http://www.sqlservercentral.com/Forums/Topic814405-146-1.aspxHi Gail, I hope you can find it this time!Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=68247348,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=160771680,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=224771908,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=356248374,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=372248431,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=388248488,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=404248545,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=420248602,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=436248659,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=452248716,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=468248773,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=484248830,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=500248887,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=516248944,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=532249001,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=548249058,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=564249115,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=580249172,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=596249229,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=612249286,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1076250939,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1204251395,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1284251680,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1316251794,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1332251851,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1348251908,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1428252193,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1460252307,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1476252364,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1492252421,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1524252535,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1604252820,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1620252877,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=2119730654,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=224771908,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=356248374,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=372248431,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=388248488,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=404248545,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=420248602,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=436248659,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=452248716,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=468248773,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=484248830,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=500248887,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=516248944,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=532249001,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=548249058,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=564249115,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=580249172,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=596249229,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=612249286,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1076250939,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1268251623,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1284251680,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1316251794,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1396252079,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1460252307,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1604252820,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1620252877,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1451152215,referenced_minor_id=8) of row (class=0,object_id=1316251794,column_id=0,referenced_major_id=1451152215,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=1451152215,column_id=8) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1451152215,referenced_minor_id=8) of row (class=0,object_id=1284251680,column_id=0,referenced_major_id=1451152215,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=1451152215,column_id=8) in sys.columns.CHECKDB found 0 allocation errors and 62 consistency errors not associated with any single object.CHECKDB found 0 allocation errors and 62 consistency errors in database 'hrptest'.Thu, 05 Nov 2009 10:14:14 GMTjulia.streatfieldhttp://www.sqlservercentral.com/Forums/Topic814072-146-1.aspxHi all.There is heavily loaded OLTP system under Sql Server 2008 Standart Edition. Database has some big tables. My question is about hard disk configuration. Database has problems with I/O (Latches). I have addition RAID and a think about dividing database. There are different options in my mind:- Move big tables on additional RAID- Move indexesHelp me, what is better.I already moved TempDb on separate diskThu, 05 Nov 2009 02:13:11 GMTsuvoravhttp://www.sqlservercentral.com/Forums/Topic815015-146-1.aspxHi there,On our SQL2005 SSRS box when i view running processes in activity monitor, the Memory Usage values are all either 0,2 or 3.I am investigating performance issues on this server and trying to rule out any red-herrings; Is this normal for SQL2005?I work in a mostly SQL2000 environment and running processes on these boxes show variable ammounts of memory usage.version info: Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) Any help in this matter is much appreciated,many thanksFri, 06 Nov 2009 09:34:35 GMTbaldehttp://www.sqlservercentral.com/Forums/Topic814606-146-1.aspxOur SQL server recently suffered a problem which cause the wholedatabase is not accessible. After checking SQL Server log, I found 2009-11-05 00:29:35.27 spid4 Process ID 60:289 owns resources that are blocking processes on Scheduler 0.I have run a Profiler trace on the database and caught the processappears in the error message. The process is a select query which isspecified in a read uncommited transaction. So I assume there is nolock to the database when running the query. When the error happens,the whole sql server is not accessible and no activities running atall according to profiler trace.I have checked MS knowledge base. there is article about this error.But it says there are many causes to the problem, which is not reallythat helpful :(Is the process id sepcified the in the error message is the processcausing the problem? Can someone point out any other possible causes andsolutions? We are running SQL Server 2000 sp4, standard edition.Many thanks!FrankThu, 05 Nov 2009 15:42:10 GMTfrankruihttp://www.sqlservercentral.com/Forums/Topic814117-146-1.aspxHi,Iam a junior DBA, i want to know how to deploy database objects from development server to production server.ThanksKoteswar RaoThu, 05 Nov 2009 04:27:36 GMTy.koteswarrao-652921http://www.sqlservercentral.com/Forums/Topic814529-146-1.aspxHi All,I executed the below query in SQL Server 2005.if 1=3BEGIN select [Job_id], [name], [freq_interval] from msdb..sysjobschedules where freq_type = 8ENDThis should not give any result as the condition 1 =3 does not match. But when, I execute this, I get the following error :w00t:Msg 207, Level 16, State 1, Line 5Invalid column name 'freq_type'.Msg 207, Level 16, State 1, Line 5Invalid column name 'name'.Msg 207, Level 16, State 1, Line 5Invalid column name 'freq_interval'. I am aware that these columns does not exist in the sysjobschedules table in SQL Server 2005. But, I think as per my query, since the conditions are not met, this error should not occur at all.Please correct me if i am wrong.... Thu, 05 Nov 2009 13:19:22 GMTkarthik -450760http://www.sqlservercentral.com/Forums/Topic682088-146-1.aspxhello can anyone suggest some site from i can download free video tutorial for learning sql server, creating assembly.,reporting etcTue, 24 Mar 2009 00:09:22 GMTshiwani2002sghttp://www.sqlservercentral.com/Forums/Topic814504-146-1.aspxI have a requirement for SQL Server audit trails and security to store a years worth of audit data through Error logs being copied/archived for later reading if necessary.How best to automate this process. I know that the ERRORLOG files are rolled over (recycled) after so many have been written.Is there a way to automate this process? I did see the "Archiving SQL Server Error Logs" article on SQLServerCentral.com site, but that is a copy of one ERRORLOG file and is not automatic as far as knowing when to copy the file before it is lost or moved down in the ERRORLOG.# order.Thanks,Zee - AtlantaThu, 05 Nov 2009 12:50:41 GMTZeeAtlhttp://www.sqlservercentral.com/Forums/Topic814565-146-1.aspxHi all,I'm having trouble deleting my 'maintenance plans'. I get the following error:[b]Exeption has been thrown by the target of an invocation. (mscorlib)Additional information:An error was encountered when trying to remove the package "Maintenance Plans\backup" from SQL Server. An error was encountered when trying to remove the package "Maintenance Plans\backup" from SQL Server.[/b]I am using MS SQL 2005 SP3, running MS Server 2003 SP2.[u]Note:[/u] I have renamed the Server name, but I have read on other discussion forums that SQL would automatically detect the change and "fix itself". I have checked the connection properties and the server name under "Product" and "Server Environment" is correct there.---I have attempted the following:[i]Re-register the dts.dll file. On the server, open a command prompt and type: regsvr32 dts.dll[/i]Any help would be appreciated. ThanksThu, 05 Nov 2009 14:17:00 GMTgrustnihttp://www.sqlservercentral.com/Forums/Topic814820-146-1.aspxHas anyone actually managed to install SQL Server 2005 Standard 64bit on Windows 2008 Server Standard 64 Bit ? I mean actually done it in practice, rather just looked at the Microsoft Compatibility list ?I have made sure the server has met all the requirements including IIS.Everything ticked to be installed.SP2 then installed (SP3 Now tried as well).However only the SQL Server 2005 configuration tools appear.I have found these posts which have a similiar issue, but they are for web server not standard: http://decoding.wordpress.com/2008/04/18/how-to-install-sql-server-2005-on-windows-server-2008/The fix will only install on web server 2008 not standard. Is there a fix for Windows Server 2008 Standard? Repeated on another server (spec) same issue.Fri, 06 Nov 2009 04:34:51 GMTMarvinTheAndriodhttp://www.sqlservercentral.com/Forums/Topic806297-146-1.aspxHi All,Can anyone share the check list for Migrating the sql 2000 databases to sql server 2005.What are steps involved from scratch to migrate the 2000 databases to 2005.Also, would like to know the Pre-requistes and Post - migration steps before actaully going to LIVE.what kind of measures should be taken while migrating logins, jobs ,dts packages to 2005, Alerts, replication measures, service accounts etc...Would appreciate sincere replies.Thanks in AdvanceWed, 21 Oct 2009 01:36:07 GMTmahesh.vsphttp://www.sqlservercentral.com/Forums/Topic814772-146-1.aspxFor example how to know how which table is making the maximum contribution in I/O?Fri, 06 Nov 2009 02:48:53 GMTsuvoravhttp://www.sqlservercentral.com/Forums/Topic814771-146-1.aspxHi,I am running SQL 2005 64-bit on a server. On that server we have the engine, analysis services and reporting services running on v3215 (SP2 CU5). SSIS is running 3042 (SP2). Management Studio version is 3042 and the Native client is 3042.My local machine I use to administer is a 32bit Management Studio running 3042 (sp2).Having different versions everywhere - is this an issue?Fri, 06 Nov 2009 02:47:48 GMTShark Energyhttp://www.sqlservercentral.com/Forums/Topic814698-146-1.aspxHi guys,After installing SP3 on sql 2005Do i need to install all CUs 1 by 1 Or i need to install only latest CU ?My doubt is whether the latest CU contains all the previous CUs or not?Thu, 05 Nov 2009 22:18:12 GMTsanketahir1985http://www.sqlservercentral.com/Forums/Topic814054-146-1.aspxiam from production , databse went dowm due to 100% increase of space in mdf file . how can we bring thwe database up ?Thu, 05 Nov 2009 00:47:45 GMTramyours2003http://www.sqlservercentral.com/Forums/Topic799875-146-1.aspxOn loads of our sql servers the devs are struggling with issues such as -Query takes 10 minutes to run at best. Suddenly takes 3 hours to run.We have an overnight task where some nights a step with the same number of rows and criteria can take 1 hour ot 6 hours.How do you go about tackling this? (I've cleared my whiteboard and I'm starting from scratch because I'm getting nowhere so start as simple as you like!)Thanks,SharkThu, 08 Oct 2009 05:17:35 GMTShark Energyhttp://www.sqlservercentral.com/Forums/Topic814481-146-1.aspxHi EveryoneIn my SQL 2005 production environment I have a director that is wanting to be able to view the properties of any of his team's databases. His read access of course is not enough and I don't want him to be able to change any of the properties of the databases.Is there a way to lock down in DBO so he only has the ability to see but not change anything in the database? He only wants to see the properties of every database.TITLE: Microsoft SQL Server Management Studio------------------------------Cannot show requested dialog.------------------------------ADDITIONAL INFORMATION:Cannot show requested dialog. (SqlMgmt)------------------------------An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------User 'adptestone' does not have permission to run DBCC showfilestats for database 'APEX'. (Microsoft SQL Server, Error: 7983)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4053&EvtSrc=MSSQLServer&EvtID=7983&LinkId=20476Thu, 05 Nov 2009 12:11:46 GMTLowry Kozlowskihttp://www.sqlservercentral.com/Forums/Topic814614-146-1.aspxI have a sql 2000 server (version may not be relevant...)I am restoring a database to it. On restoring the database, there is at least 1 table (could be more - which is worrying as this server goes live to the world next week if tested) that is giving very strange behaviour.If I run a simple Update statement on the table, it locks everything up. Everything, even unrelated objects, lock up behind it. If I see the command on DBCC INPUTBUFFER it doesn't list the t-sql it simply has the word "PASSWORD" (I am updating a txtPassword field, but I have not seen this result from dbcc inputbuffer before....).It eventually times out, or I have to kill it.Now if I DROP and RECREATE the table, then repopulate the data via a dts import, the UPDATE statement runs in seconds and the table is back to normal.What gives?Thu, 05 Nov 2009 16:20:17 GMTShark Energy