SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Connect By ServerName in SSMS

  Dear, I am working in a domain pc and its IP Series is 192.168.100.0 and I want to connect to a SQL…

  shohelr2003

  1 replies

  11 years ago

  By: free_mascot

• compare dates in rows of a table

  I have the following information in a table. What I would like to do is pull out all the visits fo…

  tndanley

  2 replies

  11 years ago

  By: Dwain Camps

• Integer Compression

  Hi all, I'm curious how SQL Server compresses integers. MSDN says: Uses only the bytes there ar…

  Xedni

  4 replies

  11 years ago

  By: ScottPletcher

• Full Text Search - Issue

  Hi everyone, I am searching for the key word 'Platform Customer Support' using full text search. M…

  ashoktheagarajan

  2 replies

  11 years ago

  By: ScottPletcher

• Slow down a transaction

  Hello I have a procedure that takes awhile to complete. What I started noticing was the procedure …

  cgreathouse

  3 replies

  11 years ago

  By: ScottPletcher

• Unable to Pass the value to the DB_ID(). Please suggest the logical error.

  declare @Str varchar(100) --@specificDB varchar(100), DECLARE @dbid int SELECT @dbid = DB_ID(@spec…

  SQL_Hunt

  5 replies

  11 years ago

  By: Grant Fritchey

• XML Nodes to retreive the child and its list of values.

  HI all, i was trying to use the XML read functionality using t-SQL for XML attached The column is c…

  pawan.clong10

  11 replies

  11 years ago

  By: Jeff Moden

• IsDate() function returns wrong results

  All dates in codes below are valid dates, at least for me. But SQL identifies as not date, although…

  seaport

  5 replies

  11 years ago

  By: seaport

• sql 2008r2 performance issues

  Hi All im using windows server 2008r2 with sql server 2008r2 on this server im running also the TFS…

  guy3145

  10 replies

  11 years ago

  By: guy3145

• Help with dynamic SQL

  Hi guys, I have a dynamic SQL script that errors out. Can you guys provide some insight on how to r…

  Briceston

  6 replies

  11 years ago

  By: Luis Cazares

• Security Problems after SSRS Domain Migration

  Morning all, I recently carried out an SSRS Migration from one domain to another. I used the backup…

  McSQL

  6 replies

  11 years ago

  By: sbogue

• How to execute SQL scripts in batch

  I have separate scripts for Creation of Tables, Stored Procedures, Views, Triggers in different .sq…

  balushanmugham

  3 replies

  11 years ago

  By: Alan Burstein

• I broke my Visual Studio 2008 BIDS...

  Hi, I cleaned my disk and also uninstalled Sql2008 and installed Sql2014. I also tested Visual Stud…

  WilburSmith

  2 replies

  11 years ago

  By: WilburSmith

• SQL Agent Replciation Job limit

  Hello I have a problem with creating a new subscription.We have replication jobs for many database …

  wannabe1

  2 replies

  11 years ago

  By: wannabe1

• How can I create my own custom SSIS 2008 SFTP Component?

  I need help, please. One of our internal departments is going from FTP to SFTP. We use SSIS to send…

  Brandie Tarvin

  12 replies

  11 years ago

  By: Brandie Tarvin