SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• getting SSIS ADO to run with the agent

  I'm building packages to move data from Progress OpenEdge to MSSQL2008r2. It runs in VStudio on thi…

  mlstephens14

  1 replies

  11 years, 8 months ago

  By: Koen Verbeeck

• How to Join the two table

  Table 1 ABCDF A1B1NULLNULLNULL A2B2NULLNULLNULL A3B3NULLNULLNULL A4B4NULLNULLNU…

  ramanathan.raman88

  6 replies

  11 years, 8 months ago

  By: Dwain Camps

• SQL Server 2005 Job email notification alerts

  Hi there, I was wondering if somebody could tell me how to configure the notification alerts on a j…

  Claudia-343424

  53 replies

  11 years, 8 months ago

  By: MaBear

• How to set value of procedure to variable?

  Hello mates. I want to create a procedure with follow two sentences. DECLARE @Wallet int SET @W…

  sasia14

  2 replies

  11 years, 9 months ago

  By: sasia14

• How many log files will exist in a SQL Server Database with 4 secondary files?

  How many log files will exist in a SQL Server Database with 4 secondary files in addition to the pr…

  RickNPHX

  4 replies

  11 years, 9 months ago

  By: RickNPHX

• attempting to recreate complex "multi-layer" Access queries in SSMS

  Please excuse me if Im not usung the right terminology. I am a SQL Server newbie and have a basic …

  vega805

  12 replies

  11 years, 10 months ago

  By: vega805

• Case When Resulting in Null

  Hi All, I just need clarification of why a field for some records would result in a null value for …

  daniness

  3 replies

  11 years, 10 months ago

  By: Lowell

• Database Design For Multiple Product Types

  I have a database containing different product types. Each type contains field that differs greatly…

  sahaamitabha123

  1 replies

  11 years, 10 months ago

  By: PaulB-TheOneAndOnly

• Backup failed

  Hello Maters, I have one SQL Server 2000 in my database environment, Our wintel team gimme a messag…

  jitendra.padhiyar

  2 replies

  11 years, 10 months ago

  By: jitendra.padhiyar

• Permission Error on Trigger

  I have a trigger that emails the user whenever their order has been marked as complete. This works …

  skempf

  4 replies

  11 years, 11 months ago

  By: skempf

• Stored Procedure Tuning

  Hi There, I have this below mentioned stored procedure which I am executing through VB.NET what is …

  farooque_s

  2 replies

  11 years, 11 months ago

  By: Jeff Moden

• To merge several tables into one

  Hi there, My company has several instances of the same app. One app/database per client. Now mainte…

  tania 56573

  9 replies

  11 years, 11 months ago

  By: Eric M Russell

• SQLXMLBULKLOAD mapping file

  Hi, I tried SQLXMLBulkLoad option by creating the mapping file and VB script, its not giving any er…

  bhagya.puccha

  1 replies

  11 years, 11 months ago

  By: Lowell

• Recursive query for a Bill of Materials table

  Hi people, I could really do with a bit of help here. I have a table in the following format: Stock…

  andy.dawson

  45 replies

  12 years ago

  By: lenar.chavez

• Help Re Indexing

  Hi, I have a 28 GB SQL 2000 Database that is in need of a re index. I am currently running DBCC DBR…

  Vertigo44

  4 replies

  12 years, 1 month ago

  By: MMartin1