• Uninstalling a SQL Server service pack

    If we have problems after installing a SQL Server service pack, can we uninstall it with no issues?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Sql Server Agent

    What causes an agent not to start? It appears in the services view as starting (instead of Started). WWhen it does start it, you try to do a job and it states that it cannot do so because the agent has not started.

    Bfsteel45 pointsBadges:
  • Error message from SQL Server 2000 Agent after antivirus installation

    SQL Server 2000 Agent would not start after the installation of the antivirus software Sophos and a reboot. I found the messaging service was shut off, so I started it, rebooted and the agent came up running. I then tried to start a backup job, but I received “error 14258,” which stated that it...

    SQL Server Ask the Experts2,585 pointsBadges:
  • insert into with select and passing variables

    This is driving me NUTZ ---- SQL Server 2005 and PHP the variable :t_id is being passed from other pages and works in other statements, but is not parsing within this statement. If I replace :t_id with say 30, it works just fine. I tried declaring a new variable and passing it to the statement, and...

    Bu33ing5 pointsBadges:
  • Scope identity on a stored procedure in SQL

    I have created the following stored procedure in SQL: CREATE procedure [dbo].[sp_trip_number] @Table_Name nvarchar(100), @Trip_Number int output as begin set nocount on begin transaction DECLARE @DynamicSQL NVARCHAR(1000) DECLARE @New_Trip_Number int SET @DynamicSQL='INSERT INTO ' +...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Finding which columns contain data in a table

    I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 abc Would give a report showing that Table 1 has Columns Col1, Col2, Col4 being...

    TedGiles5 pointsBadges:
  • Changes in stored procedures from SQL Server 2000 to SQL Server 2005

    If you could, could you please give a list of the relevant changes that have been done to stored procedures from SQL Server 2000 to SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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:
  • 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:
  • 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:

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.

Thanks! We'll email you when relevant content is added and updated.

Following