SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• How to create a Temp Table?

  I would Like to create a temporary table to store data to do some testing. How can I create a temp …

  zy-eliz

  4 replies

  15 years, 11 months ago

  By: david.gray

• Selecting data based on the max value in a seperate table.

  I'm new to SQL but a software developer for years. LINQ here I come 😉 I have a seemingly simple co…

  stewsterl 80804

  3 replies

  15 years, 11 months ago

  By: stewsterl 80804

• Copy text file from one PC (XP OS) to another PC ( Vista OS) Using Dos Copy command

  I have two PC, One of them running on XP OS and another running on Vista OS. Now I want to copy on…

  amipatel1986-1109773

  1 replies

  15 years, 11 months ago

  By: sanoj_av2001

• Incorrect syntax near the keyword 'GRANT'

  Hi All, Whats wrong for the below procedure? It is showing the following error "Incorrect syntax n…

  SqlUser-529296

  2 replies

  15 years, 11 months ago

  By: diamondgm

• datetime 0.33 ms rounded problem

  Hi, According to BOL the datetime field would round to 0.33 ms, but we want to store exact and accu…

  Chan Wai Yin

  1 replies

  15 years, 11 months ago

  By: diamondgm

• Cursor behavior from SQL 2000 to SQL 2005

  Hi all, One database on SQL 2000 had a stproc which used a cursor that called another stproc that a…

  rrenn007

  1 replies

  15 years, 11 months ago

  By: rrenn007

• xp_sendmail failed with mail error 0x80004005

  Hi , I have a job in SQL Server 2000, which has 5 steps in it, all the job is to send the …

  dakshinamurthy-655138

  7 replies

  15 years, 11 months ago

  By: lconsiglio

• SSRS report generation

  Hi Guys, Can any body tell me how to not to keep creating datasets for every single report in a pro…

  gunajnb2b

  1 replies

  15 years, 11 months ago

  By: dforck

• Insert Query issue

  Hi, I'm trying to insert data from one table into another using the following query but i'm not sur…

  sc-w

  2 replies

  15 years, 11 months ago

  By: sc-w

• Defragementation Problem

  Respected All I checked one table from DMV sys.dm_db_index_physical_stats and found avg_fragmentati…

  gupta1282

  1 replies

  15 years, 11 months ago

  By: Silverfox

• Query Issue producing strange results

  Hi, I have query that is giving me results I can't put any logic to on my production environment bu…

  sc-w

  4 replies

  15 years, 11 months ago

  By: sc-w

• problems during 2005 install

  Hello, I know that for some of you this question it will sound stupid so I’m sorry, but is been a w…

  dvora.id

  3 replies

  15 years, 11 months ago

  By: Nabha

• Deadlock and Slowness in SQL 2005

  Hi, We recently migrated to SQL Server 2005 with out client and our application is web-based using…

  TechChoc

  3 replies

  15 years, 11 months ago

  By: Jack Corbett

• SQL Licensing - what constitutes a CAL?

  I have a SQL Server on a VPS with 5 CALs. This server runs a Production DB accessed by a Web Serve…

  philmond

  2 replies

  15 years, 11 months ago

  By: philmond

• Execute Batch File

  Respected All I want to execute a batch file on system start up that call a sql script file but the…

  gupta1282

  2 replies

  15 years, 11 months ago

  By: Elliott Whitlow