SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• MCDBA certification

  What's the procedure for MCDBA certification??? Regards, Pradeep

  PradeepVallabh

  2 replies

  15 years, 7 months ago

  By: Gail Shaw

• How to find no of employees whose startTime differs by 0hrs,with 2hrs.

  Hi ALL, This is my table. Based on MatchingOff Column I need to find no of employee who…

  naresh0407 93367

  4 replies

  15 years, 7 months ago

  By: Sean Lange

• Issue with trying to incorporate the following SELECT DATEPART(WEEKDAY, GETDATE())

  Hey All I am new to SQL development and come from a help desk background. This is one of my first …

  steve4134

  2 replies

  15 years, 7 months ago

  By: steve4134

• SQL 2005 Network Load Balance

  Hi, We currently have a SQL 2005 Standard installed on a Windows 2003 Standard server. What we want…

  active_elk

  5 replies

  15 years, 7 months ago

  By: Steve Jones - SSC Editor

• Need Example of Unicode and Non-unicode data

  Hello I Need Example of Unicode and Non-unicode data. when i have to create a table and select data…

  navpreet.khurmi

  7 replies

  15 years, 7 months ago

  By: Source-NH

• Shortcut Key for Running Batches

  Hi All, Is there a shortcut key, free plug-in, add-on or a something similar that I can use with SS…

  feersum_endjinn

  1 replies

  15 years, 7 months ago

  By: hallidayd

• SqlBulkCopy - Received an invalid column length from the bcp client ... ???

  Hi I'm stumped by the following exception message: Received an invalid column length from the bcp c…

  I.W Coetzer

  1 replies

  15 years, 7 months ago

  By: rhaider

• Add empty fileds to and SQL Select Statement

  Hello, I have a BCP command that queries our database and creates a CSV file. This file is going to…

  robert693

  7 replies

  15 years, 7 months ago

  By: robert693

• How to get the Internal ID from a ROW

  Hello together, i have a table like this: ID PID 1 3 1 3 and I would like to update the f…

  guido.birkenfeld

  3 replies

  15 years, 7 months ago

  By: Carl Federl

• xp_cmdshell : 'Access Denied' running TaskKill

  Hi - I'm attempting to kill a process ( exe ) using TaskKill via xp_cmdshell and am getting the mes…

  spanielagain

  6 replies

  15 years, 7 months ago

  By: spanielagain

• Urgent SQL Linked Server Query - Cannot see ms access linked tables.

  I have a linked server connection to ms access db from my sql server. I checked the connections a…

  adonweb

  3 replies

  15 years, 7 months ago

  By: Lowell

• deploy reports programatically

  hi......... to all i've created one ssrs report and i want to deploy in programatically.. in c#.net…

  vinayak.v

  1 replies

  15 years, 7 months ago

  By: Rob Schripsema

• How to find no of employees whose TotalWorkingDays is 0 in 4 weeks

  Hi All, This is my table. I have 4weeks data of 4 employees.Out…

  naresh0407 93367

  1 replies

  15 years, 7 months ago

  By: Sean Lange

• Converting a VARCHAR to NVARCHAR

  I know that I can get into SSMS, bring up the design of any table and change its data type, but wha…

  Rod at work

  7 replies

  15 years, 7 months ago

  By: Rod at work

• Max

  Hai, I have Two tables. 1) Table name :A(Column name is Month_id) 2)table name :B(Column name is …

  mss.prince

  8 replies

  15 years, 7 months ago

  By: GSquared