Learn more about SQL Server tools


SQL Server Question and Answers

Ask a SQL Server Question

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

Menu Drive REport in SSRS
I am researching to see if a Menu Driven report is possible to develop in SSRS 2008 r2. Basically, user when lunches a SSRS report are presented with a Menu/Page where he/she can choose the criteria (filters) and submit. The user then is presented with on

asked 12/19/2014 4:10:30 PM
by Helal
0 answers

SQL Server 2012 restoring DB from NAS
I have setup the destination for backups to save to an NAS device specifying the full path to the device.   I have a maintenance plan to schedule Full and Differential backups. The backups are running and I can see the backup files on the NAS. Whe

asked 12/19/2014 6:15:02 AM
by David Scott
1 answers

To Restrict SQL account from accessing Sql server via SSMS
Hi All, We are planning to tighten the security of our SQL Server. In the initial phase, we want to restrict all the SQL accounts(except sa) from accessing SQL Server via SSMS Since the SQL passwords are used in the connection strings(plain text) of ou

asked 12/18/2014 12:17:17 PM
by senthilkumar
1 answers

SQL code problem!
Hello,   I Want to make a Advance Search box with 2 box.The first box there is "name" and seacond box there is "distance" The search box have 3 choose.  (name and null) or (null and distance) or (name and distance). I have two parameter in d

asked 12/18/2014 12:52:53 AM
by Dimitris
0 answers

the file
I removed folders from the Program Files(x86) because I was having a problem installing a program, However, I left the Microsoft SQL Server folder, I did not remove it.  After restarting the Server, The ssms.exe was missing and I cannot start the SQL

asked 12/17/2014 2:53:27 PM
by Andrea Ali
1 answers

Upgrade Sql Server version
I am tasked with upgrading a few servers from earlier versions to SQL Server 2014.  The plan is to move databases from their current location to a temporary server (SQL 2014), uninstall SQL Server and then install SQL Server 2014.  At

asked 12/15/2014 12:59:20 PM
by Larry
5 answers

Should we audit tempdb for user activity
Hi, We are currently auditing all databases on SQL Server 2008 R2 for events 47, 102,103. 104.105, 108,109,110,111, 113,117, 130, 170, 171, 173, 176. I get alot of events generated for tempdb. Do I need to monitor tempdb for all these events? Is it alri

asked 12/15/2014 3:11:05 AM
by Potta Pitot
0 answers

Generate Transaction Id(nvarchar) before inserting into DataBase
Hi, I would like to generate a Transaction Id for each row before inserting. Transaction like should follow a structure and sequence: Eg; AAA0001 AAA0002 ..... AAA9999 AAB0001   Could you please assist me in acheiving this.   Thanks

asked 12/15/2014 2:31:48 AM
by PrudviRaj
1 answers

How to use the trigger, index and views with example
  Hi Sir,  Would u send some examples of using trigger,index, and views in sql server along with artical about it.     Thanking you

asked 12/15/2014 2:20:41 AM
by chetan kumar s
0 answers

DB Read only Copy SQL12/14
I am hoping to get some guidance on the best approach for a read only copy of a database that is ~ 1TB.  The primary database is fed nightly with an ETL process.  We are currently trying to duplicate the ETL to read only server but that process

asked 12/11/2014 2:35:10 PM
by McDye
1 answers

row level security for end users, all rows for sysadmin users in combination with using “aggregated” tables
  Hi, I trying to implement row level security using AD with IS_MEMBER function in combination indexed views  for aggregated data.   In case query matches the indexed view definition the costs base optimizer should choose the clustered i

asked 12/11/2014 11:31:43 AM
by Wilfried
0 answers

Tempdb error
System SQL SERVER 2005 SP4 Standard Edition. The server this instance was installed on was renamed.  sp_dropserver and sp_addserver (local) were run to fix the name.  Server was restarted and no connection issues were found. I have a inte

asked 12/10/2014 3:09:22 PM
by mkal
0 answers

At end of SQL server 2008 installation in windows 8.1 it hang displaying "RebootMessageAction"
Greetings !! I was trying to install SQL server 2008 in my laptop which the os windows 8.1.  It shows compitibility issue. I solve this issue by right clicking the setup.exe file , went to property tab and change "run this program for in compitibil

asked 12/10/2014 1:02:42 PM
by Mahi
0 answers

Hash Join happening even where conditions are present
Hi,   In below query I have used On as well as Where condition. In execution plan, Index seek is happening for all tables even though Hash Match is happening. Select col1, col2, col3 from table1 T1 with (NOLOCK) INNER JOIN    

asked 12/10/2014 7:48:15 AM
by Ritesh Kumar Singh
0 answers

ODBC Parameter Size
Hi, I have created a SSIS package which runs every hour from my Machine. First part of my Package runs a Execute SQl Task and result set (single row, single column) is a comma separated list of Unique Record Ids which have been updated in last hour. (i.e

asked 12/9/2014 9:33:03 AM
by maulin Thaker
0 answers

The .mdf file grows much after running maintenance plans
Why the .mdf file grows after running weekly maintenance plans? any idea

asked 12/8/2014 12:17:32 PM
by Roy
1 answers

data comparison with minus statement
Hi i have uploaded two tables A & B i have removed inactive components of A as well as B & created a new table C & D now while doing minus ( C-D) i m getting values of C not prsent in D but data involves sme inactive components please hel

asked 12/4/2014 1:48:01 AM
by aryan
0 answers

error message
DECLARE @i AS int = 0;WHILE @i < 28864BEGINSET @i = @i + 1;INSERT INTO dbo.TestStructure(id,filler1,filler2)VALUES(@i, FORMAT(@I, '0000'), 'b');END;GO   When I executed the batch above, after executing for a loooong time, I got the error message

asked 11/29/2014 10:50:52 PM
by Gabriel I. Ruiz
1 answers

Automatically setting Identity value based on column of other value
I am Creating a table such as  student name, class ,roll no roll no is set as identity,information of student is being saved in on table  such as studentname,class,rollno i want such that     student name  class  roll

asked 11/28/2014 2:06:27 AM
by Kunal Choudahary
0 answers

deploy project in sql2012 remotly

asked 11/27/2014 3:03:18 PM
by az
1 answers

Sponsor Information