Sure... Disable access for groups that you don't want to access SQl Server.

Also, note that @@identity will return the last identity created, NOT necessarily the one that this transaction generated. you should use scope_identity() to use the indentity generated from the...

I figured it out! Drop a List control onto the report, get to its properties and make the dataset the same as the chart, and group by "schoolName" for the...

Well then, it is possible to have 23! combinations, I believe. You will have to have a pretty sophisticated algorithm to figure this out. I would think this...

Will they be sequential, or can it be any combination of rows?

Nice article! However, I have no idea what DAX is... I can query it now, but I don't know where or why I would 🙂 I could Google it, but...

Since nobody has any info, am I to assume that this will not cause any problems? (I already know, assuming anything makes an...) Any thoughts? Do I need to...

The business case is to allow certain groups of people to do their own data fixes (I know, that sounds scary). So, we want them to place their script as...

Sean Lange (9/19/2012)

---

SQLKnowItAll (9/19/2012)

---

Here's some sample code:

CREATE TABLE #test(id int identity (1,1), filler VARCHAR(1))

GO

INSERT INTO #test(filler)

SELECT 'a'

GO 5

DECLARE @sql VARCHAR(150)

SET @sql = 'BEGIN TRAN SELECT * FROM #test SELECT...

PaulB-TheOneAndOnly (9/19/2012)

---

As far as I...

Here's some sample code:

CREATE TABLE #test(id int identity (1,1), filler VARCHAR(1))

GO

INSERT INTO #test(filler)

SELECT 'a'

GO 5

DECLARE @sql VARCHAR(150)

SET @sql = 'BEGIN TRAN SELECT * FROM #test SELECT * FROM #test...

Here is the piece that gets us free space:

SELECT CAST(size*8/1024 - CAST(FILEPROPERTY(name, 'SpaceUsed' ) AS int)*8/1024 AS int) AS FreeSpaceMB

FROM sys.database_files

Thoughts?

Good question! I will find out. Just started at...

Of course there are no data changes... Its read-only 🙂 I had worded the subject differently and didn't remove that part. Ugh...

capn.hector (9/10/2012)

---

SQLKnowItAll (9/10/2012)

---

I suppose I don't understand the point. We know that when records do not exist in the RIGHT table that NULLs are returned. So why would...