SQL Server 2008 Code to find fields containing similar text
I want to find fields that may be the same in some parts but not 100% identical For example Field 1 Has the word “Smith” Field 2 has “Smith AB” in it Is there any code i can write to find these, without writing code for every single name I am using SQL server 2008 [...]
Answer Question
| July 14, 2010 3:37 PM
SQL commands, SQL Fields, SQL Server 2008 administration, SQL Server development
I want to find fields that may be the same in some parts but not 100% identical For example Field 1 Has the word “Smith” Field 2 has “Smith AB” in it Is there any code i can write to find these, without writing code for every single name I am using SQL server 2008 [...]
Answer Question
| July 14, 2010 3:37 PM
SQL commands, SQL Fields, SQL Server 2008 administration, SQL Server development
Sponsor Post: Fear the Cloud? Migration Pros and Cons (on-demand chat from 6/29/2010)
Organizations need to able to quickly recover failed servers and their data in the event of an outage. Deploying a server recovery solution can save a company tens of thousands of dollars in lost productivity and lost business. This live chat on June 29th from 1-3 pm EST provides an exclusive opportunity to get your [...]
Answer Question
| July 22, 2010 2:05 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Organizations need to able to quickly recover failed servers and their data in the event of an outage. Deploying a server recovery solution can save a company tens of thousands of dollars in lost productivity and lost business. This live chat on June 29th from 1-3 pm EST provides an exclusive opportunity to get your [...]
Answer Question
| July 22, 2010 2:05 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Changing over to DR database from SQL 2005
I have set up log shipping from my production SQL2005 databases to my DR server and all seems to be working fine. On examing my DR databases they are all in (Restoring…) mode. How do I now access my DR databases if/when my production system goes down? There does not seem to be any obvious [...]
Answer Question
| June 28, 2010 5:39 AM
Disaster Recovery Database, HP DL380, Restore Database, SQL 2005 Database, SQL Log Files
I have set up log shipping from my production SQL2005 databases to my DR server and all seems to be working fine. On examing my DR databases they are all in (Restoring…) mode. How do I now access my DR databases if/when my production system goes down? There does not seem to be any obvious [...]
Answer Question
| June 28, 2010 5:39 AM
Disaster Recovery Database, HP DL380, Restore Database, SQL 2005 Database, SQL Log Files
Log In then Output the Data of the Logged Person C# SQL 2005
I have a program that requires a user to input his/her IDNumber. If it doesnt exist the program will prompt to go to the NewRecord section. When the user input his IDNumber and he will be logged on to the real program. After doing the program and pressing the DONE Button. A messagebox will appear [...]
Answer Question
| August 3, 2010 2:36 PM
C#, Programming, SQL 2005, sql 2005 Performance Issues, SQL Database
I have a program that requires a user to input his/her IDNumber. If it doesnt exist the program will prompt to go to the NewRecord section. When the user input his IDNumber and he will be logged on to the real program. After doing the program and pressing the DONE Button. A messagebox will appear [...]
Answer Question
| August 3, 2010 2:36 PM
C#, Programming, SQL 2005, sql 2005 Performance Issues, SQL Database
Find the SQL value behind the decimal
I need to know if the numbers after a decimal point are greater than 0. What is the easiest SQL syntax to do this?
Answer Question
| June 24, 2010 8:42 PM
SQL, SQL Query, SQL Syntax
I need to know if the numbers after a decimal point are greater than 0. What is the easiest SQL syntax to do this?
Answer Question
| June 24, 2010 8:42 PM
SQL, SQL Query, SQL Syntax
Can anyone tell me the best way to query Active Directory in SQL?
Can anyone tell me the best way to query Active Directory in SQL? I’m using SQL Server Management Studio Express and want to add the LDAP server for AD as a linked server to query. I’m not sure what the best way to do this is.
Answer Question
| June 22, 2010 12:15 PM
Active Directory, Active Directory query, LDAP, SQL Server 2005, SQL Server Management Studio 2005, T/SQL
Can anyone tell me the best way to query Active Directory in SQL? I’m using SQL Server Management Studio Express and want to add the LDAP server for AD as a linked server to query. I’m not sure what the best way to do this is.
Answer Question
| June 22, 2010 12:15 PM
Active Directory, Active Directory query, LDAP, SQL Server 2005, SQL Server Management Studio 2005, T/SQL
Users accessing SQL Server 2008 database
how can i know how many users are accessing database remotely and how much load is on database .how can it be detected in sql server 2008. pls let me know .
Answer Question
| June 25, 2010 11:55 AM
SQL Server, SQL Server 2008, SQL Server User Accounts
how can i know how many users are accessing database remotely and how much load is on database .how can it be detected in sql server 2008. pls let me know .
Answer Question
| June 25, 2010 11:55 AM
SQL Server, SQL Server 2008, SQL Server User Accounts
Converting from RPGLE to DB2/400 SQL
My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?
Answer Question
| June 22, 2010 8:30 PM
DB2/400, RPGLE, SQL, SQL migration
My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?
Answer Question
| June 22, 2010 8:30 PM
DB2/400, RPGLE, SQL, SQL migration
SQL Server 2005: Improving performance of Multiple Databases & LUNS
I am looking at ways to improve performance of our databases. We have 4 large databases (ranging between 50gb and 200gb each) on a single SQL Server 2005 Cluster. Currently they are split 2 on one LUN and 2 on another. I am looking at ways to improve the IO performance of the databases as [...]
Answer Question
| June 22, 2010 5:25 PM
Cluster management, LUN, RAID 10, SQL Server 2005, SQL Server clustering, SQL Server performance, Storage in 2010
I am looking at ways to improve performance of our databases. We have 4 large databases (ranging between 50gb and 200gb each) on a single SQL Server 2005 Cluster. Currently they are split 2 on one LUN and 2 on another. I am looking at ways to improve the IO performance of the databases as [...]
Answer Question
| June 22, 2010 5:25 PM
Cluster management, LUN, RAID 10, SQL Server 2005, SQL Server clustering, SQL Server performance, Storage in 2010
trying to use MAC address authentication for AP from NPS RADIUS Windows Server 2008.
We are trying using MAC address authentication for AP from NPS RADIUS Windows Server 2008. Two things we are facing need help: What’s the “condition” selected and how’s the format? Secondly, How do we excute the query of SQL( 2008)table column? I do make conection successful but I do not have any action?? SQL Database [...]
Answer Question
| November 24, 2010 7:58 PM
MAC address, Radius Server, SQL Query, SQL Server 2008, Windows networking, Windows Server 2008
We are trying using MAC address authentication for AP from NPS RADIUS Windows Server 2008. Two things we are facing need help: What’s the “condition” selected and how’s the format? Secondly, How do we excute the query of SQL( 2008)table column? I do make conection successful but I do not have any action?? SQL Database [...]
Answer Question
| November 24, 2010 7:58 PM
MAC address, Radius Server, SQL Query, SQL Server 2008, Windows networking, Windows Server 2008
Bulk Insert Problem in SQL Server Management Studio 2005
Hi. I’m running into an issue performing a bulk insert. I’ve taken the following steps: Created a table Created a schema file with a .fmt extension Created a stored procedure to insert a file When I attempt the bulk insert I get the following error message: Cannot bulk load because the file “g:USB06182010.txt” could not [...]
Answer Question
| June 21, 2010 3:46 PM
SQL INSERT, SQL Server Management Studio 2005, T/SQL
Hi. I’m running into an issue performing a bulk insert. I’ve taken the following steps: Created a table Created a schema file with a .fmt extension Created a stored procedure to insert a file When I attempt the bulk insert I get the following error message: Cannot bulk load because the file “g:USB06182010.txt” could not [...]
Answer Question
| June 21, 2010 3:46 PM
SQL INSERT, SQL Server Management Studio 2005, T/SQL
SQL Query for Price Data of Different Stocks from 1 table with same dates
I am having 1 table with date, stock and price data for all stocks. I want a sql query which will display the date, stockname1, stockname2, stockprice1 and stockprice2 for the 2 stocks I mention and the date range I mention and date should be common to both stocks. If stock1 has a price on [...]
Answer Question
| June 17, 2010 7:58 AM
SQL Express, SQL Express 2005, SQL Query, SQL Server
I am having 1 table with date, stock and price data for all stocks. I want a sql query which will display the date, stockname1, stockname2, stockprice1 and stockprice2 for the 2 stocks I mention and the date range I mention and date should be common to both stocks. If stock1 has a price on [...]
Answer Question
| June 17, 2010 7:58 AM
SQL Express, SQL Express 2005, SQL Query, SQL Server
SQL 2000 migration to SQL 2005 – need to preserve user security
Hi, I have a customer that is planning on moving to new hardware and performing a SQL upgrade (2000->2005). I know that our application (FileNet Image Services) is sensitive to what we refer to as an “orphaned” database. Our app stops working if a database is simply detached/attached to another server because it loses that [...]
Answer Question
| June 17, 2010 2:24 PM
SQL Database Security, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server security, SQL Server Upgrade
Hi, I have a customer that is planning on moving to new hardware and performing a SQL upgrade (2000->2005). I know that our application (FileNet Image Services) is sensitive to what we refer to as an “orphaned” database. Our app stops working if a database is simply detached/attached to another server because it loses that [...]
Answer Question
| June 17, 2010 2:24 PM
SQL Database Security, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server security, SQL Server Upgrade
New Contest: You Could Win a New Xbox 360
Now is the time to ask and answer questions on ITKnowledgeExchange.com because you could take home a newly released Xbox 360. From today (June 16th) through July 30th, you have a chance to win 1 of 2 Xbox 360s or 1 of 3 $50 Amazon Gift Cards. The five community members who have the most [...]
Answer Question
| August 5, 2010 2:14 PM
DataCenter, DataManagement, Development, Exchange, ITKE Community, ITKE Contests, ITKE Feedback, ITKnowledgeExchange, Linux, Lotus Domino, Microsoft Windows, Mobile, SQL Server, VoIP
Now is the time to ask and answer questions on ITKnowledgeExchange.com because you could take home a newly released Xbox 360. From today (June 16th) through July 30th, you have a chance to win 1 of 2 Xbox 360s or 1 of 3 $50 Amazon Gift Cards. The five community members who have the most [...]
Answer Question
| August 5, 2010 2:14 PM
DataCenter, DataManagement, Development, Exchange, ITKE Community, ITKE Contests, ITKE Feedback, ITKnowledgeExchange, Linux, Lotus Domino, Microsoft Windows, Mobile, SQL Server, VoIP
Database backup terminating abnormally
m running this code for backing up and to have backup log backup database adventureworks to disk = ‘g:radvent6.bak’ mirror to disk=’g:radvent7.bak’ with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values(‘dreee’,'reserch’) backup log adventureworks to disk=’g:radvent6.trn’ after the backup log command executes shows the error as The statement BACKUP LOG is not allowed while the recovery [...]
Answer Question
| April 11, 2011 12:38 PM
Backup, Database Backup, SQL Server 2008
m running this code for backing up and to have backup log backup database adventureworks to disk = ‘g:radvent6.bak’ mirror to disk=’g:radvent7.bak’ with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values(‘dreee’,'reserch’) backup log adventureworks to disk=’g:radvent6.trn’ after the backup log command executes shows the error as The statement BACKUP LOG is not allowed while the recovery [...]
Answer Question
| April 11, 2011 12:38 PM
Backup, Database Backup, SQL Server 2008
Using Report Server in SharePoint 2010
In SharePoint Integrated Mode of SSRS 2008, how do you get the Report Server Instance Name, Report Server DB Name and SQL Server Instance Name hosting Report Server DB programmatically? Can it be done using SharePoint object model or through ReportService2006 web methods? This question is from the Microsoft Live Chat which took place on June 1st.
Answer Question
| March 2, 2012 8:15 PM
Report Server, ReportService 2006, Sharepoint 2010, SSRS 2008
In SharePoint Integrated Mode of SSRS 2008, how do you get the Report Server Instance Name, Report Server DB Name and SQL Server Instance Name hosting Report Server DB programmatically? Can it be done using SharePoint object model or through ReportService2006 web methods? This question is from the Microsoft Live Chat which took place on June 1st.
Answer Question
| March 2, 2012 8:15 PM
Report Server, ReportService 2006, Sharepoint 2010, SSRS 2008
Improve performance on Insert rows into DB2 400 table from SQL server
Using INSERT OPENQUERY and a linked server on SQL Svr 2005, to insert rows to DB2 table on AS400. To a local AS400 runs very quickly. Performance on a remote 400 is very slow, and seems to be out of proportion to the change in line speed. Is there anyway to improve the performance for [...]
Answer Question
| October 29, 2010 2:58 PM
AS/400, DB2/400, Linked servers, SQL Server, SQL Server 2005
Using INSERT OPENQUERY and a linked server on SQL Svr 2005, to insert rows to DB2 table on AS400. To a local AS400 runs very quickly. Performance on a remote 400 is very slow, and seems to be out of proportion to the change in line speed. Is there anyway to improve the performance for [...]
Answer Question
| October 29, 2010 2:58 PM
AS/400, DB2/400, Linked servers, SQL Server, SQL Server 2005
Documentum Stops Processing
During import of Excel files, documentum just stops processing & disappears. There’s nothing in the log, other than 49 files were processed & no errors. EMC cannot duplicate the error in their lab. Installation gone awry? CC me at morgans@southcoastplaza.com with solution.
Answer Question
| June 15, 2010 10:32 PM
Documentum, EMC Documentum, Excel import/export, SQL 2008
During import of Excel files, documentum just stops processing & disappears. There’s nothing in the log, other than 49 files were processed & no errors. EMC cannot duplicate the error in their lab. Installation gone awry? CC me at morgans@southcoastplaza.com with solution.
Answer Question
| June 15, 2010 10:32 PM
Documentum, EMC Documentum, Excel import/export, SQL 2008
Compare Two Tables With Identical Fields
Need to compare two tables A & B with identical fields and report when rows don’t match and rows from B are missing in A.
Answer Question
| June 15, 2010 7:46 PM
SQL, SQL tables
Need to compare two tables A & B with identical fields and report when rows don’t match and rows from B are missing in A.
Answer Question
| June 15, 2010 7:46 PM
SQL, SQL tables
How to split a column into SQL data..
I have table called country having one column called complete_name (varchar(max)) which is as under [table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> [tbody] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent; width: 6.15in;" valign="top" width="590"> [strong]complete_name[/strong] [/td] [/tr] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent; width: 6.15in;" valign="top" [...]
Answer Question
| June 24, 2010 4:09 PM
SQL Server 2005, SQL Server tables, T-SQL
I have table called country having one column called complete_name (varchar(max)) which is as under [table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> [tbody] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent; width: 6.15in;" valign="top" width="590"> [strong]complete_name[/strong] [/td] [/tr] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent; width: 6.15in;" valign="top" [...]
Answer Question
| June 24, 2010 4:09 PM
SQL Server 2005, SQL Server tables, T-SQL
