• Estimated cost for upgrade from SQL Server 2005 SE to SQL Server 2005 EE

    What is the estimated cost to upgrade from Microsoft SQL Server 2005 Standard Edition to Microsoft SQL Server 2005 Enterprise Edition?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to test whether the Database tables designed to avoid deadlock occurence?

    I heard from our dev team that our db tables are designed such that there is no chance of deadlock. How to test whether the Database tables design avoids deadlock? By reviewing the db scripts (table creation) can we find whether the db table design is deadlock proof or not? What else can we do?...

    Saimadhu455 pointsBadges:
  • Migrating data from Microsoft Access to SQL Server 2000

    I want to transfer data from access to sql table and vice versa through windows service. so, plz help me.

    VBNET5 pointsBadges:
  • Migrating from SQL Server 2000 to SQL Server 2005 on DTS packages

    Could someone help me with a SQL Server 2000 migration to SQL Server 2005 on DTS packages? I have a Dynamics GP integration that uses the DTS package, but I don't know SQL or DTS packages well enough.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Writing a report drawing information from a SQL Server 2005 table

    I am writing a simple report that displays records from our customer table, a table that has no corresponding records in our contacts table. My code entered in SQL Server 2005 is as follows: select contractor.name,acctstatus, statusDetail, sales_person, loggedInBy,loginDate, lastUpdateBy,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Best encryption method for SQL Server 2000

    What is a good encryption method to use in SQL Server 2000 if your database is accessed by two different languages, PHP and ASP?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Referential integrity and AS/400

    Can anyone please explain what refrential integrity means and how does it relate to AS/400? Regards, Shaddy

    Shaddy20 pointsBadges:
  • SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 pointsBadges:
  • EMC Network Backup Client/Agent backup for SQL 2000/2005 databases on Polyserve Matrix

    Hi, I am new with running SQL 2000/2005 instances on Polyserve Matrix servers. We use EMC Network as a corporate backup strategy. Can someone tell me will there be any problems using this backup tool for SQL instances on the Polyserve Matrix?

    Davidvoo5 pointsBadges:
  • How can I join 3 tables using JOIN keyword

    Hi Experts, Pls hlp me with my query How can i join 3 tables using JOIN Keyword inside PL/SQL block in SELECT ... WHERE clause Query 3 Tables namely Reg,ROOTS,ME and the select statement takes both parameter variable and local variable Thanks!!!!!

    Inprise610 pointsBadges:
  • Transfering SQL files from location to colo

    What is the fastest way to get the SQL database files transfered over? i.e. zip the files

    Phatboy81225 pointsBadges:
  • Can’t manually enter data any more; get Error Message: String or binary data would be truncated.

    Three databases that were forced restored now do nor allow manual entry, even one single character, although using an update statement works. This is not a matter of changing the length of the datatype, but something else. For the life of me, I can't figure out why this mere attempt at manual data...

    Jimruddy5 pointsBadges:
  • SQL error. There is already an object named ‘InitCap2′ in the database.

    I am running the following code in Microsoft SQL Server Management Studio Express, and after I run it, I get the following error, even though it is returning the record set that I am looking for. I would like to get rid of this error. Thanks. The error is: Msg 2714, Level 16, State 5, Procedure...

    Mmoreno5 pointsBadges:
  • Trouble with SQL Server 2005 Upgrade Advisor when trying to detect an instance

    I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when going to the pull-down menu, nor does it recognize it when I key in the instance name. We are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Combo box question when developing a SQL database in Visual Basic 6

    I am developing a SQL database using Visual Basic 6 with ADO and Microsoft Access, but in it, I have a combo box with two options - yes and no. I want the combo box, after yes or no is selected, to open another form where a user can enter other details. How would I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL SERVEUR 2005 SISS AND WHERE statement

    I create a SSIS to transfer the date from AS/400 TO SQL Server 2005, and it's work fine. when I go to modify it and I add a where statement to choose only the year 2008, I received the following error code 0x80131937

    Sqlbeg5 pointsBadges:
  • ExcelSource file – metadata validation

    I need some assistance. I am using an excel file to import data to SQL tables. The problem I am running into is having to replace the metadata of the output columns with the metadata of the external columns. I do not want to do this manually everytime. [The metadata of the following output columns...

    Mayre5 pointsBadges:
  • SQL Find a number between the given ranges of number / Find a row which has range of given number

    I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value in...

    Bsethi245 pointsBadges:
  • SQL “NOT CONNECTED” icon in my taskbar

    there is an icon in my taskbar and when i highlight it it says NOT CONNECTED. when i right click it it pops up a menu with OPEN SQL SERVER SERVICE MANAGER on the top...what is this and why is the icon in my taskbar?

    Pennymae10195 pointsBadges:
  • SSIS package that will copy a table from one server to another based on a var.

    Another NeeBee question....I would like to have an SSIS package that would check if a variable "RefreshTable" = 'YES' which is found on a table from server A, delete all the data from a table on server B and then load that table on server B with data from an identical table which is on server A....

    NewBee7105 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