Eric M Russell (2/19/2015)

---

Alvin Ramard (2/19/2015)

---

This editorial came on an interesting day.

A few hours ago I decided I need to get my hand on a cheaper option to Erwin or...

ilokris (2/19/2015)

---

@luis,

Your Question: ''Why don't you define your column as a date data type in your flat file connection and save yourself some problems? Your destination column should be a...

This editorial came on an interesting day.

A few hours ago I decided I need to get my hand on a cheaper option to Erwin or DB Artisan. I'm working...

I use it regularly, but only when I'm developing queries or in ad-hoc queries.

Interesting that I saw this post just now. I just finished removing one of these from...

It shouldn't be to hard to develop a function, or functions, on the application development side that test all SQL statements to prevent injection. Once that's done, just have...

Thanks for the idea for a great topic for an upcoming user group meeting.

Now, Just need to find someone to present it.

SSMS_2007 (2/13/2015)

---

I am trying to import 1 spreadsheet to a database table. I am using SSMS export import wizard to import spreadsheet. My goal is to import whole spreadsheet in...

Instead of deleting 5 years worth all at once, try deleting a smaller date range at a time, say one month at a time.

If I were doing this, I would do it using SSIS.

Maintenance plans generate SSIS Packages. Just edit your package(s) to add a FileSystem task to move the existing backup(s) before the backup task(s).

I would be very happy to see the script component section.

You should contact Pragmatic Works and ask them what the status is.

No, it's: "I have a dream." 😉

Can...

kabaari (1/19/2015)

---

Alvin and Andrew,

Those both achieved my goal. I was having difficulty with querying against a getDate() Inserted value. The time is also captured at insert which had thrown some...