SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Data conversions for hours.

  I have hours coming into a stored procedure with definition of nvarchar(24). I am getting this fro…

  ruffindmc

  7 replies

  14 years, 11 months ago

  By: Ron McCullough

• Minimum SQL database permissions required to use impersonation on SSRS data source connection?

  Hi I am currently encountering the following error when I try to specify a datasource from SSRS to …

  killian_Davies

  1 replies

  14 years, 11 months ago

  By: kevin_nikolai

• Login failed for user ''. The user is not associated with a trusted SQL Server connection.

  Hello all, I am on sql server 2005. And lately we been getting these error on our sql server log.…

  crazylifescary

  9 replies

  14 years, 11 months ago

  By: kevin_nikolai

• Joining on MD5 hash column

  Has anyone done any large-scale joins based off an MD5 hash? I'm inserting to a table based off of…

  TheGreenShepherd

  6 replies

  14 years, 11 months ago

  By: Elliott Whitlow

• Error from an SQL job once we migrated to sql 2008 R2

  I have a job scheduled on srvr2 that calls a stored proc The stored proc pulls in some data from sr…

  Guras

  2 replies

  14 years, 11 months ago

  By: Guras

• What is the difference between for and after trigger?

  What is the difference between for and after trigger?

  invaliddba

  3 replies

  14 years, 11 months ago

  By: Evil Kraig F

• SQL server license

  I have a couple of questions about the SQL server licensing. I see on microsoft site FAQ: 1. Q. D…

  sqlfriend

  2 replies

  14 years, 11 months ago

  By: Welsh Corgi

• SSIS - Warning on Simple Export of Data from SQL to Excel

  I get a warning when executing a package. Does anyone have any idea what I'm missing? - Executing (…

  Welsh Corgi

  2 replies

  14 years, 11 months ago

  By: Welsh Corgi

• trying to import a excel file to the database table ( the following error occurs )

  TITLE: SQL Server Import and Export Wizard ------------------------------ The operation could not b…

  koolme_85

  4 replies

  14 years, 11 months ago

  By: Orlando Colamatteo

• To increase value from Engg0 to Engg1, Engg2, and so On!!!

  Hello Dear Friends, How can I increase the value 'Engg0' to N'Engg1', N'Engg2' and so on when next …

  Gopal Singh

  19 replies

  14 years, 11 months ago

  By: Gopal Singh

• Getting db restore statements out of msdb

  Does anyone have a script to build the necessary restore statements for a full db backup and trans …

  Anonymous

  6 replies

  14 years, 11 months ago

  By: Chuck Hottle

• BackupVirtualDeviceFile::SendFileInfoBegin suddenly started to appear

  Over the past 2 days, at the same time at night, the following error messages have started appearin…

  Rayven

  3 replies

  14 years, 11 months ago

  By: Rayven

• How to get the id's of those who have a specific price for every date ....

  I want to get the id's of everyone who has a specific value for every date. ex. From the following …

  tzanouch

  8 replies

  14 years, 11 months ago

  By: tzanouch

• Need help with stored Procedure

  i have a table with below structure ID ClientID StatusStartDate Status 1 100 2010-01-2…

  Lucky9

  13 replies

  14 years, 11 months ago

  By: Welsh Corgi

• AWD SQL - Getting a single value returned when using > on 2 columns

  Hello - I'm new to this so bare with me! I'm stuck on the subquery at the end here. It seems to onl…

  chris osborn

  4 replies

  14 years, 11 months ago

  By: Sean Lange