Open IT Forum: Does the Windows 8 secure boot and Linux clash affect you?
We want to know how this “little” inconvenience is affecting the world of Linux users out there. Air your grievances or worries for the future of Linux right here, and we’ll send you 50 Knowledge Points!
Answer Question
| March 31, 2012 5:20 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows 8, Windows Server
We want to know how this “little” inconvenience is affecting the world of Linux users out there. Air your grievances or worries for the future of Linux right here, and we’ll send you 50 Knowledge Points!
Answer Question
| March 31, 2012 5:20 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows 8, Windows Server
Challenge improving query performance on large tables
Hi, Here’s the structure of the db I’m using: * Table frs_ArticlesBDFournisseur which contains article main data.One row per article/color. Key is Refrefart (int). Size is over 220000 rows at the momemt. Only index is the PK (clusterred). * Table frs_ArticlesBDFournisseurTaille contains all the various sizes and barcode for the corresponding article/color from the previous [...]
Answer Question
| March 31, 2012 2:21 PM
Query optimization, Query performance, SQL query optimization, SQL Server 2008, SQL Server 2008 R2
Hi, Here’s the structure of the db I’m using: * Table frs_ArticlesBDFournisseur which contains article main data.One row per article/color. Key is Refrefart (int). Size is over 220000 rows at the momemt. Only index is the PK (clusterred). * Table frs_ArticlesBDFournisseurTaille contains all the various sizes and barcode for the corresponding article/color from the previous [...]
Answer Question
| March 31, 2012 2:21 PM
Query optimization, Query performance, SQL query optimization, SQL Server 2008, SQL Server 2008 R2
How to configure parameters display in SSRS 2008?
Hi, I know it wasn’t possible in ssrs 2005 to have parameters displayed into more than 2 columns. My question is has it be solved in ssrs 2008r2 ? If yes, how can I do it ? If no, is there a possibility to walk around this issue ? Many thanks, Sonia
Answer Question
| March 31, 2012 11:29 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2008
Hi, I know it wasn’t possible in ssrs 2005 to have parameters displayed into more than 2 columns. My question is has it be solved in ssrs 2008r2 ? If yes, how can I do it ? If no, is there a possibility to walk around this issue ? Many thanks, Sonia
Answer Question
| March 31, 2012 11:29 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS 2008
SSRS authentication in workgroup environment
Can a workgroup be configured to authenticate to reporting services to run reports? If so, could someone please assist me in this security setup as we are currently experiencing difficulty. Our Windows 7 “server” authenticates fine but none of the current client computers are able. Thank you.
Answer Question
| March 31, 2012 2:51 PM
Reporting Services, Reporting Services Configuration Manager, SSRS, Windows 7, Workgroup Servers, Workgroups
Can a workgroup be configured to authenticate to reporting services to run reports? If so, could someone please assist me in this security setup as we are currently experiencing difficulty. Our Windows 7 “server” authenticates fine but none of the current client computers are able. Thank you.
Answer Question
| March 31, 2012 2:51 PM
Reporting Services, Reporting Services Configuration Manager, SSRS, Windows 7, Workgroup Servers, Workgroups
connecting to SQL server with mdf files
What is the best way to connect a website on a VPS to sql server 2008 R2 express, using MDF files as databases. The VPS is running on server 2008 R2. I installed the same environment on the development computer. IIS gets a connection because it sees the users that are in the ASPNETDB.MDF file. [...]
Answer Question
| March 31, 2012 12:52 AM
.MDF files, SQL Server 2008, SQL Server 2008 R2
What is the best way to connect a website on a VPS to sql server 2008 R2 express, using MDF files as databases. The VPS is running on server 2008 R2. I installed the same environment on the development computer. IIS gets a connection because it sees the users that are in the ASPNETDB.MDF file. [...]
Answer Question
| March 31, 2012 12:52 AM
.MDF files, SQL Server 2008, SQL Server 2008 R2
sys.conversation_endpoints build up
It Seems that there is a lot of problems with SB cleanup? I have SQL 2008 r2 running on two different servers. The target system processes the millions of records in the queues but will not clean out the sys.conversation_endpoints, or the sys.conversation_endpoints tables. This is part of the activation proc that is run on [...]
Answer Question
| March 31, 2012 11:40 PM
SQL Server 2008, SQL Server 2008 R2, SQL Server Service Broker, SQL Service Broker
It Seems that there is a lot of problems with SB cleanup? I have SQL 2008 r2 running on two different servers. The target system processes the millions of records in the queues but will not clean out the sys.conversation_endpoints, or the sys.conversation_endpoints tables. This is part of the activation proc that is run on [...]
Answer Question
| March 31, 2012 11:40 PM
SQL Server 2008, SQL Server 2008 R2, SQL Server Service Broker, SQL Service Broker
Reg:Problem with SSAS
Hi team, This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I [...]
Answer Question
| March 31, 2012 2:17 PM
SQL Server 2005, SQL Server 2008, SQL Server migration, SSAS, SSAS 2005
Hi team, This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I [...]
Answer Question
| March 31, 2012 2:17 PM
SQL Server 2005, SQL Server 2008, SQL Server migration, SSAS, SSAS 2005
Use of database backup from lower version to higher version of sqlserver
I am using sqlserver 2000, have a database of 2GB. I want to shift at higher version 2008. What I have to do TO upload my Old version-2000 database backup into sqlserver 2008
Answer Question
| March 31, 2012 6:18 AM
SQL Server 2000, SQL Server 2008, SQL Server database
I am using sqlserver 2000, have a database of 2GB. I want to shift at higher version 2008. What I have to do TO upload my Old version-2000 database backup into sqlserver 2008
Answer Question
| March 31, 2012 6:18 AM
SQL Server 2000, SQL Server 2008, SQL Server database
Updating SQL 2000 Data
Hi I have a database with test card numbers, I have encrytpted the card numbers and updated the database, when i run a card scanner program on my MDF file it still finds the cards that i have updated. how can i get rid of these permanently. I have a deadline to apply this same principle [...]
Answer Question
| March 31, 2012 3:56 PM
MDF File, SQL 2000, SQL Data Set, SQL Database
Hi I have a database with test card numbers, I have encrytpted the card numbers and updated the database, when i run a card scanner program on my MDF file it still finds the cards that i have updated. how can i get rid of these permanently. I have a deadline to apply this same principle [...]
Answer Question
| March 31, 2012 3:56 PM
MDF File, SQL 2000, SQL Data Set, SQL Database
Announcing the HP Elite Series Scavenger Hunt (sponsored)
Today is the first day of the HP Elite Series Scavenger Hunt, designed to better educate potential customers about all of the great qualities that make HP Elite Series “elite.” For details on how to enter check out the HP Elite Series Scavenger Hunt homepage. The Loot Grand Prize: 5 HP EliteBook 8460w (Yes, five!) [...]
Answer Question
| March 31, 2012 2:19 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, EliteBook, Exchange, Giveaways, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Scavenger Hunt, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Today is the first day of the HP Elite Series Scavenger Hunt, designed to better educate potential customers about all of the great qualities that make HP Elite Series “elite.” For details on how to enter check out the HP Elite Series Scavenger Hunt homepage. The Loot Grand Prize: 5 HP EliteBook 8460w (Yes, five!) [...]
Answer Question
| March 31, 2012 2:19 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, EliteBook, Exchange, Giveaways, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Scavenger Hunt, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Add/Rename SQL Server 2005 Server Name
Hi experts, I have am trying to rename and add new server name to Microsoft SQL server 2005. I as using following steps for rename step 1. select @@servername ‘ for seeing current server name step 2. sp_dropserver ‘ray’ ‘ for deleting current server step 3. sp_addserver ‘raynew’, local ‘ for adding new servername step [...]
Answer Question
| March 31, 2012 7:33 AM
SQL Server, SQL Server 2005, SQL Server name
Hi experts, I have am trying to rename and add new server name to Microsoft SQL server 2005. I as using following steps for rename step 1. select @@servername ‘ for seeing current server name step 2. sp_dropserver ‘ray’ ‘ for deleting current server step 3. sp_addserver ‘raynew’, local ‘ for adding new servername step [...]
Answer Question
| March 31, 2012 7:33 AM
SQL Server, SQL Server 2005, SQL Server name
Create new SQL 2008 database in external drive
My local server using SQL 2008 Express is running low on disk space. Is it possible to create new databases or move a database to an external drive? If so, how is it done, configuration wise? Thanks.
Answer Question
| March 31, 2012 4:00 PM
External Disk Drives, SQL Database, SQL Express, SQL Express 2008
My local server using SQL 2008 Express is running low on disk space. Is it possible to create new databases or move a database to an external drive? If so, how is it done, configuration wise? Thanks.
Answer Question
| March 31, 2012 4:00 PM
External Disk Drives, SQL Database, SQL Express, SQL Express 2008
Free IT Book: Official Cert Guide for CCNP Security SECURE 642-637
This week’s free IT book is just what you need if you’re planning to take your CCNP Security SECURE 642-637 certification exam. From exam topics and quizzes to exam prep tasks and realistic exam questions, the Official Cert Guide is a must for everyone preparing or planning to prepare for this certification. All you need [...]
Answer Question
| May 14, 2012 1:10 PM
AS/400, Business Intelligence, Certification preparation, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, Security certifications, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week’s free IT book is just what you need if you’re planning to take your CCNP Security SECURE 642-637 certification exam. From exam topics and quizzes to exam prep tasks and realistic exam questions, the Official Cert Guide is a must for everyone preparing or planning to prepare for this certification. All you need [...]
Answer Question
| May 14, 2012 1:10 PM
AS/400, Business Intelligence, Certification preparation, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, Security certifications, SQL Server, Storage, Virtualization, VoIP, Windows Server
Open IT Forum: Goals to round out 2011
We’re approaching the final quarter of 2011: What are some of your IT department’s goals to finish out the year? What are some of the things you are implementing to position yourself for 2012? Whether it’s updating your system documentation or updating your IT staff’s certifications, we want to know how the rest of your [...]
Answer Question
| March 31, 2012 12:57 PM
AS/400, Bounties, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
We’re approaching the final quarter of 2011: What are some of your IT department’s goals to finish out the year? What are some of the things you are implementing to position yourself for 2012? Whether it’s updating your system documentation or updating your IT staff’s certifications, we want to know how the rest of your [...]
Answer Question
| March 31, 2012 12:57 PM
AS/400, Bounties, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
t-sql and AS400
I want to develop a TSQL query. First I need to determine if all the numbers in one of the fields are in numerical order and also find the missing holes in the number sequence. Secondly I need to sort by another field and by a particular criteria. The words that I need to sort-by [...]
Answer Question
| March 31, 2012 12:34 PM
AS/400 Query, SQL, SQL Query, T-SQL
I want to develop a TSQL query. First I need to determine if all the numbers in one of the fields are in numerical order and also find the missing holes in the number sequence. Secondly I need to sort by another field and by a particular criteria. The words that I need to sort-by [...]
Answer Question
| March 31, 2012 12:34 PM
AS/400 Query, SQL, SQL Query, T-SQL
Data Fields outside of report section
I am looking at a previously written Crystal 8.5 report in which most of the data fields are outside of the report section. I can only see these fields if I reduce the report size to 50%. I have tried landscape orientation and adjusting the paper size to 11X17, but I still have many fields [...]
Answer Question
| March 31, 2012 4:45 PM
Crystal 8.5, Crystal Reports 8.5, SQL, SQL Reports
I am looking at a previously written Crystal 8.5 report in which most of the data fields are outside of the report section. I can only see these fields if I reduce the report size to 50%. I have tried landscape orientation and adjusting the paper size to 11X17, but I still have many fields [...]
Answer Question
| March 31, 2012 4:45 PM
Crystal 8.5, Crystal Reports 8.5, SQL, SQL Reports
Open IT Forum: IT’s role in customer service
One of ITKnowledgeExchange’s bloggers is working on a series about customer service in the enterprise, and how it can be improved. From the IT side, do you have any experiences or suggestions for improving how companies do customer service? We’ll take horror stories as well! Help a fellow IT Knowledge Exchanger out and we’ll give [...]
Answer Question
| March 5, 2013 1:08 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Customer service, Database, DataCenter, Development, Exchange, IT project management, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
One of ITKnowledgeExchange’s bloggers is working on a series about customer service in the enterprise, and how it can be improved. From the IT side, do you have any experiences or suggestions for improving how companies do customer service? We’ll take horror stories as well! Help a fellow IT Knowledge Exchanger out and we’ll give [...]
Answer Question
| March 5, 2013 1:08 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Customer service, Database, DataCenter, Development, Exchange, IT project management, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Free IT Book: The Python Standard Library by Example
This week’s free IT book is an essential addition to the developer’s library. If you want to master the powerful Python Standard Library through real code examples, this is the prize for you. Simply answer one of five questions and post the link to your answer in the discussion section below. Good luck! Installation error [...]
Answer Question
| March 31, 2012 12:59 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week’s free IT book is an essential addition to the developer’s library. If you want to master the powerful Python Standard Library through real code examples, this is the prize for you. Simply answer one of five questions and post the link to your answer in the discussion section below. Good luck! Installation error [...]
Answer Question
| March 31, 2012 12:59 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Visual Basic and SQL database design
i have vb.net & sql application sql database have one tabe with 37 column (there is no normalization) after runing the application more than three million of rows will enterd by users . I’m afraid it Will give a bad performance or have (out of memory massge) so i Made a solution (i make [strong]Queries(with vb.net wich [...]
Answer Question
| March 31, 2012 6:56 AM
Database design, SQL Database, VB.NET, Visual Basic, Visual Basic .NET
i have vb.net & sql application sql database have one tabe with 37 column (there is no normalization) after runing the application more than three million of rows will enterd by users . I’m afraid it Will give a bad performance or have (out of memory massge) so i Made a solution (i make [strong]Queries(with vb.net wich [...]
Answer Question
| March 31, 2012 6:56 AM
Database design, SQL Database, VB.NET, Visual Basic, Visual Basic .NET
problem in connect visual studio 2010 to SQL 2008
when i am connecting the sql in my visual studio windows application to open a database file a error occurred you don’t have the permission to open this file contact the file owner or administrator to obtain the permission
Answer Question
| March 31, 2012 11:47 PM
SQL 2008, SQL Server 2008, Visual Studio 2010
when i am connecting the sql in my visual studio windows application to open a database file a error occurred you don’t have the permission to open this file contact the file owner or administrator to obtain the permission
Answer Question
| March 31, 2012 11:47 PM
SQL 2008, SQL Server 2008, Visual Studio 2010
