At some point you have to trust the application not to send you malicious data, once again that doesn't mean that end users of the application should be sending commands...

What exactly are you trying to monitor, the amount of space the log is taking up or the amount of free space on that drive?

Well there's always excel.

Well technically you could find all the user logins that don't have strong passwords enforced on them, enable that for all the logins then force them to change their password...

Getting experience is nifty and all but being stuck supporting what is soon to be 15 year old software sucks. It might a form of job security but it's...

What exactly is the goal of your test and QA environment? Do you need just the database structure or do you actually need the production data in that environment?...

Do you have a technical contact on their end you can get to run your first query locally and see if it lags on their end as well(if so it...

Okay yeah there's nothing stopping you from doing that, if you took that idea and used it to build however many select statements you were going to run that for...

Yes potentially you could do that, all that loop is doing is building a select statement, but once again keep in mind the more you add in the more columns...

The basic idea would be something like,

CREATE TABLE #test_table (COL_ONE varchar(30), COL_TWO varchar(30), COL_THREE int)

INSERT INTO #test_table

SELECT 'test1', 'c', 1

UNION

SELECT 'test1', 'b', 500

UNION

SELECT 'test2', 'a', 2

DECLARE @sql varchar(max),

@col_three int

DECLARE temp_con...

That's not terribly hard to set up but your result set will have a huge number of columns very fast if there's any large range of data you're looking at.

Alvin Ramard (9/29/2014)

---

I would not try to migrate/upgrade DTS packages.

SSIS offers new ways to do things, so I would rebuild each package from scratch. With each package, I would...

Excel loves to mangle numbers, try selecting the columns you are importing to and changing the formating to Text.

A more true answer would be, most people just don't need every possible feature installed and all of the above reasons are benefits.

spectra (9/26/2014)

---

BWFC (9/26/2014)

---

No.......you misunderstood...