Learn more about SQL Server tools

   
   

Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Q&A List          Join

















































SQL Server Question and Answers

Ask a SQL Server Question

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

SQL Server Heterogeneous Replication
I'm trying to replicate data from sql server to oracle DB. I've configured my distributor and Publication on sqlserver but as I'm trying to configure a non-sqlserver subscriber, it keeps failing.  Please I need your guidelines as per the configurati

asked 3/10/2017 5:28:07 AM
by Thoseen
0 answers

Revoke CONNECT permissions guest excluding the master msdb and tempdb
Hello I want to create a script in T-SQL or Powershell to "Revoke CONNECT permissions guest excluding the master msdb and tempdb" I found the following:The following script lists all databases that have CONNECT permission granted to the Guest accountht

asked 3/1/2017 3:30:37 AM
by GVDMEER
0 answers

No DIFF backups but sys.master_files.differential_base_[lsn ,guid, time] columns IS NOT NULL, why?
Looking at sys.master_files.differential_base_[lsn ,guid, time] columns and they're not null for all databases except tempdb.  There are no diff backups listed in the msdb.dbo.backupset table, so why are these fields populated with info?  Though

asked 2/23/2017 5:52:42 PM
by Elise5000
0 answers

Page break is not working when using sub report inside main report
Hi Friends, Could you Please help in below issue. I have created Page breaks in SubReport and page breaks are working if runs the subreport. But I have configured this Sub Report in the another Main Report. If I rund MainReport then SubReport Page Brea

asked 2/16/2017 2:44:19 PM
by Kumar
0 answers

FCB::Open failed: Could not open file E:\MSSQL\Datamount\MSSQLSERVER\xxxx_41.21.09._1_Data.mdf for file number 0. OS error: 2(failed to retrieve text for this error. Reason: 15105).
Hi all, here is the log.. Date16/02/2017 08:23:53 LogSQL Server (Current - 16/02/2017 08:22:00)   Sourcespid2707   Message FCB::Open failed: Could not open file E:\MSSQL\Datamount\MSSQLSERVER\xxxx_41.21.09._1_Data.mdf for file number 0.

asked 2/16/2017 3:44:38 AM
by Subhamay
0 answers

REFRESH EXCEL FILE USING SSIS
Hi Team   Thanks alot for sharing the knowldge and helping lakhs of professional around the globe. I Have gone through your site and  i havent seen any post on  refresing excel file using SSIS. Could you create a post on this topic i have

asked 2/9/2017 7:07:55 AM
by surender manchirala
0 answers

"Lookup and return true or false"
Hello, i am currently running SqlServer 2008 R2 I would like a function similar to excel's VLOOKUP.  I have 2 concatenated columns, i need a function to look for the RowLine of one in the entire ColumnLine of the other and return true or false. &nbs

asked 1/24/2017 3:09:33 AM
by Arlene Woods
0 answers

SQL server Restore sequence
Hello, I have to restore a database which has the backup sequence as below:   1/11: full backup - 5:50am   1/12: diff backp - 7:10pm tlog backups -  7:45pm, 8:45pm, 9:45pm, 10:45pm, 11:45pm   1/13: Diff backup -  7:20pm

asked 1/9/2017 11:56:34 AM
by Sravanthi
1 answers

YTD has no value
Hi Everyone, It is my first time to use the Business Intelligence to create the YTD and I am not sure if I have done something wrong,  I can see any value get populated for YTD.  I can see there is value in the Current Time but not YTD. &

asked 12/9/2016 8:23:49 AM
by Sam
0 answers

Load and copy large data from staging to production table
Hello, We are truncating our Sql server table and inserting about 10 million records from Teradata server every day. It takes about 2 hours to finish it and we do it early in the morning while the table is not in use. This production table has

asked 11/26/2016 10:30:29 AM
by Leo
5 answers

sql server cursors
This query has cursors and runs for 20 yrs can we replace cursor with sonething else so it runs faster .      USE [ADP1Bill] GO   /****** Object:  StoredProcedure [dbo].[usp_Bill_DailyCalculations]    Script Date:

asked 11/4/2016 3:59:19 PM
by Kabeer Kazi
0 answers

Maximum number of versions per project in SSIS Catalog Properties
I have to question regarding the Maximum Number of Versions per Project in the SSIS Catalog Properties? What Maximum Number Microsoft recommend for this and why?

asked 10/31/2016 1:12:42 PM
by Iqbal Butt
0 answers

SQL Server DBA wants to use BigInt for all integer fields on database as standard
We have a DBA at our company that is making it mandatory that we use BigInt for all Integer fields on our SQL server databases whereever there is a field that is defined as integer.   I am totally against this becuase it is complete overkill.  

asked 10/21/2016 12:49:07 PM
by BT
1 answers

Migrated database from oracle to SQL Server
I have migrated database from oracle to Sql server using sqlmigration(SSMA) tool. After migration, report say 100% successfully migrated but the row counts in tables are not matching. Sql Server showing more row counts number thatn oracle. Please Help

asked 10/19/2016 2:14:43 PM
by kashif
0 answers

Quorum Configuration
Hello I have watched many sample videos in youtube.com and discovered that in this videos in windows failover cluster dashboard configuration looks like this : Quorum Configuration : Node and Disk Majority (Cluster Disk 1) But on my dashboard it looks

asked 10/14/2016 7:28:19 AM
by Ulvi Babashov
3 answers

What is the maximum data volume limit for SSIS in 48 hours time frame
What is the maximum data volume limit for SSIS in 48 hours time frame Using SSIS Dataflow with Cache manager(No Lookup), Buffer size and Defualt Buffer is set according to requirement.  

asked 9/2/2016 5:44:58 AM
by Swapnil Chaturvedi
0 answers

Sql database from .mdf file
We are using sql server 2005 on Win7.  The disk containing our sql server ldf files crashed so we lost them.  We have all the mdf files though. Can we recover these databases.? We have tried creating a new database, stopping sql server, repla

asked 8/23/2016 10:39:31 AM
by tobypaul509
4 answers

ssis
i have a table like bellow id       code                FName                       LName    &nbs

asked 8/18/2016 1:36:25 AM
by ali
0 answers

Delete the header of XML for deadlock email attachment
Hi I have a standard WMI deadlock alert and when alert is fired I am inserting the XML into a table but then when I open it the root of the XML is with <TextData> and I need to deleate it manually as well at the bottom of the XML and then I can

asked 8/16/2016 11:45:47 AM
by Konstantin
1 answers

Detach database loosing file level permissions
Hi There   My project is on sql server migrations runs on powershell commands. When database is detached file level permissions like owner are set to the person who has detached the database. if other person in a shift comes and want to delete th

asked 8/4/2016 12:41:34 PM
by Phani
0 answers


 
Sponsor Information






 

Follow

Get Free SQL Tips

Twitter

LinkedIn

Google+

Facebook

Pinterest

RSS

Learning

DBAs

Developers

BI Professionals

Careers

Q and A

Today's Tip

Resources

Tutorials

Webcasts

Whitepapers

Tools

Search

Tip Categories

Search By TipID

Authors

Community

First Timer?

Pictures

Contribute

Events

User Groups

Author of the Year

More Info

Join

About

Copyright

Privacy

Disclaimer

Feedback

Advertise

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