SOP for cleaning Server rooms
Hi there, I have been tasked with organizing cleaning of comms, IDF, MDF rooms at our offices. This includes: removing dust from racks, actually all surfaces – cleaning floor , light fixtures etc. Does anyone have a SOP / Method statement of how this should be carried out? Does it require specialized company or can...
| December 31, 2013 5:05 PM
Scheduling join queries in AS/400
I have an AS/400 join query that runs across 5 tables. I need to get it to run programmatically via scheduled CL scripts. I’m trying to make it work using RUNQRY, but that only shows the query itself, not the results. How can I make this work?
| December 17, 2013 4:26 PM
, CL script
Help joining data into table 1 from table 2 SQL
I have 2 tables, table1 has columns A,B,C,D and table2 has columns B,C,D, I want to update table1 column A with table2 column B, where table1 c,d matches table2 b,c. I hope that was clear.
| November 6, 2013 8:35 PM
, update query
SQL Server 2000 backup failed
can not backup a 2000 db, dbcc checkdb ok. see following: Errorlog: 2008-01-08 09:54:40.69 spid62 Starting up database 'CP2005'. 2008-01-08 09:54:41.00 backup BACKUP failed to complete the command BACKUP DATABASE [education] TO DISK = N'C:fjs1education_db_200801080954.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT 2008-01-08 10:19:18.34 backup BACKUP failed to complete the command...
| October 22, 2013 6:51 PM
, SQL Server 2000
, SQL Server 2000 Desktop Engine
full text search in sql server 2000
can anyone tell me how I can get full text search to work in SQL Server 2000 ? Ive installed it, created a catalogue, selected a table (with a primary key) stepped through the wizard, in fact followed all instructions to the letter. When I run this query SELECT * FROM guidance WHERE CONTAINS(Title, 'Cardiac')...
| October 14, 2013 3:48 PM
full text search
, SQL Server 2000
SQL Server 2005 ‘alter user’
Hello, I have been trying to run the following instruction in QA use database_name alter user db_user_name with login = [domainlogin_name] but keep getting the error Msg 102, Level 15, State 1, Line 3 Incorrect syntax near ‘login’. I know this method exist in SQL Server 2005, are any of you able to run the...
| October 14, 2013 12:45 PM
, SQL Server 2005
, SQL Server errors
Using JOIN in SQL Server 2012
I’m trying to create a list of all our employees by last name with their dependents by first name, and birth dates. My output columns are emp_last_name from the employee table and dep_name and dep_date_of_birth. Here is what I’ve specifically been tasked with doing: Use alias table names. Name each column appropriately Sort the result...
| September 17, 2013 6:59 PM
, SQL Server 2012