Archiving Exchange 2007 in a SQL database
There is already a product out there which does this and does it well. It is not a simple Here’s how” answer. You need program developers and a full time staff to acheive this. Look at <a href=”http://www.quest.com/unified-communications/archiving-ediscovery-compliance.aspx”>Quest Archive Manager</a> which uses SQL to archive email.

View Answer   |  January 18, 2010  9:19 PM
Exchange 2003, Exchange 2007, Exchange Backup & Restore, SQL Database

what is different from MSSQL, MYSQL and Oracle 11g?
Each one has there own slightly different quirks to the SQL language, and they all have slightly different ways of doing things. 15k transactions a day is nothing. Any of those three solutions can handle that workload without issue. Assuming that your workload would all happen within an 8 hour time frame, that is 1875 [...]

View Answer   |  January 15, 2010  8:36 PM
MSSQL, MySQL, Oracle 11g Database

Restoring Database
It depends. If the SQL Server was running then the file that you copied will be pretty much useless. You can try attaching it to the SQL Server and see if it will let you. If your database is in full recovery then you can get Lumigent’s Log Explorer or Quest’s LiteSpeed products and use [...]

View Answer   |  January 15, 2010  8:28 PM
.MDF files, SQL Backup, SQL Server 2005

Where did the undocumented stored procedures go in SQL Server 2008 Managment Studio?
They are in the System Stored Procedures folder (under the Stored Procedures folder). In the case of xp_fixeddrives that is an extended stored procedure so you’ll have to look in the System Extended Stored Procedures folder (under Extended Stored Procedures) for sys.xp_fixeddrives.

View Answer   |  January 14, 2010  8:04 PM
SQL Server 2008, Stored Procedures, undocumented

How to pass a store procedure and a variable to a datagrid
From the ‘GridView Tasks’ menu, select the ‘Configure Data Source’ option, and click ‘next’ until you find the window where you define if you are going to use an SQL statement or a stored procedure. If you select a stored procedure, and it has parameters, when you click ‘next’ you should see a page where [...]

View Answer   |  January 14, 2010  5:26 PM
GridView Control, Stored Procedure variables

Create Excel file on web server by using SQL
There is no native way to do this directly from a stored procedure. You can call an SSIS package have have the SSIS package create the Excel file for you. Other than that you’ll need third party tools installed on the SQL Server to do this. It is usually better to do this kind of [...]

View Answer   |  January 13, 2010  10:23 PM
Microsoft Excel, SQL Server 2005, SQL Server stored procedures

Reporting Services 2005
In order to resolve the error you need to ensure that the element http://localhost/reportserver in the rsreportserver.config is configured to the correct computer name. By default the rsreportserver.config file is in the directory C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServer.

View Answer   |  January 13, 2010  9:16 PM
Reporting, Reporting Services, Reporting Services 2005, SSRS, SSRS 2005

Select/Insert Statements causing out of memory error run under VB Script
How many rows are returned by the SELECT statement? You’ll need enough memory to hold all this data. Are you properly closing and disposing of all the objects after you have finished the database update?

View Answer   |  January 13, 2010  9:01 PM
INSERT statement, Oracle 10g, Oracle 10g Database, SELECT statement, Windows Server 2003, Windows Server 2003 32-bit

View t-sql SPID is executing
Get the sql_handle from sys.sysprocesses for that spid. Then use the sys.dm_exec_sql_text system function to get the batch of code which was executed against the engine. You can use the stmt_start and smtm_end values from sys.sysprocesses to figure out the specific statement within the batch which is being executed. <pre>DECLARE @sql_handle varbinary(64) DECLARE @stmt_start int [...]

View Answer   |  January 13, 2010  2:10 AM
SQL, SQL Server 2005

Create A Fixed Text File From SQL DB Table
The formatting should be done when writing the text to the file, but I don’t think the WriteLine method has that functionality. One way to do it (in case it could not be done by the front end) would be getting the data already formatted from the database. If you are using SQL Server, the [...]

View Answer   |  January 12, 2010  4:17 PM
ASP.NET, SQL Database, SQL tables

Writing a stored procedure across two databases
wats ur question here????

View Answer   |  January 12, 2010  8:46 AM
Backup & recovery, Stored Procedures

SQL saving off data created to copy into new database
You would need to use T/SQL commands to copy the records into the NewDB. Then import those records back into the database as needed. Most most reliable way would be script our the commands and run the script each time. It will take a little longer to setup this way, but it will give you [...]

View Answer   |  January 12, 2010  6:45 AM
SQL, SQL Database

Security Update for SQL Server 2005 Service Pack 3 (KB970892)
wat is the exact error msg u r getting?

View Answer   |  January 12, 2010  5:22 AM
Office 2007, Outlook, SQL Server 2005, SQL Server Security Bulletins, SQL Server Service Packs

passing data between two SQL Server databases
Use Linked Server to achieve this.

View Answer   |  January 12, 2010  4:52 AM
SQL 2005, SSIS, Stored Procedures, T-SQL

Cannot INSERT data into table with identity column
You should specify the column names in the insert statement. The SQL Server thinks that you are attempting to insert the employee ID into the AttendanceID column. Simply put the column names as a comma seperated list before the values like this. <pre>INSERT INTO YourTAble (Column1, Column2, Column3) VALUES (‘Value1′, ‘Value2′, ‘Value3′)</pre>

View Answer   |  January 9, 2010  12:17 PM
INSERT statement, SQL Server 2005, SQL Server 2005 Express Edition, VB.NET 2005

SQL Server 2005 error log, could not read information for this log entry
The only process which should be writing data to the SQL Server’s log file is the SQL Server. Open the ERRORLOG file in notepad and find the entry which is giving you the NULL error. What else is on that file of the file?

View Answer   |  January 8, 2010  11:29 PM
SQL Server 2005, SQL Server error logs, SQL Server errors

DB2 to SQL Server migration
Question 1 – They should have an AS400 Anaylst Question 2 – Same thing Our company has a product that converts DB2 from the AS/400 to SQL Server for .NET. We would be happy to provide that service for your client. Please let me know if you want to discuss this in more detail.

View Answer   |  January 8, 2010  3:45 AM
DB2, SQL Server migration

New Contest: Win the Nexus One Google Phone with your Knowledge Points!
Does this one count?

View Answer   |  January 7, 2010  7: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

Where can I download SQL Server 2005? All trials are no longer available.
You can download it from the <a href=”http://www.microsoft.com/sqlserver/2005/en/us/default.aspx”>SQL 2005 home page</a>.

View Answer   |  January 7, 2010  7:20 AM
SQL Server, SQL Server 2005

Microsoft servers software and hardware upgrade
Based on the very old hardware and software that you are currently running just about anything that you can buy today will be a major improvement.

View Answer   |  January 7, 2010  7:18 AM
HP ProLiant, SQL Application Server, SQL Server, Windows Server