• Alter Column Drop Identity in T/SQL?

    Is it possible to alter a column definition to remove its identity property?

    Jagoodie60 pointsBadges:
  • The IT Blog Top 10: Feb. 4, 2010

    Here are the most popular blog posts on the ITKnowledgeExchange network this week. Read the rest of the top 10 on the Community Blog, or apply for your own blog by e-mailing me at Michael@ITKnowledgeExchange.com. 1. How to allow the root user to log in to VMware ESX Server with SSH David Davis’...

    Michael Morisy8,323 pointsBadges:
  • AS/400 to SQL Server Data Migration

    What are the steps involved in migrating data from AS/400 to SQL Server. Could you please elaborate as I'm pretty new to such migration work?

    Datamig5 pointsBadges:
  • Difficult Select Statement in SQL

    I have a table with columns, to wit: FieldA FieldB A U B V C A C A C B D A D A D A E B E B E B I can get the records that are multiple in FieldA but whose values in FieldB are repeating with: Select FieldA, FieldB from table  group by FieldA, FieldB  having count(*) > 1 And the result will be:...

    bogeybetsy560 pointsBadges:
  • two dimentional output

    I have a table. The structure looks like this: id(pk) year col1 col2 date 1 2008 50 60 feb09 2 2008 40 70 feb10 3 2009 60 80 feb23 4 2009 50 70 feb24 5 2008 40 80 feb26 I have no idea how to write a sql query to output a table which includes the latest of record of 2008, and the latest record of...

    Zhao5 pointsBadges:
  • sql server 2000 in server

    Hi, We have a server in which windows 2003 is installed and we have created users in the domain (eg - aaa). The server is installed with sql server 2000 and data is stored in the database. The user name for the server is administrator. The problem is when we login from the user computer as the same...

    Radhaisgoodenough5 pointsBadges:
  • SAP UPGRADATION PROJECT PHASES ?

    Hi, Pl give some idea regarding the phases in sap upgradation project . For sap implementation there are 5 phases involved in it ,on similar basis is there any such phases involved during the upgradation of project .what are the pain areas & what are basic requirements from functional side to go...

    Sappsmm55 pointsBadges:
  • The most-watched IT questions this week: Feb. 2, 2010

    Tick tock, tick tock. What’s that sound?  The countdown for the Nexus One Challenge. What? You’ve moved on? Well

    Michael Morisy8,323 pointsBadges:
  • controlling page breaks in a spooled SQL report

    I have written a SQL report that validates many of our tables.  Only when there is an error on a table will a report of that table print.  The script contains 32 different select statements each one associated with a different table.  I need to have a page break between the reports because the...

    Sherryborden85 pointsBadges:
  • problem in my pb11 application and sql2008

    this message apper to me on the client machine "ADO,net is not supported in your current installation"

    Nonosmm5 pointsBadges:
  • differences between SQL server 2000 & SQL server 2005

    Hai  Can any one tell me What are the Main differences between SQL server 2000 & SQL server 2005. Thanks and Regards

    Sukumardba5 pointsBadges:
  • Query Calculation Part of Select Criteria

    This query works great except I need to add one thing. There are two district codes that need to be included in the query. These codes just need the MC_Tax_Amount field totaled - no dividing by two. How do I add this to my query? Thank you, SELECT "T16.CPRP".CP_DISTRICT_CODE,...

    lorit365 pointsBadges:
  • Need help executing MULTIPLE SQL extracts from a JCL

    GREYBEARD52: Thanks again for the info, BUT I'm not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won't help - it doesn't support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command to 1. Run...

    Jonty Walker105 pointsBadges:
  • sql data conversion error 91Object variable or with block variable not setExecuting sql

    Error 91 Description: Object variable or with block variable not setExecuting sql statementRetrieving division information from the sql data store. Checking for the core database. Source: AFWSvDataServices3Converter.ConvertergetSQLDivisions, converter.convertergetdivisions,...

    Dmb07125 pointsBadges:
  • how i do save picture in data base vb.net

    iam using sql express to develop application which have i picture so i can try how a save picture inside data base and loading vb picture box can any one tell me please how i do thi?

    12345678900110 pointsBadges:
  • Textbox input to a a sql dataset table in Vb.net

    How do I input data from textboxes in Vb.net to ...a table in a  data set ....and then display generated data back to some more textboxes ???? I am using sqlexpress ....Thx. mace100

    Mace1005 pointsBadges:
  • SQL Script with hyphen in the value set

    We have a particular piece of malware that will put some binary code in the HKLM/System/ControlSet001/Services/{5083B7D5-47AF-8FF9-657C651C2B10}/ I am using an sql script along with Microsofts logparser to parse some data out of the registry on a windows box and I am having trouble with the last...

    Markmorgan475 pointsBadges:
  • Constraints (MySql,tables,null,PK,FK etc)

    Hi all(waves) noob here ( :) ) ( yes you might look down upon me) ( :( ) never the less....:)  Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg "Table budgets"...with values of two budgets (£100 and £200) for...

    Ak1bo78150 pointsBadges:
  • Email Notification

    Hey i am creating an application front end = vb.net and back end = sql server db!! the application helps assign staff to jobs and when an assignment occurs i would like the staff to recieve an email informing them that they have been assigned to a job... can anyone help me out with how i would go...

    Keirameister5 pointsBadges:
  • SQL Server 2005 Legacy DTS fails when run as a job

    When the DTS is run from SQL Server Management Studio within the Legacy Data Transformation Services the log shows Executed By: sqlagent

    Ftornoe40 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