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

Replication is not working properly when i synchronize it gives this message i will write in the comment
  sql server is unable to complete the operation additional information: an error exception occured while attempting to access the subscription ( view synchronization status ) an exception occured while executing a transact-SQL statement or bat

asked 5/27/2015 12:53:55 AM
by obaidullah
0 answers

sql server reporting service goto url
I am facing problem when passing value for url through data field.   I am passing value in goto url like this ="javascript:void(window.open('file:" &Fields!url.Value &"','_blank'))"   url value = /servername/foldername/Formulá

asked 5/26/2015 4:56:01 AM
by shyam
0 answers

i want to perform a log backup in production server but my databases are in simple recovery model what can i do please help

asked 5/25/2015 2:16:53 PM
by girma mamo
0 answers

To uncluster a SQL2008 and make it as stand alone instance on one of the node
Uncluster a two node SQL 2008 cluster and make it standalone on one of the node. Here is the infrastructure setup NodeA - SQL Default Instance on lies NodeA.NodeB  NodeB is already down and they want to remove the cluster completely and make node

asked 5/25/2015 3:45:39 AM
by Prasaanth
0 answers

Error message
  UPDATE [DBASQLOverview].[dbo].[tblSQL_Servers] SET skip_sql_Overview = 'True' GO   UPDATE [DBASQLOverview].[dbo].[tblSQL_Servers] SET skip_sql_Overview = 'false' Where servers = 'SQL1\DEV1' GO   SELECT * FROM [DBASQLOverview].[

asked 5/19/2015 2:53:36 PM
by John
1 answers

Transactional database or Data warehouse
I am designing a database for a Document Management application using asp.net MVC. This application will have a lots of Metrics for Reporting. Because of the metrics and the reporting I am thinking of designing the whole database as a DataWareHouse. I wan

asked 5/19/2015 12:29:45 PM
by Ebenezer
0 answers

Calulate Salary for one week at a time in a given month
I need to calculate provider salaries in a week that starts on Sunday and ends Saturday. If the calculated salary is <$455, then the total salary=calculated+($455-calculated salary). This seems to be straightforward until I found out that beginnin

asked 5/19/2015 2:02:13 AM
by Helal
0 answers

How to view .trn backup file Sql textment (not filelistonly)
Dear all, How to view .trn backup file  Sql textment  (not filelistonly)     Thanks & regards, Subhamay Chatterjee india

asked 5/15/2015 3:23:43 AM
by Subhamay Chatterjee
0 answers

Damage of the SQL database
Good day, friends! There is the following situation.  On one server, I make a backup of the database. With integrity check everything is carried out. Transfer the backup to another server and restore from it base, has also successfully completed. I

asked 5/13/2015 11:27:31 AM
by baldwin
1 answers

SSIS 2012 : Package Deployment Model Deployment Error
I made a project with project level connections and all the packages in it are using these connections.  When I try to deploy the same project on the SQL server integration catalog, it is giving an error “Failed to deploy project. For more

asked 5/13/2015 1:58:36 AM
by Vishal Bhilare
0 answers

How many IP addresses needed for sql server clustering and what is the uses of those IP addresses ? (Active/Passive)
How many IP addresses needed for sql server clustering and what is the uses of those IP addresses ? It is for Active/Passive nodes

asked 5/12/2015 9:55:46 PM
by babuni
0 answers

SSRS Group by Display
I have a requirement in SSRS Report where, I need to group the below data set LastName  FirstName  EmployeeID Day WorkHours Gaines Edward 77430 Monday 8 Gaines Edward

asked 5/11/2015 10:01:10 PM
by SQLNewbie
0 answers

How to Alternate Row Background Color in SQL Server Reporting Services Tablix on Grouping row without Details Row in Tablix
Hello SSRS MVPS In the tablix If there is no Details row and Tablix is having multiple Groupings and in this case how do I apply Alternate Row Background Color atleast for one grouping. Please let me if theres is solution or fix. Thanks in Advance

asked 5/9/2015 1:26:36 AM
by Mahesh MSBI
0 answers

How to send file via FTP using T-sql or stored procedure
*** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copyingI want to send a file from sql to different server via FTP:

asked 5/5/2015 5:08:29 PM
by Shilpa
0 answers

data cleansing
at interview asked me about: How do you do data cleansing? please help thanks

asked 5/4/2015 7:52:30 PM
by Debbie C
0 answers

Hi. Recently i have heard about SSIS Excel Refresh Task.It seems like this task has been built to support SQL Server 2012, not SQL Server 2014. At least, after running the installer, the task does not show up in my SSIS toolbox after refreshing, and I am

asked 5/4/2015 7:38:12 AM
by Surender
0 answers

Mantainence plan Always on
Hi all, I've new to always on management, I would like to know if thre is a best practice for configuring mantainence plan on a always on system ( two nodes) or is just running the mainainance plan wizard on both nodes. Thank you very much for help

asked 5/4/2015 4:29:40 AM
by Luca Pozzoli
0 answers

SSRS 2012 Error : Report processing has been canceled by the user. (rsProcessingAborted)
Hi All, When I run the reports from Report Manager getting the error as Report processing has been canceled by the user. (rsProcessingAborted). Also the same error comes when the SSRS reports are called from the Aplication What is the Root Cause o

asked 4/30/2015 1:26:09 PM
by Mahesh MSBI
0 answers

How to script out linked in servers from sql 7.0
How to script out linked in servers from sql 7.0

asked 4/28/2015 5:12:08 PM
by Suresh
2 answers

How to achieve this output using SQL Script?
Table A:   code        aname ----------- ---------- 1           A 2           B 3    &nbs

asked 4/28/2015 4:18:02 AM
by SQL Lover
0 answers

Sponsor Information