Ninja's_RGR'us (4/21/2010)

---

Micheal.

I don't know the whole story here, but I know that management changed hands at least 2 times in 15 months and that this is one of the reasons...

Ninja's_RGR'us (4/21/2010)

---

My boss is already aware of the situation and I already told him that I would refuse all their offers (I won't turn down a 6 figure job, as...

I like that..

CEWII

EXEC master.dbo.sp_configure 'max server memory (MB)', xx

or from the GUI, right click on the server and goto the memory tab..

CEWII

First forcing a shutdown could be considered criminal, so be VERY careful with that.

I wouldn't provide one additional line of code or ANY support.

I would tell your boss that they...

SQL 2008 is even better. You would not believe the anemic hardware I've seen and then heard people complain about SQL not performing.. I have to fight the...

A trigger mat have an EXECUTE AS statement per books online. However have you considered using a certificate signed sproc instead.

Check out:

http://www.sqlservercentral.com/articles/Security/68873/

You could also use service broker.

CEWII

More than my spidey sense is tingling because of this..

Just think about the queries required to get data from all those tables.. That raises questions right there..

Here is my...

A report uses data sources. And all the reports don't have to have a single one. As far as 2 datasources on a report, I can't remember.

For cases...

Perhaps you can build a web service for your app to use, that would make it more difficult for them to directly access your system and allow you to better...

That transaction mix may change my thoughts. Let me think about it some more.. The one-for-one with the updates changes things.. That feels like a type 2...

hein-1120388 (4/21/2010)

---

Now if you're saying that the firewall is not going to solve the whole problem, then I would agree. If you're saying you won't utilize IP blocking whatsoever...

The advanced buttom next to the schedule on the Schedules tab allows repeats in minutes and hours..

CEWII

No, it isn't.

RS allows you to connect to those servers directly and in most cases I would suggest you do. Linked servers usually incur a performance penalty especially on...

hein-1120388 (4/21/2010)

---

Ok. I use SQL Server Standard om my web server but have SQL Express installed at clients. So your comment is still valid. I had some database management tasks...