If you have the SQL 2005 version of the database, you can restore (or attach) that database to a SQL 2008 server and it will automatically upgrade it.
View Answer | July 16, 2009 8:30 PM
SQL Express, SQL Server 2005, SQL Server 2008, SQL Server Training
Enjoy the chapter and be sure to check out the related <b>SQL Server</b> resources listed at the bottom of the chapter download page. Voice your feedback on this chapter or let us know of other books you’d like to see featured on the <a href=”http://itknowledgeexchange.techtarget.com/bookworm/”>IT Bookworm Blog</a> by visiting the chapter and leaving a comment. [...]
View Answer | July 16, 2009 12:11 PM
Alastair Aitchison, Apress, Free Chapters, SQL Server 2008, SQL Server Spatial Data
You can use Administrative Tools -> Performance tool to monitor the server CPU and memory utilization.
View Answer | July 15, 2009 11:31 PM
Server Performance, SQL Server, Windows Server 2003
When you attach the database you need to product the MDF, and LDF as well as any NDF files that were created. If you don’t have the LDF you can attempt to attach just the MDF file using the sp_attach_single_file_db system stored procedure. If that doesn’t work you’ll need the origional LDF file that was [...]
View Answer | July 15, 2009 5:30 PM
MDF, SQL Server database, SQL Server error messages, SQL Server errors, SQL Server logs
By running the sp_detach_db and sp_attach_db stored procedures.
View Answer | July 15, 2009 5:25 PM
C#, Database Files, SQL Server database
You need a previous backup to restore and them import the table.
View Answer | July 15, 2009 5:01 PM
SQL Server 2005, SQL Server Management, SQL Server tables
The alert is being generated because you have Quoted Identifiers off when you are running it. Remove the double quotes and replace them with square brackets. In SQL Server the double quote isn’t the default separator. This would make your code look more like this. <pre>DECLARE @tblName varchar(30) SET @tblName = CONVERT(VARCHAR(20),GETDATE(),112) + ‘Table’ DECLARE [...]
View Answer | July 15, 2009 9:43 AM
i got answer from my team mates that , its by default *Off. If this is wrong, kindly lemme know..
View Answer | July 15, 2009 7:53 AM
Data Types, RPG, RPG/400
Well, obviously the View creates those extra line items because you have several notations per quote. You say that you want to suppress those extra line entries. Does this mean that you are not interrested in those extra notes at all? If so, you can modify QUOTE_Binary_to_notes: <pre>SELECT TYPE, n.OWNER_ID , CONVERT(varchar(8000), CONVERT(binary(8000), NOTE)) AS [...]
View Answer | July 15, 2009 1:00 AM
Crystal Reports, Crystal Reports XI, SQL Server 2000, Visual Manufacturing, Windows XP
Has SAP been implemented at a shipping company? Absolutely and there are many examples. I suggest a review of sap.com. Register your e-mail on the site if you wish to do so. There is no cost and it helps in your search. So search on sap.com for functionality on shipping. Some of the more interesting [...]
View Answer | July 14, 2009 5:53 PM
Oracle interoperability, SAP implementation, SAP interoperability, SQL Server interoperability
You need to purchase <a href=”http://www.sap.com/solutions/sapbusinessobjects/sme/reporting/visualstudio/index.epx”>Crystal Reports for Visual Studio .NET</a> or Crystal Reports Developer Advantage licenses.
View Answer | July 14, 2009 12:11 AM
Crystal Reports 2008 controls, Database connectivity, SQL Server 2000, VB 6, Visual Basic 6
Use a script task to change the connection string properties of the connection object that the source of the data flow is using.
View Answer | July 13, 2009 10:51 PM
SQL Server Integration Services, SSIS 2005
First you need to get rid of the Substring function in the where clause. Using any functions against the columns in the where clause will kill your performance as your index becomes useless. Instead you should be doing something like this. <pre>select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where AuditData.TATCallType is null and AuditData.CallTo LIKE ’00500004%’ [...]
View Answer | July 13, 2009 9:12 PM
Slow SQL Query, SQL queries, SQL query optimization
First, backup your databases in case something goes wrong. Then, use the sp_detach_db and sp_attach_db system procedures to detach and then attach your databases. If users are trying to connect it may help to set single user mode on the databases. After you detach the database with sp_detach_db you can move the files, then use [...]
View Answer | July 9, 2009 10:02 PM
SQL Server 2000, SQL Server 2005, SQL Server Database Migration, SQL Server databases
You can create a single cluster that spans the two sites. This requires that both SANs are able to talk to each other and do async replication between them. The more common technique is to use database mirroring between the two sites.
View Answer | July 9, 2009 9:26 PM
Disaster Recovery, Production environments, SQL Server 2005, SQL Server 2005 mirroring, SQL Server backup and restore, SQL Server Mirroring
You’ll need to setup a web method on the public site which calls the private URL. We do this on our site to give our customers access to the reports server. I’m not sure the exact methods used, but the basics to Google will be that you are looking for code to create a proxy.
View Answer | July 9, 2009 9:22 PM
SQL Server 2005, SQL Server Reporting Services, SSRS, SSRS Access from a Web Server, VPN
OK, I will now answer my own question. The count for each Group was appearing at the top of each group BECAUSE the concatenated column (4 fields stuck together) was not a column in the report. I have the individual fields, so I did not put the concatenated column in the report. I put the [...]
View Answer | July 9, 2009 2:56 PM
Report Builder 9.0, Report Builder 184.108.40.206.33, SQL Server Report Builder
<b>Background Information:</b> The CROSS APPLY does a Cartesian join between the tables. Depending on what’s being joined, this can cause the run time of the query to increase as SQL is taking the number of rows in the first table times the number or rows in the second. CROSS APPLY <i>can</i> solve some problems that [...]
View Answer | July 8, 2009 7:06 PM
CROSS APPLY statement, SQL Server 2005, SQL Server 2005 connectivity
Yes .. to SQL commands in SQLRPGLE No, I don’t beleieve it extends to F-Spec based commands You need the STRCMT and the COMMIT of the F-Spec I think you will need two commit’s and two rollbacks Remember. records will be locked by both processes and not available for change until the commit/rollback. Phil
View Answer | July 8, 2009 1:12 PM
RPG, SQL commitment control level, SQLRPGLE
It can be, provided that the request is sent through the normal approved change process. If a developer walks up to you and asks you to delete data from a table, then its probably not an approved change. However if that request comes to you through the proper change control procedures then yes. No one [...]
View Answer | July 8, 2009 1:07 AM
Database Administrator, DBA, SQL scripts