SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Insert jpgs and file name into table

  Hello - I need to insert about 1600 pictures (jpgs) and their file names into a sql server table. …

  slsmithstone

  4 replies

  14 years, 8 months ago

  By: Sean Lange

• Incorrect syntax near 'sp_dboption'.

  Hello all, My error message is "Incorrect syntax near 'sp_dboption'" I am trying to build a script …

  Chrissy321

  8 replies

  14 years, 8 months ago

  By: Gail Shaw

• Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

  I have few SSRS 2008 reports. Databases are CRM databases. I have created a group of 10 users. Each…

  Ritesh_Dev

  5 replies

  14 years, 8 months ago

  By: Devendrakumar

• Datetime data type

  I have a data set with a date column that looks like this: '25-Apr-84'. I would like to convert i…

  Amy.G

  8 replies

  14 years, 8 months ago

  By: Devendrakumar

• SQL Agent Jovs : PowerShell step not sending notifications upon failure

  Hello, I have setup a few jobs under SQL Server Agent and have configured them to send notification…

  raotor

  3 replies

  14 years, 8 months ago

  By: Nicholas Cain

• There is already an object named '#Test' in the database

  If I run the following query: if cast(GETDATE() as time) > '12:00:00' select GETDATE() into #Te…

  okbangas

  10 replies

  14 years, 8 months ago

  By: okbangas

• Query that joins two tables and retrieves a sum

  Hi, I want to join two tables of information together. I want to bring the order information togeth…

  tarr94

  3 replies

  14 years, 8 months ago

  By: Possinator

• the location of stored procedures.

  I have a ssis that step1 is to load flat files sources to a staging database. Then step2 is load da…

  sqlfriend

  6 replies

  14 years, 8 months ago

  By: sqlfriend

• CDO vs Database Mail

  I'm in the process of moving a 2000 database to our new SQL 2008 R2 server. This 2000 DB uses CDO t…

  AVB

  2 replies

  14 years, 8 months ago

  By: spaghettidba

• Sql server 2008 AS service disabled

  Hi I tried to connect to Sql server 2008 R2 Analysis services instance but not succeeded. It is n…

  a2zwd

  5 replies

  14 years, 8 months ago

  By: s_osborne2

• I want update records from table1 to table 2 on Weekly basis

  I want update records from table1 to table 2 on Weekly basis Please can you help me the above case …

  madhoonu

  3 replies

  14 years, 8 months ago

  By: spaghettidba

• Excel 2010 VBA gives error on "Dim Conn As ADODB.Connection"

  I'm trying to populate data in Excel using a macro to call a SQL Stored Procedure. I am using the …

  Cindy Hallum

  2 replies

  14 years, 8 months ago

  By: spaghettidba

• SSRS 2005 visibility issue

  I was using SSRS 2005, and not got the sum of the desired result? I attached sample of the Filed …

  mak12

  1 replies

  14 years, 8 months ago

  By: patrickmcginnis59

• Automate new databases with role: db_datareader for sql user: readonly

  Hello, I need to auto-role a user for every new database the role: db_datareader for the sql userna…

  gala.umiy

  2 replies

  14 years, 8 months ago

  By: gala.umiy

• Transaction Log

  How do u recover data from transaction log files? Is the .ldf file and sql server log file under ma…

  Confusing Queries

  9 replies

  14 years, 8 months ago

  By: Gail Shaw