Yep.

  I finally resolved the same issue with my [varchar(50)] when I took out the square brackets..  That is when I realized that the square brackets should have...

None of you people have identified the issue.  The problem is that SQL server is returning an error "Cannot find data type varchar(50)."

I am getting the...

Whenever I sign onto to a development database to run DDL Scripts I not only put a Use statement in my script but I also use the drop down to...

I've always have any login with sys admin rights default to master, but any login with only database level rights defaults to their database.

I do not want...

Turns out if your rdl has parameters in it you will see only a blank page in your reportviewer page. When you view source then you will a see...

@ssc-Enthusiast Please read the original post.

For anyone reading this thread. Instructions provided for VS 2005 do not work in VS 2010 or 2012. This converted RDL causes...

In our type of company it is really hard to implement meritocracy fairly. The reasoon for this is not because of the individuals but because each individual works for...

Wow. Many issues and comments.

One issue concerning asking applicant how to resolve a situation. That's how I got my first two jobs in the field. In each...

@majorbloodnock

Concerning your remark from July 2008 about CS degreed folks having a better grasp of DB theory.

In my experience that has not been necessarily the case. Even...

Nice article. Very informative.

Interestingly enough, I just found out a couple of months ago in reading the articles on set-based programming versus procedural programming on Code Project

Or you could do

Select Distinct ABuyers.CustomerID from

(Select CustomerID FROM #Purchase WHERE ProductCode = 'A') ABuyers

JOIN

(Select CustomerID FROM #Purchase WHERE ProductCode = 'B') BBuyers

ON ABuyers.CustomerID = BBuyers.CustomerID

LEFT JOIN...

In the development environment in which I am working, We have three company's doing parallel development on web apps (modules) for one web site. While in many cases these...

Yeah. Same here. Who woulddov thunk it !?!

:crazy:

Grant create table to username

Grant alter to username

George, in the original post dbajunior said "I uncheck db_owner, then click OK." Well in my version of SQL Server 2008, the login mapped to dbo is not listed...