SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Extract table data along with XMl column

  Hi, I have a table which contains different columns including one column having data in XML format.…

  poratips

  1 replies

  15 years, 1 month ago

  By: LutzM

• Migration........

  Hi, Plz help me on following type of scinario. I m having a table custinfo with the coloumns Fname,…

  abhas

  2 replies

  15 years, 1 month ago

  By: J Livingston SQL

• Unwanted NULL Characters in Query-to-TextFile Output: A Solution

  This may be old news to everyone, but I posted a question here (http://www.sqlservercentral.com/For…

  Rich Mechaber

  3 replies

  15 years, 1 month ago

  By: BSql_Dev

• Cannot connect remotely to SQL Express 2005

  When I try to connect to another computer on my home network running SSEXP 2005 I get the following…

  tripower

  1 replies

  15 years, 1 month ago

  By: Adiga

• how to find max colunm values tied to 2 colunms

  hi every one well new to this as i've recently become a cripple.but i have a little query I'm tryin…

  emailcooney

  5 replies

  15 years, 1 month ago

  By: ben.bizzell

• Converting rows into columns(MSSQL and Crystal Report)

  I have 3 columns. The output of the stored procedure look like below... Month Total HoursUtili…

  deepankarthiks 21157

  3 replies

  15 years, 1 month ago

  By: torpkev

• SQL Licensing - Instances

  Hi All, Can anyone help with a licensing question? If you have multiple instances on a server that…

  Ness

  2 replies

  15 years, 1 month ago

  By: Ness

• Format report data in the app or in SQL?

  Hi reading a recent post on this site, got me to thinking about how I currently present data to use…

  J Livingston SQL

  8 replies

  15 years, 1 month ago

  By: Jeff Moden

• BCP Utility

  I have a stored procedure that uses the BCP utility to import data from a flat file using a format…

  bryan.duchesne

  8 replies

  15 years, 1 month ago

  By: Jeff Moden

• how to call sql function in stored procedure

  stored procedure SELECT TOP (100) PERCENT a.Date as Date, emp.Employee_Name AS Employeename, a.Sta…

  khizar.hasan

  2 replies

  15 years, 1 month ago

  By: Mike01

• How to fail SQLjob when we try to run ANALYSISCOMMAND?

  I have scheduled a job to run the Analysis XMLA script using the ANALYSISCOMMAND subsystem . The J…

  suneel_net

  2 replies

  15 years, 1 month ago

  By: suneel_net

• Add identity field to an existing table, change clustered primary key to non-clustered ,and created a clustered index on the new identity field

  1) ALTER TABLE TableX ADD FieldA indentity(1,1) 2) Drop the existing clustered index first (IX_Tabl…

  Maina-456685

  2 replies

  15 years, 1 month ago

  By: Maina-456685

• Error 3449

  Hi Guys, One day I noticed that my SQL Server and SQL Agent was automatically shut down. Doing a qu…

  srawant

  1 replies

  15 years, 1 month ago

  By: Tara Kizer

• SQL 2005 Std Cluster Issue

  Hi, I'm looking for a bit of assistance as I'm a bit stuck with a multiple instance cluster. The b…

  thelark1

  3 replies

  15 years, 1 month ago

  By: Steve-3_5_7_9

• Xp_SendMail - Error since migrating to 2005

  Hello - I recently migrated from 2000 to 2005. We use XP_SENDMAIL (I know that I need to switch to …

  Bosco2

  1 replies

  15 years, 1 month ago

  By: Bosco2