Viewing 15 posts - 1 through 15 (of 18 total)
I just wanted to uninstall all instances of SQL Server and only install SSMS. I'm sure it was some obscure instance of registry damage that prevented the installer from running.
I...
July 31, 2015 at 9:34 am
Slick. I'd had a similar thought.
Thanks again!
June 8, 2015 at 12:47 pm
I think we'll just add a ClosedDate datetime column and prevent changes to those records if the field is not NULL. The UI (a WinForms app loading DataGridView controls) should...
June 8, 2015 at 12:29 pm
Eric: Thanks very much for the helpful information regarding the number of records needed before partitioning becomes required. It may be that I'm worrying over a problem that won't occur...
June 8, 2015 at 12:00 pm
Michael: Once the records for a month are marked as 'reconciled,' they'll be DONE. No further changes. My only question is the best way to implement such a change. I...
June 8, 2015 at 11:26 am
Yes, that was what I was expecting. This was a hard lesson, but boy did I learn it!
My VB.NET app creates the source file by saving an Excel spreadsheet to...
May 6, 2015 at 10:10 pm
I had created a stored procedure that built a view for every desired table. I reworked it to create a synonym instead. So far everything else seems to be working....
May 9, 2011 at 9:40 am
SYNONYMS. Bloody brilliant! That way my views aren't clogged up with references to tables. Thanks!
May 9, 2011 at 9:12 am
Jeff:
Our main system supports Epicor Vantage; our goal has been to get all non-Vantage items out of that database. That includes report-specific views, user-defined functions, stored procedures, etc.
If we...
May 9, 2011 at 9:06 am
Heaven forbid! [g]
May 5, 2011 at 2:02 pm
Thanks again to all who responded. We had a meeting this morning and basically threw out the whole project. [g]
Don't worry, I'm still employed - we just are taking a...
May 5, 2011 at 12:28 pm
That right there is key. Have you considered putting all your procs and the like that you need to support this with into a 'coding' database, and simply backup/restoring the...
May 4, 2011 at 5:10 pm
By the way, THANKS, all you folks! You've been most helpful, if for no other reason than I have some new ideas and I don't feel so ALL ALONE! 😛
May 4, 2011 at 4:58 pm
I want to do a nightly backup of database tables to another database which I will then use to support reports. Just extract and load, no translate. Right now all...
May 4, 2011 at 4:58 pm
It's a reporting system. Cracking the books now, figuring out if I can do replication in a date window, ie. 'only replicate between 9pm and 5am'...
May 4, 2011 at 4:51 pm
Viewing 15 posts - 1 through 15 (of 18 total)