Learn more about SQL Server tools

solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips

   Got a SQL tip?
            We want to know!

SQL Server Question and Answers

Ask a SQL Server Question

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

SQL Server Agent is set to auto but keeps shutting down?
I can start the SQL Server Agent but it shuts down in a matter of minutes (if not seconds) and does not auto start. I have checked and double checked the settings for SQL Server Agent in Configuration Manager as well as SSMS. I have reviewed the event

asked 3/22/2014 7:50:20 PM
by Susan Merkle
2 answers

Benefits and Limitations of Adding SQL Server SSRS on AlwaysOn Availability Group Databases
     We have a Database Enivornment setup in SQL Server 2008 R2 (with WSFCI) now in a plan to transfer those databases to SQL Server 2012 Since the ALWAYSON supports multiple scenodary replicas how is it to set the Reporting Server Instance

asked 3/21/2014 1:43:21 PM
by praveen
1 answers

2012 Always On configure jobs
I have a two node availability group setup for SQL Server 2012 Always On.  My question is about the jobs.  In our old environment we had a two node cluster for a given instance. This meant we only had one set of jobs to run regardless of which n

asked 3/19/2014 12:18:28 PM
by Mike
1 answers

Want to use SQL Server instead of an Excel Macro to solve my issue
Let's say I have 3 columns in a table with data in the following format: Column A     Column B    Column C    1                

asked 3/18/2014 3:49:39 PM
by Shelley
1 answers

Seeking Solutions to Automate Excel Weekly Report with SQL Server as Data Feeder
I have a report that I need to update it on weekly basis. The report contains the raw data and bunch of Tables (Sumifs) and Pivot ones that are being fed by raw data. The current process is to extract data from SQL server and copy records to raw data tab,

asked 3/15/2014 2:02:53 PM
by Helal
0 answers

sid column on server_principals and database_principals
Is there a reason why the sid column is not shown as a result of the following queries? SELECT * from sys.server_principals SELECT * from sys.database_principals Thanks!  

asked 3/14/2014 5:58:39 PM
by Leiah
4 answers

Merge of large tables fills transaction log SQL Server 2012
Merge of large tables fills transaction log. Our ETL uses MERGE to import data from hospital information system. When number of records exceeds several million the transaction log fills. How can I restructure the statement so that the impact on transactio

asked 3/14/2014 3:50:52 PM
by Thom
0 answers

Join Between SQL Logins and Database Users
I ran the following query to join the SQL logins that correspond to a specific database: SELECT SDP.principal_ID as [Principal ID], SDP.Name as [User Name], SDP.type_desc as [User Type], SSP.Name as [Login Name], SSP.type_desc as [Login Type] F

asked 3/14/2014 11:46:16 AM
by Leiah
3 answers

SQL Serrver version deplyment
Does anyone knows Approximately how many hosts, or what percentage of hosts, in the US and the world are running SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012?

asked 3/14/2014 10:41:30 AM
by Gabriel I. Ruiz
1 answers

I am connecting me MDF file with visual studio and other database file but not connecting.  Also sql server is not conecting with sql server database. plz help me

asked 3/13/2014 8:04:31 AM
by Faisal
1 answers

Email Notifications for any job run
I've been struggling to remember the location of a setting I know exists.     I have an operator that is set up and receives an email notification any time any job is run, regardless of job status.  This was a high level setting which in

asked 3/11/2014 3:51:22 PM
by Justin
1 answers

Read Only Permissions?
So I'm an IT Auditor but it has taken me forever to get the results of the queries that I provided to the DBA. I just need to run the queries against one database and maybe the master database as well to get information about the logins and server princip

asked 3/11/2014 3:45:15 PM
by Lee
3 answers

LEFT OUTER JOIN not returning all rows
I have created a sequence of queries to return results for products in a temporary table called #Final. I want to return a record for each product wether or not there were any results for the product, so I used a LEFT OUTER JOIN , but it is not working.

asked 3/11/2014 11:48:54 AM
by David Scott
3 answers

Percent Committed Bytes has exceeded threshold (80)
sqlservr.exe is running high memory, PID 3716

asked 3/10/2014 4:23:10 AM
by Ravi
0 answers

Using cursor: Print statements are being wiped out by exec @sqlcmd
I want to search all tables in a database with columnNames containing 'SID' and then get a count of nulls for the column. Ideally I would like the output to appear as: SchemaName             

asked 3/8/2014 1:39:25 AM
by Thom
2 answers

Problems looping or using cursor.
Here is my dilemna.  I have a table that has records in it.  One of the fields is quatity field.   for that row i have to put the same line however many times is in the quatity field into another table.    I also have to get from

asked 3/7/2014 11:42:47 AM
by artistlover
6 answers

Index rebuild and full backup at same time cause any problem
Hi,   Running Index rebuild and full backup at same time cause any problem on sqlserver 2005   Thanks, Ritesh Jaiswal

asked 3/6/2014 8:23:52 AM
by adveet
1 answers

Selection using groups
I have a table which have three columns that interest me. AdEnrollID (Foreign Key), systatchangeid (Primary Key), and Effectivedate (datetime) I made the following query:   Select AdEnrollID, MAX(EffectiveDate)from systatchange where EffectiveDate

asked 3/4/2014 2:05:47 PM
by Giovanni Martinez
1 answers

sp_send_dbmail HTML formating problems
The below SP is ran to return a large amount of data that is sent via email using sp_send_dbmail however the code returned below when opened just as HTML looks fine but when sent via sp_send_dbmail does not it randomly changes the font, adds </td> a

asked 2/26/2014 11:16:20 AM
by Brad Brewer
3 answers

ssas column level security
  If there a way to do column security on ssas cube dynamically according to a table entry. For example there is a permission table storing userid and columns user can view on a cube. User.  Fields ______________ User1 column1 User1 colum

asked 2/26/2014 11:00:16 AM
by vimal
0 answers

Sponsor Information

Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | today's tip | first timer?
Some names and products listed are the registered trademarks of their respective owners.