• How can I create reference key of non-unique column in SQL server 2008

    how i create refrence key of non-unique column in sql server 2008?

    V4apr5 pointsBadges:
  • SQL statement needed to remove characters

    I have data in one of my columns in a table that I would like to remove via a SQL update statement.  In all cases, the data that I want to remove is the same 3 characters at the end of the varchar field.   How would I structure the SQL statement?

    Satonthehill5 pointsBadges:
  • Oracle 10g to SQL Server 2008

    Our DB is Oracle 10g. Our Clients Test DB is SQL Server. Now sometimes, we do incremental loads, full loads or historic load. The present system what we have is we send the insert statements and the DDL to them and they create and load. I did not write it. It takes 40 hours. Under 1 scheme we have...

    Cholan5 pointsBadges:
  • Journaling on i5 when updating from .net

    We need to update some i5 files (under v6r1) from SQL in a .NET environment. Can I control this process via SQL or will I need to call CL commands from .NET to start/stop journaling & commitment control?

    ZIS5 pointsBadges:
  • Save high volume xml transactions to db

    I'm not a DB developer, I know basic select statements but that's about it. We have a high volume xml web service that takes roughly 200K transactions per day. Each transaction request has a corresponding response so that's about 400k transactional xmls per day to save. Each request xml is anywhere...

    GreenJello15 pointsBadges:
  • unable to create a connection to DB from SQL developer

    Hi, I was using SQL developer since 2 years, suddenly lost all the existing connections.Tried creating new connections, provided all mandatory fields and clicked "Test", it was success. But when tried connecting, no response. Also tried importing the connections, but throwing...

    Abc130 pointsBadges:
  • Desktop Virtualization: SAN boot infrastructures

    Does it make sense to SAN boot infrastructure servers like Citrix DDC, PVS , Xenapp, SQL servers, Hypervisor Host in a VDI environment?

    abbis65 pointsBadges:
  • 10 Chances to Win $100

    Starting today (April 25th) and running through May 31st, you have 10 chances to win a $100 Amazon.com gift card. The 10 IT Knowledge Exchange members with the most Knowledge Points earned between today and May 31st will win. Learn how to earn points in the Community Blog, or start answering...

    ITKE346,285 pointsBadges:
  • SQL equivalent of GRTOBJAUT using Authorization List

    Using SQL script, how does one grant object authority to a table using an authorization list?   This fails because MyAutList is not a *USRPRF:  grant all on table mylib.mytable to MyAutList This works, but is not what I need: grant all on table mylib.mytable to Public 

    DavidGar15 pointsBadges:
  • Stop one database in a SQL 2005 environment

    If there are multiple databases ever one unique SQL2005, how can I stop only one of them?

    MoroExpert5 pointsBadges:
  • How do I connect SQL Server 2005(mobile edition) to Visual Studio 2005?

    How do I connect SQL Server 2005(mobile edition) to Visual Studio 2005? I tried the connection but the database is not found on the server.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Retrive The Images From Database using Vb.Net

    how Storing AND Retrieving Images in Sql Server using vb.net

    AnandKanade5 pointsBadges:
  • Running a disk check on Windows 2000 Pro

    When running a disk check on a Windows 2000 professional computer it creates files in the root of the C: drive. What are these files and can they be used to restore data?

    NewnanIT1,110 pointsBadges:
  • SQL Server active/active node clustering

    I need to scale my applications to support the future volumes. We are using sql server 2005 service pack 2, on a active and passive node cluster environment. Can I add another active node to the cluster and create a grid environment to scale my enviornment, without impacting any of my current...

    Ndtvenkat20 pointsBadges:
  • Email sp_who2 on lock/wait sql server 2008

    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 don't contain the...

    TJay85 pointsBadges:
  • Accessing email with Outlook on multiple computers

    I was wondering what the best solution is for the following situation. We are increasing the size of our network and intalling a Windows 2003 server with Active Directory. My users will have to work from multiple workstation. Is there a way I can configure the system that will allow the users to...

    Skepticals0 pointsBadges:
  • Fill out your profile and add a picture to win an iPad

    If you haven't filled out your profile and added your picture, do it now and you could win an iPad. Once you've added your picture and filled out your profile, add a comment to this post to let me know and I'll give you 100 Knowledge Points.  To increase your chances of winning, here's how to...

    EmNichs3,250 pointsBadges:
  • Restoring LTO3 tape without the app that backed it up

    Is it possible to restore data on a LTO3 tape without the application (ArcServe2000) that backed it up?

    NewnanIT1,110 pointsBadges:
  • Win Drupal’s Building Blocks!

    Are you a developer? Today's free IT book is an essential addition to your library: Drupal's Building Blocks. Learn how to quickly build web sites with CCK, Views, and Panels after you win this great resource. There are two ways to win this book: Answer one of five questions and post the link to...

    MelanieYarbrough6,345 pointsBadges:
  • EXEC and sp_executesql

    Could someone give me a concise summary of the differences between EXEC and sp_executesql? Should we set standards that require the use of one over the other by our developers? Cheers

    Douglasnz0 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