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

Auditing database insert, update, delete using Windows Group for principal
Trying to enable insert, update, delete auditing at the database level by windows group or group members, does not generate a audit record. Where am I going wrong with this configuration ?   CREATE DATABASE AUDIT SPECIFICATION [DB_AUDIT_SPEC]FOR S

asked 4/3/2014 4:28:16 PM
by deandyno
0 answers

108 MM file load problem.
Hi All, I have a .csv file of 108,640,182 records in comma delimated and I want to load this file into my database but when I am trying to laod it through DTS it is failed,I tried bul insert also it gets loaded but the data is shuffeled. and some of the

asked 4/2/2014 6:31:17 PM
by Satish Vishwakarma
0 answers

Msg 207, Level 16, State 1, Line 1 Invalid column name 'column name' hello group can u help with this stored proc
declare @db_name nvarchar(200), @tbl_name nvarchar(200), @sql nvarchar(1000) declare @lastmod datetime set @lastmod = dateadd(WK,-1,convert(varchar(10),getdate(),101))   declare curDB cursor for  select name    from master.sys.sy

asked 4/2/2014 3:03:24 AM
by Shriyank
0 answers

SQL Server 2008 R2 Best Practices?
Hi Gurus,   I'm consolidating & upgrading our sqlserver environments (2000, 2005,  & 2008r2) to a sqlserver 2008r2 database mirroring.  My boss asked me for the "SQL Server 2008 R2 Best Practices" document and so far I have no luc

asked 4/1/2014 2:32:17 PM
by Daigia
2 answers

New to SQL...
Hello group..   I am new to SQL - My knowledge of it iits VERy little.. I just do sinly queries.. IMy first question here is this.. Do any of you have or know of some good tuoturail for me.. I have isntall SQL12 - aaSince this is what my company wa

asked 4/1/2014 9:20:44 AM
by Carlos
1 answers

How do I execute a Stored Procedure that creates a Table automatically
I have two stored procedures that I need to run prior to the execution of a query.  I can schedule the automatic execution of the query via a web interface software package.  I would like to schedule the stored procedures to run first.  MS

asked 4/1/2014 9:20:35 AM
by W. Fogler
1 answers

Confused as to why an implicit conversion error only happens when a non-clustered index involved
SQLServer 2008R2. I have a table with 25 'flexible' columns defined as varchar(255).  Different organizations may use these columns in different ways. I.e. org1 may store a numeric values in column 1, while org2 may store alphanumeric values in colum

asked 3/31/2014 5:19:34 PM
by Glenn Scamman
0 answers

Select TOP 5 from each Grouping
If I have a table which has the following columns: NAME, DATE, EXECS How would I got about finding the top 5 names with the total executions by day? Week? Month?  For the output it would be something like this:   John  1/1/2014  100

asked 3/28/2014 1:49:42 PM
by Josh
1 answers

Tool to compare content of two tables across two different DB's.
Hi, I have a migration project to migrate from sql server 2008 to 2012. I am looking for a tool that can compare the table content across DB’s with options to not compare certain columns. For example we have auditing columns for each table which w

asked 3/28/2014 1:26:41 PM
by Pinki
2 answers

Filestream Best practices
Hi All;    Long time visitor first time poster. Just want to first of saying how great this site is...I try to tell everyone about it, so thank-you for such a wonderful resource!    Now on to my pondering questions...We are in the

asked 3/28/2014 12:08:54 PM
by Nick LaPointe
0 answers

firing a stored procedure
I have a table tmpclaims it has a field called status.  Anytime the value changes i need a stored procedure to run.  how do i do that any ideas

asked 3/27/2014 4:35:39 PM
by artistlover
1 answers

sql server 2000, openquery is returning null values, please help to resolve this issue.

asked 3/27/2014 1:04:14 AM
by Piya
0 answers

Restore script required
Hi Guys, Can anyone help me in providing the SQL Script to restore my staging database using the production database copy. In my current environment my production database backups are being taken through SQL Maintenance plan. Hence the production databas

asked 3/26/2014 10:40:41 PM
by Parthiban
2 answers

Install cumulative update packages
I need to install CU's for SQL Server 2008 R2 after SP1.  There are 13 of them.  Does SP2 incudes all 13 of these? Do I have to install all 13 of them before installing SP2?  If I need to install CU 5, Do I have to install CU 1-4 before I

asked 3/26/2014 2:53:38 PM
by Gabriel I. Ruiz
2 answers

I have 2 node cluster with one running instance , when the instance runs under the node1 , i am able to make test connection for linked server but once we do failover and instance moves to second node i am unable to do test coneection and jobs are getting failed as well.
I have 2 node cluster with one running instance , when the instance runs under the node1 , i am able to make test connection for linked server but once we do failover and instance moves to second node i am unable to do test connection and jobs are getting

asked 3/26/2014 11:12:38 AM
by adveet
0 answers

Question About Service Accounts
Should the following accounts have sysadmin permissions in the server? (SQL Server 2008 R2) Any service account to run SQL services NT Service \MSSQLSERVER NT Service\ SQLSERVERAGENT Or is it more advisable to review the actual permissions needed

asked 3/25/2014 12:51:04 PM
by Lee
0 answers

Can we automate to run 100 new sps on db run with batch files or other way
need to automate  can run 100 sps or trigger with single click

asked 3/25/2014 9:34:36 AM
by pramod
0 answers

The permissions granted to user 'DOT-KWT-ASSET\uapmadmin' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

asked 3/24/2014 10:06:03 AM
by fundiswa
1 answers

Unable to start/stop local windows service from a SQL job
Hi,   I am trying to start/stop a windows service through a SQL job and I am getting the below errror. The command I am using is  SC START/STOP "Service_Name". Error Msg: Executed as user: XYZ\Abc. [SC] StartService: OpenService FAILED 5: &

asked 3/24/2014 8:00:01 AM
by Ali
3 answers

SQL Server Agent is set to auto but keeps shutting down?
I can start the SQL Server Agent but it shuts down in a matter of minutes (if not seconds) and does not auto start. I have checked and double checked the settings for SQL Server Agent in Configuration Manager as well as SSMS. I have reviewed the event

asked 3/22/2014 7:50:20 PM
by Susan Merkle
2 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.