If you add "WITH VALUES" to your ALTER TABLE ADD statement, it will put the default value in regardless of the NULL/NOT NULL setting...

USE tempdb;

GO

CREATE TABLE test (c INT...

As db_owner, you cannot...

sqlstunner (8/18/2014)

---

Hello Folks,

I have a 2008R2 Report Server and I have almost 40 reports, 10 DataSources and aorund 60 Datasets.

I got a new Server with 2012 and SQL Server 2012....

for the report, go to the manage screen (mouse over the report and select Manage)

On the LHS of the screen, select "Security"

You should see "Revert to Parent Security" as an...

You don't give much information so you can't really expect any detailed replies

Have a look at the MAX aggregation function

Whilst you cannot use the same database, you may be able to distribute some of your load onto other servers using read only replicas - part of Availability Groups. ...

Replication does not use linked servers. It uses various agents to move data around. Underneath the wrappers, these are actually EXE's that are normally run using SQL Server...

ericjlawson (8/6/2014)

---

Hi,

We have a LKP table that we will use to decode incoming codes from multiple sales feeds to link to the relevant surrogate key for the ultimate dimension table.

The...

I am wondering whether you can use read only routing as per http://msdn.microsoft.com/en-au/library/hh710054.aspx

If you can, then all you need to do is to update the connection string - no need...

pwalter83 (8/5/2014)

---

Hi,

I need to custom sort a list of countries populated through SQL code. At the moment, it follows a A-Z sort as follows:

AUSTRIA

BALTIC

BELGIUM

BUFFER

CZECH REPUBLIC

DENMARK

FINLAND

FRANCE

GERMANY

IRELAND

NETHERLANDS

NORWAY

PORTUGAL

SPAIN

SWEDEN

SWITZERLAND

But I need the sort in...

PRR.DB (8/5/2014)

---

Hi,

In my local environment , i was setup transnational replication then i have added new article by using below script

EXEC sp_changepublication @publication = 'demo', @property =

N'allow_anonymous', @value='TRUE'

Go

EXEC...

Dan Guzman - Not the MVP (8/5/2014)

---

I upgraded my 2008 R2 instance to 2012 and the Linked Server I use for aconnect to a csv file stopped working.

Create script:

EXEC sp_addlinkedserver...

Firstly - I haven't done this as yet but...

They should be - in the project properties, you set the folder that you want to deploy shared datasets to. So,...

What version of SSRS are you using ?

If you are on SSRS 2008 R2, you can right click on one of the columns, select Series Properties and then click...

A little more info on declaring variables (scalar and table variables) - whilst the example in this question is quite right and the loop does not attempt to create...