SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• What causes "Sqlcmd: Warning: The last operation was terminated because the user pressed CTRL+C."?

  We have a generic script (rebuild_indexes.sql) that we use to rebuild/reorganize our SQL Server 200…

  shew

  6 replies

  14 years, 5 months ago

  By: Ant-Green

• .net error while opening the database

  While opening the database in one of my 2008 server , I am getting an error - Property is Datawareh…

  aby_dvd

  7 replies

  14 years, 5 months ago

  By: Gail Shaw

• Run batch file from SQL

  Hi, I know I can run a batch file with SQL Server using xp_cmdshell, but does anyone else know of a…

  Mike Scalise

  5 replies

  14 years, 5 months ago

  By: Mike Scalise

• Make selection in the table in various schemas.

  Hello, The structure of my database has a common schema and several schemas with the same table tha…

  cristiano.testai

  5 replies

  14 years, 5 months ago

  By: cristiano.testai

• Transaction Log Issue -- Please Help

  I have a Transaction log for one of my databases that after backing it up, only gets to about 40% f…

  Jeff Mayer

  25 replies

  14 years, 5 months ago

  By: Ninja's_RGR'us

• Restore Database in a Network Location having FILESTREAM enabled

  Hello, I am running a restore Database command from one machine say "abc" to restore the Dat…

  mitramadhu06

  5 replies

  14 years, 5 months ago

  By: Ant-Green

• SQL query to return child-paren relationship

  I have below table with fields (Plan_id, child_id, Child_type) Please suggest me the query which re…

  piyush_srivastava

  7 replies

  14 years, 5 months ago

  By: Erwin Dockx

• SQL 2008 Logshipping, secondary database issue

  I've got logshipping set up between two SQL 2008 EE (64-bit) servers and it's been running smoothly…

  MyDoggieJessie

  38 replies

  14 years, 5 months ago

  By: Devendrakumar

• Subquery returned more than 1 value

  I have the following tables and query: DECLARE @Employee TABLE( [ID] [int] IDENTITY(1,1) NOT NULL, …

  bubs

  6 replies

  14 years, 5 months ago

  By: Erwin Dockx

• Need Script to create log file

  Dear All, I need to create a log file in SQL Server 2008 which records the activities of th…

  anandha31

  13 replies

  14 years, 5 months ago

  By: anandha31

• table partitioning limitations

  Hi, Wonder to know the limitations of partitioned table if any exists. Could anyone help me? Have f…

  parissa_bakhshi

  5 replies

  14 years, 5 months ago

  By: parissa_bakhshi

• Down loading file from Ftp site

  For our web I am having to down load a file off a ftp site. The file name can change from RORD0001,…

  kyle.doouss

  15 replies

  14 years, 5 months ago

  By: Devendrakumar

• upgrade reporting server

  We would like to upgrade our reporting server that is installed on a separate server from another S…

  sqlfriend

  7 replies

  14 years, 5 months ago

  By: Ant-Green

• [DBNETLIB][ConnectionRead (recv()).]General network error

  Hi We have SQL Server 2008 EE 64bit SP3, with 16 logical processor and 64GB RAM on Windows 2008R2 …

  hemdbya

  4 replies

  14 years, 5 months ago

  By: hemdbya

• addlogin Issues

  We have a script that creates a server login, then a database, then associates/creates a database u…

  Jim Mace

  1 replies

  14 years, 5 months ago

  By: Lynn Pettis