Learn more about SQL Server tools


SQL Server Question and Answers

Ask a SQL Server Question

Search All Questions:
SQL Server Questions And Answers
<< Previous Page        Next Page >>

Get the value before last one SSRS
I  create a report with SSRS 2008 in this format : create a report with SSRS 2008 in this format :                  yearData        20

asked 4/10/2015 6:04:52 AM
by Ahmed
0 answers

Replication Error in 2012
  The following error is shown when REPLICATION MONITOR is seen in SNAPSHOT AGENT. Can anyone clear this why it is showing. While creating no error can both for publication and substription. please.  Thanks in advance Error messages: Sourc

asked 4/9/2015 7:45:27 AM
by Satya Sai P
1 answers

MDS Model disappeared from MDS Excel/Web UI
  Hello,   One of our MDS Model is not showing up in MDS Excel interface/Web UI. Back end tables/Views are intact.   Have anyone come acrross this issue? any pointers are appreciated.   thanks, Susheel

asked 4/8/2015 1:06:57 PM
by Susheel
0 answers

Time Calculations in a cube
Hi All, I have been working at this for sometime to no avail. I hope the community can help. Here goes I have cube that ultimately measures compliance in an organisation Each compliance topic has a duration e.g. Equality and Diversity - 3 yrs or Fire Saf

asked 4/7/2015 6:35:53 AM
by Marvin Perrott
0 answers

Database is a corrupt file. This file cannot verify
After a backup exec job is finished backing up databases the following errors appears: Click an exception below to locate it in the job log The backup options or selections for this job have changed since the last time it ran.   Backup- SQL-SERVER

asked 4/6/2015 12:44:14 PM
by heribertolaverde
2 answers

How to recover corrupted database file( .mdf .ldf)?
I run MSDE on a Windows XP Server and i found that my database was marked as "suspect" by Enterprise Manager and its icon become gray. I detach that database and try to re-attach it but there is an error as the following: Error 3624: Location : page.cp

asked 4/6/2015 12:17:40 PM
by norbertosolares
1 answers

LogShipping references wrong server in Ls_Copy
I have a weird issue with LogShipping: When I add a secondary server the job that is created references the wrong machine!- The secondary server is SqlServer3H\SqlServer4- But the ls_Copy and ls_Restore jobs reference SqlServer4H\SqlServer4Notea: - Initia

asked 4/2/2015 9:41:33 AM
by John Turpin
0 answers

I need to export Excel data (which has only one sheet) into SQL server table. Number of column for excel are fixed but the last few(consider 3) column names of excel sheet are changing dynamically(i.e. column names changes as per organization's requireme

asked 4/2/2015 2:08:54 AM
by pjyoti
0 answers

Database is a corrupt file. This file cannot verify. Is any method for recovery?
After a backup exec job is finished backing up databases the following errors appears: Click an exception below to locate it in the job log The backup options or selections for this job have changed since the last time it ran. Backup- SQL-SERVER-SQL1.doma

asked 4/1/2015 6:01:38 PM
by manuelsantos
2 answers

the question is related to Apache Tomcat server(library management system). How to upload images in MY SQL server/ TOMCAT server and store them in MY SQL data base, and retrieve from MY SQL database ?

asked 4/1/2015 11:37:33 AM
by vishwanath
0 answers

Recover Entire SQL Database Objects with SQL Repair Tool
Hi. I have a legal program that uses SQL express 2005. Somehow the company is saying my sql file has become corrupted and needs to be sent to a company to be rebuilt or fixed. Is there a way I can fix it?

asked 3/31/2015 8:07:29 AM
by James
3 answers

SQL Server Database Instance Consolidation and Clustering
Hi, I have a Environment where there are 115 Database Instances, Which includes Production as well as Development Servers. These Instances host various Business application. I have given a task of Consolidating these servers may be using Cluster. T

asked 3/31/2015 3:54:05 AM
by Nitin Saklecha
3 answers


asked 3/31/2015 3:04:14 AM
by obaidullah
0 answers

Attach multiple Database file at one time in sql server 2008 r2
I am  Formated my PC I install sql server 2008 R2 but i have more than 20 databases then how i can attach those database files at one time on sql server 2008 R2

asked 3/28/2015 3:20:58 AM
by Priyanka Belhekar
1 answers

I need to split a column values containing example character 450560663-AVI-PRO-TRA-TRA1-181JN15. Each part should be included different columns like below   Column 1             &nbs

asked 3/26/2015 3:35:33 AM
by bryan beeharry
2 answers

Extracting DDL of Database objects using SQL Authentication for redeployment
Hello  dbscripter.ps1 (http://powershell.com/cs/media/p/33996.aspx)  which I found on one powershell web site is very useful and works but with limitation. I am newbie for powershell and I am trying to understand it can be modified to to S

asked 3/24/2015 7:13:29 AM
by Arun
1 answers

ERROR: Failed to connect to server AUDDBAS1
Greetings for the day,  i am getting the error while configuring log shipping its ran successfully after 3 days after  I am getting LS_Backup  Job is running continuously from last 1 day. In view history of the backup job i am getting the

asked 3/23/2015 4:29:13 PM
by Siva Kolluri
2 answers

List All Securables Permissions on Tables, by Roles
  I am having a real metal brain block.  I have created this script before and now I can not get it right since I have to recreate it since I didnt take it with me from my last job.   I need a script that lists all of the tables in a d

asked 3/23/2015 2:46:11 PM
by Swoozie
1 answers

I am running SQl 2008 and have a database from an application called Therascribe.  From Therascribe i pulled reports and write queries. The issue is,there is no trainiing on Therascribe and i am new on the job. So i am looking for a way to be able t

asked 3/23/2015 1:34:04 PM
by Tech1
1 answers

Create a view in an ODBC connection
How can i re-create a view (which is being cleared out each time an application is run) through an ODBC connection by using a bacth file?

asked 3/23/2015 8:41:29 AM
by bryan beeharry
0 answers

Sponsor Information



Get Free SQL Tips










BI Professionals


Q and A

Today's Tip







Tip Categories

Search By TipID



First Timer?


Free T-shirt



User Groups

Author of the Year

More Info








Copyright (c) 2006-2015 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.