You don't. You've opened the floodgates.

However, there's a hardware mechanism you can use if you've got a centralized N-Tier and these users aren't running the app off their PCs....

SQL_Surfer (5/21/2013)

---

Doesn't have to be real time data. Would cube work if there is no facts? I mean just the dimensions. Doesn't sound like they need any facts on this...

Look up using the delimitedsplit8k function here. It creates a table you can join against instead of using an IN clause and will protect you from injections.

Run a profiler trace against the target box and see what the query is sending down explicitly. It might be a simple difference in the dateformat defaults on the...

Dynamic report builders are tricky and nasty. If this doesn't have to be real time data, check into SSAS cubes and Powerpivot for your power users.

On a side note, my gaming rig still runs Vista (yes, it's that old). It's about to be upgraded in the next month or two which means I'm getting...

No, it's not exposed externally.

You can call external components from within an SSIS package that way, but you can't invert the process. There's no API/Driver components that will let...

Debbie,

In this particular case, I think you'd be better off learning a bit of scripting. Don't worry, it won't be much. A Script Source component which does...

As far as I know, there's no DDL trigger that can pickup a TRUNCATE, unfortunately. You'll find the list here:

http://msdn.microsoft.com/en-us/library/bb522542(v=sql.105).aspx

Now, as a workaround, you could create an instead of...

What's the error, and can you describe the linked server you're calling mysqlapp?

Someone had to do it, it's not automatic.

If you're curious, check out this blog from Kimberly Tripp:

When did SQL Server stop putting indexes on Foreign Keys?

http://www.sqlskills.com/blogs/kimberly/when-did-sql-server-stop-putting-indexes-on-foreign-key-columns/

MSDN also discusses the value...

ScottPletcher (5/13/2013)

---

I also search table sys.sql_modules, which contains the code for all sys.objects members of type P, RF, V, TR, FN, IF, TF, and R.

If you want to check for...

Jeff Moden (5/13/2013)

---

Heh......

It'll only matter if you start doing query hint overrides... which you should avoid in 99% of circumstances, so yeah... won't matter. 🙂

Brandie Tarvin (5/13/2013)

---

Thanks everyone for the responses. We're going to start checking them now. I'm glad I asked the question as this was not the direction I had been heading...