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
SQL Server Help
Hi all, I am running into a little bit of a problem. I need to insert records with a stored procedure into a table based on the information selected. From the info selected, it decides what table to insert it into. Example: Select top 1 SerialNo from dbo.Serial –returns ‘ASEEADL1234567′ based on the 8th letter [...]
Answer Question
| March 31, 2012 8:36 PM
INSERT SELECT statement, SQL Records, SQL Server, SQL Server administration, Stored Procedures
Hi all, I am running into a little bit of a problem. I need to insert records with a stored procedure into a table based on the information selected. From the info selected, it decides what table to insert it into. Example: Select top 1 SerialNo from dbo.Serial –returns ‘ASEEADL1234567′ based on the 8th letter [...]
Answer Question
| March 31, 2012 8:36 PM
INSERT SELECT statement, SQL Records, SQL Server, SQL Server administration, Stored Procedures
Open IT Forum: Will HP be a worthy cloud contender?
HP announced its Cloud Services program in beta and we wanted to know initial reactions. Have you registered for the beta? Share your initial thoughts, whether or not you have, and we’ll return to this in the next phase of HP’s cloud services. Share your thoughts and we’ll share 50 Knowledge Points!
Answer Question
| March 31, 2012 8:24 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, CRM, Database, DataCenter, Development, Exchange, Hewlett-Packard, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
HP announced its Cloud Services program in beta and we wanted to know initial reactions. Have you registered for the beta? Share your initial thoughts, whether or not you have, and we’ll return to this in the next phase of HP’s cloud services. Share your thoughts and we’ll share 50 Knowledge Points!
Answer Question
| March 31, 2012 8:24 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, CRM, Database, DataCenter, Development, Exchange, Hewlett-Packard, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Ageing Report T-SQL
Im trying to write a query to retrive debtors ageing report in sql I have two tables [strong]1. Billing(billAmount,BillDate,AccountNo)[/strong] [strong]2.Payments(payAmount,payDate,AccountNo)[/strong] I need the output to show ageigng [strong]0-30, 31-60, 61-90, 91+[/strong] with the balances for each period The Billing table is pre-populated with the charges per month as per the amortization schedule when a client [...]
Answer Question
| March 31, 2012 1:29 PM
MSSQL, SAP Aging Reports, SQL 2005, T-SQL
Im trying to write a query to retrive debtors ageing report in sql I have two tables [strong]1. Billing(billAmount,BillDate,AccountNo)[/strong] [strong]2.Payments(payAmount,payDate,AccountNo)[/strong] I need the output to show ageigng [strong]0-30, 31-60, 61-90, 91+[/strong] with the balances for each period The Billing table is pre-populated with the charges per month as per the amortization schedule when a client [...]
Answer Question
| March 31, 2012 1:29 PM
MSSQL, SAP Aging Reports, SQL 2005, T-SQL
Free IT Book: Essential Skills for the Agile Developer
The team at Net Objectives (including CEO Alan Shalloway) has compiled the essential skills for the Agile developer. To get this resource and guide to better programming and design, simply answer one of five questions and paste the link to your answer in the discussion section below. Ultrium 4, data size in tape? Entire System [...]
Answer Question
| March 31, 2012 12:56 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
The team at Net Objectives (including CEO Alan Shalloway) has compiled the essential skills for the Agile developer. To get this resource and guide to better programming and design, simply answer one of five questions and paste the link to your answer in the discussion section below. Ultrium 4, data size in tape? Entire System [...]
Answer Question
| March 31, 2012 12:56 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
