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

Insert Excel Cell Value to SQL Query
Hi, I need to create a report with data coming FROM SQL server database with a WHERE condition that will be coming from the Excel file. Since we don't want excel to pull and store too many transactions, we only want the query to run based on the user's

asked 9/22/2017 12:05:05 AM
by RinRin
0 answers

Separating reporting database from Transaction DB
Hi All, I have a database which is frequetly updated with huge Data and the same databse is use for reporting. For the data loading to be fast we don't need indexes but the reporting need indexes to run faster. Am looking for the best option to separate

asked 9/19/2017 12:45:00 PM
by Kwabena
0 answers

Error code # 1642 when installing Microsoft SQL Server 2012 Service Pack 3 (CU) CVE-2017-8516 (4019090) for x64-based Systems on Windows server 2008R2 Enterprise edition
Hi, I am getting below errors in event viewer when I applied SQLServer2012-KB4025925-x64.exe(CU) patch on top of SQL server 2012 SP3 MS16-136(SQLServer2012-KB3194724-x64.exe)(QFE) components. But installation is successful and also updated version to la

asked 9/14/2017 11:46:03 AM
by Kiran
0 answers

foreign key have no reference to the child table
i have a parent table address contains addID (identity 1 , 1 ) as integer , area as varchar,streeat as varchar a child table client which contains addID as foreign key and clID PK identity(1,1) , name , fname ....  a form in VS which contains sever

asked 9/10/2017 2:09:58 PM
by mahdi
0 answers

cannot be opened due to inaccessible files or insufficient memory or disk space

asked 8/15/2017 10:46:39 AM
by Mike
0 answers

Script or ways to find out if SSRS encryption key backup completed
Hi Experts,          Is there a way I can find out if SSRS encryptlion key has been backuped up successfully and when the last backup completed. I am looking for metata/system table information or script to find out the results.

asked 8/11/2017 2:43:34 AM
by Dev
0 answers

Excel extensions and SQL server Packages
Hi Everyone,   I am new to sql server creating packeges and scheduling. Please help me with my questions, any information would be helpful. I have installed Sql server 2016 64 bit with data tools (17.1 for visual studio 2015) and sql server manage

asked 7/21/2017 7:26:41 PM
by Pranitha
0 answers

How to add cmd prompt messages in Sql unattended install
Hi  I am new to Sql server, and so far i'v installed a few Sqls using the standard gui & lately have done a few installs using the unattended approach. I wanted to get  progress messages in the cmd-prompt so I thought to put a few echo sta

asked 7/13/2017 11:43:05 PM
by john
0 answers

Convert String Datatypes
Convert the string:    "(id,created,employee(id,firstname,employeeType(id), lastname),location)"  to the following output  id created employee - id - firstname - employeeType -- id - lastname location  output in alpha

asked 7/11/2017 4:30:56 PM
by Rony
1 answers

MSDB database grows huge
we found that msdb database grows huge because sysxmitqueue table,  does anyone know how to shrink and solve this issue permanently  without  recurrence . the log shipping is configured on the serverthe service broker is enabled o

asked 6/6/2017 1:52:46 PM
by madhu
2 answers

SSRS Pie Chart
I have a pie chart with 2 slices having the same values. However, the pie chart only displays 1 slice. How can we have the pie chart displays all slices even if the same values? Thanks

asked 6/5/2017 2:52:15 PM
by Kim
0 answers

how can I open .mdf files?
How can I open .mdf files( SQL server files) and access the data. I  downloaded MSDE software but unable to install it says Strict username and psaaword required . were should i look for that. Are there any other solutions.

asked 5/24/2017 10:15:38 AM
by BjornPorgilsson
2 answers

Moving SQL from one datacenter to another datacenter
*** 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 copyHi, I am working on to find some workaround for moving SQL Serv

asked 5/7/2017 7:26:56 AM
by Prasad
1 answers

sqlexception exception processing 'opensession' request failed to initialize the common language runtime
sqlexception exception processing 'opensession' request failed to initialize the common language runtime CLR V2.0.50727 due to memory pressure

asked 4/20/2017 3:24:39 AM
by Benson
0 answers

db mail cant be send without using script in sqlserver2012

asked 4/16/2017 11:58:43 AM
by sirisha
0 answers

SSRS Parameter Search on a long list id
I am creating a searchable SSRS report where staff can search the datasest on client ids. Staff should be able to insert client id (one at a time) into client id search parameter and then get all the info about the client in the report. The issue I have i

asked 4/14/2017 2:34:05 PM
by Helal Mobasher
0 answers

SQL Server SELECT statement error message
The column name is 'CandIDX' from a table called EHTNIG0040100. This is the Select statement from a VBA code in Access2007 frontend to retrieve data from SQL 2008  database: strSQL = "SELECT * FROM " & filenameB & _    &n

asked 3/31/2017 7:35:03 AM
by Laide
1 answers

Force ssl breaks user-defined functions
Im running sql server 2016 on an Azure VM with no vpn.  i want to force encryption over the network to all clients. I successfully changed the force encryption from no to yes and restarted sql server. (Using the autogenerated self-signed cert for no

asked 3/30/2017 3:01:51 AM
by Daniel
0 answers

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
1 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
2 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.