SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Input form to populate SQL table.

  Hi I'm using SQL Server 2005 Reporting Services. I need to create a table that a user can edit that…

  jona-913705

  6 replies

  1 year ago

  By: Lee From Bangalore

• alter table alter column with default value of getdate

  Why is the following not parsing? ALTER TABLE [dbo].[strategy_card_definition] ALTER COLUMN [create…

  AshaRRichardson2nd

  7 replies

  1 year, 5 months ago

  By: Ahmad Mahmood

• How Do I resolve SSMS 'is busy" issue

  Hi Folks I thought I had asked this before but cannot seem to find it. Anyway I am really getting f…

  JC-3113

  22 replies

  1 year, 7 months ago

  By: nickyboylusdoc@gmail.com

• Suggestion Req for Best SQL Courses

  Hello this is Gulshan Negi I am a Software Developer, well I'm looking for SQL courses that are des…

  gulshan212

  3 replies

  1 year, 12 months ago

  By: gulshan212

• Which is better? SSIS or SSMA?

  Hi, I need to migrate data from Sybase db to SQL2005 db. Which is better to use, SSIS or SSMA? Sinc…

  Soorya

  6 replies

  3 years, 5 months ago

  By: francesco.mantovani

• Enable user to execute a sys stored procedure

  I am struggling to enable a user to be able to execute a system stored procedure (sys.sp_droproleme…

  SZ

  1 replies

  4 years, 8 months ago

  By: SZ

• Enable normal user to execute a sys stored procedure

  I tried GRANT EXECUTE ON OBJECT :: sys.sp.droprolemember TO John; GO Cannot find the object 'dropro…

  SZ

  3 replies

  4 years, 8 months ago

  By: Steve Jones - SSC Editor

• Force job to fail based on condition of IF

  I am using SQL Server 2005 and I need to force a job to fail based on a condition of an IF statemen…

  dangoodwin96

  1 replies

  4 years, 12 months ago

  By: Jeff Moden

• Using SQL for multiple pulldowns

  So, I need to be able to use SQL to provide options in a series of pulldowns related to an employee…

  mm92280

  2 replies

  5 years, 7 months ago

  By: drew.allen

• Server Organization

  I just secured a job where the company has about 98 SQL Servers installed. I only know this b…

  chappell grant-willis

  2 replies

  6 years ago

  By: DinoRS

• Azure logins

  There is no forum for Microsoft Azure (It's 9 years we are waiting. Hello Steve !), so I'll post it…

  Senchi

  1 replies

  6 years, 7 months ago

  By: Sue_H

• SUM of 2 columns in 2 tables THIS IS REALLY SIMPLE

  I want to SUM a column in one table and SUM a column of another table and have the two SUM results …

  brett.y

  15 replies

  6 years, 9 months ago

  By: Sean Lange

• An idiots guide to moving from sql server 2005 to sql server express 2012?

  Apologies if I'm asking in the wrong place and let me firstly say I know next to nothing about SQL …

  mike 91138

  7 replies

  6 years, 11 months ago

  By: sgmunson

• Unable to get format file to work

  I am importing a text file with tab delimiters into an SQL2005 table.The BCP command works fine wit…

  ron.abbott

  22 replies

  6 years, 11 months ago

  By: Jeff Moden

• eed to get previous quarter date from current date

  Can anyone help me with this one. I need to get the previous quarter from the current date. exampl…

  BKW

  8 replies

  7 years ago

  By: Lynn Pettis