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

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

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

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.