SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• How to "tag" viewed customer records

  Hi all, I tried to search on my question, but I'm having difficulty specifying helpful search param…

  SteveBell

  2 replies

  14 years, 8 months ago

  By: SteveBell

• How to use Trigger

  Hi friends..... I created a report using JSP, for that report i've used around 15 tables, usi…

  sh_kishor

  6 replies

  14 years, 8 months ago

  By: sh_kishor

• Error while storing results of sp_spaceused in a new table.

  Hi All, I am getting the following error when run the below script. "Insert Error: Column name or n…

  anjaliv

  10 replies

  14 years, 8 months ago

  By: anjaliv

• ANSI Padding In Only Some of Result Rows for Joined Table

  I have a question about some strange behavior I've observed. I'll simplify things a little for thi…

  rapperson

  4 replies

  14 years, 8 months ago

  By: Orlando Colamatteo

• sql server agent error

  Hi All, The sql server Agent(MSSQLSERVER) service on local computer started and stopped.Some servic…

  shilpa.shankar87

  4 replies

  14 years, 8 months ago

  By: RP_DBA

• Is there a limit on the number of values that can be used in an IN clause?

  Hi Does anybody know if here is a limit on the number of records that can be used in an 'IN' clause…

  darren.siegert 26212

  4 replies

  14 years, 8 months ago

  By: darren.siegert 26212

• ISO Week - calculate first monday day from given week

  Sombody now how to calculate first monday day from given week   For example I need get the day…

  requena

  3 replies

  14 years, 8 months ago

  By: geoff5

• SQL Server 2005 on Small Business Server 2003

  Is SQL Server 2005 for SBS without SSIS (and SSAS)? If that's the case, are SSIS and SSAS on SBS no…

  drew.georgopulos

  2 replies

  14 years, 8 months ago

  By: drew.georgopulos

• COMPLEX QUERY --select a coloumn name as value and using the value in a SELECT query.

  Hi All, Using the TABLE_NAME OR COLOUMN NAME from the result of a query and Using THESE values in a…

  hemanth T

  7 replies

  14 years, 8 months ago

  By: nigel.

• Transactions In Stored Procedure

  Hi Friends, I've three tables viz : Classes, Students, Logs. Classes - Store records of one single …

  Ashwin9

  1 replies

  14 years, 8 months ago

  By: LutzM

• create table through cursor

  Hi All, I am creating a table using cursor and it gets created in tempdb. Even if i specify the dat…

  anjaliv

  10 replies

  14 years, 8 months ago

  By: anjaliv

• Column Delete Issue

  Hello Friends I need to delete a column from a table that has 30000 records and it should not effec…

  sqlquest2575

  4 replies

  14 years, 8 months ago

  By: Eric M Russell

• Efficient ways to reset lost sql sa password

  Have you ever forgot or lost your SQL Server sa password? Did you hava any ideals to reset your los…

  yitiana

  25 replies

  14 years, 8 months ago

  By: Eric M Russell

• Using SET DATEFIRST 1 (Monday as day 1 )

  Hi, I am working on a report which displays the week numbers for a particular year. The problem is …

  pwalter83

  8 replies

  14 years, 8 months ago

  By: LutzM

• String conversion problem

  Hi, I am having the following problem. I am loading a string formated number from one table so as t…

  hector__21

  4 replies

  14 years, 8 months ago

  By: hector__21