Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "how to"

1

Changing a column that is already populated into a column that uses a sequence

Just got a question on my A first look at sequences in SQL Server Denali post.

The question is the following: How can you add a new column to existing table (already populated) and make it a sequence column?

Let’s take a look. First create this ve…

Read More...
1

Using a Dedicated Administrator Connection via SSMS

If you need to use a Dedicated Administrator Connection (DAC) via SSMS, you can’t just use the Connect Object Explorer, if you try you will get the following error

Dedicated administrator connections are not supported via SSMS as it establishes multi…

Read More...
2

Using WITH RESULT SETS with stored procedures that return multiple resultsets

Yesterday I blogged about using WITH RESULT SETS with the EXECUTE command here: Use WITH RESULT SETS to change column names and datatypes of a resultset. Naomi Nosonovsky left the following comment
Can you use this feature to get result sets from the s…

Read More...
4

Use WITH RESULT SETS to change column names and datatypes of a resultset

SQL Server 2012 has added WITH RESULT SETS to the EXCECUTE command. You can now override the data types and names that the resultset is returning

EXEC (‘SELECT name FROM sys.tables’ )
WITH RESULT SETS
(
(TableName nvarchar(100))
);

Table…

Read More...
0

Dealing with the Column name ‘TEXT()’ contains an invalid XML identifier as required by FOR XML; ‘(‘(0×0028) is the first character at fault error

I had to deploy a user defined function I was given yesterday, when I tried to I got the following error

Msg 6850, Level 16, State 1, Procedure fnGetBooks, Line 8
Column name ‘TEXT()’ contains an invalid XML identifier as required by FOR XML; ‘(‘(0x…

Read More...
4

SQL Advent 2012, here is what is coming

I decided to do a SQL Advent series of posts this year as well, this year I will focus on best practices. In case you are interested in last year’s posts, all of them are listed here: SQL Advent 2011 Recap

Here is what the preliminary 25 posts will l…

Read More...
2

Find all the tables and indexes that have data compression

I took a backup of one of our test databases today and gave it to someone so that it could be restored on one of their servers.

I got back the following in an email from the person who tried to do the restore

Date 11/16/20…

Read More...
1

Why do you need additional privileges for truncate table compared to delete?

One of the people on my team wants to have the ability to truncate tables on the staging database while this person is testing, why are special permissions required compared to a delete?

Read More...
3

How to shutdown windows 8

If you installed Windows 8, you might be wondering how to shut down or restart this operating system. There is no more start button so where do you start?

There are a couple of ways to shut down the operating system

1) Hit CTRL + ALT + DELETE and…

Read More...
3

Don’t put a return statement in a stored procedure inside a transaction

I answered the following question earlier this evening: Return an output parameter from SQL Server via a stored procedure and c#

Here is the proc in question, take a good look at it, do you see the problem?

ALTER PROCEDURE [dbo].[Insert_UnknownCus…

Read More...
Next Page »