Techniques for storing SQL Server data online and for backing up the server
For a banking application, I would like to keep 10 years worth of data using SQL Server. I would like to keep two years online and backup the other eight years. What are some techniques to do this?  

Answer Question   |  October 27, 2009  3:50 PM
Backup, Online Backup, SQL Server backup, SQL Server backup and restore

Database restore
I’m struggling with when is the right time to do my last transactional log backup before my full database backup. My question is this: if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm). If i have to restore the [...]

Answer Question   |  October 27, 2009  2:53 PM
Database backup and recovery, SQL Server 2005, SQL Server administration

MySQL database size
Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance?

Answer Question   |  October 26, 2009  5:45 PM
MySQL, PHP, PHP Coding, SQL, SQL Database

Converting SQL 7 Database to Excel
Hi, I would like to know any possible way of converting my Sql 7 Database to Excel formats. Any ideas anyone. Thanks

Answer Question   |  November 4, 2009  7:37 AM
Microsoft Excel, SQL, SQL 7, SQL to Excel Database Conversion

Windows Server 2003
i have a sever 2 G.B ram ,prosser Intel Xeon 3.0Ghz, i want to configare a domain controllar with using sql application server on that server i want to configare it domain along with sql application server . IS this configaration enough for both server or i needed to  improve configration . tell me please

Answer Question   |  October 27, 2009  3:44 PM
Domain Controller, SQL Application Server, Windows Server 2003

Auditing Windows 2003 and MS SQL 2005
Are there any audit scripts I can use to audit Windows 2003 and MS SQL 2005?

Answer Question   |  October 23, 2009  9:17 AM
IT auditing, IT security, SQL Server 2005, SQL Server Auditing, Windows Server 2003, Windows Server Auditing

Is having the auto create statistics on in a database a good thing?
Hello I have a 250GB database and the auto create statistics is on is that a good thing?

Answer Question   |  October 23, 2009  2:08 AM
SQL Server 2005, SQL Server administration, SQL Server performance, SQL Server performance tuning

Replication sync_method set to concurrent in SQL Server 2000
Hi, Just wondering what happens to data that are inserted during the time of a snapshot replication generation when the sync_method is set to concurrent, as there are no table locks, are the data insert into the publisher then held in the distribution database and when the snapshot has been completed, the data in the [...]

Answer Question   |  October 22, 2009  12:24 PM
SQL Server 2000, SQL Server database, SQL Server replication

STORED PROCEDURE
Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on  it  

Answer Question   |  October 21, 2009  5:14 AM
DB2, SQL stored procedures, SQL/400

MS Exchange on Server 2000 one user can receive but not send mail
One of my users reported that he is not able to send e-mail from his Outlook client.  I sent test messages from his Outlook client to both an internal and external address and did not receive eitehr message.  I sent him e-mail from both my internal and external e-mail addresses and they went through without [...]

Answer Question   |  October 30, 2009  7:54 PM
Exchange 2000, Outlook, Outlook 2003, Server 2000, Windows 2000 Server

The most-watched IT questions this week: Oct. 20, 2009
Here are the 5 most watched questions on ITKE: There’s some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, [...]

Answer Question   |  October 21, 2009  6:20 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Set identity to not for replication in T-SQL
Hi, Does anyone know the TSQL to change the identity column on a table in SQL Server 2000. And also the TSQL to change trigger to not for replication. Thanks

Answer Question   |  October 23, 2009  5:58 AM
ALTER, SQL Server 2000, T-SQL

Five t-shirts to give away: Upload those profile pictures!
I’ve been noticing a dropoff in profile pictures lately — here’s a reminder on how to upload yours if you haven’t already. If you’re participating in the community, we want to know who you are! I’ll be mailing out five t-shirts to the first five people (with eligible mailing addresses) to upload profile pictures and [...]

Answer Question   |  December 29, 2009  7:43 PM
AS/400, CIO, CRM, DataCenter, Development, Exchange, Giveaways, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Profile Pictures, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Grant users rights to run reports on reporting services
How do I grant users rights to run reports on reporting services?  Those with admin access can run them, but users without admin access can’t – they get an error that they don’t have access to the data source.  When setting up the source, we used windows authentication.  I’ve given clearance on the website itself [...]

Answer Question   |  January 16, 2010  3:10 PM
Microsoft SQL Reporting Services, Reporting Services 2005, SQL 2005

store image to sql server
would you please give me a code to store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end

Answer Question   |  January 23, 2010  8:28 AM
SQL Server 2000, SQL Server Image Store, VB 6.0, Visual Basic, Visual Basic 6.0

SQL Server 2005 distribution agent failed
Getting this error message

Answer Question   |  October 16, 2009  5:01 PM
SQL Server 2005, SQL Server Distributor, SQL Server error messages

Most popular blog posts this week
10. Removing old hardware after a P2V conversion Eric Siebert shares a long-held best practice regarding old server management. 9. The challenge of managing risk when IT budgets tighten Linda Tucci explains the challenges of a down economy — and offers some tips on coming out ahead. 8. Ellison commits to the hardware business Find [...]

Answer Question   |  October 16, 2009  2:53 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

MS SQL Server 2000 Vulnerability
Hello, I have installed on one of my servers SQL Server 8.00.2273 – SP4 (Standard Edition). At the last vulnerability tests it founds the followings: 1. Microsoft SQL Server MTF Data Structures Memory Corruption Vulnerability (MS08-040) 2. Microsoft SQL Server ‘sp_replwritetovarbin’ Remote Memory Corruption Vulnerability (MS09-004) Searching for an answer at microsoft I found that [...]

Answer Question   |  October 19, 2009  7:17 AM
SQL Server 2000, SQL Server vulnerabilities, Windows Server 2003, Windows Server 2003 SP2

SQL related tables
I have 2 tables one with all my products and their accociated details and another with comments on the products. Product table 1 prodID, title, description, price Comments table 2 commID, prodID, comment I would like to export this to a single XML file, thus an XML element for each product from table 1 with [...]

Answer Question   |  October 19, 2009  7:10 AM
MySQL, MySQL 5.0, PHP, SQL Related Tables, SQL tables

Community Announcement: Cash in your Knowledge Points for an Amazon gift card
Members who have earned over 1,000 Knowledge Points in the community by December 15th have the opportunity to cash in their points for Amazon gift cards — just e-mail us at contactus -AT- itknowledgeexchange.com with your handle when you choose to cash out. You can also post here in the discussion area when you’d like [...]

Answer Question   |  April 3, 2012  2:32 PM
AS/400, CIO, CRM, DataCenter, Development, Exchange, Giveaways, ITKE, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, Virtualization, VoIP