SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How Many type of Function in SQL Server ?

  function in sql server? Thanks Alok

  Alok Kumar Sharma

  7 replies

  13 years, 10 months ago

  By: Lowell

• moving large data

  I need to move over 30 million rows from server A table A1 to server B table B1. Which is the best …

  HBK_4700

  3 replies

  13 years, 10 months ago

  By: TheSQLGuru

• check collation settings

  We have a small application that using sql express. But I see no management studio installed on tha…

  sqlfriend

  6 replies

  13 years, 10 months ago

  By: Lowell

• Recode 2008 Code to 2005 Code

  I have a sql script that will run on 2008 but when I run it on2005 server/db, it gives me errors. …

  GrassHopper

  2 replies

  13 years, 10 months ago

  By: Lowell

• Porting the SQL logins - User Roles

  Hi, I am moving SQL logins from a server instance to another (Both are same versions - SQL server 2…

  Rainmaker097

  2 replies

  13 years, 10 months ago

  By: timster

• Optional parameters in WHERE clause

  I've been looking around for various ways to do SELECTS in a stored procedure with optional paramet…

  pdanes

  14 replies

  13 years, 10 months ago

  By: pdanes

• Update a table with a column image

  Hi, I added a new column (image) to an existing table. I'd like to update this table populating th…

  pacita_tibay

  3 replies

  13 years, 10 months ago

  By: Lynn Pettis

• A network-related or instance-specific error occurred while establishing a connection to SQL Server - Error

  Dear All, I have been trying to resolve the following error message for a while now, but I have no …

  tt-615680

  15 replies

  13 years, 10 months ago

  By: Jared

• Schedule job failure

  i guys, A scheduled job is failing continuously with this error Executed as user: BLAH\admin. Faile…

  Rainmaker097

  3 replies

  13 years, 10 months ago

  By: Rainmaker097

• Xp_Cmdshell Problem

  Hi Getting the folling error when running any xp_cmdshell command "A transport-level error has occ…

  timster

  5 replies

  13 years, 10 months ago

  By: Lokesh Vij

• Transaction Logs Initial Size

  I am at a total loss here... :ermm: Yesterday I noticed my log file was larger than my database. I …

  SQL_Enthusiast

  1 replies

  13 years, 10 months ago

  By: Robert Klimes

• Upgrade 2008 r2 Cluster to SQl 2012 Always on (with SAN)

  I can't find anything which demonstrates best practise while doing an in-line upgrade of 3 node clu…

  Bobby Glover

  4 replies

  13 years, 10 months ago

  By: Perry Whittle

• sql query

  Hi Friends, Table1 RPTTypeCode Firstname LastName BarrowerID LoanTransID ...................…

  Swetha527

  15 replies

  13 years, 10 months ago

  By: Luis Cazares

• trying to connect via cognos catalogue (7.3) to sql 2008 database

  The user i am using is me and I have permission to the database in question, but I cannot access th…

  Trout

  4 replies

  13 years, 10 months ago

  By: blbaloun

• Debugging becomes complex for finding missing rows in joins

  Hey Everyone, I am experiencing a complex situation where i am writing query to move huge(1 million…

  hemanth T

  2 replies

  13 years, 10 months ago

  By: Jared