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 functions
in sql server ..declare @colName varchar(20)set @colName = 'oKaY'select upper(left(@colName, 1)) + substring(LOWER(@colName), 2, len(@colName)) --as @colNamethis is fine for only 1 word it provides output like ... Okaybut if we have more than 1 word like

asked 10/1/2014 3:33:19 AM
by taj
0 answers

SSRS Space(5) within Expression
I would like to use the Space(5) within an SSRS Expression: This works: =(Fields!WMFNO.Value) & "   |   " & (Fields!CourtDT.Value) & "   |   " & (Fields!L_D.Value)   But I would like to add the Space(5), within

asked 9/30/2014 12:56:19 PM
by JE Ramirez
0 answers

How to shrink the transaction log file in SQL Server
USE DBName;    ALTER DATABASE DBName SET RECOVERY SIMPLE; GO   CHECKPOINT;    DBCC SHRINKFILE (N'DBName_Log' , 2)   Result Cannot shrink log file 2 (smvmch_Log) because of minimum log space required. DbId   F

asked 9/30/2014 8:35:40 AM
by TamilSelvan
1 answers

stored procedure insert into table1 select from table2 query not inserting all the records into table1
i have a sql server 2000 stored procedure. The proceudure inserts the select statement result into different table. There were more than one such insert statement returned in this procedure. When I execute the stored procedure, it executes well. But,

asked 9/29/2014 10:14:34 PM
by Harikumar Srinivasan
0 answers

How to automate the process of Generating Scripts for Server Objects (DDL Triggers etc)
I am looking for a way to create a job that will create an .sql file on disk to store the scripts of all server objects (DDL Triggers etc). I need this so that I can use these scripts as backup and migrate all server objects if needed. Please help me. &

asked 9/29/2014 11:04:44 AM
by Burhan Uddin
6 answers

SSIS Package runs Under Package Execution Utility but not SqlServer Agent
Package is designed to open a remote share to a folder using Net Use as to folder is not in our domain. Package runs fine with utility but has the following errors when run from Agent.  If run as Sql Server agent- Executed as user: KERNPROBATION\sql

asked 9/25/2014 7:25:04 PM
by joe munch
2 answers

migration oracle to sql server 2008
i am migrating oracle database to sql server 2008 without using SSMA is there any doc or pdf for guideline

asked 9/25/2014 3:26:19 AM
by taj kazi
7 answers

How to optimize a stored procedure query containing views & joins to load data into a table(truncate & load).

asked 9/24/2014 1:08:19 PM
by Pravin
0 answers

SMS Text msg data Unreadable
Our company sends out sms text mesgs from our MSSQL Database and stores the responses in a table when a reply is received. My problem is now that some mesgs are showing as blank(even when I copy the raw data field out of the query return window) yet when

asked 9/24/2014 2:38:45 AM
by Enrique Mallon
1 answers

SSRS 2008 r2 - Bullet Points
Is there a way to left align bullet points so they have no indent?

asked 9/23/2014 7:12:20 PM
by Aden Stone
0 answers

load TableC from TableB based on value of TableA in SSDT/SSIS
I have 3 tables- CREATE TABLE TableA (GROUP_ID INT  ,STATUS VARCHAR(10))  CREATE TABLE TableB (GROUP_ID INT  ,NAME VARCHAR(10)  ,STATE VARCHAR(50) ,COMPANY VARCHAR(50))    CREATE TABLE TableC (GROUP_ID INT ,NAME VARC

asked 9/23/2014 6:45:46 PM
by sql84
0 answers

how to connect a 32bit XP machine to a 2012 SQL server ??
But the big issue is how to connect a 32bit XP machine to a 2012 SQL server ?? Steve               ***But the big issue is how to connect a 32bit XP machine to a 2012 SQL server ?? NOTE *** - If you want to incl

asked 9/23/2014 8:09:54 AM
by Steve
0 answers

SQL server correct client Driver
Hi This is the problem my clients can not connect to the SQL 2012 database I have migrated to from an Access backend. System is 2008R2 64 bit server running SQL 2012 Clients are some 64 bit Pc's & some 32 bit Pc's I have on 64 bit Development clie

asked 9/23/2014 7:28:12 AM
by Steve
3 answers

SQL server correct client Driver
Hi This is the problem my clients can not connect to the SQL 2012 database I have migrated to from an Access backend. System is 2008R2 64 bit server running SQL 2012 Clients are some 64 bit Pc's & some 32 bit Pc's I have on 64 bit Development clie

asked 9/23/2014 6:13:09 AM
by Steve
0 answers

issue with creating linked sever on Microsoft Windows 2008, with Microsoft Jet 4.0 OLE DB Provider
I have SQL server 2005 express edition running on Microsoft 2003 server. I need to create a link to MS Access files, which located on Microsoft 2008 server. The error message, OLE DB privider "Microsoft Jet database enjoine cannot open the file (.MDB). I

asked 9/19/2014 5:00:19 PM
by Marilyn Zhang
1 answers

SSRS Reports - Dynamically show one report in another report
I'd like to be able to add a report (Report2) to another report (Report1) when there is information in report2. Report1 and Report2 have been created and look similar,  but information in Report2 is not always available.  However, they sha

asked 9/17/2014 11:24:51 AM
by Chieko
2 answers

Expression for Joining and using a LookupSet for 2 datasets
I am a beginner and working in Report Builder 3.0. I have 2 Datasets where I am trying to compare the column in 1 to the column in another (1 to many, but also have blanks) where the final goal is to find which items in Dataset 1 do not have any matches i

asked 9/17/2014 9:25:56 AM
by Sheila
0 answers

Resource governor in mysql like MSSQL server
I am using MYsql 5.5 on my desktop PC, I want to know "how i can reserve resources like CPU, memory and IOPS " in mysql server. MSSQL server has Resource Governor tool through which we can do that.  I read about MYsql Governor but don't know whether

asked 9/15/2014 10:55:38 PM
by M.A Jan
0 answers

Limitation of buffer pool size
What happens if a data to be loaded from a disk in a buffer pool is more than the max limit of buffer pool. 

asked 9/15/2014 9:05:06 AM
by Snehil
0 answers

POS Transactions in SQL database
Hi,I am looking to view cashier transaction details in various Point of Sale Systems that use SQL Databases.Is there a standard format of tables that hold these details? Where and how would i be able to see where certain keystrokes are recorded in a Datab

asked 9/13/2014 12:09:14 AM
by LPS
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.