Consistency errors on virtualized SQL 2000 SP4 servers
Did anyone experience problems with SQL Server 2000 SP4 and consistency errors on o 2003 R2 x64 guest OS. CHECKDB shows databases corrupt, the next run they are clean, then they might become corrupt again. We are banging our heads against the wall to find a solution for this problem. We have this problem with [...]
Answer Question
| May 19, 2010 5:46 PM
ESX 3.5, ESX Server 3.5 Update 4, Microsoft SQL Server 2000, SQL 2000, SQL Server 2000 SP4, Virtualization in 2010
Did anyone experience problems with SQL Server 2000 SP4 and consistency errors on o 2003 R2 x64 guest OS. CHECKDB shows databases corrupt, the next run they are clean, then they might become corrupt again. We are banging our heads against the wall to find a solution for this problem. We have this problem with [...]
Answer Question
| May 19, 2010 5:46 PM
ESX 3.5, ESX Server 3.5 Update 4, Microsoft SQL Server 2000, SQL 2000, SQL Server 2000 SP4, Virtualization in 2010
SSRS blank columns
am having a problem with SSRS dropping columns from the datasource if the cell in the first row is blank. Is there a configuration setting that causes this? I don’t want to crete a dummy first row that has something in every column in order for the reports to work. The data is coming in [...]
Answer Question
| May 12, 2010 5:43 PM
SSRS 2005, SSRS reports, XML
am having a problem with SSRS dropping columns from the datasource if the cell in the first row is blank. Is there a configuration setting that causes this? I don’t want to crete a dummy first row that has something in every column in order for the reports to work. The data is coming in [...]
Answer Question
| May 12, 2010 5:43 PM
SSRS 2005, SSRS reports, XML
How to Make Fixed Row Table
Hi all My question is that i want to make the table which will accept only 500 row. even it could not accept 501th row. i mean to say i can’t accept at the time of insertion not on fetch time
Answer Question
| May 13, 2010 7:35 AM
SQL Server, SQL Server 2008, SQL tables
Hi all My question is that i want to make the table which will accept only 500 row. even it could not accept 501th row. i mean to say i can’t accept at the time of insertion not on fetch time
Answer Question
| May 13, 2010 7:35 AM
SQL Server, SQL Server 2008, SQL tables
Is an existing BI solution required to use the BI capabilities of SQL Server R2?
Is an existing BI solution required to use the BI capabilities of SQL Server R2?
Answer Question
| May 12, 2010 6:30 PM
Business Intelligence, SQL Server 2008 R2, SQL Server 2008 R2 Features
Is an existing BI solution required to use the BI capabilities of SQL Server R2?
Answer Question
| May 12, 2010 6:30 PM
Business Intelligence, SQL Server 2008 R2, SQL Server 2008 R2 Features
oracle 9i in windows 7
i installed oracle 9i in windows 7 os,and i open sql plus and login as scott and tiger it gives authentication fail message,pls help me,same i installed in win xp it works fine,one of my frnd says oracle 9i doesnot works on win7,he formatted win 7 and installed win XP
Answer Question
| October 10, 2011 10:09 AM
Oracle 9i, Oracle 9i installation errors, SQL Plus, Windows 7
i installed oracle 9i in windows 7 os,and i open sql plus and login as scott and tiger it gives authentication fail message,pls help me,same i installed in win xp it works fine,one of my frnd says oracle 9i doesnot works on win7,he formatted win 7 and installed win XP
Answer Question
| October 10, 2011 10:09 AM
Oracle 9i, Oracle 9i installation errors, SQL Plus, Windows 7
About MCTS 70-432 Certification
Hi Sir, I got to know whether i should get the training from any of the study center for the certification or will it do if i continue with the selfbased training and then appear for the certification .Is the certification that difficult that i have to join a regular training session ,as m on [...]
Answer Question
| May 19, 2010 7:26 AM
IT training and certifications, mcts 70-432 certification, SQL Server
Hi Sir, I got to know whether i should get the training from any of the study center for the certification or will it do if i continue with the selfbased training and then appear for the certification .Is the certification that difficult that i have to join a regular training session ,as m on [...]
Answer Question
| May 19, 2010 7:26 AM
IT training and certifications, mcts 70-432 certification, SQL Server
Cost to Upgrade to SQL Server 2008 R2
How much will it cost to upgrade from SQL 2005 to the 2008 R2?
Answer Question
| January 28, 2011 8:15 PM
SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008 R2
How much will it cost to upgrade from SQL 2005 to the 2008 R2?
Answer Question
| January 28, 2011 8:15 PM
SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008 R2
Managed Self Service Approach to BI
How can the “managed self service’ approach to BI benefit my organization?
Answer Question
| May 10, 2010 8:13 PM
Business Intelligence, SQL Server 2008 R2
How can the “managed self service’ approach to BI benefit my organization?
Answer Question
| May 10, 2010 8:13 PM
Business Intelligence, SQL Server 2008 R2
Are ITKE and MicrosoftExpert just shills for Microsoft?
Is it just me, or are ”ITKE” and “MicrosoftExpert” just using this forum to promote Microsoft SQL Server products? ITKE posts a leading question. MicrosoftExpert posts a reply (that reads suspiciously like Microsoft marketing bumf). ITKE marks the “solution” as “Approved”. Is this an appropriate use of this forum?
Answer Question
| May 14, 2010 8:29 PM
Marketing, Microsoft, SQL Server
Is it just me, or are ”ITKE” and “MicrosoftExpert” just using this forum to promote Microsoft SQL Server products? ITKE posts a leading question. MicrosoftExpert posts a reply (that reads suspiciously like Microsoft marketing bumf). ITKE marks the “solution” as “Approved”. Is this an appropriate use of this forum?
Answer Question
| May 14, 2010 8:29 PM
Marketing, Microsoft, SQL Server
SQL Server Log Shipping 2005 to 2008
Does anyone know if i can logship from a sql server 2005 to a sql server 2008?
Answer Question
| May 10, 2010 7:07 PM
Backup and recovery software, SQL Server 2005, SQL Server 2005 log shipping, SQL Server 2008, SQL Server backup
Does anyone know if i can logship from a sql server 2005 to a sql server 2008?
Answer Question
| May 10, 2010 7:07 PM
Backup and recovery software, SQL Server 2005, SQL Server 2005 log shipping, SQL Server 2008, SQL Server backup
Performance benchmarks for SQL Server 2008 R2
Have performance benchmarks for SQL Server 2008 R2 been published somewhere?
Answer Question
| May 7, 2010 8:25 PM
SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring
Have performance benchmarks for SQL Server 2008 R2 been published somewhere?
Answer Question
| May 7, 2010 8:25 PM
SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring
Do I need to remove SQL Server 2005 to install SQL Server 2008 R2?
Do I need to do a complete removal of 2005, as tried that on a new Windows Web server 2008, as wanted to put 2008 SQL Server.
Answer Question
| May 7, 2010 8:23 PM
SQL Server 2005, SQL Server 2005 to SQL Server 2008 R2 Upgrade, SQL Server 2008 R2, SQL Server 2008 R2 installation
Do I need to do a complete removal of 2005, as tried that on a new Windows Web server 2008, as wanted to put 2008 SQL Server.
Answer Question
| May 7, 2010 8:23 PM
SQL Server 2005, SQL Server 2005 to SQL Server 2008 R2 Upgrade, SQL Server 2008 R2, SQL Server 2008 R2 installation
SQL Server 2008 R2 provides direct integration with Oracle Database
Does SQL server 2008 provide direct integration with the databases built-in within an oracle DB?
Answer Question
| May 7, 2010 8:20 PM
Oracle Database, SQL Server 2008 R2, SQL Server 2008 R2 and Oracle, SQL Server 2008 R2 Features, SQL Server 2008 R2 Integration
Does SQL server 2008 provide direct integration with the databases built-in within an oracle DB?
Answer Question
| May 7, 2010 8:20 PM
Oracle Database, SQL Server 2008 R2, SQL Server 2008 R2 and Oracle, SQL Server 2008 R2 Features, SQL Server 2008 R2 Integration
SQL Server 2008 R2 fully supported by Visual Studio Team Database 2008 or 2010?
Is R2 fully supported by Visual Studio Team Database 2008 or 2010?
Answer Question
| May 7, 2010 8:17 PM
SQL Server 2008 R2, SQL Server 2008 R2 Benefits, Visual Studio 2010, visual studio team Database 2008
Is R2 fully supported by Visual Studio Team Database 2008 or 2010?
Answer Question
| May 7, 2010 8:17 PM
SQL Server 2008 R2, SQL Server 2008 R2 Benefits, Visual Studio 2010, visual studio team Database 2008
What is the process to upgrade a database from SQL Server 2000 to SQL Server 2008 R2?
What is the process to upgrade a database from 2000 to 2008?
Answer Question
| May 7, 2010 8:15 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2008 R2, SQL Server 2008 R2, SQL Server Upgrade
What is the process to upgrade a database from 2000 to 2008?
Answer Question
| May 7, 2010 8:15 PM
SQL Server 2000, SQL Server 2000 to SQL Server 2008 R2, SQL Server 2008 R2, SQL Server Upgrade
Can you explain Master Data Services
Can you explain Master Data Services?
Answer Question
| May 7, 2010 8:13 PM
Master Data Services, SQL Server 2008 R2, SQL Server 2008 R2 Features
Can you explain Master Data Services?
Answer Question
| May 7, 2010 8:13 PM
Master Data Services, SQL Server 2008 R2, SQL Server 2008 R2 Features
SQL Server 2005 Express SP3 Memory Usage
Upon Startup of my system the sqlwriter process immediately grabs 700mb of RAM and holds it. As I use the SQL Server to do different thing the memory usage grows and causes the memory on my system to decline. The SQL Server never releases the memory and it causes my system to respond slowly. I [...]
Answer Question
| May 6, 2010 12:50 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server memory, SQL writer
Upon Startup of my system the sqlwriter process immediately grabs 700mb of RAM and holds it. As I use the SQL Server to do different thing the memory usage grows and causes the memory on my system to decline. The SQL Server never releases the memory and it causes my system to respond slowly. I [...]
Answer Question
| May 6, 2010 12:50 PM
SQL Server 2005, SQL Server 2005 Express, SQL Server memory, SQL writer
embedding sql to rpgle
couldd someone pls help me wid generating week number of a year in rpgle. i guess its done thru embedding sql into rpgle pls help
Answer Question
| May 11, 2010 11:47 AM
AS/400, Embedded SQL, RPGLE, SQL Server
couldd someone pls help me wid generating week number of a year in rpgle. i guess its done thru embedding sql into rpgle pls help
Answer Question
| May 11, 2010 11:47 AM
AS/400, Embedded SQL, RPGLE, SQL Server
data type alter Error
Hi, m getting an Error when m converting a charater type to a numeric type ie to int or float through ALTER COLUMN command ERROR IS: Cannot convert a char value to money. The char value has incorrect syntax. The statement has been terminated.
Answer Question
| May 6, 2010 11:28 AM
Character Set change, SQL Server
Hi, m getting an Error when m converting a charater type to a numeric type ie to int or float through ALTER COLUMN command ERROR IS: Cannot convert a char value to money. The char value has incorrect syntax. The statement has been terminated.
Answer Question
| May 6, 2010 11:28 AM
Character Set change, SQL Server
BACKUP in SQL SERVER
Hello Sir, Can u get me the answer to this question Management wants the backups to be done daily. Transaction log backups must be every afternoon and morning and that you should keep in mind that the content of the log will get larger and larger. You also need to take measure to do the log file. [...]
Answer Question
| May 7, 2010 6:21 AM
SQL Server backup, SQL Server logs
Hello Sir, Can u get me the answer to this question Management wants the backups to be done daily. Transaction log backups must be every afternoon and morning and that you should keep in mind that the content of the log will get larger and larger. You also need to take measure to do the log file. [...]
Answer Question
| May 7, 2010 6:21 AM
SQL Server backup, SQL Server logs
