How to Display Japanese character in Crystal Report 8.5
I really don’t think you can do this. I tried goggleing this and I didn’t find anything. Yanni from <a href=”http://www.dsr-inc.com”>DSR Inc.</a> HI Yanni, I also did the same search & couldn’t find any solution, that’s why i’ve put question over here.
View Answer
| January 4, 2011 1:44 AM
Crystal Report 8.5, NVARCHAR, SQL Database, SQL Server 2005, SQL Server 2005 Database
I really don’t think you can do this. I tried goggleing this and I didn’t find anything. Yanni from <a href=”http://www.dsr-inc.com”>DSR Inc.</a> HI Yanni, I also did the same search & couldn’t find any solution, that’s why i’ve put question over here.
View Answer
| January 4, 2011 1:44 AM
Crystal Report 8.5, NVARCHAR, SQL Database, SQL Server 2005, SQL Server 2005 Database
Backup solutions for VMware environment
Worse comes to worse, you can just install the current TSM agents on the VMs within the VMware environment and backup the VMs as if they were physical machines until you can upgrade your TSM system so that you can backup the VMs via the host.
View Answer
| January 3, 2011 10:01 PM
Desktop virtualization, ESX 3.5, ESX 4.0, Oracle Database, RedHat, Server virtualization, SQL Server 2005, vCenter 4.0, VMware, Windows Server 2003, Windows Server 2008
Worse comes to worse, you can just install the current TSM agents on the VMs within the VMware environment and backup the VMs as if they were physical machines until you can upgrade your TSM system so that you can backup the VMs via the host.
View Answer
| January 3, 2011 10:01 PM
Desktop virtualization, ESX 3.5, ESX 4.0, Oracle Database, RedHat, Server virtualization, SQL Server 2005, vCenter 4.0, VMware, Windows Server 2003, Windows Server 2008
Migrating stored procedures from SQL Server 2000 to 2005
How did you migrate them? Did you upgrade the database by restoring it from the old server to the server? Did you upgrade the old server to SQL 2005? Did you attach the database to a new machine running SQL 2005? In all these cases the stored procedures are written exactly how they were when [...]
View Answer
| January 3, 2011 6:36 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server stored procedures
How did you migrate them? Did you upgrade the database by restoring it from the old server to the server? Did you upgrade the old server to SQL 2005? Did you attach the database to a new machine running SQL 2005? In all these cases the stored procedures are written exactly how they were when [...]
View Answer
| January 3, 2011 6:36 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server stored procedures
Recursive Association with compound primary key in SQL database
I see three options for you. 1. Change the foreign key so that it uses the same columns for the parent and the child. 2. Add computed columns to the table so that if the Lead_Client value is not null then the values are entered in automatically. 3. Change the front end so that the [...]
View Answer
| January 2, 2011 8:38 AM
Database issues, Design principles, SQL, SQL Database, SQL Server database, SQL Server errors
I see three options for you. 1. Change the foreign key so that it uses the same columns for the parent and the child. 2. Add computed columns to the table so that if the Lead_Client value is not null then the values are entered in automatically. 3. Change the front end so that the [...]
View Answer
| January 2, 2011 8:38 AM
Database issues, Design principles, SQL, SQL Database, SQL Server database, SQL Server errors
T-SQL Programming Tutorials
Another useful web page is SQLServerTutorials.com. Professor William Iverson has broken down the ‘Introduction to T-SQL’ into 15 videos (3 hours & 40 minutes) that have been very helpful to me.
View Answer
| December 31, 2010 11:33 PM
SQL 2005 Database, SQL Server 2005, T-SQL
Another useful web page is SQLServerTutorials.com. Professor William Iverson has broken down the ‘Introduction to T-SQL’ into 15 videos (3 hours & 40 minutes) that have been very helpful to me.
View Answer
| December 31, 2010 11:33 PM
SQL 2005 Database, SQL Server 2005, T-SQL
Recovering database files from failed Brightstor 12 server
As of ARCserve 12.0 the default ARCserve database is SQL Express, however SQL Server can also be used. If the database resides on another system then during the installation of ARCserve just point it to the location of the database and select to not overwrite the database. By detault ARCserve creates a database protection job [...]
View Answer
| December 31, 2010 7:29 PM
Backup and restore, BrightStor, BrightStor ARCserve Backup 12, Database Files, Database Recovery
As of ARCserve 12.0 the default ARCserve database is SQL Express, however SQL Server can also be used. If the database resides on another system then during the installation of ARCserve just point it to the location of the database and select to not overwrite the database. By detault ARCserve creates a database protection job [...]
View Answer
| December 31, 2010 7:29 PM
Backup and restore, BrightStor, BrightStor ARCserve Backup 12, Database Files, Database Recovery
SQL Server 2005 query
<pre>select deptno, sum(case gender when ‘M’ then sal else 0 end) [maletotal sal], sum(case gender when ‘F’ then sal else 0 end) [femaletotal sal] from table group by deptno</pre>
View Answer
| December 31, 2010 7:06 PM
SQL Query, SQL Server 2005, SQL Server Query, SQL statements
<pre>select deptno, sum(case gender when ‘M’ then sal else 0 end) [maletotal sal], sum(case gender when ‘F’ then sal else 0 end) [femaletotal sal] from table group by deptno</pre>
View Answer
| December 31, 2010 7:06 PM
SQL Query, SQL Server 2005, SQL Server Query, SQL statements
Full and differential backup size same in SQL Server
That is very strange. The only reason that the differential backup would not be very small after the full backup was taken would be if the COPY_ONLY flag was used when the full backup was taken. Check the maintenance plan and make sure that the package isn’t generating T/SQL using this flag.
View Answer
| December 29, 2010 7:20 PM
Backup and restore, SQL Backup, SQL Server, SQL Server backup and restore
That is very strange. The only reason that the differential backup would not be very small after the full backup was taken would be if the COPY_ONLY flag was used when the full backup was taken. Check the maintenance plan and make sure that the package isn’t generating T/SQL using this flag.
View Answer
| December 29, 2010 7:20 PM
Backup and restore, SQL Backup, SQL Server, SQL Server backup and restore
SQL Server Plan Cache
You can flush the cache using DBCC, or restarting the SQL Server. If you do an sp_recompile on the object being queried then you will mark all the plans for that object as invalid. You can also change a server wide setting which will flush the cache.
View Answer
| December 29, 2010 2:46 AM
Cache, Cache Mode, SQL, SQL 2005, SQL performance, SQL Server
You can flush the cache using DBCC, or restarting the SQL Server. If you do an sp_recompile on the object being queried then you will mark all the plans for that object as invalid. You can also change a server wide setting which will flush the cache.
View Answer
| December 29, 2010 2:46 AM
Cache, Cache Mode, SQL, SQL 2005, SQL performance, SQL Server
Is it possible on iSeries that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used.
Hi JohnsonMumbai: I do not know for sure since I had asked that question myself, but I think you should use the new index (which I assume is a logical file or view) in your query. Then you can be sure it is used (specially if the query order matched the logical). FlorenJM
View Answer
| December 23, 2010 7:17 PM
Index Performance, iSeries, SQL, SQL Select, V5R4
Hi JohnsonMumbai: I do not know for sure since I had asked that question myself, but I think you should use the new index (which I assume is a logical file or view) in your query. Then you can be sure it is used (specially if the query order matched the logical). FlorenJM
View Answer
| December 23, 2010 7:17 PM
Index Performance, iSeries, SQL, SQL Select, V5R4
SQL servers merge transactions
What you want to use is the native Merge replication. The users at each branch office will always connect to their local SQL Server instance. When the network is online the branch office SQL Server will update the central database is near real time. When the network is down the changes will be queued and [...]
View Answer
| December 20, 2010 10:25 PM
SQL Server 2008, SQL Server database, SQL Server synchronization, SQL Server transactions, SQL transaction logs
What you want to use is the native Merge replication. The users at each branch office will always connect to their local SQL Server instance. When the network is online the branch office SQL Server will update the central database is near real time. When the network is down the changes will be queued and [...]
View Answer
| December 20, 2010 10:25 PM
SQL Server 2008, SQL Server database, SQL Server synchronization, SQL Server transactions, SQL transaction logs
Two SQL server synchronization
OK, what you want to use is the native Merge replication. The users at each branch office will always connect to their local SQL Server instance. When the network is online the branch office SQL Server will update the central database is near real time. When the network is down the changes will be queued [...]
View Answer
| December 20, 2010 10:13 PM
.NET, SQL, SQL Server, SQL Server synchronization, VB.NET
OK, what you want to use is the native Merge replication. The users at each branch office will always connect to their local SQL Server instance. When the network is online the branch office SQL Server will update the central database is near real time. When the network is down the changes will be queued [...]
View Answer
| December 20, 2010 10:13 PM
.NET, SQL, SQL Server, SQL Server synchronization, VB.NET
SQL Server 2005 with SAN storage problem
What SQL is clustered you need to ensure that the SQL Server instance is dependent on shared disks within the cluster manager. If it isn’t then you won’t be able to attach the databases on those disks. Stop the SQL Service, right click the SQL Server resource within the cluster manager and select properties. Select [...]
View Answer
| December 20, 2010 4:48 AM
SAN, SAN storage, SQL 2005, SQL Server 2005
What SQL is clustered you need to ensure that the SQL Server instance is dependent on shared disks within the cluster manager. If it isn’t then you won’t be able to attach the databases on those disks. Stop the SQL Service, right click the SQL Server resource within the cluster manager and select properties. Select [...]
View Answer
| December 20, 2010 4:48 AM
SAN, SAN storage, SQL 2005, SQL Server 2005
SOLAP in SQL 2008R2
I do not think that there is. Check the Microsoft.com/sql website for a full feature list. You may also wish to wait and see what will be release in the next release which is code named “Denali”.
View Answer
| December 20, 2010 4:45 AM
GEOSpatial, Oracle OLAP, SQL Server 2008, SQL Server 2008 R2, Windows Server 2008, Windows Server 2008 R2
I do not think that there is. Check the Microsoft.com/sql website for a full feature list. You may also wish to wait and see what will be release in the next release which is code named “Denali”.
View Answer
| December 20, 2010 4:45 AM
GEOSpatial, Oracle OLAP, SQL Server 2008, SQL Server 2008 R2, Windows Server 2008, Windows Server 2008 R2
SQL I/O Best Practice
You can run SQLIO against the server, but it will impact the performance of the SQL Server, and anything else which shares spindles on the SAN with the SQL Server, and possibly anything else on the SAN as you flood the SAN cache. It is usually recommended to not run SQLIO on production servers.
View Answer
| December 18, 2010 12:42 AM
iSCSI SAN Server, SQL 2005, SQL Server 2005, SQL Server administration, Windows Server 2003
You can run SQLIO against the server, but it will impact the performance of the SQL Server, and anything else which shares spindles on the SAN with the SQL Server, and possibly anything else on the SAN as you flood the SAN cache. It is usually recommended to not run SQLIO on production servers.
View Answer
| December 18, 2010 12:42 AM
iSCSI SAN Server, SQL 2005, SQL Server 2005, SQL Server administration, Windows Server 2003
Sample Test Data from Production in SQL Server 2008
SSIS can do this, it will require some work, but it isn’t all that hard to do.
View Answer
| December 16, 2010 11:11 PM
Data Extraction, SQL 2008, SQL Server 2008, T/SQL
SSIS can do this, it will require some work, but it isn’t all that hard to do.
View Answer
| December 16, 2010 11:11 PM
Data Extraction, SQL 2008, SQL Server 2008, T/SQL
Create QA database with only some production tables
I believe that you are look for a file group backup and restore. That should give you the keywords to find the article you are looking for.
View Answer
| December 16, 2010 8:18 PM
Clone database, Filegroup, QA, SQL scripts, SQL Server 2008, SQL Server tables
I believe that you are look for a file group backup and restore. That should give you the keywords to find the article you are looking for.
View Answer
| December 16, 2010 8:18 PM
Clone database, Filegroup, QA, SQL scripts, SQL Server 2008, SQL Server tables
cannot connect vb program with sql server 2005 in local machine
The problem is most likely that Sql server has been configured to work in Windows Authentication Mode so it doesn’t allow using sql accounts. If that is the case, changing it to work in Mixed Mode should solve the problem. Take a look at this Microsoft article: <a href=”http://support.microsoft.com/kb/555332″>Login failed for user ‘username’. The user [...]
View Answer
| December 15, 2010 11:08 PM
SQL Server, SQL Server 2005, SQL Server Management Studio 2005, VB.NET 2008, Visual Basic, Visual Basic .NET, Visual Basic 2008
The problem is most likely that Sql server has been configured to work in Windows Authentication Mode so it doesn’t allow using sql accounts. If that is the case, changing it to work in Mixed Mode should solve the problem. Take a look at this Microsoft article: <a href=”http://support.microsoft.com/kb/555332″>Login failed for user ‘username’. The user [...]
View Answer
| December 15, 2010 11:08 PM
SQL Server, SQL Server 2005, SQL Server Management Studio 2005, VB.NET 2008, Visual Basic, Visual Basic .NET, Visual Basic 2008
Access or SQL Server tables
Yes, future growth would be best handled with SQL Server. Depending on the amount of data, you could start with the express edition and upgrade to standard or some other edition when needed. ———–
View Answer
| December 14, 2010 4:31 PM
Access Tables, SQL Server administration, SQL Server Table Migration, SQL Server tables, SQL tables
Yes, future growth would be best handled with SQL Server. Depending on the amount of data, you could start with the express edition and upgrade to standard or some other edition when needed. ———–
View Answer
| December 14, 2010 4:31 PM
Access Tables, SQL Server administration, SQL Server Table Migration, SQL Server tables, SQL tables
Recovering lost SQL Server 2000 data
If the MDF isn’t damaged you should be able to attach the MDF without the LDF using the sp_attach_single_file_db system stored procedure. This will generate a new log file when it attaches the database. If this works without issue run a DBCC CHECKDB to ensure that there aren’t any problems with the database. Keep in [...]
View Answer
| December 13, 2010 7:41 PM
Data Recovery, LDF, MDF, SQL Server 2000, SQL Server backup and restore
If the MDF isn’t damaged you should be able to attach the MDF without the LDF using the sp_attach_single_file_db system stored procedure. This will generate a new log file when it attaches the database. If this works without issue run a DBCC CHECKDB to ensure that there aren’t any problems with the database. Keep in [...]
View Answer
| December 13, 2010 7:41 PM
Data Recovery, LDF, MDF, SQL Server 2000, SQL Server backup and restore
