• Upgrade SQL 2005 Cluster to SQL 2008

    We have a remote sql 2005 server set we will be replacing with a Windows 2008 Cluster. The db supports a 3rd party app. The app has not completely endorsed for sql 2008. If I build an active/passive cluster with sql 2005 on Windows 2008, is there the ability to upgrade the sql server to a SQL 2008...

    tcstl95 pointsBadges:
  • Exporting to Excel – Sort doesn’t work due to merged cells

    How can I change my SSRS to allow exporting into EXCEL and eliminate the header portion of report which includes merged cells. These prohibit my user from being able to sort a column in the table data.

    Gma885 pointsBadges:
  • Transactional Replication: Publisher & Subscriber size mismatch

    Hello, We have implemented transactional Replication[Push] on our SQL Server 2005 DB. The Distributor is the Publisher. The publisher is on one server and the subscriber on another. After synchronizing the DB, the tables count and the no of recs per table are identical on both the servers, however...

    Test1215 pointsBadges:
  • Oracle DECODE and SSMA

    Does the SSMA or SQL Server Migration Assistant actually have a custom DECODE function that can be used in SQL Server? I've installed SSMA and can't find that function in the sysdb database. I assumed there was such a function based on a blog posting made by Kevin Kline.  If there is a function...

    Dirk5 pointsBadges:
  • Scheduled job for Oracle 9 returning ORA-01858

    We have an Oracle 9.2.0.1.0 database and get the ORA-01858: a non-numeric character was found where a numeric was expected error. Our production jobs are a series of stored procedures which are set up to run automatically by being called through another stored procedure, the Scheduler. While the...

    OracleATE190 pointsBadges:
  • 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...

    C1a4h15 pointsBadges:
  • Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005 and 2000

    HI]] I want to send email alert when aotomatic failover occurs in in Sql-Server 2005/2000.  Specs: Active/Active  NO DR solutions

    ETHMAN55 pointsBadges:
  • SQL Server 2005 Log Shipping question

    I have setup log shipping on our production SQLServer to send the logs to a server I have at my home for a warm backup solution. The process seemed to work but then I had a problem on my secondary server - it seemd to stop working for a period of 2 weeks (I dont know why - I could not login to it...

    Lorelei10 pointsBadges:
  • Change the size of a column and then reorganize the rows in SQL tables

    I think this one will be tricky. What I have is a table like: CREATE TABLE PHOTO_DETAIL   (     "PHOTO"        VARCHAR2(25 BYTE) NOT NULL ENABLE,     "NUM_LINE"   NUMBER(20,0) NOT NULL ENABLE,     "PHOTO_LINE"  VARCHAR2(180 BYTE)   )   what I am going to have is: CREATE TABLE...

    Hispi25 pointsBadges:
  • AS/400 SQL Procedure call from CL program

    I am calling an SQL stored procedure (counts records for a value) from a CL program. I want to send the value to compare to the CL SQL pricedure and get back the count. How do I define the count variable (&COUNT ?) in the CL program? I am using STRQMQRY to call.

    Burmanr10 pointsBadges:
  • SQL query How to select nth row from a table if they are not in any order

    How to select nth row from a table if they are not in any order

    Johnsmak5 pointsBadges:
  • How to display values in one table by referring and checking values in another table?

    how to display values in one table by refering and checking values in another table

    Sqldb5 pointsBadges:
  • SQL SERVER 2005 Security use Kerberos instead of NTLM

    How can I setup sql server 2005 to use kerberos authentication instead of NTLM?

    Rick Martinez585 pointsBadges:
  • Master Data Services – Confused by mdm.tblStgMember

    Hi, In Denny's excellent blog on loading data into Master Data Services, he populated the staging tables as follows: INSERT INTO mdm.tblStgMember (ModelName, HierarchyName, EntityName, MemberType_ID, MemberName, MemberCode) VALUES ('Adventure Works', NULL, 'FirstName', 1, '', 1), ('Adventure...

    IanR5 pointsBadges:
  • Excel as a front end to sql, data integrity

    how do I put a value in a sql field that will not be counted in a excel pivot table? I am using excel as a front-end to sql. In particular, I am using pivot tables to slice and dice sql tables. The field I am interested in has either a text value or a NULL: CaseID (varchar (15), null). When I pull...

    Dannl10 pointsBadges:
  • SQL-Using count and inner join in a single query

    Hi Trying to retrive a report from the DataBase using left join on two tables. To get the count of resultant table, I'm using count. But the output shows error. If I comment count statement then the query executes successfully. I feel there is some error in the syntax of the count that I'm using....

    SQLmurali5 pointsBadges:
  • Does Forefront Endpoint Protection support SQL Server 2008?

    Does Forefront Endpoint Protection support SQL Server 2008? This question is from the Microsoft Live Chat which took place on July 13th.

    ITKE351,300 pointsBadges:
  • Problem on Roaming Profile

    I have implemented Roaming profile in our organization. It is creating profile on the local system when the users get login. After logoff the user the data is saving on server and local pc also. I like to delete the profile when the user logoff to avoiding space occupying on the local system. Can...

    Jothibasu0 pointsBadges:
  • sql 2008 export to txt for backup and incremental backup

    Hi i have one db that i want to back up, so thought id export to txt file/flat file then back that up and then daily increments into that file? cant find the steps to do it..have the wizard..

    Jordaan5 pointsBadges:
  • Help upgrading from SQL Server 1997 to SQL Server 2005

    When upgrading from SQL Server 97 to SQL Server 2005, what needs to be done? Can I restore 97 backups to 2005? Do I need to install any other software? Is this an easy process? We have 6 databases with about 300 GB of data currently.

    ITKE351,300 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following