SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• query results not matching

  I have two queries one is fetching data for a particular id select max(a1.sequence) from A a1, R r1…

  Pink123

  3 replies

  15 years, 1 months ago

  By: Dave Ballantyne

• Table partitionong in SQL 2005

  Hi All , Some queries are running slow and we are suspecting a table that is causing it . We want …

  aby_dvd

  4 replies

  15 years, 1 months ago

  By: Dave Vick

• problem with trigger

  Hello All I am having problem with a trigger which i really cant understand. I am use this trigger…

  kurtlgreen

  4 replies

  15 years, 1 months ago

  By: kurtlgreen

• Question On Returning The Earliest Date

  Here's my data: EmpId Date 11/18/2011 6:30:00 AM 11/18/2011 4:45:00 PM 21/18/2011 …

  mkc116

  3 replies

  15 years, 1 months ago

  By: GSquared

• Difference between SQL server 2000 & 2005

  Hi, I have worked on SQL server 2000 but never got a chance to work on SQL server 2005.Can anyone h…

  Seemita Das

  10 replies

  15 years, 1 months ago

  By: reddy.pradeep722

• sql server default username and password

  hello guys! i am new here at sqlservercentral.com and this is my first post 🙂 i have some questions…

  kornflakes20

  9 replies

  15 years, 1 months ago

  By: Gail Shaw

• Trigger? SQL Server 2005 SP2

  Hi. I would like to send email notification to all@domain.com when user logins = 28. Email: Please …

  2Tall

  6 replies

  15 years, 1 months ago

  By: 2Tall

• Inserting Select statement within join

  Hello, I am trying to create a query wherein I need to create multiple columns using the same field…

  pwalter83

  6 replies

  15 years, 1 months ago

  By: pwalter83

• Openquery returning only 1 row result from AS400

  Hi, I have a strange problem with a simple openquery statement to an AS400 linked server. my statem…

  Jordan Chan

  3 replies

  15 years, 1 months ago

  By: kevinwils

• Wierd process...

  Hi guys, I could use some assistance... I was noticing some sluggishness on mt SQL 2k5 server - whe…

  tina_tysinger

  1 replies

  15 years, 1 months ago

  By: Gail Shaw

• Performance degrades over time reboot only provides temporary fix

  I have an SQL Server 2005 64 bit installation running in Windows 2008 R2 Enterprise. The performanc…

  Benjamin Bellamy

  7 replies

  15 years, 1 months ago

  By: Grant Fritchey

• SSRS Shared Schedule Permission

  I would like to give a group of users the ability to use Shared Schedules in Reporting Services. H…

  robshobs

  1 replies

  15 years, 1 months ago

  By: Jenn S

• Intermittent Timeouts from all client types

  Dear all, in November 2010 we migrated from a singe Windows 2000 Server hosting SQL 2000 (32-bit) a…

  balde

  1 replies

  15 years, 1 months ago

  By: homebrew01

• Percentage change

  I am trying to find the percentage change from a value of the month of Jan 2011, compared to the va…

  SQLbeginner

  4 replies

  15 years, 1 months ago

  By: Mike01

• Simple Query Question

  the table i'm querying looks something like this: empid name Da…

  mkc116

  10 replies

  15 years, 1 months ago

  By: mkc116