SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• IDENTITY_INSERT ON but error about column list, even though using column list

  Using [AdventureWorks2012] to perform insert which fails with error and I don't understand what to …

  KoldCoffee

  1 replies

  11 years, 10 months ago

  By: Luis Cazares

• Database mail alert fails for group account

  This is a new SQL Server 2008 R2 standard edition 64 bit environment. I've been down this path bef…

  jralston88

  4 replies

  11 years, 10 months ago

  By: jralston88

• Access Denied error when trying to attach AdventureWorks2012 .mdf file

  I've installed SQL Server 2012 (Enterprise trial) onto my laptop running Windows 7 Home Premium. I'…

  polkadot

  16 replies

  11 years, 10 months ago

  By: soyvanilla

• Access to the remote server is denied because no login-mapping exists

  Hi all, I created an app user and granted EXEC privs to run a procedure. There are no linked server…

  RightOnTarget

  4 replies

  11 years, 10 months ago

  By: RightOnTarget

• How to pull query result in excel sheet

  Hello Masters, We have around 47 MSSQL Servers and have around 1400 databases in it. We are monitor…

  jitendra.padhiyar

  2 replies

  11 years, 10 months ago

  By: SQLBlimp

• cannot access image data in sql server with linq to sql (drag-drop in vb winform)

  I tried data binding using linq to sql new technology by drag-drop from AdventureWorkDW2012.mdf , E…

  arayametee

  1 replies

  11 years, 10 months ago

  By: SQLBlimp

• First time for MSSQL to Oracle DB links

  Our management has decided to allow DBLinks from MSSQL to our Oracle system. What things should I …

  JeepHound

  1 replies

  11 years, 10 months ago

  By: SQLBlimp

• Variable Table and insert multiple values from a function

  Hi Everyone, Create Procedure InvoiceReport @StartDate Datetime @EndDate Datetime DECLARE @DateRepo…

  dquirion78

  11 replies

  11 years, 10 months ago

  By: dquirion78

• Syntax

  I am not sure whether this is correct or not ... Can anyone tell me. I am trying to take a count …

  sharonsql2013

  1 replies

  11 years, 10 months ago

  By: Lowell

• Query with most expensive CPU usage

  I find out a few top cpu consuming queries, what should I do with them? Thanks.

  Grace09

  6 replies

  11 years, 10 months ago

  By: Luis Cazares

• SSRS Report Manager Site Problem

  Hi all, I have recently started learning SQL Server mainly focusing towards SSRS. I have installed …

  artistdedigital

  3 replies

  11 years, 10 months ago

  By: artistdedigital

• How to change the Excelsheet filename while Export a report to Excel in ssrs

  Hi, I have generating many reports in SSRS, Now i need to add current time with the file name. For …

  ssjganesh

  1 replies

  11 years, 10 months ago

  By: Koen Verbeeck

• need to update 2nd table if data exists in table 1

  Hi everyone, I've 2 tables and both have a common field. What I'm after is to search table 1 and if…

  mick burden

  4 replies

  11 years, 10 months ago

  By: mick burden

• CommandShellLogin

  Hi All, I am new in the SQL SERVER. Can anyone tell me why we used to give IMPERSONATE grant access…

  arooj300

  3 replies

  11 years, 10 months ago

  By: pietlinden

• Extracting several rows of information

  Hi Guys I am very new to SQL and I am busy using microsoft access to learn the syntax. I am trying …

  craig.y.fraser

  6 replies

  11 years, 10 months ago

  By: craig.y.fraser