SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Cannot alter a column what should i do to alter

  I ran the command Alter Table Login ALter Column X varchar NULL ; and got Msg 5074, Level 16, Stat…

  SQLTestUser

  5 replies

  14 years, 11 months ago

  By: Jack Corbett

• Trigger

  Hi, I am new to sql server,we have a stored procedure it creates automatic trigger for update,inser…

  swathi31g

  4 replies

  14 years, 11 months ago

  By: Brandie Tarvin

• SQL 2005 Job history

  I have scheduled a sql 2005 job to run at 1am in the morning, example: 10-09-10 > I created a jo…

  RGP

  1 replies

  14 years, 11 months ago

  By: Suresh B.

• Install Issues

  Hello all!!! Newbie 1 Kanoobie here and I would like to say that installing SQL Server 2008 R2 on W…

  Clkgtrs1

  7 replies

  14 years, 11 months ago

  By: Clkgtrs1

• Logging error in SSIS

  Hi, I was trying to modify a SSIS package from server based to File based. When we were running the…

  sravan.here

  4 replies

  14 years, 11 months ago

  By: sravan.here

• Search in all the DB

  Hi How can I search a specific word in all the DB? I have this DB with about 200 tables. Half of i…

  tilew-948340

  12 replies

  14 years, 11 months ago

  By: SQLRNNR

• Development to Production

  Hi, I want to move(migrate) from Development to production server. I'm developing the database fo…

  NoviceJatt

  7 replies

  14 years, 11 months ago

  By: Brandie Tarvin

• What a nice place to be

  Hi All can I just say, (I know I've been around SQLServerCentral for a good while, I still consider…

  Mike Cunningham

  12 replies

  14 years, 11 months ago

  By: Stuart Davies

• Error: 2627 PRIMARY_KEY constraint 'PK...' Cannot insert duplicate...

  We upgraded to a new version of our ERP software and the new version added 'Menu Config' tables. In…

  EdA ROC

  6 replies

  14 years, 11 months ago

  By: EdA ROC

• Sync Develepment and Production Databases

  Hi, How can I sync the development and production databases. i.e how to keep the contents same o…

  NoviceJatt

  10 replies

  14 years, 11 months ago

  By: Varinder Sandhu

• Make a table in SS from Access

  I have this code to make a table in SS from Access. It worked fine as far as creating a new generic…

  Os-984017

  5 replies

  14 years, 12 months ago

  By: Evil Kraig F

• SQL trace owned by accoung sa - system generated?

  Hi, I have a SQL Trace that is running under the souce spid of 5s that is owned by "sa". I can't …

  Kevinl 24972

  3 replies

  14 years, 12 months ago

  By: Gail Shaw

• Adding and totaling duplicate data from a single column

  I have a large column with >1 million rows with 8 digit #'s in it (in varchar format). I need t…

  pharmboy4u

  11 replies

  14 years, 12 months ago

  By: Brandie Tarvin

• Making a data region scrollable in SSRS 2008

  I have a report with multiple rectangles which has tablix and or list inside. I want the tablix an…

  stevenplee

  2 replies

  14 years, 12 months ago

  By: stevenplee

• To insert data only if it doesnot exist if exist show the table info and print a message

  Basically i am trying to accomplish Inserting data into a table only if it doesnot exist and if do…

  SQLTestUser

  7 replies

  14 years, 12 months ago

  By: SQLTestUser