• ASP.NET

    i want to insert the data into the existing database

    5555544425 pointsBadges:
  • The most-watched IT questions this week: March 9, 2010

    1. A member asks how they can apply GPOs to non-domain computers to make sure they don’t get on the corporate domain, and MrDenny, Technochic, Denwood, and SiThu help with a solution. 2. A member asks about business intelligence in a cloud environment. 3. A SQL Server reader asks how to monitor...

    Michael Morisy7,943 pointsBadges:
  • Multiple rows locked in sqlserver when updating one row

    In Microsoft SQLServer, I found out that when you perform an SQL update, in a lot of cases multiple rows are locked, even when row-locking is configured for that table and page-locking is prohibited, and even when you force row-locking in the SQL statement using WITH (ROWLOCK).

    Nevenfi5 pointsBadges:
  • When submitting a procedure via CL program, i do not get any abnormal end message.

    When submitting a procedure via CL program, i do not get any abnormal end message even though the procedure has not not completed normally, is there anyway by which we can find the cause of the failure of the completion of the procedure normally.

    JohnsonMumbai1,160 pointsBadges:
  • How should I make the SQL in iBatis having Parameter of ListMap?

    How should I make the SQL in iBatis having Parameter of List<Map>? When I search primery key at a table having two primery key, I have plural parameters as a parameter. This parameter is List<Map>. It is an example of Parameter as follows EX) 1. parameter List<Map> paramList = new...

    Jhyukchoi5 pointsBadges:
  • iseries stored procedure : read character string containing single apostrophe …. ex: Let’s

    I am working on a stored procedure that requires a literal string to be input into a VARCHAR(1024) variable. My stored procedure has no problem reading the word........... Let''s However, if I try to read the word............Let's, I get a code violation. Do I need to read the string as a datatype...

    Dsthornton5 pointsBadges:
  • SQL index on dds file

    Will and existing rpg program that is doing a file read/table scan utilize an sql index with changing any of the rpg program?

    Finch25 pointsBadges:
  • Forum data transfer – SQL

    Hi, my question is: we're developing a new forum so want to learn how can we transfer the data in one or two tables in old forum’s SQL database to the SQL database of this new forum? that means we hope some posts in old forum to be moved to the new ones. Please give the steps to do it. Thank you...

    Bmblog20 pointsBadges:
  • retrieving run time records in SQL

    how to retrieve multiple rows at run time in sql

    Sasthri5 pointsBadges:
  • Can I get a holistic view of applications, like SharePoint, that leverage the capabilities of a number of underlying technologies like SQL Server, IIS

    Can I get a holistic view of applications, like SharePoint, that leverage the capabilities of a number of underlying technologies like SQL Server, IIS, and Virtual Server / Hyper-V? We need to know that SharePoint is performing badly, but we need to know which underlying technology or hardware...

    ITKE56,495 pointsBadges:
  • MS DNS query logging to sql server?

    Does anybody know if it is possible using 2003 server r2 dns to log querys to a sql server database instead of a file?

    Ryan99795 pointsBadges:
  • Is SQL Server an application that I should run within a VM? Can I monitor it while it is on a VM?

    Is SQL Server an application that I should run within a VM? Can I monitor it while it is on a VM? This question was asked during the Microsoft System Center live chat on IT Knowledge Exchange in January 2010.

    ITKE56,495 pointsBadges:
  • Encrytpion on SQL Server 2008

    I want to encrypt a stored procedure in SQL Server 2008. I tried software such as SQL shield, it's great but the problem is SQL Profiler can still record/log the content of my original SP. Is there any way to avoid SQL Profiler from recording/logging my original content? If not, do you suggest any...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Documenting column in SQL table in QADBIFLD (AS400)

    When a table is created with SQL, several fields in the system cross-reference file QADBIFLD gets content (headings, defults a.o). I noticed that the QADBIFLD table contains a column named DBIREM (length 2000 bytes..). I also noticed that the old S36 IDDU actually put some documentation into this...

    DanTheDane2,555 pointsBadges:
  • Loading a new database from an Old one

    I am new to SSIS. We are running SQL Server 2008, and I have to load a new database from an old one which had a different structure. I'm not sure how to cope with PK's that are identities. For example, I have three tables: 1) Main table eg. A list of applications 2) Joiner table eg. A list of...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can Systems Center help with uptime, availability and performance of SQL Server instances and Exchange mailbox servers?

    We are particularly concerned with the uptime, availability, and performance of SQL Server instances and our Exchange Mailbox Servers. How can Systems Center help me with this? This question was asked during the Microsoft System Center live chat on IT Knowledge Exchange in January 2010.

    ITKE56,495 pointsBadges:
  • Synchronization of Windows Server 2008 Active Directory Users from a Sql Server table

    I have a table in a sql server database than contains the data of all the users of my network. How can I create a procedure that will add-remove-modify users to the windows server 2008 using the data entered in that table?

    Sasa11115 pointsBadges:
  • MSDE for adminDB

    Ever since I installed Diskeeper Administrator 2009 on my PC (it runs XP Pro, svc pk 3), every time I print something, I get some "MSDE for AdminDB" pop-up that says "Setup has detected that your current SA password is set to blank. Please use sp_password to set a strong SA password and restart...

    John82175 pointsBadges:
  • New Contest: Win the Nexus One Google Phone with your Knowledge Points!

    You're asking and answering questions already, so why not put those Knowledge Points to good use? Win a Nexus One, Google's new cell phone! It's unlocked, so you can sign on with the (select) carrier of your choice contract-free! Read all the details, but the short and long of it is that over the...

    Michael Morisy7,943 pointsBadges:
  • how to give report name dynamically – SSRS 2005

    I created report in ssrs 2005. i added ms report viewer in c# windows application and from smart tag i gave the report name. It display the report but how to give name dynamically, for example i want to put the report name through textbox and want to show the report at runtime.

    paritosh5 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