How can I see SQL VIEW inside ?
Dear Friend, I see the VIEWS on AS/400 as logical file,but I don’t know wit which SQL it is created. How can I see the SQL Sentence of this VIEW ?
Answer Question
| November 9, 2010 1:32 PM
AS/400 SQL View, Logical Files, SQL View, SQLVIEW AS/400
Dear Friend, I see the VIEWS on AS/400 as logical file,but I don’t know wit which SQL it is created. How can I see the SQL Sentence of this VIEW ?
Answer Question
| November 9, 2010 1:32 PM
AS/400 SQL View, Logical Files, SQL View, SQLVIEW AS/400
Can I backup the entire SQL drive?
I have an application that uses SQL Express 2005. I will be upgrading the application and am planning for rollback should it be required. I have nightly database backups which also go to tape but I am wanting the entire hard drives of the server backed up to tape prior to the upgrade. As a [...]
Answer Question
| November 15, 2010 12:43 PM
Backup Exec, SQL Backup, SQL Express 2005, SQL Server, Veritas Backup Exec
I have an application that uses SQL Express 2005. I will be upgrading the application and am planning for rollback should it be required. I have nightly database backups which also go to tape but I am wanting the entire hard drives of the server backed up to tape prior to the upgrade. As a [...]
Answer Question
| November 15, 2010 12:43 PM
Backup Exec, SQL Backup, SQL Express 2005, SQL Server, Veritas Backup Exec
Connecting VC6 to SQL server
how can i connect VC++6 MFC application to SQL server? plz help m out!!
Answer Question
| November 2, 2010 5:04 PM
SQL Server, SQL Server connectivity, VC++, VC++ 6, VC6
how can i connect VC++6 MFC application to SQL server? plz help m out!!
Answer Question
| November 2, 2010 5:04 PM
SQL Server, SQL Server connectivity, VC++, VC++ 6, VC6
SQL Server error 7125: Updated driver to get around?
I have used Microsoft ODBC SQL Server Driver to create a link to an SQL table using Microsoft Access. The table stores Word documents. However Access will not save records once large pictures are added to the Word document (thus increasing the size of the document). The following error occurs: #7125: The text, ntext, or [...]
Answer Question
| November 2, 2010 5:32 AM
Access, ODBC, SQL Server, SQL Server error messages, SQL Server errors, SQLSRV32
I have used Microsoft ODBC SQL Server Driver to create a link to an SQL table using Microsoft Access. The table stores Word documents. However Access will not save records once large pictures are added to the Word document (thus increasing the size of the document). The following error occurs: #7125: The text, ntext, or [...]
Answer Question
| November 2, 2010 5:32 AM
Access, ODBC, SQL Server, SQL Server error messages, SQL Server errors, SQLSRV32
Using Excel 2010 to pull data from SQL Server?
How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.
Answer Question
| November 1, 2010 9:05 PM
Excel 2010, Excel Database, ODBC, SQL Server, SQL Server database
How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.
Answer Question
| November 1, 2010 9:05 PM
Excel 2010, Excel Database, ODBC, SQL Server, SQL Server database
Cannot forward events from SQL Server 2005
I’m trying to forward events from SQL Server 2005 SP3 to a different server, but the only server I can select is the local server. What must I do to see other servers in the Event Forwarding Server drop-down box?
Answer Question
| November 1, 2010 4:03 PM
SQL, SQL Server 2005, SQL Server 2005 SP3, SQL Server Agent
I’m trying to forward events from SQL Server 2005 SP3 to a different server, but the only server I can select is the local server. What must I do to see other servers in the Event Forwarding Server drop-down box?
Answer Question
| November 1, 2010 4:03 PM
SQL, SQL Server 2005, SQL Server 2005 SP3, SQL Server Agent
Migrating from Windows server 2003 32-bit to Windows Server 2008 64-bit
We are migrating from Windows server 2003 32bit to 2008 64 bit. What should we be aware of before progressing? What pitfalls or incompatibilities should we be prepared for? The server is an Active Directory box running SQL 2005.
Answer Question
| November 3, 2010 2:22 PM
Active Directory, SQL 2005, Windows Server 2003, Windows Server 2003 32-bit, Windows Server 2008, Windows Server 2008 64-bit, Windows Server Migrations and Upgrades, Windows Server Upgrades
We are migrating from Windows server 2003 32bit to 2008 64 bit. What should we be aware of before progressing? What pitfalls or incompatibilities should we be prepared for? The server is an Active Directory box running SQL 2005.
Answer Question
| November 3, 2010 2:22 PM
Active Directory, SQL 2005, Windows Server 2003, Windows Server 2003 32-bit, Windows Server 2008, Windows Server 2008 64-bit, Windows Server Migrations and Upgrades, Windows Server Upgrades
Documenting stored procedure jobs in SQL 2005 enterprise
Our consultant created several stored procedure jobs within SQL 2005 enterprise. How can we view them to document them? SQL runs on a Windows 2008 box with 32gb of memory.
Answer Question
| November 1, 2010 2:19 PM
SQL 2005, SQL procedure, SQL Server 2005, SQL Server 2005 Enterprise Edition, Stored Procedures, Windows Server 2008
Our consultant created several stored procedure jobs within SQL 2005 enterprise. How can we view them to document them? SQL runs on a Windows 2008 box with 32gb of memory.
Answer Question
| November 1, 2010 2:19 PM
SQL 2005, SQL procedure, SQL Server 2005, SQL Server 2005 Enterprise Edition, Stored Procedures, Windows Server 2008
cpyf and cpysplf: How to copy spool files and database files in AS/400?
Hi, Can you give me the what are the steps to copy the data from one pf to another pf using cpyf? and how to copy the data from spool file to database file using cpysplf?
Answer Question
| November 9, 2010 5:12 AM
AS/400 Spool Files, CPYF, CPYSPLF, Database Files, RPG
Hi, Can you give me the what are the steps to copy the data from one pf to another pf using cpyf? and how to copy the data from spool file to database file using cpysplf?
Answer Question
| November 9, 2010 5:12 AM
AS/400 Spool Files, CPYF, CPYSPLF, Database Files, RPG
Can’t log in after upgrading SQL Server 2005 express to SQL 2005 standard
I have upgraded SQL Server Express 2005 to Standard 2005. Every thing is updated and all Services are well running, But not able to login because I have got only Configuration Tools in Menu- Start->Programs->MSS 2005->Configuration Tools. and if I try through Run SQLWB,it’s shows not avalable. Kindly help how can I will get all [...]
Answer Question
| November 1, 2010 6:18 AM
SQL Server, SQL Server 2005 Standard Edition, SQL Server administration, SQL Server Express 2005, SQL Server Upgradation, SQL Server upgrades
I have upgraded SQL Server Express 2005 to Standard 2005. Every thing is updated and all Services are well running, But not able to login because I have got only Configuration Tools in Menu- Start->Programs->MSS 2005->Configuration Tools. and if I try through Run SQLWB,it’s shows not avalable. Kindly help how can I will get all [...]
Answer Question
| November 1, 2010 6:18 AM
SQL Server, SQL Server 2005 Standard Edition, SQL Server administration, SQL Server Express 2005, SQL Server Upgradation, SQL Server upgrades
Importing a “flat” field into a Lookup Table format in SQL database
* I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated…). * I have created a table called tblPurpose with the [...]
Answer Question
| November 5, 2010 10:54 PM
Access, SQL, SQL Database, SQL Query, SQL Records, SQL Server Flat File Input
* I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated…). * I have created a table called tblPurpose with the [...]
Answer Question
| November 5, 2010 10:54 PM
Access, SQL, SQL Database, SQL Query, SQL Records, SQL Server Flat File Input
How do I INSERT records into AS400 DB2 file from SQL server?
I can pull data from AS400 to SQL but cannot get my command on the SQL server to push the data back. This is a very small process, I only need an item number and date. Also, the date on the SQL db is “datetime”. I’ll need to convert that to a more recognizable date field [...]
Answer Question
| November 3, 2010 3:52 PM
AS/400, DB2/400, SQL Server, SQL Server 2005
I can pull data from AS400 to SQL but cannot get my command on the SQL server to push the data back. This is a very small process, I only need an item number and date. Also, the date on the SQL db is “datetime”. I’ll need to convert that to a more recognizable date field [...]
Answer Question
| November 3, 2010 3:52 PM
AS/400, DB2/400, SQL Server, SQL Server 2005
Deleted items folder retention policy on exchange 2007
How to set up retention policy for deleted item folder on exchange 2007? I would like to run the policy to empty the folder based on item age. Thank you.
Answer Question
| October 29, 2010 5:18 PM
Data Retention Policy, Deleted Items Retention Policy, Exchange 2007, Exchange policy management, Standard Edition
How to set up retention policy for deleted item folder on exchange 2007? I would like to run the policy to empty the folder based on item age. Thank you.
Answer Question
| October 29, 2010 5:18 PM
Data Retention Policy, Deleted Items Retention Policy, Exchange 2007, Exchange policy management, Standard Edition
Migrating SQL Server 2000 to SQL Server 2005
How can we migrate our sql server 2000 to sql server 2005 on another box? We have about 36 databases and it is around 65 terabytes of data on an external array. The array will be connected to the new server.
Answer Question
| January 6, 2011 3:21 PM
Array, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server Upgrade
How can we migrate our sql server 2000 to sql server 2005 on another box? We have about 36 databases and it is around 65 terabytes of data on an external array. The array will be connected to the new server.
Answer Question
| January 6, 2011 3:21 PM
Array, SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server Upgrade
SQL Server 2005 Enterprise Edition SP3 Performance
We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer cache the maximum memory is 28GB, the PAGEIOLATCH_SH [...]
Answer Question
| January 31, 2011 3:27 AM
SQL, SQL performance, SQL Server, SQL Server 2005, SQL Server 2005 SP3, SQL Server Enterprise Edition
We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer cache the maximum memory is 28GB, the PAGEIOLATCH_SH [...]
Answer Question
| January 31, 2011 3:27 AM
SQL, SQL performance, SQL Server, SQL Server 2005, SQL Server 2005 SP3, SQL Server Enterprise Edition
Write Record to table as XML from RecordSet destination
Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?
Answer Question
| October 27, 2010 3:19 PM
Recordset Destination, SQL Server, SQL Server Dataset, SSIS, XML
Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?
Answer Question
| October 27, 2010 3:19 PM
Recordset Destination, SQL Server, SQL Server Dataset, SSIS, XML
SQL SERVER 2005 Database Options
We have a database in production that is 500GB, what are the pros and cons for setting the ”Page Verify” option to ”NONE” on the database for best performance? How will ”TORN_PAGE_DETECTION” and “CHECKSUM” affect performance?
Answer Question
| October 28, 2010 3:08 PM
SQL, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database
We have a database in production that is 500GB, what are the pros and cons for setting the ”Page Verify” option to ”NONE” on the database for best performance? How will ”TORN_PAGE_DETECTION” and “CHECKSUM” affect performance?
Answer Question
| October 28, 2010 3:08 PM
SQL, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database
ESXi v4.1 White Box
I’m looking to put together a server to run ESXi v4.1. I’ve selected the following hardware components and would appreciate any advice/input good/bad: Case: Athena Power CA-SWH02BH7 Mobo: TYAN S8230GM4NR-DL PSU: Athena Power AP-P4ATXK110FEP CPU: AMD Opteron 6134 Magny-Cours 2.3GHz 64gig RAM: Kingston 8GB KVR1333D3E9SK2/8G x 8 2 500gig drives – RAID1: This partition will [...]
Answer Question
| October 27, 2010 1:18 PM
ESXi, SQL Server, Virtual Machines, VMware ESXi, Web servers, Windows Server 2008
I’m looking to put together a server to run ESXi v4.1. I’ve selected the following hardware components and would appreciate any advice/input good/bad: Case: Athena Power CA-SWH02BH7 Mobo: TYAN S8230GM4NR-DL PSU: Athena Power AP-P4ATXK110FEP CPU: AMD Opteron 6134 Magny-Cours 2.3GHz 64gig RAM: Kingston 8GB KVR1333D3E9SK2/8G x 8 2 500gig drives – RAID1: This partition will [...]
Answer Question
| October 27, 2010 1:18 PM
ESXi, SQL Server, Virtual Machines, VMware ESXi, Web servers, Windows Server 2008
Extracting in SQL Server 2005
IS THERE ANY WAY TO EXTRACT FROM A FIED EXAMPLE: I HAVE A ADDRESS LINE AS 1065 VALLEY LANE APT 120 SCHAUMBURG IL 60195 I NEED TO EXTRACT APT 120 INTO ANOTHER LINE LIKE APT 120 1065 VALLEY LANE SCHAUMBURG IL 60195
Answer Question
| October 27, 2010 1:17 PM
EXTRACT, Field-Level keywords, SQL 2005, SQL 2005 Database, SQL Server 2005
IS THERE ANY WAY TO EXTRACT FROM A FIED EXAMPLE: I HAVE A ADDRESS LINE AS 1065 VALLEY LANE APT 120 SCHAUMBURG IL 60195 I NEED TO EXTRACT APT 120 INTO ANOTHER LINE LIKE APT 120 1065 VALLEY LANE SCHAUMBURG IL 60195
Answer Question
| October 27, 2010 1:17 PM
EXTRACT, Field-Level keywords, SQL 2005, SQL 2005 Database, SQL Server 2005
SQL Server 2005 Memory
I have a server with 8 dual core processors, 32GB of RAM, windows server 2003 32bit, sql server 2005 enterprise, and a 500GB database running on it. 1. How does sql server use memory in this case? 2. I have heard from sql server pro’s that sql server can only use 4GB of RAM is that [...]
Answer Question
| October 26, 2010 1:54 PM
SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server memory
I have a server with 8 dual core processors, 32GB of RAM, windows server 2003 32bit, sql server 2005 enterprise, and a 500GB database running on it. 1. How does sql server use memory in this case? 2. I have heard from sql server pro’s that sql server can only use 4GB of RAM is that [...]
Answer Question
| October 26, 2010 1:54 PM
SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server memory
