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 >>

SSIS.... i have a table like......sales india    usa   srilanka    pakistan a1       a2      a3           a4 b1       b2      b3    

asked 4/24/2015 8:52:20 AM
0 answers

mdf files to big in SQL server 2005
Hi There,I hope someone can advise me on what to do here.I am running my database on SQL Server 2005. I had created a backup maintance job myself using the  SQL Server Management Studio,when using a maintance plan i set up this to delete files based

asked 4/22/2015 2:09:42 PM
by GregoryGood
1 answers

Sql sorting And searching
HiThe following questions are about "Microsoft SQL server 2008 R2" or newer. I have 125 tables in my database, and they are sorted only by their names. I want the largest table to be first. (the table that has more records.) How can we sort tables by

asked 4/18/2015 9:59:25 AM
by bhgh
2 answers

Powershell scripts for upload only current date text file to sql server from various app server
Hi All,   Powershell scripts for upload only current date  text file to sql server from various app server

asked 4/18/2015 2:27:32 AM
by Subhamay Chatterjee
0 answers

SSAS running in SSIS packages failing
0 Sign in to vote I have a SQL Server 2014 Always On QA environment with 3 nodes running Developer Edition 64-bit with Build version 12.0.2456.0.  I’m having an issue with a couple of packages in QA that has me stumped. 

asked 4/17/2015 11:34:01 AM
by Phillip Holtquist
0 answers

Trouble with a couple SSIS packages in SQL Server 2014
I have a SQL Server 2014 Always On QA environment with 3 nodes running Developer Edition 64-bit with Build version 12.0.2456.0.  I’m having an issue with a couple of packages in QA that has me stumped.  It works fine in production, so I&r

asked 4/16/2015 12:16:15 PM
by Phillip Holtquist
0 answers

Procedure to import data daily on DB1 (table 1) from DB2 (table 1)
  Hi all, I have come across an issue and I need some info. I need to create a procedure to enter data into a table in a database (eg DB1, Table1), but the data will come from another database within the same server (eg DB2, Table X). Can anyone

asked 4/16/2015 11:31:09 AM
by Gieorg
1 answers

SQL Server 2008 Agent Job Failing to connect to an Oracle Database
Dear All,   I am running SQL Server 2008 on a OS Windows 2008 64 bit. I have created a Job that needs to update some tables in an Oracle Database. The data source definition is setup only with a user id where i cannot setuo the sysntax as pa

asked 4/16/2015 8:48:37 AM
by Anibal Lopez
0 answers

Refresh Replicated Database from non replicated database
Sever 1 DB1 = replication is set Server 2 DB1= Same database as DB1 but no replication How to I refresh DB1 in Server 1 from DB1 in Server 2 without intrupting the replication.??? Need Help ASAP

asked 4/15/2015 11:00:33 AM
by jama
0 answers

Error: "The server failed to resume the transaction"
After conversion from Visual Studion 2003 to Visual Studio 2005, we started to get some error related to server transaction. "The server failed to resume the transaction".   What possible reasons can cause this? 

asked 4/15/2015 10:06:53 AM
by Eugene
0 answers

How to execute the below SQL query automatically daily and send the result .xlsx format to an emailDL group
The SQL query is something like this declare @run_date varchar(20), declare @run_date_plus_1 varchar(20), select @run_date = '13 April 2015'   -- change this run date select @run_date_plus_1 = dateadd(dd,1,@run_date) select @run_date,@run_d

asked 4/14/2015 12:58:40 PM
by Rakesh Kumar
1 answers

SSL Certificate
can we logon sql server using SSL certificate? how do sql client connect to sql server using SSL certificate?

asked 4/10/2015 10:45:52 AM
by Rahul
0 answers

Active Directory
Hi Since they have change AD structure i'm getting trouble to make my query work as i wanted. Below is the structure containing two groups one nameed 'Coordination' and the oher 'Administrator' Administrator contain Coordination and both are under OU O

asked 4/10/2015 9:09:08 AM
by Alexandre
0 answers

Using DTEXEC to set database name as a variable in SQL Server Agent job
Hi   I have saved some SQL import routines as File System and created a SQL Server Agent job which includes each table import as a step.  This works okay for the Database that I was using during the import, but I want to be able to run the sam

asked 4/10/2015 6:11:57 AM
by Simon A
0 answers

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
0 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

Sponsor Information