A community of more than 1,500,000 database professionals and growing

Stairway to Server-side Tracing - Level 8: How to Automate Traces with SSIS

Dan Guzman from SQLServerCentral.com

Level 8 of this stairway series looks at the automation of your tracing using Integration Services. More »

SQL Saturday #154 | St.Louis, MO

Press Release from PASS

Sept 15th, 2012 at the CAIT Campus of Washington University in St.Louis - 5 Jackson Avenue, Clayton, MO 63105 SQL Saturday #154 is the very first SQL Saturday event in the St.Louis area. It is a free one day event for SQL Server professionals and those wanting to learn about SQL Server. We are planning on a 4 track event with 200 attendees. We currently have several sessions aligned towards Database Administration, Application Development, Business Intelligence and professional Development Tracks. We also have several sessions focused on SQL Server 2012! Please visit our event website for more details and free registration. More »

SQL Saturday #156 - Providence, RI

Press Release from SQLServerCentral.com

Come visit Rhode Island and meet fellow SQL Server professionals from all over New England as SQL Saturday comes on Sept 15, 2012. More »

Cleaning Up SQL Server Deployment Scripts

Additional Articles from SimpleTalk

Although, generally speaking, source control is the truth, a database doesn't quite conform to the ideal because the target schema can, for valid reasons, contain other conflicting truths that can't easily be captured in source control. Dave Ballantyne explains the problems and suggests a solution. More »

This weekend is Labor Day in the US. It's a holiday set aside to recognize the workers and their contributions to the economy. It's a holiday here that marks the end of summer and the beginning or school for many people. Hopefully it's a relaxing and enjoyable day for you. 

It's a day off for me from work but probably one where I'm laboring. With a fence to build and a horse shelter, I'm going to be busy for the next few weeks. I've included a blooper reel for you to enjoy. Whether you're working or relaxing, hopefully you enjoy it.

Steve Jones

View the WMV bloopers (31.9MB)

View the MP4 bloopers (27.4MB)

Steve Jones from SQLServerCentral.com

» Join the debate, and respond to today's editorial on the forums

» To submit an article, rant or editorial, log in to the Contribution Center

Today's Question:

It's Labor Day, and an easy question today: what is the name of the Red Gate training events that will be in six cities in the US this fall?

By Steve Jones

Think you know the answer? Click here, and find out if you are right.

This question is worth 7 points in this category: SQLServerCentral. We keep track of your score to give you bragging rights against your peers.

We'd love to give you credit for your own question and answer. To submit a QOD, simply log in to Contribution Center.

Professional SQL Server 2012 Adminstration

Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of SQL Server and deciphers how these changes will affect the methods that administrators have been using for years. Loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server admin issues, this how-to guide deciphers topics such as performance tuning, backup and recovery, scaling and replication, clustering, and security.

Get your copy from Amazon today.

SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach

SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Get your copy from Amazon today.

DECLARE @tmp TABLE (SlNo INT IDENTITY,Name VARCHAR(200))

INSERT INTO @tmp(Name) Values('SCREW')
INSERT INTO @tmp(Name) Values('HAMMER')
INSERT INTO @tmp(Name) Values('SAW')

DELETE FROM @tmp WHERE SlNo = 2

SET IDENTITY_INSERT @tmp ON

INSERT INTO @tmp(SlNO,Name) Values(2,'SHOVEL')

SELECT * FROM @tmp

What will be the Result ?

By Unknown

Answer: An error will return

Explanation: The table variable does not support the statement "SET IDENTITY_INSERT ON". Only static tables and temporary tables support the statement "SET IDENTITY_INSERT ON".

Ref: SET IDENTITY INSERT - http://msdn.microsoft.com/en-us/library/aa259221%28v=SQL.80%29.aspx

» Discuss this question and answer on the forums

Find Mismatched Views and Stored Procs

Pratap Prabhu from SQLServerCentral.com

Find missing and mismatched views and stored procs between 2 Databases More »

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2005 : Administering

How to restrict Users from running SQL. - We use SQL Server 2005. We have created a SQL Server Login called RUNSQLQUERYUSER. We have the following questions: 1. How...

Temp db log file is growing . - tempdblog file is growing to 5 gb. I dont have more space on the drive. want a immediate solution . without restarting...

Career growth - Production Support SQL Server DBA - I have just started as a Production Support SQL Server DBA . Earlier as I Was working as a development dba. Personally...

SQL Server 2005 : Backups

Could not locate file 'SAML' for database 'SAML' in sys.database_files - Good Morning - I know this topic has been beaten to death over the years but I can't shrink a large...

SQL Server 2005 : Business Intelligence

BI Jobs? - Hi people! I'm asking directly to people who works in Business Intelligence! Definition of BI? Do performancepoint, reporting services, excel services...

SQL Server 2005 : SQL Server 2005 General Discussion

Ideas about Error 266 "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 1, current count = 0." - I had to deal with this whilst writing a unit test framework for my TSQL Create simple procedure that performs rollback: [code="sql"]create...

SQL Server 2005 : SQL Server Newbies

Automate alerts for database blockings. - Hi Everyone, Just want to ask if anyone have "script" or jobs that will automatically check database blocking. I want to...

SQL Server 7,2000 : SQL Server Newbies

Get Month Name - Hi all Is there any best way to get month name in SQL SERVER 2005. I know that we can do...

SQL Server 2008 : SQL Server 2008 - General

SSRS - Cannot Export to Excel - Hey everyone, I'm trying to export a report in report manager and I'm getting an error saying "An error occurred...

download sql server management studio and BI - hi i need to download sql server management studio and Business Intelligence , i am not finding link. i went to msdn ,but...

Issue shredding Deadlock Graph XML - I'm working on a script that shreds deadlock graph information. Using the deadlock graph that was posted [url=http://www.sqlservercentral.com/Forums/FindPost1278601.aspx][u]here[/u][/url], I'm running...

Error converting data type nvarchar to numeric - Hi, I have this stored proc that I run nightly. I keep on having issues with it failing because it's...

how to make a search proc for this tables and their conditions ? - here iam having 5 tables for example i have declare 5 tables the @adforum table is used for add a bussiness...

Extensible rule-based tool to find problems in stored procedures? - Hello, Is there a extensible rule-based tool to find problems in SQL Server stored procedures? What I'm looking for is something...

Question About Transactions - When working with a stored procedure that executes several INSERT, UPDATE , DELETE queries, do I structure the sp so that...

SqlCodeGuard - free addin for SSMS for static T-Sql analysis - Hi! i'd like to introduce SqlCodeGuard - free addin for SSMS and VS2010. It provides fast and comprehensive static analysis for T-Sql code...

SQL Server 2008 : T-SQL (SS2K8)

Fiscal Dates - My company wants to create a Financial Calendar Table which contains only the Fiscal Dates. The requirements is ti populate...

using IN statment & a string variable. - Hi, I need some assistance and i've read multiple answers which are very similar but just not sure how to tie...

Unpivot question, struggling with data please help - Have a table with the following structure .. recordid (int), column1a (int), column2a (bit), columns3a (bit), column4a (bit), column1b (int), column2b...

ORDER BY PROBLEM - Hi, I have column in a table which needs to be ordered in an ascending order. [code="sql"]DECLARE @NumberTable TABLE( ItemNumber VARCHAR(50)) INSERT @NumberTable SELECT 'ABC-1702-XYZ' ItemNumber...

Date Query Format Problem - Hi all, my database has a column called StartDate_Time and the format in this column is like so Wed Sep...

XML Creation - Hi to all, I have the follwing piece of TSQL COde [code="sql"] SET @DateTo = '20110330' SELECT ----- FileHeader ------------------------------------------------------------------ CONVERT(VARCHAR(16), GETDATE(), 120) AS '@Created' ,'Nephro, Indication' AS...

Help with a query - self join on table - Im haveing a lot of trouble writing a query. Ive been spinning my wheels for over an hour, and cant...

Employee Hierarchy - There is a table similar to the one below: [code="sql"]create table #Orders ( OrdNum varchar(5) , Empid int , Mgrid int , MgrLevel int ) insert #Orders values ('XZ1', 100,...

SQL Server 2008 : SQL Server Newbies

Using Access to put data into SQL Server - Hello everyone. So I have a database in SQL Server 2008 that contains 5 tables. I have connected Microsoft Access...

Updating multiple rows for multiple values - Hi, I wasn't sure how to phrase my query so wasn't sure what to search for. I'm attempting the simplest of updates...

Need Help With SQL Query - Have a table with a SSN column that is a float data type. My objective is to obtain the correct...

SQL server 2008 r2 expired? how reinstall? - Hello! I have problem, because I have SQL Server 2008 R2, and we have to install 180 day trial, and now...

SQLServerCentral.com : Anything that is NOT about SQL!

Fantasy football 2012 - Only 2.5 short months to football, can you believe it? I'm not ready, hardly feels like it's summer time yet. You...

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...

Reporting Services : Reporting Services

Line Chart with Conditional Line - Hello, I am having trouble with a line chart I am trying to add to a report. The dataset contains a...

One RDL with multiple data sources - Is it possible to create a single report that will be ran by multiple clients, each with their own data...

Data Warehousing : Integration Services

how to send sql data to dynamaic excel sheets in ssis - hi friend i have small doubt in ssis plz how to solve this. i have a table that table contains data...

Data Warehousing : Analysis Services

linked server for ssas - hi, any one please tell me about how to create linked server for ssas in sql server management studio2008 in step by...

Microsoft Access : Microsoft Access

Access 2007 front end to SS2K8 problem - My app includes 1) SS2K8 database on the back end 2) Access 2007 front end NOT LINKED, data flows through ADO...