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
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
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
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
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
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
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
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
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
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
wats ur question here????
View Answer | January 12, 2010 8:46 AM
Backup & recovery, Stored Procedures
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
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
Use Linked Server to achieve this.
View Answer | January 12, 2010 4:52 AM
SQL 2005, SSIS, Stored Procedures, T-SQL
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
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
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
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
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
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