solving sql server problems for millions of dbas and developers since 2006

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

granting table level secrity
Guys I would like to know can you grant table security in sql 2008? If it can be done can you do it based on active directory user group I normally do security at the database level however a business unit has requested table level security.

asked 12/13/2013 6:29:56 AM
by Mike
2 answers

Want to learn " Cursor " Concept in MSSQL (IMMEDIATELY)
Hello,   I want to learn Cursor concept in MSSQL immediately. Please send me email immediately about deeply information about cursor.   1. Why we use. 2. How to use. 3. Advantage & Disadvantage.

asked 12/10/2013 7:38:03 AM
by Puneet
1 answers

mssql cannot see available drive
hi i found a strange thing here. i use to be able to see the drive (is a local drive) in maintanance plan but now cannot see it anymore. The account use to startup the server is a domain account. Anywhere i can check?  

asked 12/9/2013 9:02:10 PM
by judith
0 answers

Query Results in Tabs??
Hi.  I'm new to MSSQL Server Management Studio (08).  I'm also not a developer, but one of those pesky business analyst types!!    My question is pretty simple.  I used to use a SQL query tool at a previous job called iSQL.

asked 12/7/2013 6:05:49 PM
by Brent Hess
4 answers

seeing ssrs report over Internet
I am owner of company, in my office I have uploaded ssrs report on my office sql server , suppose I want to see that reports from my home over internet  so is it possible? as there no any lan connection between my office and home.

asked 12/5/2013 12:03:56 PM
by mahendra
1 answers

when we add data file in primary database in log shipping that will be add the secondary or not ? what will happen?
when we add data file in primary database in log shipping  configuration that will be add  that data file to the secondary or not?  what will happen?

asked 12/5/2013 12:46:06 AM
by Kesee Reddy
2 answers

Strange behavior when inserting parsed records from xml
A strange behaviour on insert!

asked 12/4/2013 10:57:52 AM
by Mahesh V S
0 answers

any script that will generate workload
hi guys,  is there any workload scripts. I am learning how to do performance tuning on mssql.  Just into the available tools offer by mssql.  

asked 12/4/2013 3:46:15 AM
by judith
2 answers

My backup maintenance plan is failing
Operating system error 3(The system cannot find the path specified.). BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not est

asked 12/3/2013 11:12:17 AM
by Enoch Abankwah
1 answers

Not able to execute scalar function
Hi Experts i am able to craete scalar function in my local database when i try to execute the function, i am etting error like  invalid object but the function is avilable in the DB please help me here  

asked 11/30/2013 10:04:59 AM
by Reddy
1 answers

RESTORE cannot process database
My database is in Stand by server in Log shipping congiguration. Restore job showed as pass but actually it is getting fail shows error messafe('DatabaseName' has restore threshold of 45 minutes and is out of sync. No restore was performed for 21409 mi

asked 11/30/2013 3:35:59 AM
by shiva
1 answers

SQL Server 2012 AlwaysOn Availability Groups and Transactional MSMQ
I have a question concerning SQL Server 2012 AlwaysOn Availability Groups and MSMQ with transactional queues: can these two be combined, as distributed transactions are not supported by the former?

asked 11/28/2013 5:57:56 AM
by Rudi Claes
0 answers

What 3rd Party Recovery Tool to Use When DBCC Fails ? Real World Experience Please!
Hi Everyone, I'm looking to buy one or more recovery tool software, but it's very difficulty to find real world experiences on the internet.Most of the 'tips' are from the manufacturers, advertising on forums as fake users/specialists.The rest are just r

asked 11/26/2013 8:21:18 AM
by Sergio
0 answers

Job schedule using Metadata table (User table)
  Scenario 1 Job 2 ,job 3,job5 and job 6 need to run parallel after completion of Job 1 Successful . Job 4 will run sequential after completion of job 3 Job7 and job 8 will run sequential after completion of job 5  . Scenario 2 If support

asked 11/25/2013 6:38:39 AM
by Sandeep M S
1 answers

Converting Crystal Reports expression to SQL
I have the following code that I use in Crystal reports to exclude records based on its outcome. If the expression evaluates to 1 it does one thing, if it evaluates to 2 another and so on. I am converting the report into an SQL script but do not know how

asked 11/23/2013 5:54:10 PM
by Robert
1 answers

Granting Execute Permissions to a stored Procedure
I have two databases on the same server and I am the database owner of both ( user = dbo) . I am using Windows login on the server I am trying to setup accounts with minimum privileges to a group of users to create reports. All the Stored Procedures hav

asked 11/20/2013 11:40:45 AM
by David Scott
2 answers

Database Tasks Generate Scripts ...
Can we modify the basic scripts generate by the "Tasks Generate Scripts ..." Wizard? CAN WE HAVE HAND ON THE BASIC TEMPLATES USED OR IS IT HARD CODED? Ex: for objects such as Tables, Views, or StoreProcs IF EXISTS [OBJECT] DROP OBJECT GO CREATE

asked 11/19/2013 8:31:26 AM
by Serge Cadieux
2 answers

sql data import wizard cannot view an access query
when trying to import data into SQL database from Access query the SQL Data import wizard can't identify the Access query

asked 11/19/2013 2:15:56 AM
by Calvin
0 answers

SQL Question if Possible
I have a column where VARCHAR(15) document number field. What I like to do is be able to check each character of the document number and verify it doesn't have a certain number or alpha character in each space. The 15th character will be not used or in ve

asked 11/17/2013 9:40:48 AM
by ros110
7 answers

masking the connection to a named instance
I am looking at doing a large consolidation project taking multiple sql server instances into a large cluster. One thing I have not been able to identify or validate is my current connection to the existing non-cluster db is for example bis-tes-prd is

asked 11/15/2013 2:23:04 PM
by emmett
1 answers

Sponsor Information

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