Questions & Answers

  • SQL Server: How do I add an identity to my existing column

    On SQL Server, I'm trying to change the primary key of my table to an identity column. But there's already a number of rows in the table. I created the script so the IDs all start at 1. Is there a command that can alter the column to have a identity property? Thanks!

    ITKE380,305 pointsBadges:
  • Getting the IP address from a user’s machine in ASP.NET

    In ASP.NET, I'm able to get the IP address but it's not the right one. I need the IP address from the user machine (not the user's ISP). Is there a way I can get the real IP address? Is there some sort of IP address check I can use? Thanks!

    ITKE380,305 pointsBadges:
  • Connect to VPN using VPN router

    I'm trying to use a VPN through a VPN router but I'm having difficulties connecting to it.

    iopearce25 pointsBadges:
  • Change to Crystal report affect export to Excel

    We have a Crystal Report that has been being exported to Excel for a few months. It is then imported into an Excel template with macros. We have used this report and the macros have worked properly for several months. Recently I made a change to the Crystal report, adding subtotals to the footer of...

    cbonnell5 pointsBadges:
  • VBA: Wrap function for running time

    I'm using VBA and I'm wondering if there's some form of code that I can wrap a function with so it would let me know how long it took to run. I have to compare several different running times of functions.

    ITKE380,305 pointsBadges:
  • Audit work for programmers

    How can we audit all work for programmers?

    406310 pointsBadges:
  • Best software for photo editing

    Which is the best software for editing a photo of my choice?

    Shahnawaz6615 pointsBadges:
  • Use of codes in a computer

    What is the use of code in a computer?

    nehaaaswani5 pointsBadges:
  • AS/400 backup – BRMS

    How do I check if previous back up tapes used BRMS during their backup. Thank you. I need it urgently.

    excellentrandy1,310 pointsBadges:
  • Career in AS/400 Admin

    Hello Recently I joined a company, where they are offering me training on AS/400 Administration.I want to know whether I am on right track ie Is there is a good scope ahead in this field?? Please hepl........... Thanks in Advance.

    Vishal2370 pointsBadges:
  • How to reset Yahoo password

    I have been using Yahoo mail for so many years and I have forgotten my password. What can I do?

    Rydel12345 pointsBadges:
  • Protect myself from DDoS attacks

    How can I protect myself from DDoS attacks? Also, what about DNS Amplification attacks too?

    roshan24thakre5 pointsBadges:
  • Execute scheduled tasks in a Windows environment

    In the past few weeks, my team has developed a console app for running scheduled tasks on our ASP.NET site. But, as it turns out, it's pretty difficult to maintain. Is there a better way to run our scheduled tasks in a Windows environment? Thank you very much.

    ITKE380,305 pointsBadges:
  • What is the next step for an Excel database?

    I have been developing Excel applications for 6 years. Creating Scheduling, Invoicing, Estimating, HR & CRM applications with Excel exclusively. As my applications and customer needs get larger i have been running into some headaches with Excel as a database. Customers want to share workbooks...

    Excel4Business15 pointsBadges:
  • How to open .tra file in R?

    I am trying to work with a .tra file in R studio. But I'm unable to open it. Can someone tell me how to open it or suggest me a code to convert it to a csv file?

    niveditha5 pointsBadges:
  • Clustered or non-clustered primary key in SQL Server?

    For SQL Server, I'm creating a test database and I'm debating if I should use NONCLUSTERED or CLUSTERED primary key. What's the difference between the two? Is there a preference of one over the other?

    ITKE380,305 pointsBadges:
  • Creating a partition

    How can I create a partition?

    rakebye5 pointsBadges:
  • Run SQL query with CSV format

    I'm trying to run a SQL query from my Linux command line and getting the result in a CSV format. Here's what I have so far: mysql -u uid -ppwd -D dbname << EOQ | sed -e 's/ /,/g' | tee list.csv select id, concat("\"",name,"\"") as name from students EOQ And here's my issue: The columns that...

    ITKE380,305 pointsBadges:
  • SFTP is not working after v7r2 upgrade

    We upgraded to v7r2 and an application using SFTP is not working.

    tommarquis5 pointsBadges:
  • Reinstall SQL Server on Samsung Medison EKO7 machine

    How do I reinstall SQL Server on Samsung Medison EKO7 machine?

    AdewaleAdebayo5 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