• SBS 2003, SQL Server 2005 and database mirroring

    Hello! I m trying to get db mirroring to work between two sbs 2003 premium based sql (2005) servers. Am I just plain stupid or did I miss sth? And please dont tell me about traceflags becaouse they dont seem to have an effect on my ... problem? Perhaps I came out as a bastard but Im in a realy bad...

    Bljahvljah30 pointsBadges:
  • SQL Server 2000 Enterprise Edition upgraded to SQL 2005

    I am researching different Hosting companies with dedicated servers that we can look at moving to. I need to know some information when I am looking at these different companies about the SQL server. We are currently running SQL Server Enterprise 2000. I have seen that the companies are offering...

    Gauravpadia5 pointsBadges:
  • Error when restoring a SQL Server 2005 database

    Every time I restore one of my SQL Server 2005 databases to a point in time, my log shipping restore job fails on my secondary server. Any ideas on how to correct this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Assigning data distributions to SQL Server 2005 databases

    In SQL Server 2005, we have two databases. We want the first one to store tables, and the second one to store views of the tables in the first one. We have achieved this if the tables and views are in the same database, but is there a way to do it with two?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Joining Tables in SQL Server

    What is the difference between Outerjoin and Left outerjoin.

    Bijaybehera2915 pointsBadges:
  • SSRS Performance

    I Have created an SSRS Report for retrieving 55000 records using a Stored Procedure.When Executing from SP it is taking just 3 Seconds but when executing from SSRS report It is taking more than one Minuits.How i can solve this problem?

    Sinshith5 pointsBadges:
  • SQL Column Headings

    When I run an SQL statement the column headings I see are the field names. When any of the other members of our team run the same statement they get the field descriptions as column headings. I have compared user profiles and there are no differences. Is there some other place that this setting is...

    deniseg35 pointsBadges:
  • SQL Stored Procedure

    I need to create a stored procedure with an input parameter of member name to create an Alias, select all the data in the member then drop the Alias. This procdure wil be called by 3rd party software using an odbc connection.

    Markpg155 pointsBadges:
  • SQL Server – where clause

    When I execute query like below select * from A where bb in ('1','2','3') That is very fast. not a problem. But in procedure first, if I make a "B" table with '1','2','3' and join with A table like below, select * from a a , B b where a.xx = b.xx and than it is very slow. Do you know why and how to...

    Overbrain5 pointsBadges:
  • How to use SQL triggers to log errors in a SQL table?

    How to log errors in sql table using sql triggers

    DotNetKoti5 pointsBadges:
  • merging 2 rows into 1 row

    Hi , i have 2 tables table a m_id name 1 abcd 2 bcde table b m_id id org_name ind_name 1 1192 gold coast 1 1193 fred 2 1196 greg 2 1198 TechTronics i am now generating the report through a sql query whose output shud be id Id Org_name Ind_name 1 1192 or 1193 gold_coast fred 2 1196 or 1198...

    Taffer235 pointsBadges:
  • ALTER INDEX statement

    'ALTER INDEX ' || C_Indices.INDEX_NAME ||' REBUILD '; 'ALTER INDEX ' || C_Indices.INDEX_NAME || ' REBUILD ONLINE COMPUTE STATISTICS'; In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure. In middle of the code , i...

    Shaksing5 pointsBadges:
  • PL/SQL: How to handle OUT Parameter during INSERT

    HI Experts, I have a OUT parameter in my procedure(whihc performs INSERT data into a table),how to handle this OUT parameter (primary key of table) -- Will Insert statement inside the PL/SQL block should include this parameter or we should use SELECT stm after Insert to add this attribute ,i am...

    Inprise610 pointsBadges:
  • Multiple instances with SQL Server

    Is it adviceable to put SQL 2000 and 2005 in one single CLuster by putting them in different instances?

    IMR5 pointsBadges:
  • Executing DTSX from VB.NET 2003

    We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we...

    BClawson10 pointsBadges:
  • Linked servers from SQL 2000 to SQL EXPRESS 2005

    I wanted to create a linked server on SQL SERVER 2000 to SQL EXPRESS 2005.Both servers are on the same machine .SQL SERVER 2000 using username and password while SQL EXPRESS using integrated security.Thanks in advance.Any one let me know how to create this?

    Pdeevi5 pointsBadges:
  • SQL script output to a file

    I am running ad hoc SQL scripts in iSeries Navigator (V5R4) and need to direct the output to a text file. Is there a way to do this? TIA... Steve B

    SBatSI415 pointsBadges:
  • Inserting rows and multiple rows in SQL Server 2005 Express

    Anyone there who can help me solve my problem? I can’t continue my program because of this problem which I know someone can solve or can suggest the best possible solution. I have a project in my study doing simple accounting program. To facilitate the discussion, I will just show you the three...

    Ariell5 pointsBadges:
  • Writing a hidden trigger against a SQL table

    How do I write a hidden trigger against a SQL table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • PLS-00103: Encountered the symbol “E_PROD_REQ_ID_NOT_FOUND” when expecting one of the following:

    how can i resolve that error? when i compile the store proc....it compiled without any errors....but in a package its throwing error

    Roopak055 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