I don't see why it would necessarily be that bad, at least for a straightforward "row must match the username" check. I've done these a few times w/o any...

And, finally, you don't really need SUBSTRING, LEFT is good enough :-):

SELECT @string, LEFT(@string, LEN(@string) - CHARINDEX('\', REVERSE(@string)) + 1)

I wouldn't try using views, as then the table/view name changes every time, so you're forced to use dynamic SQL, which causes additional security headaches.

Instead, I suggest creating a controller...

Your stated incrementation method is so unusual and customized that I'd suggest just creating table with pre-generated key values; and, when you need to increment by one, instead of...

SQLKnowItAll (3/22/2013)

IT is worth noting that we have 6 different environments and making sure all logins have a synced sid is sometimes not realistic. So that is why I...

SQLKnowItAll (3/22/2013)

---

ScottPletcher (3/22/2013)

---

SQLKnowItAll (3/22/2013)

---

ScottPletcher (3/22/2013)

---

IF you can very briefly drop the problem login(s) on your clients' machines, and immediately recreate them, you can fix this problem once and for all!...

SQLKnowItAll (3/22/2013)

---

ScottPletcher (3/22/2013)

---

IF you can very briefly drop the problem login(s) on your clients' machines, and immediately recreate them, you can fix this problem once and for all! Then...

IF you can very briefly drop the problem login(s) on your clients' machines, and immediately recreate them, you can fix this problem once and for all! Then you would...

frecal (3/21/2013)

---

Thanks Very much for this i was trying to also get it to work using this method (it is easier to follow). but get an error like

Msg 1033, Level...

Very little to go on ... but here's my best guess so far:

IF EXISTS(SELECT 1 FROM sys.objects WHERE name = 'FACT_SalesAnalysis')

DROP TABLE FACT_SalesAnalysis

-- ...

SELECT

DATEADD(HOUR, DATEDIFF(HOUR, 0, RunDateTime), 0) AS AvgHourlyDateTime,

--DATEADD(MILLISECOND, -3, DATEADD(HOUR, DATEDIFF(HOUR, 0, RunDateTime) + 1, 0)) AS AvgHourlyEndDateTime,

AVG([RowCount]) AS...

It looks to me like you're checking all connections to the database. If there are many such connections for different users, that could be a drag on the trigger.

So,...

Would need to also at least see the DDL ("CREATE TABLE"/"CREATE INDEX") for the tables, including all indexes.

You can use COALESCE(): for only 4 values, it's actually clearer to me personally (ymmv) than the other method.

SELECT

t.id,

COALESCE(t.field1, t.field2, t.field3, t.field4)...

Lynn Pettis (3/20/2013)

---

You do realize that shrinking a database will fragment the indexes used by the queries run to generate the reports and that this will impact the performance of...