General

• Topics

  Started by

  Posts

  Last post

• COM+ isolation level

  I read a book the other day, and tells me the isolation level for MTS/COM+ is set of serializable. …

  ckempste

  2 replies

  22 years ago

  By: ckempste

• Creating a View

  How can I work around Error 207: invalid Column Name (B) in this example? Select A, B = Case A …

  hamdan

  2 replies

  22 years ago

  By: terryute

• Group By Help

  I have a query below. I have several cloumns of Output and am trying to and a count column to the …

  dchelm

  3 replies

  22 years ago

  By: terryute

• Storing wav files

  There is a need in our project to store wav files associated with a particulat type of event ocurri…

  madhu_r

  1 replies

  22 years ago

  By: Andy Warren

• SQL Function

  I have a table set up where every part in an assembly that has sub-parts is set up in a table with …

  jmscotty

  3 replies

  22 years ago

  By: GRN

• Error Handling in T-SQL

  Hi, Is it possible to retrieve Error Description in T-Sql just like @@Error. Also, is it possible t…

  mitracv

  2 replies

  22 years ago

  By: sergey

• Tmp Tables

  How do I test for tmp tables??? I want to test if the tmp table exists if so drop tmp table. Steve …

  Steve Johnson

  3 replies

  22 years ago

  By: sergey

• RTRIM in DTS package

  Hi All, When using a query in a dts package, functions parse as valid SQL, however usually the dts …

  n-igma

  1 replies

  22 years ago

  By: n-igma

• how to run bcp

  Hi, I run a bcp command inside my sql analyzer. I did this: master.dbo.xp_cmdshell "bcp dbname.dbow…

  zishanz

  3 replies

  22 years ago

  By: zishanz

• bcp / how to run bcp from within a sp

  Hi, I had never used bcp before. So I got a lot of questions to ask about bcp. First, how to run bc…

  zishanz

  10 replies

  22 years ago

  By: zishanz

• Trigger Problem

  Hi All, I want to use Begin Transaction and Commit Transaction in my trigger. But when I used it an…

  pbd_76

  4 replies

  22 years ago

  By: pbd_76

• bcp / how to check database option

  Hi, according the book, Microsoft SQL Server 2000 DBA Survival Guide, in order to achieve fast mode…

  zishanz

  4 replies

  22 years ago

  By: zishanz

• Using the Default Object or any other way

  Providing the following information:- SQL Server: 7.0 Database Name : TestDB Table Name: TestTBL (F…

  hamdan

  3 replies

  22 years ago

  By: hamdan

• creating tables using SP

  Question : Is ther a way to create a table using a dynamic name like : Declare @tablename as varcha…

  dyckwalter

  6 replies

  22 years ago

  By: Antares686

• CURSOR ERRORS

  I developed this procedure that when executed will grant or revoke privlages to users or user group…

  kirmssr

  1 replies

  22 years ago

  By: ojn