I need to replace a word in a Document through SQL Server 2008
Hello i’m using SQL 08 R2 to store my resume collection , i want Sql to find an Email in the MS WORD document and replace it with an empty string so far I’ve succeeded to find the word using fullTextSearch this my example for finding the documents that contain an email SELECT document FROM [...]
Answer Question
| January 4, 2011 3:52 PM
SQL 2008, SQL Server, SQL Server 2008, SQL Server 2008 R2
Hello i’m using SQL 08 R2 to store my resume collection , i want Sql to find an Email in the MS WORD document and replace it with an empty string so far I’ve succeeded to find the word using fullTextSearch this my example for finding the documents that contain an email SELECT document FROM [...]
Answer Question
| January 4, 2011 3:52 PM
SQL 2008, SQL Server, SQL Server 2008, SQL Server 2008 R2
Backup solutions for VMware environment
We’ve added VMware servers to our data center, and we’re looking for a backup solution that works. There will be a mix of ESX 4.0 and ESX 3.5 hosts along with vCenter 4.0 with a mix of Windows Server 2003, Windows Server 2008, Red Hat 4.x and 5.x, SQL Server 2005 and Oracle database. TSM [...]
Answer Question
| January 3, 2011 7:57 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
We’ve added VMware servers to our data center, and we’re looking for a backup solution that works. There will be a mix of ESX 4.0 and ESX 3.5 hosts along with vCenter 4.0 with a mix of Windows Server 2003, Windows Server 2008, Red Hat 4.x and 5.x, SQL Server 2005 and Oracle database. TSM [...]
Answer Question
| January 3, 2011 7:57 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
after migrating store procedures from 2000 to 2005 sql server, how we can check the store procedures are migrated correctly without executing them?
Answer Question
| January 3, 2011 4:06 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server stored procedures
after migrating store procedures from 2000 to 2005 sql server, how we can check the store procedures are migrated correctly without executing them?
Answer Question
| January 3, 2011 4:06 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration, SQL Server stored procedures
How to Display Japanese character in Crystal Report 8.5
Hi, I’ve some data stored in japanese language in sql server 2005 database using nvarchar datatype. When i execute store proc in sql server, it’s showing japanese character properly in sql server. However, when i’m trying to display data in crystal report 8.5, it’s showing ????? character. I’ve tried to change font to ‘Arial Unicode [...]
Answer Question
| May 6, 2012 11:14 AM
Crystal Report 8.5, NVARCHAR, SQL Database, SQL Server 2005, SQL Server 2005 Database
Hi, I’ve some data stored in japanese language in sql server 2005 database using nvarchar datatype. When i execute store proc in sql server, it’s showing japanese character properly in sql server. However, when i’m trying to display data in crystal report 8.5, it’s showing ????? character. I’ve tried to change font to ‘Arial Unicode [...]
Answer Question
| May 6, 2012 11:14 AM
Crystal Report 8.5, NVARCHAR, SQL Database, SQL Server 2005, SQL Server 2005 Database
Recursive Association with compound primary key in SQL database
Hello, I’m afraid I’m very new to this and really struggling. I have a table with a compound primary key composing of Code, Date, Client to represent an attendee on a course. I need to include a ‘Lead Client’ column to represent a recursive relationship where one attendee can be nominated to lead others attending [...]
Answer Question
| January 3, 2011 11:53 PM
Database issues, Design principles, SQL, SQL Database, SQL Server database, SQL Server errors
Hello, I’m afraid I’m very new to this and really struggling. I have a table with a compound primary key composing of Code, Date, Client to represent an attendee on a course. I need to include a ‘Lead Client’ column to represent a recursive relationship where one attendee can be nominated to lead others attending [...]
Answer Question
| January 3, 2011 11:53 PM
Database issues, Design principles, SQL, SQL Database, SQL Server database, SQL Server errors
SQL Server 2005 query
Hello sir I am new to sqlserver when retriving data like name gender sal deptno df F 100.00 10 mf M 1100.00 10 if M 1010.00 10 uf M 1000.00 20 yf F 1200.00 20 gf F 1030.00 20 hf M 1005.00 30 ff F 1040.00 30 from this i want retrive deptno maletotal sal [...]
Answer Question
| December 31, 2010 7:54 AM
SQL Query, SQL Server 2005, SQL Server Query, SQL statements
Hello sir I am new to sqlserver when retriving data like name gender sal deptno df F 100.00 10 mf M 1100.00 10 if M 1010.00 10 uf M 1000.00 20 yf F 1200.00 20 gf F 1030.00 20 hf M 1005.00 30 ff F 1040.00 30 from this i want retrive deptno maletotal sal [...]
Answer Question
| December 31, 2010 7:54 AM
SQL Query, SQL Server 2005, SQL Server Query, SQL statements
Recovering database files from failed Brightstor 12 server
We have a failed brightstor 12 server. I can recover the files from the hard drive but the server is dead. We will be rebuilding a new one. Can I recover the database files and import them? And if so where are they located?
Answer Question
| January 8, 2011 4:28 PM
Backup and restore, BrightStor, BrightStor ARCserve Backup 12, Database Files, Database Recovery
We have a failed brightstor 12 server. I can recover the files from the hard drive but the server is dead. We will be rebuilding a new one. Can I recover the database files and import them? And if so where are they located?
Answer Question
| January 8, 2011 4:28 PM
Backup and restore, BrightStor, BrightStor ARCserve Backup 12, Database Files, Database Recovery
Adding another level of security to SQL 2005 database
We have a SQL 2005 Database. It is protected by Windows Authentication. Can we add another level of security – requiring a SQL username and password along with a valid user name and password on the domain?
Answer Question
| January 12, 2011 4:17 PM
Network security, Network Security Management, SQL 2005 Database, SQL Security, SQL Server 2005, SQL Server security, Windows authentication
We have a SQL 2005 Database. It is protected by Windows Authentication. Can we add another level of security – requiring a SQL username and password along with a valid user name and password on the domain?
Answer Question
| January 12, 2011 4:17 PM
Network security, Network Security Management, SQL 2005 Database, SQL Security, SQL Server 2005, SQL Server security, Windows authentication
Full and differential backup size same in SQL Server
Hi, Sub:Full and differential backup size same. I am facing the following problem on production server,I am getting the full backup(600MB) and differential backup size(598MB).On off peak hours I have taken full backup and just after a min I have taken differential backup but the sizes of both backups are almost same.As per BOL diff [...]
Answer Question
| December 30, 2010 1:56 PM
Backup and restore, SQL Backup, SQL Server, SQL Server backup and restore
Hi, Sub:Full and differential backup size same. I am facing the following problem on production server,I am getting the full backup(600MB) and differential backup size(598MB).On off peak hours I have taken full backup and just after a min I have taken differential backup but the sizes of both backups are almost same.As per BOL diff [...]
Answer Question
| December 30, 2010 1:56 PM
Backup and restore, SQL Backup, SQL Server, SQL Server backup and restore
SQL Server Plan Cache
There is a bucket in plan cache with 75 objects in it and it is the same sql statement. Other than using DBCC FREEPROCCACHE what will clear out the cache? Restarting SQL SERVER Service? I use the code below to look up how many plans are in a bucket. SELECT bucketid, entries_in_bucket = [...]
Answer Question
| December 29, 2010 11:30 PM
Cache, Cache Mode, SQL, SQL 2005, SQL performance, SQL Server
There is a bucket in plan cache with 75 objects in it and it is the same sql statement. Other than using DBCC FREEPROCCACHE what will clear out the cache? Restarting SQL SERVER Service? I use the code below to look up how many plans are in a bucket. SELECT bucketid, entries_in_bucket = [...]
Answer Question
| December 29, 2010 11:30 PM
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.
Is it possible on i series that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used. We had an issue wherein an entire library had to be cleared and all files from had to be restored from a previous backup, after the [...]
Answer Question
| December 24, 2010 9:45 AM
Index Performance, iSeries, SQL, SQL Select, V5R4
Is it possible on i series that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used. We had an issue wherein an entire library had to be cleared and all files from had to be restored from a previous backup, after the [...]
Answer Question
| December 24, 2010 9:45 AM
Index Performance, iSeries, SQL, SQL Select, V5R4
Execute trigger only on update of selected fields
We have created some trigger programs in COBOL that should be executed only if certain fields change. When creating a SQL-After trigger and -program on a file I can specify that the trigger should run only when specified fields are updated by using: AFTER UPDATE OF {fields} ON {file}. Unfotunately when removing a SQL trigger [...]
Answer Question
| January 4, 2011 11:00 AM
AS/400, AS/400 triggers, COBOL, SQL Trigger, Triggers
We have created some trigger programs in COBOL that should be executed only if certain fields change. When creating a SQL-After trigger and -program on a file I can specify that the trigger should run only when specified fields are updated by using: AFTER UPDATE OF {fields} ON {file}. Unfotunately when removing a SQL trigger [...]
Answer Question
| January 4, 2011 11:00 AM
AS/400, AS/400 triggers, COBOL, SQL Trigger, Triggers
SQL servers merge transactions
In vb.net windows application,i used sql server 2008 for database. For deployemnt and implementation process, we used currently the sql server is in the web.client have different locations and want to access application from any where. The problem is at some rural area the internet down time is high and user unable to do data [...]
Answer Question
| December 20, 2010 8:04 AM
SQL Server 2008, SQL Server database, SQL Server synchronization, SQL Server transactions, SQL transaction logs
In vb.net windows application,i used sql server 2008 for database. For deployemnt and implementation process, we used currently the sql server is in the web.client have different locations and want to access application from any where. The problem is at some rural area the internet down time is high and user unable to do data [...]
Answer Question
| December 20, 2010 8:04 AM
SQL Server 2008, SQL Server database, SQL Server synchronization, SQL Server transactions, SQL transaction logs
SOLAP in SQL 2008R2
IS there SPATIAL OLAP implementation in SQL 2008R2
Answer Question
| December 20, 2010 9:28 PM
GEOSpatial, Oracle OLAP, SQL Server 2008, SQL Server 2008 R2, Windows Server 2008, Windows Server 2008 R2
IS there SPATIAL OLAP implementation in SQL 2008R2
Answer Question
| December 20, 2010 9:28 PM
GEOSpatial, Oracle OLAP, SQL Server 2008, SQL Server 2008 R2, Windows Server 2008, Windows Server 2008 R2
SQL Server 2005 with SAN storage problem
i have a very strange problem: - i have an windows 2003 server - a SAN storage attached to that server - i installed SQL server 2005 proffesional into the server - database files in the san storage - when i attach the database into the san storage it gives an error that it cann’t [...]
Answer Question
| December 20, 2010 10:20 AM
SAN, SAN storage, SQL 2005, SQL Server 2005
i have a very strange problem: - i have an windows 2003 server - a SAN storage attached to that server - i installed SQL server 2005 proffesional into the server - database files in the san storage - when i attach the database into the san storage it gives an error that it cann’t [...]
Answer Question
| December 20, 2010 10:20 AM
SAN, SAN storage, SQL 2005, SQL Server 2005
SQL I/O Best Practice
I just inherited a SQL SERVER 2005 32-bit attached to a SAN Server. I want to use SQLIO for performance testing and stress testing. The database is in production. Would it be a good idea to run SQLIO on a production sql server during non-work hours?
Answer Question
| December 20, 2010 10:11 PM
iSCSI SAN Server, SQL 2005, SQL Server 2005, SQL Server administration, Windows Server 2003
I just inherited a SQL SERVER 2005 32-bit attached to a SAN Server. I want to use SQLIO for performance testing and stress testing. The database is in production. Would it be a good idea to run SQLIO on a production sql server during non-work hours?
Answer Question
| December 20, 2010 10:11 PM
iSCSI SAN Server, SQL 2005, SQL Server 2005, SQL Server administration, Windows Server 2003
Two SQL server synchronization
How can I merge two SQL Server databases? One sql server is in web and another in local machine both sql servers will have daily data transactions entries. how to merge those daily data transactions between the two sql server? i am new to sql synchronization and merging. could you kind enough to help me?
Answer Question
| December 20, 2010 3:14 PM
.NET, SQL, SQL Server, SQL Server synchronization, VB.NET
How can I merge two SQL Server databases? One sql server is in web and another in local machine both sql servers will have daily data transactions entries. how to merge those daily data transactions between the two sql server? i am new to sql synchronization and merging. could you kind enough to help me?
Answer Question
| December 20, 2010 3:14 PM
.NET, SQL, SQL Server, SQL Server synchronization, VB.NET
Sample Test Data from Production in SQL Server 2008
Is there a data generation tool that can populate tables in a test database with a percentage of actual data from a production database? For example, to extract data based for a date range from a specific table, and all related tables to be populated based on the corresponding related referenctail data.
Answer Question
| December 21, 2010 9:42 PM
Data Extraction, SQL 2008, SQL Server 2008, T/SQL
Is there a data generation tool that can populate tables in a test database with a percentage of actual data from a production database? For example, to extract data based for a date range from a specific table, and all related tables to be populated based on the corresponding related referenctail data.
Answer Question
| December 21, 2010 9:42 PM
Data Extraction, SQL 2008, SQL Server 2008, T/SQL
Adding New Parameter to a existing Crystal reports 9.5
I have a exsiting crystal rpt that passes 5 parameters to a stored proc. We have added 1 more parameter to the procedure now when attempting to run the crystal rpt it errors out with proc expects parameter “new” (new being the added parameter). I have been unable to get around this. Can anyone help. [...]
Answer Question
| December 16, 2010 6:32 PM
Crystal 9.5, Crystal Reports 9, Parameters, SQL 2000 to 2005 Migration
I have a exsiting crystal rpt that passes 5 parameters to a stored proc. We have added 1 more parameter to the procedure now when attempting to run the crystal rpt it errors out with proc expects parameter “new” (new being the added parameter). I have been unable to get around this. Can anyone help. [...]
Answer Question
| December 16, 2010 6:32 PM
Crystal 9.5, Crystal Reports 9, Parameters, SQL 2000 to 2005 Migration
Create QA database with only some production tables
I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They’re all in the same filegroup in the original database. I’ve done [...]
Answer Question
| December 16, 2010 1:50 PM
Clone database, Filegroup, QA, SQL scripts, SQL Server 2008, SQL Server tables
I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They’re all in the same filegroup in the original database. I’ve done [...]
Answer Question
| December 16, 2010 1:50 PM
Clone database, Filegroup, QA, SQL scripts, SQL Server 2008, SQL Server tables
