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

Reg Log Backup LSN chain
Hi, As per my Understanding SQL Server Maintain Log Backup Chain depends upon full backup/last log backup. When ever we took Full backup a new LSN chain will start and next log backups will depend on this full backup. For Ex: Full Backup---6 AM TLOG Ba

asked 8/19/2015 7:31:08 AM
by Pradeep
3 answers

Hi Xiong,   Now the task succeded. I will get u the msg what i am getting for success and for failure. -------------For failure------------------------------ MessageThe job failed.  The Job was invoked by User WUNDERWEAR\dd1.  The last

asked 8/19/2015 6:10:10 AM
by ranjan
0 answers

Sending out SSRS Report
I'm in a SQL 2K5 envirornment and I have subscription reports which go out to my users, I would like to change that so they will get an email message that will point them to a link of the report (instead of sending out serveral reports), however when they

asked 8/18/2015 8:41:22 PM
by Kevin
0 answers

if a server performance is slow? how can troubleshoot a problem?

asked 8/18/2015 5:01:49 AM
by raj
1 answers

System Database Rebuild Process
Hi Jugal, Im New to Database and i searched for the rebuild process for system databases i didn't get any usefull info, can you please write a article for the system databases rebuild process  

asked 8/18/2015 1:12:48 AM
by Ramchinni
1 answers

How does an SQL Program look like, for a client
Hello, I have a really stupid, yet important question to ask here. I am a Computer Sciences student, and having not learned anything about Database yet, I have a friend's father who wants me to make him a program to a database for his clients.He basicall

asked 8/17/2015 5:58:14 PM
by Patrick Y
1 answers

Table Design - monthly goals for multiple units
Hello, I need to store the monthly goals for 50+ business units by year. (UnitID, Year, Month, Goal)  These numbers should be static and new goals inserted yearly.  The data will be used in reports to display % to goal and other calculations. &

asked 8/17/2015 12:46:06 PM
by Darwin
1 answers

What are the possible errors found at the time of restoration of database.  

asked 8/16/2015 3:04:17 AM
by Jiten
1 answers

The operating system returned error 665(The requested operation could not be completed due to a file system limitation)
Got this error message on a ~500GBs database DBCC CHECKDB operation: Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be

asked 8/14/2015 12:36:42 PM
by Elise5000
0 answers

Schema, Pranet_object onwership, and child_object ownership
All, This is a project for a Security Class @ a California State University.  Resources VERY limited for help. Trying to gather SQL Server information across a network.  Specifically, what users own which schemas, which schemas conta

asked 8/13/2015 5:58:16 PM
by Elise5000
3 answers

Changes in parameter value on reports in BIDS are not reflected when deployed to website
I have numerous reports built in SSRS 2008 and I need to change the value in the parameters.   The changes done in Bids are saved and the reports run fine from Bids when the new values.   However, when I deploy those reports, the

asked 8/13/2015 3:31:20 PM
by Cindy Filler
0 answers

Object Ownership: Triggers
Apparently you can't change the owner of a trigger using ALTER AUTHORIZATION OBJECT::.  However, if the trigger is in an owned SCHEMA will changing the owner of the SCHEMA effectively change the owner of the trigger in the SCHEMA?  If so, then d

asked 8/13/2015 11:30:09 AM
by Elise5000
2 answers

Windows Server Cluster and SQL AlwaysOn Avaiabilty Group
Hello, i have a problem with my Windows Server 2012 R2 Cluster. I have two nodes of SQL Server 2012. SQL Server was Standalone and use AlwayOn Availability Groups. I Use a File Share Witnees as Quorum. Now when i reboot the Fileserver on which the Fil

asked 8/13/2015 9:50:00 AM
by Alex
0 answers

initial catalog name change as per db name in ssis configuration.
Dear all, in our ssis package migrartion package project. i have faced a problem. our previous version ssis package there are lot of connection manager and we are configed ssis package configuration at that time db name is like ABC_DEPLOY. but after move

asked 8/12/2015 2:04:20 AM
by Subhamay
0 answers

Correcting Server Connection in Maintenance Plans
In SQL 2008 R2, if we clone an environment including SQL server, the maintenance plans retain a connection string to the source/original server they got cloned from and are not editable.  But, I was able to use a work around by editing them in BIDS a

asked 8/11/2015 6:21:24 PM
by Neel
0 answers

Excel source file issue in SSIS
The SSIS is getting fail, The excel source file not having all mapped column, so it is failing to read excel file, I want if column is not present in excel then just keep null for that column. I tried to insert data without column header,but not succeed.

asked 8/6/2015 9:13:07 AM
by Mohit Yadav
0 answers

When i use function and when i use store procedure in sql server
When i use function and when i use store procedure in sql Server

asked 7/31/2015 1:46:59 AM
by sameer Patil
1 answers

Dynamic Stored Procedure work only on limmted number of records
This dynamic Sp works only where there are very few records and failes with 100+ lines of data. I can't firgure out why. Please help. Error Message when runnin g against data with 100+ records: "CategoryTimestampDurationMessageLinePosition Error7/30/201

asked 7/30/2015 6:28:08 PM
by helal
1 answers

stored procedure
dear all sql doctors, i had one stored procedure ...it has multiple coluns some of columns like start date, enddate, spped , distance , address. my need is the startdate & enddate are having records 12 am to 12 am, io need to change that to 2 am to

asked 7/30/2015 8:49:49 AM
by ys reddy
1 answers

  I see below messages in error log(screenshot below).Due to this the response time was very slow. And it caused timeout errors.As per my understanding,"ACCESS_METHODS_SCAN_RANGE_GENERATOR” indicates lot of concurrent parallel scans.Could you

asked 7/30/2015 6:42:12 AM
by ChaituKiran
1 answers

Sponsor Information



Get Free SQL Tips










BI Professionals


Q and A

Today's Tip







Tip Categories

Search By TipID



First Timer?




User Groups

Author of the Year

More Info








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