I have purchased 9 seats though volume liscensing for Outlook 2007 with BCM. The first 7 installs with out a problem. The last 2 have thrown this error: Setup failed to install the required component Microsoft SQL Server 2005 Express (MSSMLBIZ). Business Contact Manager for Outlook 2007 cannot continue. See C:Program FilesMicrosoft SQL Server90Setup BootstrapLogSummary.txt [...]
Answer Question | March 29, 2010 1:58 PM
BCM, Email, Outlook 2007, SQL Server Express 2005, WinXP
i have a new mdf and ldf file created in sql server 2000.how could i attach these to sql server 2005 enterprise edition?i tried it by right click the database and select attach.but it shows an error when click the add button in database dialogue box.
Answer Question | March 26, 2010 6:45 PM
LDF, MDF, SQL Server 2000, SQL Server 2005, SQL Server 2005 Enterprise Edition
there are two tables employees and jobs .employees table attributes are job_id and salary.jobs having attibute job_id,job_title.i want to retrieve sum(salary),job_title group by job_id
Answer Question | March 26, 2010 2:36 PM
SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo
I have a user defined function that returns a single scalar value, e.g. a formatted name. Is it possible to reference the UDF as the value of a field in SSRS 2008? If so, how? Thanks.
Answer Question | March 25, 2010 10:17 PM
SSRS 2008, UDF, user-defined function
Be proud to show off you are part of the community with your free ITKnowledgeExchange.com sticker. All you have to do is answer a question and email me your handle and address and we will get one out in the mail to you. Allow 4-6 weeks delivery. Even if you have one already get one [...]
Answer Question | September 1, 2011 3:15 PM
CIO, CRM, Database, DataCenter, Domino, Exchange, Linux, Networking, Oracle, SAP, Security, SQL, SQL Server, Storage, Virtual Server, VoIP, Windows
Date calculation incorrect in sql when 1 month entered. If we add 1 month to 28-Feb then it shows 28-Mar instead of 31-Mar. Similarly if I add 1 month to 30-Nov it should show 31-Dec instead of 30-Dec. SQL command run is SELECT CCDATE + 1 MONTHS FROM COGNOSMIS/xyzPF WHERE CCDATE = ’2010-02-28′
Answer Question | March 26, 2010 12:31 PM
SQL, SQL Date Calculation
We have upgraded a number of Windows XP clients (from MSDE 1 to MSDE 2000) which interact with a clustered SQL server 7 system (running on Windows NT server) via transactional replication. Our problem is that these clients are connected over ISDN dial up lines and since the upgrade we have noted a significant increase [...]
Answer Question | March 24, 2010 11:39 AM
ISDN, MSDE, SQL Server, Windows NT, Windows XP Professional
I have an alert set up to run a stored proc that will email me the results of a sp_who2 when the Lock Waits/sec rises above 2 seconds. The problem is that the alert doesn’t fire off until after the lock has cleared, so the results of the sp_who2 are not very useful because they [...]
Answer Question | April 15, 2011 9:10 PM
SQL Server 2008, SQL Server 2008 administration
I have a database that went to suspect mode in sqlserver 2000.How do i recover the DB from suspect without restore the DB?
Answer Question | March 22, 2010 4:15 PM
Database, SQL Server 2000, SQL Server 2000 Suspect Mode
I want to have a stored procedure run on a schedule that automatically creates a database output file as a result and saves it to a specific location on my network. Can someone please tell me how to do this?
Answer Question | June 1, 2010 1:14 PM
Automated SQL Query, SQL, T-SQL
How can I extract key phrases from a log file using a batch file. I am new to this. I need to know how to extract key phrases from a log file using a batch file. I need to create the batch file first to extract the phrases from the log file. I don’t need to [...]
Answer Question | March 22, 2010 1:18 AM
Performance testing, RSScripter
When line to primary Domain controller is dropped, some of the current logged on clients are dropped by SQL when they try to access the database. For some clients, the application still works just fine. The clients are all set up and authenticated in the local Domain Controller. It is my thought that the authentication [...]
Answer Question | March 19, 2010 9:14 PM
Active Directory, SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity, VB
How do I increase the number of users CAl to my SQL server 2008 Licensed by server?
Answer Question | March 18, 2010 7:18 PM
CAL, SQL Server 2008, SQL Server licensing
I have pictures stored in a Ms Sql table in an image data type column. I want to be able to write the image(which is a JPG to a file. Is there a function in MS SQL 2005 or is another tool necessary?
Answer Question | March 17, 2010 3:36 PM
blob data, Image databases, SQL, SQL 2005
i want to create a procedure it should be able to audit any change done in the database ie. drop/delete of schema tables. the procedure should be able write audited data into a remote server machine inaccessible by the system manager/dba.
Answer Question | March 17, 2010 6:24 AM
DELETE statement, DROP, SQL Developer
Hi I am creating a database. In my legacy system I had what we called a tables system where coded data could be expanded into different values eg 0 = No 1 = Yes I tried to create this in SQL by having a properties table and then relating the other tables to the [...]
Answer Question | March 17, 2010 4:25 AM
SQL 2005, SQL tables
Up against a SQL question that is difficult to code. Any help is greatly appreciated.
Answer Question | March 22, 2010 8:47 PM
SQL Find, SQL Server, SQL Server 2008
What is the easiest and best Front End development for SQL server. I have Visual Studio 2008 Professional IDE. VB.net or VB.
Answer Question | March 15, 2010 6:21 PM
SQL Server 2008, VB, VB.NET, Visual Studio 2008 Professional
can some one teach me this
Answer Question | March 16, 2010 12:28 PM
Im getting the following error when running the code below: SQL> @n377d_load_tfdscpm_sxb.sql exception * ERROR at line 224: ORA-06550: line 224, column 7: PLS-00103: Encountered the symbol “EXCEPTION” when expecting one of the following: begin case declare end exit for goto if loop mod null pragma raise return select update while with <an [...]
Answer Question | April 7, 2010 1:13 AM
ORA-06550, Oracle Error Codes, PL/SQL, SQL Execution