SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• Create Function - Query works fine stand-alone but has error message for the line

  I can't seem to find any syntax problems - can someone please advise? The Select Count ... forward …

  Mile Higher Than Sea Level

  4 replies

  11 years, 5 months ago

  By: Luis Cazares

• SQL - Regular Maintenance - Best Practice??

  Hi - I'm relatively new to SQL and am trying to obtain advice regarding regular maintenance that sh…

  dax.latchford

  5 replies

  11 years, 5 months ago

  By: Jeffrey Williams

• SQL Server Newbie Q about specific trigger implementation

  I have a table called K2K01.dbo.cust and another called K2KConceptActions.dbo.Actions(different dat…

  haroldg

  4 replies

  11 years, 5 months ago

  By: Jack Corbett

• retrieving 1 record takes 5 times longer than before PC went into sleep and woke up

  I have a chart which updates every 5 seconds it takes 5 ms to update the chart and 5ms to retrieve …

  mike 40330

  7 replies

  11 years, 5 months ago

  By: mike 40330

• FULL --> SIMPLE --> FULL Recovery Model - SQL 2008 R2 Standard

  Hello, We have a requirement to rebuild a load of very heavily fragmented indexes. We do not have E…

  lilywhites

  9 replies

  11 years, 5 months ago

  By: EdVassie

• Want to get records only from particular set of numbers.

  Table : Consumer KNO Amount 8789 10 8896 15 6963 0 8959 30 8789 0 8896 0 6963 0 8959 0…

  selpoivre

  4 replies

  11 years, 5 months ago

  By: Sean Lange

• Query returning more than 1 value????

  Hi can someone please tell me why sql says Msg 512, Level 16, State 1, Line 6 Subquery returned mor…

  crazy_new

  26 replies

  11 years, 5 months ago

  By: Umer Akram

• comparision based on Dates

  I need to compare the ACC_Backlog data for the last two months. The table has monthwise data from M…

  sharonsql2013

  6 replies

  11 years, 5 months ago

  By: Sean Lange

• The cluster resource 'SQL Server' Could not be brought online

  Hello Masters, I am trying to install MSSQL Server 2008 R2 cluster on OS Windows server 2008 R2, in…

  jitendra.padhiyar

  5 replies

  11 years, 5 months ago

  By: Perry Whittle

• SQL User Account assigned as db_owner of any new database that is created.

  While going through a monthly security check I noticed that a user account that is the owner of one…

  bkrankel

  3 replies

  11 years, 5 months ago

  By: bkrankel

• Your SQL Query is required

  your urgent help is highly appreciated as this is a high priority task. Here is a little background…

  Sana4u

  1 replies

  11 years, 5 months ago

  By: Koen Verbeeck

• SQL Service startup/shutdown - Windows or Configuration Manager?

  Hi - I've been advised that when a SQL service needs to be stopped or started this should be done t…

  dax.latchford

  2 replies

  11 years, 5 months ago

  By: dax.latchford

• replication Error: MSSQLServer, Error number: 8152

  i apologize if this in the wrong place. i have a replication job publishing to 7 other instances, o…

  jon.strout

  4 replies

  11 years, 5 months ago

  By: jon.strout

• Help - Need to take all SQL DB's down for possible electrical shutdown

  Hi - We have been advised that some electrical work is possibly being carried out tomorrow morning …

  dax.latchford

  6 replies

  11 years, 5 months ago

  By: Grant Fritchey

• function and procedures

  in an interview i have said that the functions are executed at the clients memory and stored proced…

  rama_kavuri

  4 replies

  11 years, 5 months ago

  By: Grant Fritchey