SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Import problem

  Hello, I have 2 servers. I've created a select query to import data from server host to server dest…

  crowegreg

  28 replies

  9 years, 1 months ago

  By: Sue_H

• Adding extra rows based on supplied integer

  Hi All,Please i have a Tsql statement that i want to use to add extra rows to a set of rows based o…

  timotech

  2 replies

  9 years, 1 months ago

  By: timotech

• Puzzling INSERT to itself

  My database monitor tool, SolarWinds DPA, shows this INSERT coming from SSMS on my machine: INSERT …

  Eliyahu

  8 replies

  9 years, 1 months ago

  By: Sue_H

• SQL SErvice Browser

  Dear all, Let me put one question related with the SQL Browser Service. Is it necessary if I have j…

  river1

  2 replies

  9 years, 1 months ago

  By: spaghettidba

• Upgrading 2008 r2 SP2 to 2008 r2 SP3 - any concerns?

  Is it safe to assume that there are no deprecated features to be concerned with when upgrading to S…

  DentalDBA

  2 replies

  9 years, 1 months ago

  By: ScottPletcher

• Moving Transaction logs to a newly defined database on another server.

  We are finally getting around to moving an old SQL 2000 database to a new server; new OS; new versi…

  nelsonj-902869

  4 replies

  9 years, 1 months ago

  By: nelsonj-902869

• Need urgent help for creating index on subscriber replication server

  Hi All, I have set  up Transactional replication on our servers,need a clarification on below …

  Database admin(DBA)

  7 replies

  9 years, 1 months ago

  By: Database admin(DBA)

• Varchar Column type estimates

  I just realized sql server is estimating different data size when my column is varchar(7000) with t…

  curious_sqldba

  4 replies

  9 years, 1 months ago

  By: curious_sqldba

• seeking input on a polling process to copy info from one DB to another

  Looking for input on a desired result concerning multiple database and having a process "poll" one …

  timsheffield

  2 replies

  9 years, 1 months ago

  By: Steve Jones - SSC Editor

• Access Issue

  I have sqlagent reader role, operator role, user  role but when i try to create jobs it throws…

  premkuttan

  1 replies

  9 years, 1 months ago

  By: sgmunson

• Global Temp Table

  If I use #Final as a table (instead of #3Final) I get a message Invalid Object Name #Final.  I…

  texpic

  1 replies

  9 years, 1 months ago

  By: texpic

• 2008 R2 Jobs from .bak files not shown in new server when restoring

  Hello, I did full backup to our 2008 R2 SQL and restore to another 2008 R2 SQL server the only prob…

  alex_martinez

  4 replies

  9 years, 1 months ago

  By: Eirikur Eiriksson

• sqlcmd error when executed from bat file

  Hi All, Any ideas why I am getting the following error below?  It is being executing in a batc…

  davidsalazar01

  14 replies

  9 years, 1 months ago

  By: Jeff Moden

• Event 16969 logged with "remote calls to the SAM database have been denied in the past 900 seconds throttling windows" when i try to mount a remote bcm database

  Hi, i have a Ms BCM 2010 running on a Win 10 Pro station which is also a file server with SQL2008 S…

  ataenter

  2 replies

  9 years, 1 months ago

  By: ataenter

• Need Help Refuting a Statement about Normalization

  Hi there,  I just needed to get some collaborative advice.  I work on a system that is 15…

  amy26

  16 replies

  9 years, 1 months ago

  By: Luis Cazares